Microsoft Power Bi training course

Scope

Topic                                                                              

Introduction

1. Introduction to Power BI and Power BI Products. Also, pricing of Power BI
2. Installing Power BI desktop and sign-in to Power BI app service from Desktop

DesktopApp Service

1. Explore the Power BI Desktop panels
2. Options window (left to Home Menu)            ii. Top Ribbon with different data sources
3. Left side vertical panel                                       iv.Right side vertical panels (Visualizations, Fields)

Data Cleansing

1. Explore all the data sources and connecting to excel file, text file, folder source, sql server database
2. What is Load and edit?  Can we do edit after loading to the model?
3. HOME ribbon

I) Choose & Remove columns    ii) Keep & remove rows iii) Remove duplicates & Error rows

iv) Sorting       v) Split column (by delimiter / by no. of characters)   vi) Group by    vi) data type change

vii) First row as headers   viii) Replace values     ix) Merge queries & Append Quires

Transform ribbon

i) Transpose, Reverse and Count Rows           ii) Fill          iii) Pivot and Un-pivot     iv) Format

      v) Merge columns and Extract   vi) statistics / standard/ Scientific / Trigonometry / Round/ Information

     vi) Date/ Time / Duration

Add Column ribbonà Add Custom columns / Index column

View ribbon

i) Query settings  ii) Advanced editor iii) Formula bar (M-Query)

iv) Mono spaced v) Show whitespace

Left / RightPanels

i) Left side vertical panel (Queries)à Table and options

       ii) Left side vertical panel (Query settings)à Properties and Applied steps with gear icons

1. How to load the cleansed and transformed data to the data model (Close and Apply option)?

Data Modelling

1. What is relationship window and Data window from Left side vertical panel
2. Relationship window à Explore Table properties and Field properties

& manage relationships from ribbon

Data windowà Explore the field properties from the right side vertical panel (Fields)

                                    Difference between new measure & New columns

1. Create multiple measures and columns with DAX functions

Reports

1.  What is reports windows from Left side vertical panel and explore the options of reports window
2. Top ribbon with report options à New page, visuals, Text box, image, shapes and page view
3. Right side panel(Fields options) àRename, hide/Unhide, delete, Hierarchy and filters

              (Visualizations) àaround 25+ styles with formatting options

1. Different report styles and apply formatting options
2. Table, Matrix, Card, Multi row card,
3. Bar charts, Line charts
4. Dual style charts (Line and bar)
5. Pie charts, Donut charts, Tree maps and geographical maps (Globe and Filled Map)
6. Scatter plot, Funnel, Gauge, KPI and Slickers.
7. R based charts
8. After adding 4 visuals to page, explore the below options
9. Ribbon (Home)   à Format painter 
10. Ribbon (Format) àEdit interactions, Align, distribute and bring forward, send backward
11. Visual optionsà Focus mode, sort by, export data
12. How to create drilldown charts?
13. How to publish the files Power BI App service and what are the options while publishing?
14. Explore Power BI App service window with top ribbon and panels
15. Top black ribbonà 1. Full focus mode with print option while in focus mode option

                                   2. Gear iconàContent packs, settings, gateways, Dev tools and embed code

                                   3. Downloads, support, feedback and account info

      ii. white ribbon under black ribbonà 1. Add widget (Web content, image, video and Textbox)

                                                                          2. Share

                                                                          3. … à Duplicate / print / refresh/ featured dashboard

    iii. question bar below white ribbonà provide business question, answered in a report format

    iv. Left side ribbon (from bottom)à

1. Datasets:  Explore data set options

Gateways

1. Types of gateways and what are those?
2. refresh the data from on-premise to Cloud App service

Help

Help Links

1. Power Bi Desktop help -

https://support.powerbi.com/knowledgebase/articles/567183-power-bi-designer-help

1. Power Bi Get started-

https://support.powerbi.com/knowledgebase/topics/63037-getting-started

1. Power Bi- General updates (GA) for every month -http://blogs.msdn.com/b/powerbi/archive/2015/09/23/44-new-features-in-the-power-bi-desktop-september-update.aspx
2. Power Bi Software links-https://powerbi.microsoft.com/downloads
3. Power BI Blog-http://blogs.msdn.com/b/powerbi/
4. Power BI on-premises third party hosting 

http://www.futurepointtech.com/microsoft-power-bi-training.html