Power BI

Course Details

Detailed Syllabus

Introduction to Power BI

• What is Business Intelligence (BI)?
• Understanding Data Analytics
• What is Power BI?
• What is Power BI Desktop?
• What is Power BI Service?
• Power BI Pricing
• Building Blocks - Data Models, Reports and Visuals, Workspaces, and Dashboards
• Flow of Power BI

Getting started with Power BI Desktop and Power BI Service

• How to install Power BI Desktop
• Components of Power BI Desktop - Ribbons, Different Views, Pages, Visualizations and Fields panes
• Loading data/Importing data
• Understanding Data Model
• Building a report with Visuals
• Publishing report to Power BI Service
• Creating a free account
• Logging into Power BI Service
• Creating Workspace
• Creating Dashboard
• Pinning report to Dashboard
• Sharing report with others

Retrieving data

• Understanding Connectors
• Retrieving data from different sources
• Getting data from files and folders
• Getting data from databases like SQL Server
• Getting data from other sources like Web and REST API
• Understanding Storage Modes – Import, DirectQuery

Building Data Model

• What is Data Model - Semantic Model?
• Understanding Fact and Dimension tables
• How to convert Flat Schema to Star Schema
• How to convert Star Schema to Snowflake Schema
• Selecting tables and columns
• Specifying table and column properties - metadata
• Creating new calculated columns based on DAX (Data Analysis Expressions)
• Creating Measures
• Using Quick Measures
• Calculated columns vs. Measures
• Creating Calculated Tables
• Creating relationships between tables
• Creating Date tables and role-playing dimensions
• What is the difference between Active and Inactive relationship
• Understanding Cross-filter and Cross-highlighting
• Defining cardinality and cross-filter direction of relationship
• Creating hierarchies
• Performance issues to be considered while modelling data

Clean, Transform and Load Data

• Filling data up and down
• Using Power Query Editor
• Understanding M Language
• Working with Applied Steps
• Column Profiling
• Replacing null values
• Replacing invalid values
• Changing column names
• Changing data types of columns
• Removing duplicate rows
• Splitting columns
• Merging columns
• Deleting unnecessary rows and columns
• Applying auto update with AI
• Transpose, Pivot and Unpivot data
• Grouping data
• Merging and Appending tables
• Using Parameters

Data Analaysis Expressions (DAX)

• DAX Formula
• DAX Operators
• How to reference tables, columns and measures
• Using variables in DAX
• Implicit vs. Explicit measures
• Types of measures - additive and non-additive
• Understanding Evaluating Context - Row Context and Filter Context
• Aggregation functions
• Date and Time Functions
• Logical Functions
• Filter Functions
• Information Functions
• Relationship Functions
• Table Manipulation Functions
• Text Functions
• Time Intelligence Functions
• Iterator Functions

Building Reports

• Working with Bar and Column Chars
• Working with Stacked Column and Bar Chars
• Working with Line Charts
• Working with Area Chart
• Pie and Doughnut Chart
• Working with Combination Charts
• Ribbon, Waterfall and Funnel charts
• Working with Map visuals
• Using Table and Matrix visuals
• Gauge and KPI charts
• Using tooltips
• Formatting data and titles
• Styling the report
• Working with Colors
• Apply filtering
• Creating and using Slicers
• Conditional Formatting
• Report Page formatting
• Using Elements – textbox, images, shapes etc.
• Ordering items on the report (Z-Order)
• Drill through reports
• Drill-down reports
• Working with Analyses tab to create different lines
• Creating what-if reports

Working with Power BI Service

• Creating and using workspace
• Creating Dashboard and Tiles
• Editing details of a Tile
• How to pin reports to Dashboard
• Using Q&A feature
• Using quick insights
• Showing usage metrics and linage
• Sharing dashboard with others
• Using Focus mode
• Understanding Power BI Apps
• Configure Data Alerts
• Applying Dashboard Theme
• Subscribing to Dashboard