Login
Online Course Power BI
Science And Technology

Power BI

The course “Data Analytics with Power BI” is designed to equip students with the skills to create interactive dashboards, analyze business data, and build visually appealing reports using Microsoft Power BI – one of the leading BI tools in the industry.
Course ModeOffline
Duration2 Weeks
Starts07 Jul 2025
Ends18 Jul 2025
Course Fee
₹1,000 /-
Registration Closed
About The Course

Overview

The course “Data Analytics with Power BI” is designed to equip students with the skills to create interactive dashboards, analyze business data, and build visually appealing reports using Microsoft Power BI – one of the leading BI tools in the industry.

Learning Goals

Course Outcomes

  • Participants will be able to use Power BI for data connection, transformation, and analysis.
  • Learners will design and publish interactive dashboards and reports.
  • They will be able to apply DAX formulas to add analytical value.
  • Students will demonstrate practical BI project development and presentation skills.

Participants will be job-ready for analytics and BI roles.

Curriculum

Course / Modules

Unit 1: Introduction to Business Intelligence and Power BI (2 hrs)

  • What is Business Intelligence?
  • Overview of Power BI ecosystem
  • Power BI Desktop interface

 

Unit 2: Data Loading and Transformation (Power Query) (2 hrs)

  • Connecting to Excel/CSV/SQL
  • Power Query Editor basics
  • Data types, cleaning, splitting, merging, appending

Unit 3: Data Modeling (2 hrs)

  • Data relationships and cardinality
  • Star vs snowflake schema
  • Creating calculated columns and measures

Unit 4: DAX Fundamentals (2 hrs)

  • Introduction to DAX
  • Aggregation, filter, and time intelligence functions
  • Measures vs calculated columns

Unit 5: Visualization & Report Building (2 hrs)

  • Charts: bar, pie, line, combo
  • Slicers, cards, tables, KPIs
  • Formatting and themes

Unit 6: Advanced Visuals and Custom Charts (2 hrs)

  • Tree maps, waterfall, maps
  • Drill-throughs and bookmarks
  • Tooltips and buttons

Unit 7: Power BI Service & Sharing (2 hrs)

  • Publishing to Power BI Service
  • Creating and sharing dashboards

Unit 8: Case Study – Mini BI Project (2 hrs)

  • Sales/HR dataset
  • Problem statement, dashboard design, presentation

Unit 9: Power BI + Excel & SQL Integration (2 hrs)

  • Using Excel files in Power BI
  • Connecting to SQL Server
  • Refresh, schedule, gateway overview
Learn From Experts

Our Trainers

Prof. Durvakshi Vyas
Prof. Durvakshi Vyas
I hold an M.Tech in Data Science and have one year of experience as a Data Analyst Trainer, along with an additional year of teaching in a Data Scienc...
Need More Information?

Contact

Name: Prof. Neha Sharma

Mobile No: 8871548408

Email: [email protected]