POWER BI TRAINING

Need more compelling reports? Finally, a reliable, practical course that prepares you to

Take your analytics and visualization skills to the next level. Get in-demand skills and be ready to take on that analyst / BI role

Data cleaning, Modeling, DAX and Visualization in Power BI

Wed 20, Thu 21 & Fri 22 March 2024

at The Heron Portico Hotel, Nairobi

KES 29,900

Get Ahead!

Anyone can drag and drop a chart in Power BI, but few understand how to get the measures or calculations right. This course shows you how to automate the data cleaning and shaping process and create scalable measures using DAX

Master Core DAX

Gain in-depth understanding of must-know DAX formulas to enrich your calculations

Compelling Data Stories

Leverage on modern charts and custom visuals to interactively bring your data story to life

Advance your Career

Improve your career prospects with this in-demand skill. Set yourself apart from the pack

Why Choose DCA as your Power BI Trainers?

Take guesswork out of the way!

With over a decade of Microsoft Business Intelligence experience, our trainers are dedicated to offering training that has practical business application that produces results.

We’ve gone through the cycles of Power BI improvements since its inception ensuring we’re abreast on the best practices and formulas to build robust BI solutions.

  • Expedite access to business insights for managerial decisions

  • Collaborate easily on data

Will the staff who go through this training have anything to show?

The answer is YES.

“The dashboard skills in Power BI and Excel have transformed the way I do financial and management reporting in my role. I’ve since applied these techniques which has helped sort of automate the reports resulting in greater speed of execution and less errors”

Galileo Omondi, WVS

Course Structure

Course overview

With Microsoft Power BI you can integrate multiple data sources into single source of truth. This Power BI training will use hands-on labs to walk you through Power BI end to end.

What more…

You’ll not have to grapple with having to send heavy Excel files. You only give access once, and managers can access them ANYWHERE

Pre-requisites

  • No prior knowledge in Power BI is assumed

  • The learner is however assumed to be familiar with Pivot tables, SUMIFS, and lookups in Excel

Power BI Training Course outline

  • 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 multiple sources –Excel, PDF, CSV/TXT, Web, Google Sheets, SharePoint, and bulk import and consolidation from a folder
  • Filtering unwanted rows
  • Column manipulations
    • Splitting text, (un)pivoting, keep/remove columns, filling blanks, data type checks, transposing, conditional columns to classify and segment data, ‘flash fill’ feature, etc..
  • Data categorization/segmentations –grouping, conditional columns
  • Combining data sets –using the Merge Queries versus Append Queries feature
  • Common Power Query errors and how to troubleshoot
  • Different ways to load the re-shaped data into Power BI desktop
How to get your already connected data sets to work together

  • Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables -features and differences
  • Creating and managing relationships –lookup columns
  • Calculated columns and measures –what is the difference? Using examples
  • Adding a date dimensions table using CALENDARAUTO and ADDCOLUMNS functions and sorting months
  • Hiding unnecessary columns/tables from user view
  • Working with multiple fact/data tables
Write DAX calculations to enrich your reports and generate powerful insights

  • What is context? Row versus filter context -demystifying this central concept in DAX
  • Common DAX formulas and their usage -SUM, COUNTROWS, IF, VALUES, SUMX, DIVIDE, DISTINCTCOUNT
  • RELATED and RELATEDTABLE and when to use these
  • Modifying filter context using CALCULATE function
  • Analyzing data over time
    • Current period versus prior period (DATEADD, SAMEPERIODLASTYEAR, DATESBETWEEN, etc.)
    • Cumulative calculations (YTD, QTD, MTD) + running totals with the FILTER & DATESINPERIOD functions
  • Controlling filters –ALL, ALLEXCEPT, REMOVEFILTERS, FILTER
  • Handling multiple relationships with USERELATIONSHIP
  • Top ‘X’ items analysis -RANKX, TOPN
  • Integrating disconnected parameter tables in your measures (Actual, QTD, YTD filter table) -combined with SELECTEDVALUE, HASONEVALUE, and SWITCH functions
  • Integrating parameter tables in your measures (Actual, QTD, YTD filter table)
  • Working with variables to simplify your DAX formulas
  • Visualizing your data using Cards and Multi-Row Cards
  • Common charts and how to adjust their properties -Doughnut, Area, Column, Line, Bar
  • Cross tabular reports with Table and Matrix visuals -top tips for polished table reports
  • Other modern charts -Treemap, ArcGIS map chart, Waterfall chart
  • Applying conditional formatting on column charts and tables
  • Filtering and highlighting and how to control cross-interactions between visuals
  • Using custom visuals in reports
  • Report design tips -custom backgrounds, leveraging tooltip pages, locking visuals, customizing colours, visual alignment
  • App-like page navigation
Get data into the hands of decision makers when and where they need it!

  • Publishing your reports
  • Sharing, security and compliance
  • Workspace vs App workspace
  • Consuming reports on Power BI mobile app
  • A note on data gateways for data refresh

Logistics

Learn Power BI by doing

Plenty of interactive lab sessions to get you comfortable with DAX and data modeling

Power BI Training

What you get:

  • Hands-on lab sessions –work on real world projects. Not disjointed examples

  • Supporting files for more practice

  • Manual that explains the concepts progressively by looking at a case scenario

  • Certificate of completion

  • Access to the trainer for support post the training