INTERMEDIATE LEVEL IN MICROSOFT POWER BI FOR DATA ANALYSTS

Tickets
From ₦ 188,125.00 to ₦ 279,500.00
× Tickets
Live-Online Training
₦ 188,125.00 188125.0 NGN
Classroom
₦ 279,500.00 279500.0 NGN

Live-Online Training: N188,125
Classroom Training: N279,500
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

(PARTICIPANTS SHOULD BRING THEIR LAPTOP)

Program Description:

The Intermediate Level Microsoft Power BI Training Program for Data Analysts is designed to build upon foundational Power BI knowledge and equip participants with more advanced skills and techniques to effectively analyze data, create compelling visualizations, and generate actionable insights. This 5-day intensive program combines hands-on exercises, real-world case studies, and expert guidance to empower data analysts to harness the full potential of Power BI for data-driven decision-making.

Prerequisites:

Participants should have a fundamental understanding of Microsoft Power BI and basic data analysis concepts. Familiarity with Excel and SQL can be beneficial but is not required.

 Course Objectives:

Upon completion of this training program, participants will be able to:

  • Develop complex data models and relationships in Power BI.
  • Create advanced calculations using DAX (Data Analysis Expressions).
  • Design interactive and insightful reports and dashboards.
  • Leverage advanced visualization techniques for effective data storytelling.
  • Automate data loading and transformation with Power Query.
  • Collaborate and share Power BI reports securely with colleagues.
  • Optimize performance and maintain Power BI solutions.

 Course Content

DAY ONE

 Power BI Data Modeling and Relationships

  • Understanding data modeling in Power BI
  • Importing and shaping data with Power Query
  • Creating relationships between tables
  • Handling many-to-many relationships
  •   Using calculated columns and measures
  • Introduction to DAX.

DAY TWO

Advanced DAX and Data Analysis

  • Mastering DAX functions and formulas
  • Time intelligence functions for date analysis
  • Ranking and filtering techniques
  • Handling errors and exceptions in DAX
  • Advanced calculations and patterns.

DAY THREE

Advanced Data Visualization

  • Custom visuals and themes
  • Drill through and bookmarks
  • Using filters and slicers effectively
  • Advanced charting options
  • Interactive storytelling with Power BI.

DAY FOUR

Data Transformation with Power Query

  • Transforming data with M language
  • Combining and merging queries
  • Error handling and data quality
  • Parameterized queries for dynamic data loading
  • Advanced transformations and transformations using functions.

 DAY FIVE

Collaboration and Performance Optimization

  • Power BI service and Power BI Desktop
  • Sharing and publishing reports securely
  • Row-level security and data security options
  • Performance optimization techniques
  • Data refresh and maintenance best practices
Date & Time
Monday
November 4, 2024
Start - 8:30 AM
Friday
November 8, 2024
End - 3:00 PM Africa/Lagos
Location

Tom Associates Training

5/7, Alade Lawal Street, Opposite Anthony Police Station, Off Ikorodu Road, Anthony Village,
NG-LA
Nigeria
+234 817 859 1654
+234 809 276 3968 | +234 810 365 2225
tomassociatestraining@yahoo.com | info@tomassociatesng.com
Get the direction
Organizer

Tom Associates Training

+234 817 859 1654
+234 809 276 3968 | +234 810 365 2225
tomassociatestraining@yahoo.com | info@tomassociatesng.com