Power BI for
Government – Intermediate
September 22nd & 29th, 2023 | 1:00 PM – 4:00 PM EST | Online
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
Build your own Power BI report and develop a
comprehensive hands on understanding of the
Creation of interactive and visually appealing
dashboards and reports with Power BI’s robust
Advanced data modeling techniques for optimizing
performance and data accuracy.
Mastery of advanced calculations and DAX functions for complex data analysis.
Meet Your Facilitator
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.
- 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
- Merge or split columns
- Date / Time / Duration