Power BI – Visualisation – Intermediate Program

Power BI – Visualisation – Intermediate Program

No Sessions Started Yet

Course Features

  • Certificate: Yes
  • Course Capacity: 20
  • Skill Level: Intermediate
  • CPE Hours: 16

Descriptions

Overview

The objectives of this course are to strengthen the participants’ intermediate visualisation and DAX programming skills in Power Bi, so that they become confident at self-serving their analytical needs using the tool. This will be achieved by refining their applied knowledge of common visualisation techniques and exposing them to complex DAX functions within Power Bi. The course will be fully hands-on with example datasets provided in Excel format. Participants are expected to have a beginner-to-intermediate knowledge of the Power Bi tool. The Power Bi Desktop application must be installed on each participants’ laptop.

Key Takeaways for Participants:

  • Core workshop 1 – Data modelling and DAX functions
  • Load and transform data using an example datasets and build a working data model.
  • Understand different primary and secondary keys within the data model
  • Build relationships linking primary/secondary keys
  • Clarify the type of relationships such as one-to-one, one-to-many etc.
  • Apply feature engineering to create new variables from existing variables in a table using different DAX functions
  • Build KPIs and metrics that help visualise specific business performance questions
  • Apply feature engineering to create new variables from existing variables in a table using different DAX functions
  • Creating MEASURES using DAX functions
  • Using Conditional Formulas/Functions
  • Examples of Dax formulas/functions to apply: filter, if, sum, calculate, distinct count, divide, all, summarize columns etc.
  • Use cases of complex and multiple nested DAX functions such as nesting multiple if statements or using summarise, sum and filter functions together
  • Using time intelligence Dax functions
  • Core workshop 2 – Visualisations
  • Waterfall chart
  • Column and Bar charts
  • Pie and Donut charts
  • Scatter plots
  • Funnels
  • Time series charts
  • Format the charts
  • Apply filters on visualisations, reports, pages etc.

Who should attend (Participants):

This hands-on course is designed for middle and senior industry professionals who want to strengthen their front-end and self-service skillset in Power Bi, including:

  • Finance Managers and Controllers
  • Strategy Directors and Managers
  • Budget, Corporate, Business and Financial Analysts
  • Project Managers and Risk Analysts
  • Investment and Management Accountants
  • Heads of Business Units and Business Planners
  • Financial Advisors and Corporate Analysts
  • Business and Financial Analysts
  • HR Managers

In House Training

This program is available for Inhouse Training .We can help you if you’re looking for a training partner to meet your in-house training needs, you can rely on the in-company training division of ABN Executives Academy.

In house Training Program Requirements :

  • Do you have five or more people interested in attending this Program?
  • Do you want to tailor it to meet your company’s exact requirements?

If you’d like to do either of these, we can bring this Program to your company’s office.

You could even save up to 40% on the cost of sending participants to a public Program.

If you want to run this Program at a location convenient to you or if you want a completely customized learning solution, we can help you customize this Program for your organization.

We produce learning solutions that are completely unique to your business. We’ll guide you through the whole process, from the initial consultancy to evaluating the success of the full learning experience. Our learning specialists ensure you get the maximum return on your training investment.

    Please fill the form below to request brochure.






    By submitting this form you agree to our Terms of Service & Privacy Policy.

    Related Course

    SUBSCRIBE TO OUR NEWSLETTERSign up to receive email updates about courses and ABN Finsights Academy