Power BI Roadmap
Chapter 1: Introduction to Power BI
- Power BI Introduction
- Power BI Products
- Components of Power BI Desktop
- Power BI Service
- Gateways
- Power BI Mobile
- Role of Azure & Office 365 in Power BI
- Power BI Installation and its Prerequisites
Chapter 2: Power Query
- Overview of Power Query Editor
- How to open Power Query Editor
- Connecting to different Data Sources like Excel, SharePoint, SQL, etc.
- Different Connection Modes
- Data Transformation in Power Query using GUI options
- Advanced Editor using M Query
- Query Dependencies
- Different Tabs in Power Query (Home, Transform, Add Column, View, Tools & Help)
- Applied Steps & Query Dependencies
Chapter 3: Power Pivot and Data Modeling
- Understanding Power Pivot
- Data Modeling Concepts
- Star Schema, Snowflake Schema
- Dimension Table, Fact Table
- Cardinality and its types
- Cross Filter Directions
- Measures, Calculated Columns & Calculated Tables
- Advanced options in Power Pivot
Chapter 4: Power View and Visualization
- Understanding Power View
- Fields Pane, Visualization Pane, Filter Pane
- Filters and its types
- Drill Down & Drill Through
- Row Level Security
- Visual Interactions
- Mobile view
- Hierarchy
- Different Visuals, Purpose & Usage
- Custom Visuals
- Performance Analyzer
Chapter 5: Advanced Visualization and Features
- Power Map
- Tool Tips & Custom Tool Tips
- Grouping
- Bookmarks, Selection pane & Buttons
- Publish
- Format Tools
- Column Tools
Chapter 6: Power BI Service and Administration
- Introduction to Power BI Service
- Power BI Cloud Architecture
- Power BI licenses and its Types
- My Workspace & Project Workspaces
- Workspace level Access
- Report level Permissions
- Dashboard
- Datasets
- Dataflows and its Types
- Report Actions
- Dataset Actions
- Security
- On-demand & Schedule Refreshes
- App Creation
- Favourites
- Deployment Pipelines
- Permission to SG
- Data Source Settings
- Admin Portal and objects of Admin Portal
- Creating Security Groups in Office 365
- Assigning Licenses
- Understanding Gateways
- Types of Gateways
- Installation
- Adding or Removing Sources and Users