Power BI for
Government – Intermediate

September 22nd & 29th, 2023 | 1:00 PM – 4:00 PM EST | Online

Training Overview

Take your Power BI skills to the next level and master data analysis with advanced techniques and insightful visualisations

The Power BI Intermediate training is designed for professionals who have a basic understanding of Power BI but are looking to expand their skills and gain deeper insights into their data. The training covers advanced data modeling techniques, empowering attendees to optimise performance and accuracy of their data.

The course also covers the use of DAX functions and calculations for complex data analysis, allowing attendees to uncover valuable insights and trends in their data. In addition, attendees will learn how to create interactive and visually appealing dashboards and reports with Power BI’s robust visualization tools, helping them to effectively communicate their findings to stakeholders.


With the skills gained from this training, attendees will be able to take their data analysis to the next level, making informed decisions and drive success for their departments and agencies.

Who Should Attend

This course is designed for heads, directors, assistant directors, managers, and team leaders in charged in all three levels of government including:

Data Science, Analysis and Engineering

Business Intelligence

Solution Architects

Learning Outcomes

Build your own Power BI report and develop a
comprehensive hands on understanding of the
software.

Creation of interactive and visually appealing
dashboards and reports with Power BI’s robust
visualization tools.

Advanced data modeling techniques for optimizing
performance and data accuracy.

Mastery of advanced calculations and DAX functions for complex data analysis.

Meet Your Facilitator

ludovic_Bocken


LUDOVIC BOCKEN

Meet Ludovic Bocken, a visionary researcher and developer who has been driven by the deep desire to innovate in our knowledge society for the last 30 years. Trained in philosophy, linguistics, didactics, cognitive computing, artificial intelligence and natural language processing, his passion for designing solutions that serve the public interest has led him to deep dive into research about Wikipedia for which he received several scholarships. Previously, he taught French communication to managers, professional communication, methodologies, and project management for economics students in public relations and business computer science. He developed datadriven e-learning solutions for higher education and universities, as well as worked in research and development for the IT industry and several public companies as a data scientist, a machine learning engineer, and a client engineering lead. Today, Ludovic’s focus lies
on project management and digital leadership models to design the best solution architectures for cognitive cloud computing.

With a life that has taken him across three continents – Africa, Europe, and America – Ludovic’s diverse background is reflected in his genetics, with ancestors from all over the world. His thirst for adventure and
challenge is evident in his goal of completing his first sprint triathlon before turning 50. But Ludovic’s biggest dream is to direct a science fiction movie as good as “The Matrix.” With his wealth of experience and knowledge, Ludovic is proud to share his expertise with public sector professionals, making him a valuable asset to anyone looking to shape the future.

Key Sessions

Day 1Day 2
  • Creating relationships
  • Relationships, structure, filtering directions
  • Preview and discuss the dataset
  • Unique ways of creating a report look and feel
  • Choosing a design template
  • Simple DAX (Count, Sum, averages, and measures within measures, etc.)
  • Dax Intermediate (Calculate and time intelligence formulas)
  • Creating DIM_DATES and Fiscal DIM_DATES from the front and back end
    • M Language for Transforming Data
    • Creating Visuals and importing Visuals
    • Lay Out Concepts
    • Embracing Bookmarks to create something unique
  • Grouping, merging tables and calculations for data transformation
  • Transform – When to use “Transform” or the “Add Column” Tab
    • Detect Data Types
    • Replace Values
    • Move Columns
    • Format
    • Merge or split columns
    • Date / Time / Duration
  • Bringing it all together, advanced features, publishing and sharing projects
    • Clustering
    • Grouping
    • Using “Analytics” within Visuals
    • “Get more visuals”
    • Adding Buttons and Bookmarks
    • Booked marked filters
  • Demonstrate new skills in personal project, and show & tell

Pricing

Save $300
until June 30th

$595 USD

(Sale Ends June 30th)

per person + tax

Save $150
until July 31st

$750 USD

(Sale Ends July 31)

per person + tax

Regular Price
Starts August 1st

$895 USD

(Limited Inventory)

per person + tax

Additional discounts are available for group registrations of 10 or more.
For group discount inquiries, payment inquiries, or custom training solutions please contact [email protected]

* Registration for this training is exclusively for professionals currently working within the Public Sector.

Customised in-house options available for teams

Interested in any of our online trainings?

You can also choose to have them delivered in house. We will work closely with our inspiring session facilitators to tailor the content around the key development areas your team are prioritising, shape the learning outcomes around your core departmental challenges and make the most of your L&D and upskilling budget.