Цель курса:
This course is designed to teach the participant how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI into graphs, charts, KPIs, reports, and other visualizations for use in their business. This course is lab example intensive.

Целевая аудитория:
The course is targeted towards business analysts, business intelligence developers, and reporting professionals.

После окончания курса Вы будете уметь:

• Navigate the Power View interface. 
• Utilize Power View reports. 
• Work with tables. 
• Understand aggregations. 
• Utilize matrix. 
• Configure drill through. 
• Use cards as a visualization. 
• Apply filters. 
• Create charts. 
• Utilize tiles. 
• Add slicers to reports. 
• Utilize themes. 
• Navigate the PowerPivot interface. 
• Load data. 
• Examine and configure relationships. 
• Configure calculated columns are calculated fields. 
• Create PivotTables. 
• Understand and utilize DAX. 
• Use KPIs. 
• Work with hierarchies. 
• Manage perspectives. 
• Navigate the Power Query interface.
• Load data.
• Filter data.
• Merge datasets.
• Manage modifications.
• Perform data cleaning.
• Navigate the Power Map interface.
• Use Bing maps.
• Examine map data.
• Configure tours, scenes, and layers.
• Add time to a presentation.
• Navigate the Power BI interface.
• Utilize data sources.
• Understand querying with natural language.

Предварительная подготовка:
Для успешного освоения курса необходимы знания в объеме курса

• 20761: Querying Data with Transact-SQL

• Introduction 
• Course 
• Materials 
• Facilities 
• Prerequisites 
• What We'll Be Discussing

• Successfully log into their virtual machine. 
• Have a full understanding of what the course intends to cover.

• Exploring the Power View Interface 
• Visualizing Power View Reports 
• Working with Tables 
• Understanding Aggregations 
• Utilizing Matrix 
• Configuring Drill Through 
• Using Cards 
• Applying Filters 
• Creating Charts 
• Examining Tiles 
• Adding Slicers to Reports 
• Theming Reports

• Power View Interface 
• Working with Tables 
• Aggregations 
• Matrix 
• Drill Through 
• Cards 
• Filters 
• Charts 
• Tiles 
• Adding Slicers to Reports 

• Navigate the Power View interface. 
• Utilize Power View reports. 
• Work with tables. 
• Understand aggregations. 
• Utilize matrix. 
• Configure drill through. 
• Use cards as a visualization. 
• Apply filters. 
• Create charts. 
• Utilize tiles. 
• Add slicers to reports. 
• Utilize themes.

• Exploring the PowerPivot Interface 
• Loading Data 
• Examining Relationships 
• Configuring Calculated Columns and Calculated Fields 
• Creating PivotTables 
• Understanding DAX 
• Utilizing DAX Functions 
• Using KPIs 
• Working with Hierarchies 
• Managing Perspectives

• Introduction to the PowerPivot Interface 
• Importing Data 
• Importing Large Datasets 
• Importing Data with a Query 
• Creating Relationships 
• Creating a Cascading Relationship 
• Hiding Columns, Change Data Type, Sorting, and Filtering 
• Calculated Columns and Calculated Fields 
• KPIs 
• Hierarchies 
• Perspectives 

• Navigate the PowerPivot interface. 
• Load data. 
• Examine and configure relationships. 
• Configure calculated columns are calculated fields. 
• Create PivotTables. 
• Understand and utilize DAX. 
• Use KPIs. 
• Work with hierarchies. 
• Manage perspectives. 

• Exploring The Power Query Interface 
• Loading Data 
• Managing Modifications 
• Examining Data Cleaning

• Getting External Data 
• Data Filtering 
• Merging Datasets 

• Navigate the Power Query interface. 
• Load data. 
• Filter data. 
• Merge datasets. 
• Manage modifications. 
• Perform data cleaning.

• Exploring The Power Map Interface 
• Using Bing Maps 
• Examining Map Data 
• Reviewing Map Types and Presentation

• View Power Map in Action 
• Geocoding 
• Tours, Scenes, and Layers 
• Adding Time 

• Navigate the Power Map interface. 
• Use Bing maps. 
• Examine map data. 
• Configure tours, scenes, and layers. 
• Add time to a presentation.

• Introducing Power BI 
• Explaining Excel and Power BI 
• Examining Data Sources 
• Querying with Natural Language

• Introduction to Power BI 
• Data Sources 

• Navigate the Power BI interface. 
• Utilize data sources. 
• Understand querying with natural language.