Power BI Syllabus

• Introduction to Power BI

• Overview of BI concepts
• Why we need BI?
• Introduction to SSBI
• SSBI Tools
• Why Power BI?
• What is Power BI?
• Building Blocks of Power BI
• Getting started with Power BI Desktop

• Power BI Desktop

• Power BI Desktop
• Extracting data from various sources
• Workspaces in Power BI
• Data Transformation
• Measures and Calculated Columns
• Install Power BI Desktop
• Data Transformation
• Using Query Editor

• Data Analysis Expression (DAX)

• Modelling Data
• Manage Data Relationship
• Optimize Data Models
• What is DAX?
• Data Types in DAX
• Calculation Types
• DAX Functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text and Aggregate
• Measures in DAX
• Create relationships
• Calculated Columns
• Data Types in DAX
• Explore DAX Functions such as Aggregation, Counting, Logical, Information, Text
• Creating Calculated Measure
• Time Intelligence Functions

• Data Visualization

• How to use Visual in Power BI?
• Charts in Power BI
• Matrixes and tables
• Slicers
• Map Visualizations
• Gauges and Single Number Cards
• R Visuals in Power BI
• What Are Custom Visuals?
• KPI Visuals
• Data Binding
• Power BI report server

• Power BI Q&A and Data Insights

• Why Dashboard?
• Dashboard vs Reports
• Creating Dashboards
• Configuring a Dashboard: Dashboard Tiles, Pinning Tiles
• Power BI Q&A
• Quick Insights in Power BI
• Power BI embedded
• Explore Power BI Q&A
• Creating a Dashboard
• Pinning a Tile to a Dashboard
• Run Quick Insights on a Dataset
• Pin a range to a Dashboard
• Connect to Power BI Data in Excel
• Monitor Real-time Data with REST API

• Direct Connectivity

• Use the developer API to create custom visuals
• Connecting Excel to Power BI
• Creating content packs