PB304: Advanced Power BI

PB304: Advanced Power BI

Duration: 12~15 hours

1)     Power Pivot

Power Pivot is an Excel 2013 add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

In both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.

2)     Power View

Power View is Microsoft’s new, visually-focused self-service BI (Business Intelligence) tool. Power Views can distill complex information into easy to understand graphics that are highly flexible, highly interactive, and highly engaging. Users can easily dig deeper into areas of interest, and even boring data can be made engaging. Power Views are available in three platforms, including Excel 2013, SharePoint 2013 Business Intelligence Site, and SharePoint Office 365 Site. Functionality varies depending upon the platform. This Power View course covers the Excel 2013 platform, and can be attended without attending any of our other PowerPivot courses. Topics covered include creating Power Views embedded in Excel workbooks, and using advanced Power View techniques.

3)     Power Query

Microsoft Power Query for Excel provides an intuitive user interface for data discovery, data transformation and enrichment. With the Power BI for Office 365 edition, you can share and manage queries as well as search data within your organization. For more information about how to share queries, see Share Queries.

4)     Power Map

Microsoft Power Map for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways. A power map lets you discover insights you might not see in traditional two-dimensional (2-D) tables and charts.

 

Course Content

Power Pivot

Import data from different sources

Create tables

Edit data in a table

Create relationships between tables

Create calculations

Create hierarchies

Create key performance indicators (KPIs)

Create perspectives

Create PivotTables and PivotCharts

Enhance a model for Power View

Use Visual Basic for Applications (VBA)

Group data

SharePoint integration

Shaping Reports

Evaluation Contexts and CALCULATE

Using DAX as a Query Language

Advanced DAX techniques

DAX Patterns

Power View

PowerPivot Data using Power View
What is Power View?
Creating a Power View
Filtering a Power View
Power View Drill Down
Understanding Power View
Understanding Power View Reports
Understanding Table Views
Tile By & Map Features
Multipliers
Creating Effective Views
Creating Power View Data Models
Understanding Drill-through
Power View Metadata
Understanding Drill-through
Managing Power Views
Designing considerations
Creating Power View Templates
Design Limitations

 

Power Query

Getting Started

Import data from external data sources

Shape data

Add a query to an Excel worksheet

Combine data from multiple data sources

Search data

Using the Query Editor

Introduction to the Query Editor

Modify a formula

Edit query step settings

Refresh a query

Filter, sort, and group data

Shape data in a query

Shape or transform a query

Remove duplicates

Remove rows with errors

Privacy Levels

Working with columns

Insert a custom column into a table

Aggregate data from a column

Merge columns

Promote a row to column headers

Remove columns

Rename a column

Replace values

Split a column of text

Unpivot columns

Combine data from related queries

Combine multiple queries

Merge queries

Append queries

Drill down into a related table

Expand a column containing a related table

Advanced queries

Create an advanced query

Power Query formula categories

Power Map

Explore your data in a Power Map tour

Geocode your Power Map data

Move around in Power Map

Visualize your data in Power Map

Change the look of your Power Map

Create a custom map in Power Map

Add or move a scene in a Power Map tour

Filter data in a Power Map tour

Change Power Map time options

Export a Power Map tour as a video