• Lesson 1: What is Power BI?
• Lesson 2: History and Evolution of Power BI
• Lesson 3: Power BI Components and Ecosystem
• Lesson 4: Installing and Setting Up Power BI
• Lesson 5: Power BI vs Other BI Tools

• Lesson 1: Introduction to Power BI Desktop
• Lesson 2: Navigating the Power BI Interface
• Lesson 3: Connecting to Data Sources
• Lesson 4: Loading and Transforming Data
• Lesson 5: Creating Basic Visualizations

• Lesson 1: Introduction to Power Query
• Lesson 2: Data Cleaning and Shaping
• Lesson 3: Using Applied Steps
• Lesson 4: Combining and Merging Queries
• Lesson 5: Advanced Data Transformations

• Lesson 1: Introduction to Data Modeling
• Lesson 2: Creating and Managing Relationships
• Lesson 3: Star and Snowflake Schemas
• Lesson 4: Using Calculated Columns
• Lesson 5: Introduction to Measures

• Lesson 1: What is DAX?
• Lesson 2: Basic DAX Syntax
• Lesson 3: Common DAX Functions (SUM, AVERAGE, COUNT)
• Lesson 4: Creating Simple Measures with DAX
• Lesson 5: Using Variables in DAX

• Lesson 1: Types of Visualizations in Power BI
• Lesson 2: Creating Bar, Line, and Pie Charts
• Lesson 3: Using Filters and Slicers
• Lesson 4: Formatting and Customizing Visuals
• Lesson 5: Interactions Between Visuals

• Lesson 1: Introduction to Power BI Service
• Lesson 2: Publishing Reports to Power BI Service
• Lesson 3: Creating Dashboards
• Lesson 4: Sharing and Collaborating in Power BI
• Lesson 5: Setting Up Power BI Gateways

• Lesson 1: Filtering Data in Reports
• Lesson 2: Using Slicers for Interactive Reports
• Lesson 3: Drill-Through and Drilldown Features
• Lesson 4: Bookmarking and Report Navigation
• Lesson 5: Using Sync Slicers Across Pages

• Lesson 1: Connecting Excel Files to Power BI
• Lesson 2: Importing and Using Pivot Tables
• Lesson 3: Power Query in Excel vs Power BI
• Lesson 4: Exporting Power BI Reports to Excel
• Lesson 5: Power BI and Power Pivot

• Lesson 1: Introduction to Mapping in Power BI
• Lesson 2: Creating Basic Map Visuals
• Lesson 3: Using ArcGIS Maps in Power BI
• Lesson 4: Working with Location Data
• Lesson 5: Customizing Map Visuals

• Lesson 1: Power BI on Mobile Devices
• Lesson 2: Creating Mobile-Optimized Reports
• Lesson 3: Cloud Storage and Data Connections
• Lesson 4: Embedding Reports in Other Applications
• Lesson 5: Power BI Licensing and Pricing

• Lesson 1: Complex Relationship Types
• Lesson 2: Role-Playing Dimensions
• Lesson 3: Handling Many-to-Many Relationships
• Lesson 4: Aggregations in Power BI
• Lesson 5: Composite Models and DirectQuery

• Lesson 1: Advanced Aggregate Functions
• Lesson 2: Time Intelligence Functions
• Lesson 3: Parent-Child Hierarchies in DAX
• Lesson 4: Dynamic Row-Level Security with DAX
• Lesson 5: DAX Performance Optimization

• Lesson 1: Improving Data Model Performance
• Lesson 2: Query Folding and Performance Impact
• Lesson 3: Optimizing DAX Measures
• Lesson 4: Reducing Report Load Time
• Lesson 5: Best Practices for Large Datasets

• Lesson 1: Advanced M Language Concepts
• Lesson 2: Using Parameters in Power Query
• Lesson 3: Custom Functions in Power Query
• Lesson 4: Query Dependencies and Performance
• Lesson 5: Automating Data Refresh

• Lesson 1: Using Custom Visuals from Marketplace
• Lesson 2: Creating Themes in Power BI
• Lesson 3: JSON Theme Files for Custom Styling
• Lesson 4: Advanced Conditional Formatting
• Lesson 5: Creating KPI Dashboards

• Lesson 1: Introduction to Paginated Reports
• Lesson 2: Creating Print-Ready Reports
• Lesson 3: Using Parameters in Paginated Reports
• Lesson 4: Advanced Layout and Design Options
• Lesson 5: Exporting and Automating Reports

• Lesson 1: Introduction to AI Features in Power BI
• Lesson 2: Using Key Influencers Visual
• Lesson 3: Applying Machine Learning Models
• Lesson 4: AutoML and Azure ML Integration
• Lesson 5: AI-Driven Data Analysis

• Lesson 1: Introduction to Streaming Datasets
• Lesson 2: Configuring Real-Time Dashboards
• Lesson 3: Using Azure Stream Analytics
• Lesson 4: Connecting to IoT and Sensor Data
• Lesson 5: Power BI REST API for Live Data

• Lesson 1: Role-Based Access Control in Power BI
• Lesson 2: Row-Level and Object-Level Security
• Lesson 3: Data Sensitivity Labels and Compliance
• Lesson 4: Auditing and Monitoring Power BI Usage
• Lesson 5: Power BI Admin Portal

• Lesson 1: Introduction to Power Automate
• Lesson 2: Automating Report Refreshes
• Lesson 3: Embedding Power Apps in Power BI
• Lesson 4: Interactive Workflows Between Power BI and Power Apps
• Lesson 5: Business Process Automation with Power Platform

• Lesson 1: Power BI Deployment Pipelines
• Lesson 2: Version Control for Power BI Projects
• Lesson 3: Automating Deployment with DevOps
• Lesson 4: Continuous Integration for Power BI
• Lesson 5: Monitoring and Maintenance Best Practices

Course Duration: about 50+10 hours

The online class is held via Skype (or Zoom or Microsoft Teams) and the cost per hour of tutoring is only $15. At the end of this long course, you will master all the required basic and advanced concepts of Power BI Software and we will accomplish a real-world project together for about 10 hours, which fully prepares you to find a job as a entry level data engineer in data engineering or data analyst job markets.
To book this class, message or call my telegram or WhatsApp:
+98 (912) 490-8372 or +98 (935) 490-8372.
You can also send email to me:
abolfazl.mohammadijoo@gmail.com