Highly interactive dashboards with drill downs. Avail data to decision makers when they need it!

As an analyst you would want to avail data to users as and when they need it for decision making. This course will use hands-on labs to walk you through Power BI end to end. Whether you’re looking at enhancing your career growth or a solution that eliminates frustrations of heavy Excel files hanging, or a solution that gives your organization an edge by improving visibility to business data, you have come to the right place.

In this module you will learn:

  1. Importing and transforming your data with the Query Editor
  2. Data modeling
  3. Defining Metrics using Data Analysis Expressions (DAX)
  4. Visual analytics and storytelling
  5. Publishing, sharing and refreshing

No prior knowledge in Power BI is assumed. The learner is however assumed to be familiar with Pivot tables, SUMIFS, and lookups in Excel.

  • The Microsoft BI ecosystem –Power Pivot, Power Query, Power BI desktop, Power BI cloud/service and mobile app
  • Comparison with other Business Intelligence (BI) tools
  • Orientation with a simple dashboard
Different ways to access your data, clean and merge multiple data sources. Take back the hours in your busy day with Power BI’s data shaping and modeling capabilities.

  • Getting data from a file (text versus Excel files), a folder, database and from web
  • Filtering unwanted rows
  • Column manipulations
    • Splitting text, (un)pivoting, keep/remove columns, filling blanks, data type checks, transposing, conditional columns, etc.
  • Data categorization/segmentations –grouping, conditional columns
  • Combining data sets –using the Merge Queries versus Append Queries feature
  • Different ways to load the re-shaped data into Power BI desktop
How to get your already connected data sets to work together

  • Creating and managing relationships –lookup columns
  • Calculated columns and measures –what is the difference? Using examples
  • Adding a date dimensions table -various approaches, sorting months
  • Defining hierarchies –dates, products, regional hierarchies
  • Hiding unnecessary columns/tables from user view
Write DAX calculations to enrich your reports and generate powerful insights

  • What is context? Row versus filter context
  • Modifying filter context using CALCULATE function
  • Analyzing data over time
    • Current period versus prior period (DATEADD, SAMEPERIODLASTYEAR, DATESBETWEEN, etc.)
    • Cumulative calculations (YTD, QTD, MTD)
  • Controlling filters –ALL, ALLEXCEPT, FILTER
  • Integrating parameter tables in your measures (Actual, QTD, YTD filter table)
  • Working with different visuals –adding and adjusting their properties
  • Filtering and highlighting and how to control cross-interactions between visuals
  • Incorporating custom visuals
  • Drilling within a hierarchy
Get data into the hands of decision makers when and where they need it!

  • Sharing, security and compliance
  • Using Power BI Gateway –personal versus enterprise
  • Scheduling data refresh

22may(may 22)8:30 am24(may 24)4:00 pmData Modeling & Dashboards with Power BILearn to deliver highly interactive, mobile-ready reports with drill-downs8:30 am - 4:00 pm (24) The Heron Portico Hotel, Nairobi

Reserve your seat now

What you get:

  • 18 hours instructor-led, practical sessions

  • A step-by-step guide

  • After-course instructor support

  • Certificate of participation

Do you have 8 or more staff who could benefit from this program?

Run this course in-house