Power BI Beginner to Intermediate

Course Overview

• Course Title: Power BI Beginner to Intermediate
• Instructor: Mohammad Shabbir Taibani
• Target Audience:
  • Complete beginners in Power BI
  • Business professionals
  • Aspiring data analysts
  • Students
• Prerequisites:
  • No prior experience in Power BI or data analytics is required
  • Basic knowledge of Excel can be helpful but is not mandatory
  • A computer with Windows OS (Power BI Desktop is not available on Mac)
  • Internet connection to download and install Power BI and access Power BI Service

Curriculum Highlights

• Key Topics Covered:
  • Master Power BI Fundamentals
  • Transform and Clean Data
  • Build Data Models and Use DAX
  • Create Interactive Visualizations
  • Publish and Share Reports
  • Bonus Reports: End-to-End Creation - Finance Dashboard & Sales Report
  • Data Collection & Preparation
  • Data Modeling
  • Creating the Dashboard
  • Real-World Reporting
  • Building KPIs and Metrics
  • Interactive Sales Dashboards
• Key Skills Learned:
  • Installing Power BI
  • Connecting to various data sources (Excel, CSV, SharePoint)
  • Importing data for analysis
  • Understanding data types
  • Data cleaning best practices
  • Creating custom and conditional columns
  • Data modeling
  • Relationships in data
  • DAX formulas for calculations (SUM, IF, CALCULATE)
  • Designing professional reports
  • Using visual elements (cards, bar charts, line charts, pie charts, slicers, matrix formats)
  • Publishing reports on Power BI Service
  • Creating workspaces
  • Adding members to workspaces
  • Exploring different sharing options
  • Building finance dashboards and sales reports
  • Preparing financial datasets for analysis
  • Calculating key financial metrics (profit margins, revenue growth)
  • Designing dynamic dashboards
  • Building and formatting polished reports
  • Creating powerful KPIs
  • Providing detailed insights with filters, slicers, and interactive visuals

Course Format

• Duration: 9.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 1 article
  • 4 downloadable resources
  • Access on mobile and TV
  • Certificate of completion