Cursor Insert India

Power BI

Power BI

Power BI

Course Description

Module 1: Introduction to Power BI

  • Overview of Business Intelligence (BI) & Data Analytics
  • Introduction to Power BI Desktop, Power BI Service & Power BI Mobile
  • Understanding Data Sources & Connectivity
  • Power BI Licensing & Deployment Options

Module 2: Data Extraction & Transformation (Power Query)

  • Connecting to Various Data Sources (Excel, SQL, APIs, Cloud)
  • Data Cleaning & Transformation with Power Query
  • Merging & Appending Queries
  • Data Types & Column Operations

Module 3: Data Modeling & DAX (Data Analysis Expressions)

  • Introduction to Data Modeling & Relationships
  • Star & Snowflake Schema in Power BI
  • Understanding DAX (Measures vs. Calculated Columns)
  • Key DAX Functions: SUM, COUNT, IF, SWITCH, FILTER, CALCULATE
  • Creating Time Intelligence Functions (YTD, MTD, QTD)

Module 4: Data Visualization & Dashboard Design

  • Creating Tables, Matrices, Bar & Line Charts, Maps
  • Advanced Visuals: KPI, Gauge, Cards, Waterfall Charts
  • Using Bookmarks, Tooltips, and Drill-Through
  • Best Practices for Dashboard Design

Module 5: Power BI Service & Cloud Features

  • Publishing & Sharing Dashboards on Power BI Service
  • Creating Workspaces, Apps & Row-Level Security (RLS)
  • Scheduling Data Refresh & Auto Updates
  • Embedding Reports in Websites & Apps

Module 6: Advanced Analytics & AI in Power BI

  • Forecasting & Trend Analysis
  • Clustering & Anomaly Detection
  • Using AI-Powered Visuals (Decomposition Tree, Key Influencers)
  • Python & R Integration in Power BI

Module 7: Power Automate & Power BI Integration

  • Automating Workflows with Power Automate
  • Connecting Power BI with Power Apps & Microsoft 365
  • Exporting & Automating Reports in Excel/PDF

Course Syllabus

1: Introduction to Power BI

2: Data Extraction & Transformation (Power Query)

3: Data Modeling & DAX (Data Analysis Expressions)

4: Data Visualization & Dashboard Design

5: Power BI Service & Cloud Features

6: Advanced Analytics & AI in Power BI

7: Power Automate & Power BI Integration


Duration: 3 Months
(14 Reviews)
Share on:

Search box

Advertisements

Popup Image Offer
Admission Query