Course Content
Module 1: Power BI Basics
- Power BI Terminology, Features and Release History
- Power BI Components (Desktop, Power Query, Power Pivot, Service, Mobile App, Gateway, On-premises Report Server)
- Power BI Account Types (Free, Pro, Premium) and Installation
- Data Types in IT and Data Applications/Models/Systems (OLTP vs OLAP)
- OLAP vs. OLTP vs. Insights and Analytics
- Data Warehouse, Data Mart and differences
- Data Lake and Blob Storages
- Data Granularity
- Dimension, Dimension Table & types
- Fact, Fact Table & measures types
- Fact less fact table
- Star Schema, Snow Flake Schema, Galaxy Schema
Module 2: Data Modelling
- ER Model Relationships and Dimensional Model Relationships
- 1:1, 1: Many, Many: Many relationships
- Active, Inactive relationships
- Single and Bidirectional relationships
- Cross filtering relationship
- Role Playing dimension
- Tabular & Multi-dimensional model
- Data Warehousing concepts
- Get Data File Categories & Getting Data from Flat files, Excel, JSON, XML, Web pages, and Databases (Query, View, Procedures)
- Working with Import/Load and Direct Query, Connect Live modes
- Power BI Aggregations
- Power Query Menu (Home, Transform, Add Column, View, Help)
- Power BI Dataset and Field Properties, Queries Properties, and Column Properties
- Ribbon Options & Power BI Parameters
- Power BI Reusability & Power BI Mashup Language
- Using Blank Query and M-scripting knowledge
- Dynamic Query in Power BI
- Introduction to Power BI Report Builder
- Data types in Desktop and Query Editor
- Joins Concepts in Power BI
- Refresh, Enable Load, Functions, Grouping, Duplicate and Reference
- Power BI Sharing Methods (PBIX, PBIT, Datasets usage, Data flow usage)
- Power Desktop Menu (Home, View, Modeling, Help)
- Filters in Power BI (Visual, Report, Page, Drill through)
- Filters and Highlighting
- Buttons, Bookmarking, Slicer and Sync Slicers
- Row-Level Security and Dynamic Row-Level Security
- Drill down and drill through Implementation
- Report creation on top of Python Script
- Report creation on top of R Script
Module 3: DAX
- Major DAX functions covered based on real-time scenarios
Module 4: Power BI Service
- Power BI Service Intro, Workspace, Apps
- Dashboard creations, subscription, alert, content packs, Gateways
- Add users and provide roles
- Dataflows
- Publish workspace
- Sharing reports to app workspace
- Row Level Security
- Power BI Gateways and Configure Data Gateway (Personal and Standard)