Get in Touch
 Duration 14 hours

Course Outline

Review and Principles of Data Model Design

  • Exploring the data modeling layer within Power BI
  • Understanding star and snowflake schema architectures
  • Establishing and maintaining relationships between tables

Fundamentals of DAX (Data Analysis Expressions)

  • DAX syntax structure and supported data types
  • Distinguishing between calculated columns and measures
  • Key DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX Application and Business Logic

  • Utilizing time intelligence functions (YTD, MTD, QTD)
  • Implementing conditional logic and dynamic calculations
  • Generating rankings, running totals, and comparative metrics

Data Transformation and Performance Optimization

  • Utilizing Power Query for complex data transformations
  • Efficiently integrating multiple data sources
  • Enhancing performance through query folding and relationship management

Advanced Visualizations and User Interactivity

  • Integrating custom visuals and marketplace extensions
  • Implementing drill-downs, bookmarks, and what-if parameters
  • Developing paginated and dynamic reporting layouts

Performance Management and Governance in Power BI

  • Adopting best practices for dataset administration
  • Optimizing refresh schedules and query execution speed
  • Deploying row-level security (RLS) controls

Practical Exercise: Developing a Sales Intelligence Dashboard

  • Creating Key Performance Indicators (KPIs) using DAX measures
  • Designing a model-driven dashboard for actionable business insights
  • Applying governance standards and effective sharing protocols

Conclusions and Future Directions

Requirements

  • Familiarity with the Power BI interface and report development processes
  • Practical experience in constructing dashboards within Power BI
  • Foundational knowledge of data relationships and filtering mechanisms

Target Audience

  • Business intelligence specialists
  • Data analysts and reporting experts
  • Developers focused on data visualization and analytics solutions

Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793

Testimonials (4)

How to use relationships in Power BIand the differences between columns and measurements

LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

The application of Data Modelling and DAX

Rachel KY Wong - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Emoji setting. SharePoint data source linkage. Concept of DAX in measure and column.

Lam Chit Wui (Ray) - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Calculate, Measure

TONY ZHOU CHEN - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Kenya (online or onsite) is designed for business analysts, data analysts, and developers who wish to utilize Power BI's advanced features and tools to perform complex data analysis and create interactive visual reports.

By the end of this training, participants will be able to:

  • Install and configure Power BI and the necessary components.
  • Understand and explore the advanced features, components, and tools in Power BI.
  • Get valuable insights on advanced data analysis and strategy.
  • Apply advanced data modeling techniques.
  • Learn how to implement advanced formulas and calculations using DAX.
  • Know the tips and tricks on data handling, visualization, and presentation.
  • Make reports and dashboards interactive to enable collaboration within Power BI.
  • Learn and explore embedded analytics in Power BI.
Read more...

Analyzing Data with Power BI

 28 Hours
This training in Kenya focuses on data analytics with Power BI, covering data modeling, visualization, and analysis using DAX and AI visuals. You will learn to prepare, transform, and secure data from diverse sources while optimizing performance for enterprise-scale workloads and reporting.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live session in Kenya equips beginner and intermediate users with the skills to perform data analysis using Power BI. Learners will focus on data preparation, building interactive dashboards, and securing report distribution, thereby developing the practical competencies necessary for data-driven decision-making in contemporary business environments.
Read more...

Data Analysis with Python, R, Power Query, and Power BI

 21 Hours

This instructor-led live training in Kenya (online or onsite) is targeted at beginner-level professionals who want to clean and analyze data, develop statistical projections, and create insightful visualizations using these tools.

Upon completing this training, participants will be able to:

  • Grasp the fundamentals of Python, R, Power Query, and Power BI in the context of data analysis.
  • Clean and organize datasets using Python and Power Query.
  • Conduct statistical analysis and projections with R.
  • Design professional dashboards and reports using Power BI.
  • Effectively integrate and analyze data from various sources.
Read more...

Excel to Power BI

 7 Hours

This instructor-led live training delivered in Kenya (online or onsite) is designed for data analysts who want to acquire skills in preparing data using Excel and visualizing it via Power BI.

By the conclusion of this training, participants will be able to:

  • Comprehend the core principles, goals, and approaches of data analysis.
  • Apply DAX formulas in Power BI for sophisticated calculations.
  • Create and utilize visualizations and charts suited to particular analysis requirements.
  • Import data using Power View to shift from Excel-dependent Power BI workflows to independent Power BI solutions.
Read more...

Power BI Dashboards

 14 Hours
Explore the process of creating interactive dashboards using Power BI. You will learn to manipulate data, generate visual reports, and oversee distribution strategies within Kenya. This module highlights key competencies including data connectors, advanced filtering techniques, and best practices for leveraging business intelligence and ensuring accessible insights for the entire organization.
Read more...

Power BI for Financial Analysts: Exam Preparation (PL-300)

 7 Hours
Ready yourself for the Microsoft PL-300 certification with this instructor-led course in Kenya. Built for financial analysts, it addresses data preparation, modeling, KPI development, and dashboard visualization using Power BI. Acquire practical expertise through interactive labs and exam-centric exercises.
Read more...

PL-300T00: Microsoft Power BI Data Analyst

 21 Hours

This course explores the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from diverse sources, encompassing both relational and non-relational data. The course also covers the implementation of robust security standards and policies across the Power BI ecosystem, including datasets and groups. Additionally, it addresses the management and deployment of reports and dashboards to facilitate effective sharing and content distribution.

Read more...

Power BI

 14 Hours

This instructor-led, live training in Kenya (offered online or onsite) is designed for beginner to intermediate-level data professionals and business analysts who wish to utilize Power BI effectively for data analysis and visualization.

By the conclusion of this training, participants will be able to:

  • Understand the architecture and core components of Power BI.
  • Connect to diverse data sources and carry out data transformations.
  • Develop effective visualizations and interactive dashboards.
  • Implement row-level security and manage data access.
Read more...

Power BI and Power Apps for Data Visualization and Business Process Automation

 21 Hours
This practical course in Kenya provides a deep dive into Power BI and Power Apps for enhancing data visualization and automating workflows. Participants will learn to integrate diverse data sources, construct interactive dashboards, and design low-code applications that boost operational efficiency without the need for advanced coding skills.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led, live training in Kenya (online or onsite) is tailored for data professionals at beginner to intermediate levels who wish to create compelling data visualizations and dashboards with Power BI.

By the end of this training, participants will be able to:

  • Import and transform data from various sources.
  • Develop and optimize data models.
  • Create visually appealing and interactive reports and dashboards.
  • Apply best practices in data visualization and dashboard design.
  • Utilize advanced features of Power BI for in-depth data analysis.
Read more...

Power BI: Basic, Intermediate, and Advanced

 14 Hours
This live training in Kenya supports learners from entry-level to advanced proficiency in creating Power BI dashboards. Participants will master data transformation, DAX, and visualization techniques through practical exercises with real-world datasets, enabling them to share compelling and interactive business insights effectively.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI workshop in Kenya empowers finance and HR specialists to visualize cash flow and payroll data with precision. Learners will develop interactive dashboards, apply DAX formulas for financial metrics, and automate reporting processes to facilitate informed decision-making.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours
This instructor-led Power BI training in Kenya assists financial and HR professionals in creating comprehensive cash flow and payroll dashboards. Participants will learn to apply DAX formulas, integrate diverse data sources, and visualize trends to enhance decision-making, supported by hands-on exercises and real-world case studies.
Read more...

Power BI DAX Fundamentals

 21 Hours

This instructor-led live training in Kenya (online or onsite) is aimed at beginner to intermediate-level business analysts, data analysts, and developers who wish to learn the fundamentals of DAX in Power BI.

By the end of this training, participants will be able to:

  • Have a comprehensive understanding of Data Analysis Expressions (DAX) in Power BI.
  • Create custom calculations and expressions in Power BI for analyzing data and deriving insights.
  • Learn best practices to optimize DAX performance.
Read more...

Related Categories

Power BI
Power BI