Power BI Training

Microsoft Power BI is a leading business intelligence tool used by companies to turn raw data into interactive reports and dashboards. Data analyst and MIS roles increasingly ask for it. In this course at Aptech Fatehabad you learn the complete Power BI workflow: connecting to data from Excel, CSV and SQL Server, cleaning it with Power Query, building data models, writing DAX measures, and designing interactive reports that you publish and share in the Power BI Service. You finish by building a sales dashboard project from start to end.

Power BI Training Course Content

Introduction to Power BI

•     Business intelligence concepts
•     Power BI Desktop, Service and Mobile
•     Installing Power BI and the interface
•     The Power BI workflow: connect, transform, model, visualise, share

Getting Data

•     Connecting to Excel, CSV, SQL Server and web data
•     Import vs DirectQuery
•     Data source settings and refresh

Power Query

•     Power Query Editor
•     Cleaning and transforming data
•     Merge and append queries
•     Pivot and unpivot columns
•     Column from Examples
•     Introduction to M language

Data Modelling

•     Star schema: fact and dimension tables
•     Relationships and cardinality
•     Cross-filter direction
•     Date table
•     Hierarchies

DAX

•     Calculated columns vs measures
•     SUM, COUNT, AVERAGE and DISTINCTCOUNT
•     CALCULATE and filter context
•     Time intelligence: YTD, MTD, SAMEPERIODLASTYEAR
•     Iterators: SUMX, AVERAGEX
•     Variables in DAX
•     Quick measures

Visualisation and Reports

•     Charts, tables, matrix and cards
•     Maps
•     Slicers and filters
•     Drill-down and drill-through
•     Bookmarks and buttons
•     Conditional formatting
•     Report themes and design best practices

Publishing and Sharing

•     Power BI Service and workspaces
•     Dashboards vs reports
•     Scheduled refresh and gateway
•     Sharing reports and apps
•     Row-level security
•     Exporting to PDF and PowerPoint
•     Project: Sales Dashboard