Traning

Power BI module

1.   Introduction to Power BI

1.1.   Introduction to Power BI desktop

1.2.   Connect to a database

1.3.   Basic information

1.3.1.Managing query groups

1.3.2.Splitting columns

1.3.3.Changing data types

1.3.4.Working with dates

1.3.5.Removing or reordering columns

1.3.6.Conditional columns

1.4.   Connect to files in a folder

1.4.1.Merge queries

1.4.2.Query dependency view

1.5.   Data transformation

1.5.1.Enter data

1.5.2.Query parameters

2.   Data modeling

2.1.   Introduction to modeling data

2.2.   Create calculated columns

2.3.   Model optimization

2.3.1.Quick measures

2.4.   Create calculated measures

2.4.1.Data hierarchies

2.5.   Create calculated tables

2.5.1.Time intelligence

2.5.2.Insert a new data table

2.5.3.Include/exclude

2.5.4.Grouping and binning

3.   Introduction to visuals in Power BI

3.1.   Create and format visualization

3.1.1.Hierarchical axis and concatenating

3.1.2.Filters, including top N

3.2.   Combo charts

3.2.1.Forecasting

3.2.2.Clustering data (and machine learning)

3.3.   Slicers

3.3.1.See the data behind the visuals

3.3.2.Data slicers

3.4.   Map visualization

3.4.1.ESRI map

3.5.1.Table styles

3.6.   Create and format scatter plot

3.7.   Waterfall and funnel charts

3.8.   Gauge, cards and KPIs

3.8.1.Coloring charts

3.9.   Static images: shapes, text boxes and images

3.9.1.Grid lines and snap to gridlines

3.10. Page view and page size settings

3.10.1.  Visual interactions

3.10.2.  Duplicate and rename a page

3.10.3.  Show categories with no data

3.10.4.  Show all, default summarization and default categorization

3.10.5.  Positioning, sorting and aligning and sorting visuals

3.10.6.  Creating and working with hierarchies

3.10.7.  Integrate Power BI with R

4.   Introduction to Power BI service

4.1.   Overview of dashboards and Power BI service

4.2.   Publish report to the Power BI service

4.2.1.Get insights

4.3.   Pin a tile on a dashboard

4.3.1.Add widgets to dashboards

4.3.2.Navigating content in Power BI service

4.3.3.Filter the list of dashboards in navigation panel

4.3.4.Dashboard settings

4.4.   Intro to Power BI and natural language query

4.4.1.Q&A feature

4.5.   Sharing a dashboard

4.5.1.Power BI Mobile app-windows, ipad and iphone

4.5.2.Display dashboard and report tiles in a focus mode

4.5.3.Pin a live page to dashboard

4.5.4.Customize dashboard tiles

4.5.5.Dashboard display option

4.5.6.Share, print and export a dashboard

4.5.7.Export data to csv and excel

4.5.8.Export to PowerPoint

4.6.   Power BI notifications

4.6.1.Alerts in the Power BI service

4.6.2.Power BI flow integration

4.6.3.Power BI email subscriptions

4.7.   Install and configure personal gateway

4.7.1.Publish to web

4.7.2.Admin portal

5.   Introduction to Excel data in Power BI