Terminy kursów:

02.10.2023 - 06.10.2023
06.11.2023 - 10.11.2023
27.11.2023 - 01.12.2023
18.12.2023 - 22.12.2023

MS-20466 Implementing Data Models and Reports with SQL Server 2014

Czas trwania kursu: 5 dni
Cena: 3399 zł netto

KLUCZOWE ZAGADNIENIA

tworzenie kostek OLAP, praca z miarami i wymiarami
podstawy MDX
praca z modelem Taular
podstawy DAX
raportowanie przy użyciu Reporting Services
integracja Reporting Services z SharePointem
tworzenie portalu BI i interaktywnych Dashboardów w SharePoint przy wykorzystaniu „SharePoint Performance Points Services”
wstęp do Data Mining

Przemysław Rosłon, Microsoft Certified Trainer

CERTYFIKACJE ZAWODOWE

Certyfikacja podstawowa	CertyfIkacja specjalistyczna	Certyfikacja ekspercka
FUNDAMENTALS	ASSOCIATE	EXPERT

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSE: Data Management and Analytics
Dowiedz się więcej o certyfikacjach Microsoft

POZIOM SZKOLENIA

podstawowy	średniozaawansowany	zaawansowany	ekspercki
100	200	300	400

TEMATYKA ZAJĘĆ

Module 1: Introduction to Business Intelligence and Data Modeling
Introduction to Business Intelligence
The Microsoft Enterprise BI Platform
Lab: Exploring a BI Solution

Module 2: Creating Multidimensional Databases
Introduction to Multidimensional Analysis
Creating Data Sources and Data Source Views
Creating a Cube
Overview of Cube Security
Lab: Creating a Multidimensional Database

Module 3: Working with Cubes and Dimensions
Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Hierarchies
Lab: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups
Working with Measures
Working with Measure Groups
Lab: Configuring Measures and Measure Groups

Module 5: Introduction to MDX
MDX Fundamentals
Adding Calculations to a Cube
Using MDX to Query a Cube
Lab: Using MDX

Module 6: Customizing Cube Functionality
Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
Lab: Customizing a Cube

Module 7: Implementing an Analysis Services Tabular Data Model
Introduction to Tabular Data Models
Creating a Tabular Data Model
Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
Lab: Implementing an Analysis Services Tabular Data Model

Module 8: Introduction to Data Analysis Expression (DAX)
DAX Fundamentals
Using DAX to Create calculated Columns and Measures in a Tabular Data Model
Lab: Creating Calculated Columns and Measures by using DAX

Module 9: Implementing Reports with SQL Server Reporting Services
Introduction to Reporting Services
Creating a Report with Report Designer
Grouping and Aggregating Data in a Report
Showing Data Graphically
Filtering Reports Using Parameters
Lab: Creating a Report with Report Designer

Module 10: Automating Report Execution and Delivery
Managing Report Security
Managing Report Execution
Delivering Reports with Subscriptions and Data Alerts
Troubleshooting Reporting Services
Lab: Implementing Report Subscriptions

Module 11: Delivering BI with SharePoint PerformancePoint Services
Introduction to SharePoint Server as a BI Platform
Planning Security for a SharePoint Server BI Solution
Planning for PerformancePoint Services
Lab: Implementing PerformancePoint Services

Module 12: Performing Predictive Analysis with Data Mining
Overview of Data Mining
Using the Data Mining Add-in for Excel
Creating a Custom Data Mining Solution
Validating a Data Mining Model
Connecting to and Consuming Data Mining Data
Lab: Using Data Mining to Support a Marketing Campaign

Wdrażanie i konfiguracja Windows 10 w środowisku domenowym

21.08.2023 - 25.08.2023

MS-55341 Installation, Storage, and Compute with Windows Server (dawniej MS-20740)

21.08.2023 - 25.08.2023

MS-55337 Introduction to Programming

26.06.2023 - 30.06.2023

MS-55238 SharePoint Online for Administrators

20.04.2023 - 21.04.2023

MS-55244 Javascript for Developers (dawniej MS-20480)

26.06.2023 - 30.06.2023

MS-55320 Programming with HTML, CSS, and JavaScript (dawniej MS-20480)

04.09.2023 - 08.09.2023

MS-55348AC Administering Microsoft Endpoint Configuration Manager (dawniej MS-20703-1)

21.11.2022 - 25.11.2022

MS-55349 Networking with Windows Server 2016 (dawniej MS-20741)

26.06.2023 - 30.06.2023

PL-300 Microsoft Power BI Data Analyst

19.06.2023 - 21.06.2023

AZ-801 Configuring Windows Server Hybrid Advanced Services

21.08.2023 - 24.08.2023

AZ-800 Administering Windows Server Hybrid Core Infrastructure

19.06.2023 - 22.06.2023

DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB

19.06.2023 - 22.06.2023

ASP.NET MVC Core

04.09.2023 - 08.09.2023

SQL SERVER – WYSOKA DOSTĘPNOŚĆ

19.06.2023 - 23.06.2023

AZ-305 Designing Microsoft Azure Infrastructure Solutions

19.06.2023 - 22.06.2023

AZ-030 Microsoft Azure technologies for AWS architects

28.08.2023 - 31.08.2023

AZ-020 Microsoft Azure solutions for AWS developers

26.06.2023 - 28.06.2023

DP-090 Implementing a Machine Learning Solution with Microsoft Azure Databricks

23.06.2023 - 23.06.2023

PL-400 Microsoft Power Platform Developer

19.06.2023 - 23.06.2023

PL-600 Microsoft Power Platform Solution Architect

04.09.2023 - 06.09.2023

PL-200 Microsoft Power Platform Functional Consultant

28.08.2023 - 31.08.2023

PL-100 Microsoft Power Platform App Maker

04.09.2023 - 06.09.2023

AZ-220 Microsoft Azure IoT Developer

19.06.2023 - 22.06.2023

WS-050 Migrating Application Workloads to Azure

28.08.2023 - 29.08.2023

AZ-600 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub

28.08.2023 - 31.08.2023

AZ-040 Automating Administration with PowerShell

21.08.2023 - 25.08.2023

AZ-700 Designing and Implementing Microsoft Azure Networking Solutions

19.06.2023 - 21.06.2023

MS-55215 SharePoint Online Power User

19.06.2023 - 22.06.2023

DP-080 Querying Data with Microsoft Transact-SQL

26.06.2023 - 27.06.2023

DP-203 Data Engineering on Microsoft Azure

19.06.2023 - 22.06.2023

AZ-140 Configuring and Operating Microsoft Azure Virtual Desktop

21.08.2023 - 24.08.2023

AI-102 Designing and Implementing a Microsoft Azure AI Solution

21.08.2023 - 24.08.2023

SC-900 Security, Compliance, and Identity Fundamentals

26.06.2023 - 26.06.2023

SC-200 Microsoft Security Operations Analyst

28.08.2023 - 31.08.2023

SC-300 Microsoft Identity and Access Administrator

04.09.2023 - 07.09.2023

SC-400 Microsoft Information Protection Administrator

19.06.2023 - 20.06.2023

MS-55300 Microsoft Teams for End Users

26.06.2023 - 26.06.2023

MS-55133 PowerShell for System Center Configuration Manager Administrators

19.06.2023 - 21.06.2023

MS-10984 Deploying and Managing Office 365 Hybrid Deployments

21.08.2023 - 23.08.2023

DP-300 Administering Microsoft Azure SQL Solutions

26.06.2023 - 29.06.2023

MS-203 Microsoft 365 Messaging

28.08.2023 - 01.09.2023

DP-900 Microsoft Azure Data Fundamentals

23.06.2023 - 23.06.2023

WS-012 Windows Server 2019 Hybrid and Azure IaaS

28.08.2023 - 30.08.2023

MS-55371 Windows Server Administration (dawniej WS-011)

28.08.2023 - 01.09.2023

AZ-304 Microsoft Azure Architect Design

28.08.2023 - 31.08.2023

AZ-303 Microsoft Azure Architect Technologies

21.08.2023 - 25.08.2023

MS-050 SharePoint Hybrid Deployment and Migration

26.06.2023 - 30.06.2023

AI-900 Microsoft Azure AI Fundamentals

23.06.2023 - 23.06.2023

AZ-400 Designing and Implementing Microsoft DevOps solutions

26.06.2023 - 29.06.2023

MS-500 Microsoft 365 Security Administration

28.08.2023 - 31.08.2023

AZ-104 Microsoft Azure Administrator

26.06.2023 - 29.06.2023

DP-070 Migrate Open Source Data Workloads to Azure

01.09.2023 - 01.09.2023

AZ-204 Developing Solutions for Microsoft Azure

26.06.2023 - 30.06.2023

PL-900 Microsoft Power Platform Fundamentals

01.09.2023 - 01.09.2023

MS-10990 Analyzing Data with SQL Server Reporting Services

21.08.2023 - 25.08.2023

MS-10988 Managing SQL Business Intelligence Operations

28.06.2023 - 30.06.2023

DP-060 Migrate NoSQL workloads to Azure Cosmos DB

30.06.2023 - 30.06.2023

DP-050 Migrate SQL workloads to Azure

19.06.2023 - 20.06.2023

MS-700 Managing Microsoft Teams

26.06.2023 - 29.06.2023

MS-600 Building applications and solutions with Microsoft 365 core services

26.06.2023 - 30.06.2023

AZ-010 Azure Administration for AWS SysOps

28.08.2023 - 29.08.2023

MS-55354 Administering Office 365 (dawniej MS-030)

26.06.2023 - 30.06.2023

AZ-500 Microsoft Azure Security Technologies

28.08.2023 - 31.08.2023

DP-100 Designing and Implementing a Data Science Solution on Azure

21.08.2023 - 23.08.2023

MS-55039 Windows PowerShell Scripting and Toolmaking

21.08.2023 - 25.08.2023

MD-101 Managing Modern Desktops

26.06.2023 - 30.06.2023

MD-100 Windows Client

19.06.2023 - 23.06.2023

MS-900 Microsoft 365 Fundamentals

19.06.2023 - 19.06.2023

AZ-900 Microsoft Azure Fundamentals

31.08.2023 - 01.09.2023

MS-10987 Performance Tuning and Optimizing SQL Databases

26.06.2023 - 29.06.2023

MS-101 Microsoft 365 Mobility and Security

19.06.2023 - 23.06.2023

MS-100 Microsoft 365 Identity and Services

26.06.2023 - 30.06.2023

MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014

SQL Server 2012/2014

07.09.2020 - 11.09.2020

MS-20466 Implementing Data Models and Reports with SQL Server 2014

SQL Server 2012/2014

26.06.2023 - 30.06.2023

MS-20465 Designing Solutions for Microsoft SQL Server 2014

SQL Server 2012/2014

28.06.2023 - 30.06.2023

MS-20464 Developing Microsoft SQL Server 2014 Databases

SQL Server 2012/2014

21.08.2023 - 25.08.2023

MS-10986 Updating Your Skills to SQL Server 2016

SQL Server 2016

28.08.2023 - 30.08.2023

MS-55315 Introduction to SQL Databases (dawniej MS-10985)

SQL Server 2012/2014

04.09.2023 - 06.09.2023

MS-10994 Data Analysis Fundamentals using Excel

SQL Server 2016

31.08.2023 - 01.09.2023

MS-20779 Analyzing Data with Excel

SQL Server 2016

21.06.2023 - 23.06.2023

MS-55345 Implementing and Managing Windows 11 (dawniej MS-20697-1)

Windows 10

26.06.2023 - 30.06.2023

MS-55342 Supporting and Troubleshooting Windows 11 (dawniej MS-10982)

Windows 10

26.06.2023 - 30.06.2023

MS-55200 SharePoint 2016 Power User Training

SharePoint 2016

31.08.2023 - 01.09.2023

MS-55199 SharePoint 2016 End User Training

SharePoint 2016

26.06.2023 - 28.06.2023

MS-20745 Implementing a Software-Defined DataCenter

System Center

04.09.2023 - 08.09.2023

MS-10997 Office 365 Administration and Troubleshooting

Office 365

04.09.2023 - 06.09.2023

MS-55313 Administering Configuration Manager, Part I: Fundamentals and Asset Management (część MS-20703-1 oraz MS-55348- podstawy)

System Center

28.08.2023 - 30.08.2023

MS-55247 Designing and Implementing Cloud Data Platform Solutions

19.06.2023 - 21.06.2023

MS-20487 Developing Windows Azure and Web Services

Programowanie

21.08.2023 - 25.08.2023

MS-20486 Developing ASP.NET MVC 4 Web Applications

Programowanie

28.08.2023 - 01.09.2023

MS-55339 Programming in C# (dawniej MS-20483)

Programowanie

26.06.2023 - 30.06.2023

MS-55319 HTML5 and CSS (dawniej MS-20480)

Programowanie

19.06.2023 - 23.06.2023

MS-55318 Advanced Automated Administration with Windows PowerShell (dawniej MS-10962)

MCSA

28.06.2023 - 30.06.2023

MS-55154 Office 365 for the End-User

Office 365

01.09.2023 - 01.09.2023

MS-55179 Advanced Microsoft Outlook 2016

26.06.2023 - 26.06.2023

MS-55178 Introduction to Microsoft Outlook 2016

23.06.2023 - 23.06.2023

MS-55177 Advanced Microsoft PowerPoint 2016

PowerPoint 2016

01.09.2023 - 01.09.2023

MS-55176 Introduction to Microsoft PowerPoint 2016

PowerPoint 2016

21.08.2023 - 21.08.2023

MS-55167 Advanced Microsoft Excel 2016

Excel 2016

26.06.2023 - 26.06.2023

MS-55166 Intermediate Microsoft Excel 2016

Excel 2016

19.06.2023 - 19.06.2023

MS-55165 Introduction to Microsoft Excel 2016

Excel 2016

23.06.2023 - 23.06.2023

MS-55175 Advanced Microsoft Word 2016

Word 2016

28.08.2023 - 28.08.2023

MS-55174 Intermediate Microsoft Word 2016

Word 2016

01.09.2023 - 01.09.2023

MS-55173 Introduction to Microsoft Word 2016

Word 2016

28.08.2023 - 28.08.2023

MCSA: Windows Server 2016 (wzbogacony o elementy Windows Server 2019) – online

MCSA

MS-20768 Developing SQL Data Models

SQL Server 2016

26.06.2023 - 28.06.2023

MS-55321 SQL Server Integration Services (dawniej MS-20767)

SQL Server 2016

19.06.2023 - 23.06.2023

MS-20334 Core Solutions of Skype for Business 2015/2019

Skype for Business 2015

26.06.2023 - 30.06.2023

MS-20744 Securing Windows Server 2016

Windows Server 2016

26.06.2023 - 30.06.2023

MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager

System Center

19.06.2023 - 23.06.2023

MS-55004 Installing and Configuring System Center 2012 Operations Manager

System Center

26.06.2023 - 30.06.2023

MS-20765 Provisioning SQL Databases

SQL Server 2016

28.08.2023 - 01.09.2023

MS-55316 Administering a SQL Database (dawniej MS-20764)

SQL Server 2016

19.06.2023 - 23.06.2023

MS-20762 Developing SQL Databases

SQL Server 2016

26.06.2023 - 30.06.2023

MS-20761 Querying Data with Transact-SQL

SQL Server 2016

26.06.2023 - 30.06.2023

MS-55343 Networking with Windows Server (dawniej MS-20741)

Windows Server 2016

28.08.2023 - 01.09.2023

MS-55324 Installation, Storage, and Compute with Windows Server 2016 (dawniej MS-20740)

Windows Server 2016

26.06.2023 - 30.06.2023

MS-55344 Identity with Windows Server (dawniej MS-20742)

Windows Server 2016

19.06.2023 - 23.06.2023

MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016/2019

Exchange Server 2016/2019

19.06.2023 - 23.06.2023

MS-20345-1 Administering Microsoft Exchange Server 2016/2019

Exchange Server 2016/2019

26.06.2023 - 30.06.2023

MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016

Windows Server 2016

26.06.2023 - 30.06.2023

MS-10972 Administering the Web Server (IIS) Role of Windows Server

Windows Server 2012/2012R2

17.07.2023 - 21.07.2023

MS-10967 Fundamentals of a Windows Server Infrastructure

Windows Server 2012/2012R2

26.06.2023 - 30.06.2023

MS-10969 Active Directory Services with Windows Server

Windows Server 2012/2012R2

19.06.2023 - 23.06.2023

Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune

Microsoft Azure / Office 365 / Windows Intune

19.06.2023 - 21.06.2023

Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016

Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016

26.06.2023 - 30.06.2023

Bezpieczeństwo w środowiskach Windows Client oraz Windows Server

Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016

23.08.2023 - 25.08.2023

Podstawy bezpieczeństwa w środowiskach Microsoft

Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016

19.06.2023 - 21.06.2023

MS-10961 Automating Administration with Windows PowerShell

MCSA

26.06.2023 - 30.06.2023

MS-20463 Implementing a Data Warehouse with Microsoft SQL Server

SQL Server 2012/2014

28.08.2023 - 01.09.2023

MS-20462 Administering Microsoft SQL Server Databases

SQL Server 2012/2014

19.06.2023 - 23.06.2023

MS-20461 Querying Microsoft SQL Server

SQL Server 2012/2014

19.06.2023 - 23.06.2023