Course Outline
Introduction
- Overview of Power BI features and architecture for government
- Advanced tools and data analysis capabilities in Power BI
Getting Started
- Installing Power BI and other necessary components
- Workflow for preparing reports and dashboards for government use
- Overview of the user interface
Power Query – Importing Data
- Types of data connectors
- Query folding techniques
- Extracting data from various sources:
- Flat files
- Entire folders of data
- Websites and web services
- Working with unstructured data files
- Advanced techniques in Power Query:
- Merging and appending tables
- Pivoting and unpivoting data
- Automated column creation from examples
- Working with inconsistent tables
- Decomposition of complex tables
- Best practices for text analysis
- Basics of the M language
Data Model – Why You Need One
- Definition and importance of a data model
- Data model normalization techniques
- Two main types of tables
- Relationship cardinality:
- One to many
- One to one
- Many to many
- Understanding filter flow and the underlying logic
- Creating hierarchies in your data model
- Data modeling best practices for government applications
DAX – The Best Tool to Make Your Data Useful
- Introduction to DAX and its benefits
- Difference between measures and calculated columns, and when to use each
- Understanding filter context versus row context
- Creating measure tables for efficient data management
- Using variables in measures:
- How to create variables
- Why you should use variables
- Handling errors and debugging with variables
- Scalar functions:
- Basic aggregation functions
- Iterator functions
- The SWITCH function as an improved IF statement
- Using the COALESCE function for data integrity
- Advanced use of CALCULATE:
- Modifiers and their applications
- REMOVEFILTERS and KEEPSFILTERS functions with examples
- Understanding patterns in DAX
- Table and filter functions:
- Common table functions
- Difference and usage of VALUES and DISTINCT functions
- Incorporating SELECTEDVALUE into your reports
- ALLEXCEPT and ALLSELECTED functions
- Why you should use SUMMARIZE in data analysis
- Generating new data for your report using various methods
- Table joins:
- CROSSJOINing tables
- EXCEPT and INTERSECT functions with examples
- Using the UNION function to combine data
- Relationships functions:
- Difference between physical and virtual relationships
- RELATED and RELATEDTABLE functions
- Using USERELATIONSHIPS for dynamic data linking
- Advanced time intelligence concepts
- Preparing fiscal and non-standard calendars for your model
Advanced Visualization Techniques:
- Creating a custom color palette for your reports
- Building themes for consistent report design
- Designing effective slicer panels
- Creating compelling graphs that accurately represent data
- Distinguishing between good, bad, and misleading visualizations
- Simplified methods to enhance the appearance of your reports
- Interactive scenario analysis for user engagement
- Forecasting and trend lines for better data recognition
- Drilling up and drilling down through data layers
- Using parameters to enhance report flexibility
- Leveraging bookmarks to improve data visualization
Requirements
- A clear understanding of Power BI for government use
- Practical experience with Power BI in a government context
Testimonials (5)
The coding and analysis, how the information come together in a report which will be useful for my work
Nokuthula Dhludhlu - National Transmission Company South Africa
Course - Analyzing Data with Power BI
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
