Power BI Introduction

1. 1. What is BI

   2. What is Power BI

   3. Architecture of Power BI

   4. Download the tool from Website

   5. Download the tool from Office Store

   6. Power BI Vs Tableau Vs Qlikview

   7. Different Power BI Products

   8. Different tools in Power BI

Power Query – Introduction

1. 1. 1. How to import data into Power Query from Excel file?

      2. How to import data into Power Query from CSV file?

      3. How to import data into Power Query from Text file?

      4. How to import data into Power Query from MS Access file?

      5. Loading data from Power Query back to Excel sheet

      6. What happens to Power Query data when output changes?

Power Query – Data Transformation

1. 1. How Rename, add, split, merge, sort, unpivot columns inside Power Query

   2. How to keep or remove – empty / duplicate rows, define header row, filter rows?

   3. How to perform left, right, mid, len formulas on Text data inside Power Query

   4. How to perform addition, subtraction, multiplication, division inside Power Query?

   5. How to get date related information like Day name, month name, Year, Quarter, etc.?

   6. Writing conditional IF type formulas inside Power Query using user interface.

Power Query – Working on data from multiple sources

1. 1. No more manual copy and paste to append data from multiple sheets, files, etc.

   2. What does it means to Duplicate or reference a Power Query

   3. Working with ALL files stored in a folder

   4. Creating dynamic inventory of all the files stored in a folder.

   5. Workaround for issue while sharing files with Power Query

Power Query – I have stopped using VLOOKUP function – want to know why?

1. 1. Limitation of VLOOKUP and how to overcome them

   2. Use Six different type of Joins as alternative to VLOOKUP

   3. Perform complex CROSS join of multiple dataset with NO common field

Power Query – Apply the knowledge gained to real world datasets

1. 1. How to convert multiple year financial data converted to tabular format

   2. How to transform monthly payroll data for 1000s of employee with simple click of button

   3. You data stacked up one above another – no worries Power Query is there for you

   4. No more manually applying multiple items in filter drop downs

Power Query – Advanced

1. 1. Conditional Column

   2. Column from Examples

   3. Getting Data from Web

   4. Create Table from Examples

   5. Get data from PDF into Tables in Power Query

Power Query – M functions

1. 1.  Date Functions (Approx 30 functions)

   2. Number Functions ( 20+ Functions)

   3. Text Functions (20+ Functions)

   4. Logical Functions (5 + Examples)

   5. Other Functions

Power View – Introduction

1. 1. What is Power View in Power BI?

   2. Using Power BI Desktop Tool – Options

   3. Report Visuals, Fields, Pages and Filters

   4. Report, Data and Relationship Options

   5. Working with Visualizations and PBI Canvas

   6. Working with Enter Data, Get Data Options

   7. Enter Data from Excel Files, Basic Reports

   8. PBIX and PBIT File Formats. Differences

   9. Designing Simple / Basics Reports in PBI

   10. Visual Interactions in Power BI – Options

   11. Spotlight Options with Visuals, Real-time Use

   12. VIEW Options with Power BI Desktop Tool

   13. Web View and Mobile View Options, Scaling

   14. Table Visual and GRID Options for Display

Power View- Hierarchies

1. 1. Grouping and Binning with Fields

   2. Bin Size and Biz Limits (Max, Min)

   3. Creating Hierarchies. DrillDown Reports

   4. Drill Thru Reports and Conditional Filters

   5. Expand, Expand All Down, Goto Next Level

   6. Drill Up, Drill Down. Exclude & Include

   7. See Data, Export Data, See Records Options

   8. Filters : Types and Usage in Real-time

   9. Visual Filters, Page Filters, Report Filters

   10. Drill-thru Filters with Hierarchy Levels

   11. Basic, Advanced, TOP N Filters – Usage

   12. Filtering at Category Level, Summary Level

   13. Import and Direct Query with Power BI

Power View – Visuals

1. 1. Power BI Visualizations and Types

   2. Fields, Formats and Analytics Options

   3. Table Visuals and Properties, Filters

   4. Data Bar and Data Scaling Options

   5. Divergent Colors and Data Labelling

   6. Conditional Formatting, Grid Lines

   7. Matrix : Sub Totals, Drilldown Options

   8. Row Groups and Column Groups in Matrix

   9. Slicer – Single Select and Show All

   10. Chart Reports – Types, Common Properties

   11. Axis, Legend, Value and Tooltip Options

   12. Stacked Bar Chart, Clustered Column Chart

   13. Stacked Bar Chart, Stacked Column Chart

   14. Clustered Bar Chart : Properties, Use

   15. Clustered Column Chart : Properties

   16. 100% Stacked Bar and Column Charts

   17. Data Label Properties, Legend Properties

Power View – Advanced Visualization

1. 1. Line Chart, Area Chart Properties, Usage

   2. Stacked Area Chart – Properties, Usage

   3. Line and Stacked Column Charts Usage

   4. Line and Clustered Column Chart Usage

   5. Visual Fields, Shared Axis, Legend

   6. Column Series and Column Axis in Lines

   7. Join Types, Lines: Round, Bevel, Miter

   8. Shapes and Markers in Power BI Visuals

   9. X Axis, Y Axis Properties, Plot Area

   10. Series, Custom Series and Legends

   11. Ribbon Chart – Properties, Line Width

   12. Match Series and Plot Area Options

   13. Waterfall Chart – Sentiment Colors

   14. Breakdown Count – Decrease / Increase

   15. Scatter Chart – Play Area and Axes

   16. Axis Values, Color Saturation, Legend

   17. Line and Donut Charts – Properties

Power View – Supporting Elements for Visualization

1. 1. Data Point and Series Limitations

   2. Tree Map, Funnel and Gauge Reports

   3. Group and Values in Tree Map Visuals

   4. Max Values and Goal Indicators

   5. Single Row Card and Multi Row Cards

   6. Non-Interactive Visuals in MultiRow

   7. Callout Values in KPI Reports and Use

   8. Indicator, Trend and Target Goals in KPIs

   9. Map Reports and Filled Map Reports

   10. ArcGIS Maps – Latitudes and Longitudes

   11. Using Buttons, Images in Power BI Canvas

   12. Bookmarks in Power BI Desktop – Usage

   13. Using Bookmarks with Buttons, Actions

   14. Using Bookmarks for Visual Filters

   15. Using Bookmarks for Page Navigations

   16. Using Selection Pane with Bookmarks

   17. Buttons, Images in Power BI Desktop

Power BI Service – Cloud

1. 1. POWER BI CLOUD (OPS)

   2. Power BI Service (Cloud) Architecture

   3. App Workspace Creation in Real-time

   4. Publish Reports from Power BI Desktop

   5. Reports, Datasets in Power BI Cloud

   6. Creating Dashboards and Realtime Use

   7. Pin Visuals and Pin LIVE Report Pages

   8. Dashboard Creation with Tiles, Media

   9. Tiles – Images, Web Content, Chapters

   10. Subscriptions, Insights and Refresh

   11. Metrics, Distribution Methods, Actions

   12. Favorites, Shares, Dashboard Themes

   13. Performance Inspector and QR Codes

   14. Dataset Actions – Report Creation Options

Power Pivot – Introduction

1. 1. Importing Data

   2. Importing Data into Power Pivot

   3. Importing Data from Relational Databases

   4. Importing Data from Text Files

   5. Reusing Existing Connections to Update the Model