Power BI Bootcamp

Description

This five-day Power BI Bootcamp Course provides a comprehensive journey from beginner to advanced levels. We will aim to cover essential concepts, practical skills, and real-world applications to empower learners to harness the full potential of Power BI for data analysis, transformation, and data visualization


    Course Registration Link

By taking this course, you will have a lifetime commitment from Wafaa Analytics data scientists and Engineers to help you accomplish your data analytics projects. It’s all free of charge after the completion of this course.

Subjects to be covered:

  • Morning Session:
    • Welcome and Introduction to Power BI
    • Power BI Interface Walk-Through
    • Importing Data into Power BI, Data Connectors, & Direct Query
    • Basic Data Transformations
    • Introduction to DAX (Data Analysis Expressions)
  • Post Lunch Break Session:
    • Introduction to Data Modeling in Power BI
    • Creating Relationships between Data Tables
    • Basic Visualizations: Bar Charts, Line Charts, and Pie Charts
    • Hands-on Exercises: Building Simple Reports – 2 hou
  • Morning Session:
    • Review Day 1
    • Advanced Data Transformations: Pivot Tables, Merging Queries
    • Working with Date Tables and Time Intelligence Functions
    • Introduction to Advanced DAX Functions
  • Post Lunch Break Session:
    • Advanced Visualizations: Scatter Plots, Treemaps, and Gauges
    • Slicers, Filters, and Drill-Downs
    • Conditional Formatting and Custom Visuals
    • Hands-on Exercises: Creating Interactive Dashboards – 2 hours
  • Morning Session:
    • Review Day 2
    • Advanced Data Modeling Techniques: Many-to-Many Relationships, Bidirectional Filtering
    • Advanced DAX Calculations: CALCULATE, FILTER, RELATED, etc.
  • Post Lunch Break Session:
    • Introduction to Power Query M Language
    • Working with Parameters and Variables
    • Advanced Data Modeling Scenarios: Hierarchies, Calculated Tables
    • Hands-on Exercises: Building Complex Data Models and Reports – 2  hours
  • Morning Session:
    • Review Day 3
    • Storytelling with Data: Creating Compelling Narratives
    • Advanced Visualization Techniques: Custom Visuals, Themes, and Backgrounds
    • Drillthrough and Bookmarking Features
  • Post Lunch Break Session:
    • Power BI Service Overview: Sharing, Collaboration, and Security Features
    • Introduction to Power BI Mobile App
    • Best Practices for Performance Optimization and Data Refresh
    • Guided Project:
      • Build a real world solution with your own data.     
         OR
      • Use Data Provided by your instructor

Instructor:

Shweta Pathak is a highly skilled Data Science Engineer, who has a passion for uncovering insights and driving decision-making through data, Shweta combines technical proficiency with a keen eye for innovation. Her dedication to continuous learning as evident from her graduate degree in Big Data and Microsoft plus other industry certifications. Her zeal to stay current in the field of AI, machine learning, data analytics and visualization techniques makes her an asset in any data-driven organization.

 

A trailblazer in her field, Shweta played a pivotal role in the introduction, research, setup, and deployment of Power BI platform within her organization. Over the past five years, she has been deeply immersed in the Power Platform and Power BI applications, revolutionizing the way data is presented and utilized within her organization. Shweta’s dedication and expertise have simplified complex data and analytics processes, facilitating better dissemination and absorption of information across the board.

 

With a wealth of knowledge and a love for education backed by teaching degree, Shweta also inspires students to excel in the fields of data science, data engineering, data mining & analytics and ever evolving landscape of technology as an instructor.

 

LinkedIn Profile: Shweta Pathak – Fleming College | LinkedIn

Course fee:

CA$950 (+ applicaple taxes)