Transforming Data Using Power BI Desktop

• Overview of Power Query Editor Interface and Tools
• Basic Data Transformations: Filtering, Sorting, and Shaping Data
• Understanding Power Query’s M Language
• Importing and Cleaning Data with Power Query Editor
• Managing Query Groups and M Queries
• Conditional Columns and Advanced Transformations
• Merging and Appending Data from Multiple Sources
• Automating Data Refresh and Optimization
• Understanding Power Query’s M Language
• Hands-on: Data Transformation Techniques

Data Modelling in Power BI Desktop

• Managing Data Relationships
• Creating Calculated Columns and Measures
• Optimizing Data Models for Performance
• Time Intelligence and Hierarchies
• Using Calculated Tables and Grouping Data
• Hands-on: Building Data Models

DAX – Data Analysis Expressions

Aggregate Functions

• Advanced Usage of SUM, SUMX, AVERAGE, MIN, and MAX
• Practical Scenarios and Performance Tips

Understanding the Difference Between a Column and a Measure

• Key Differences in Context, Calculation, and Usage
• When to Use Columns vs. Measures in Your Reports

Date & Time Functions

• Working with Date Calculations: YEAR, MONTH, DAY, etc.
• Do’s and Don’ts of Date Calculations in Power BI
• Building Custom Date Calculations for Specific Needs

Logical Functions

• Advanced Scenarios with IF, SWITCH, AND, OR, and NOT
• Nested IF Logic: Handling Complex Conditional Calculations

Relationship Functions

• Understanding RELATED, RELATEDTABLE, and LOOKUPVALUE
• Cross-Table Calculations and Their Applications
• Cross-Table Calculations
• Techniques for Performing Calculations Across Related Tables
• Best Practices and Performance Optimization

Text Functions

• Manipulating Text Data in DAX
• Formatting and Parsing Text Fields: CONCATENATE, LEFT, RIGHT, UPPER,
• LOWER

Time Intelligence Functions

• Working with CALENDAR, SAMEPERIODLASTYEAR, PARALLELPERIOD, and DATEADD
• Creating Dynamic Time Calculations for Business Insights

Hands-on Practice

• Practical Scenarios to Apply DAX Functions
• Real-world Challenges and Problem-Solving Using DAX
• Step-by-Step Exercises to Solidify Understanding

Visualizing Data in Power BI

• Creating Basic Charts: Pie, Donut, Bar, and Line Charts
• Advanced Visuals: Scatter, Waterfall, KPI, Gauge
• Using Slicers, Filters, and Drill through
• Customizing and Formatting Visuals
• Working with Map Visualizations and Analytics Pane
• Hands-on: Designing Interactive Dashboards
• Publishing Reports and Implementing Security

Hands-on: Setting Up Your First Report

• Creating Your First Report from Scratch
• Connecting to a Sample Dataset
• Applying Basic Transformations and Building Visuals
• Publishing Your First Report to Power BI Service

Working with Power BI Service

• Overview of Power BI Service and Dashboards
• Publishing Reports to Power BI Service
• Configuring Dashboards and Adding Widgets
• Sharing, Collaborating, and Configuring Data Refresh
• Alerts, Notifications, and Data Exports
• Hands-on: Managing Power BI Service Dashboards

Apps, Security, and Groups – Collaboration

• Creating and Managing Power BI Apps
• Row-Level Security Implementation
• Collaboration with Workspaces and Groups
• Hands-on: Security and App Management

Exploring the Power BI Community

• Engaging with the Power BI Community Forum and Blogs
• Accessing Power BI Templates and Best Practices
• Learning from Community Showcases and Use Cases
• Networking with Other Power BI Professionals

Exploring Power BI Content Online

• Navigating Report Galleries and Public Content
• Learning from Published Reports and Best Practices

In-Class Project

Tips and Tricks for Building Effective Reports

• Best Practices for Report Design and Layout
• Advanced Techniques for Data Visualization
• Common Pitfalls and How to Avoid Them
• Enhancing User Experience with Interactivity

Building the In-Class Project

• Applying Skills Learned to Build a Real-World Report
• Step-by-Step Guidance on Project Execution
• Hands-on Problem Solving and Data Analysis
• Integrating Data Sources and Building Visuals

Presentation and Peer Feedback

• Presenting Your Project to the Class
• Receiving Constructive Feedback and Suggestions
• Discussing Challenges and Solutions
• Refining Your Report Based on Feedback

Final Reflection and Learnings

• Reflecting on Key Learnings from the Training
• Identifying Areas for Improvement
• Planning for Future Power BI Projects
• Final Q&A and Course Wrap-up

Microsoft Fabric Overview

• What is Microsoft Fabric?
• Key Features of Microsoft Fabric
• Unified Data Platform
• Integrated with Power BI
• Lakehouse Architecture
• Dataflows and Pipelines
• Synapse Integration
• Security and Compliance
• Collaboration and Data Sharing
• AI and Machine Learning Integration
• Benefits of Microsoft Fabric