Power BI training 2018-05-22T20:57:21+00:00

DATA MODELING & VISUALIZATION WITH MS POWER BI

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
  • Other DAX formulas –COUNTROWS, HASONEVALUE, SWITCH, RANK, VALUE, RELATED
  • 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

Don’t miss this upcoming session

Executive Excel Dashboards

Wed – Fri
18 – 20, July 2018

Fee
KES 44,500

Venue
The Norfolk Hotel, Nairobi

Reserve your spot now

Click here to reserve