Why take this course
If you want to advance your career in data analytics and become an expert in creating reports, this training will provide you with comprehensive knowledge of Power BI. You’ll gain the skills needed to prepare, model, and visualize data, which will allow you to independently create complex and professional business reports.
What you’ll learn
- Prepare, model, and visualize the data needed to create a report.
- Create visually rich reports that present information in a way that facilitates business decision-making.
- Use good development practices, such as code formatting, naming conventions, and the classification of tables and columns.
- Understand how relationships between tables work and the ability to create them.
- Independently create complex reports using advanced DAX formulas.
- Gain information about operations on tables imported into the model, as well as tables and columns created with DAX formulas.
- Build a solid foundation for further self-development of the acquired knowledge.
- Handle more complex datasets.
Who is this course for
This training is intended for both beginners who have not previously worked with Power BI data analysis, as well as for those who work as a developer/data analyst or are involved in creating reports and want to consolidate their knowledge.
Training schedule
Day 1
- Introduction to Power BI
- Data retrieval, transformation, and formatting
- Merging, references, duplicates
- Star schema and assigning functions to tables
- Creating appropriate relationships
- Context-based filtering
- Themes, templates, backgrounds
- Selecting visualizations for data types
- Hierarchy, drilling, labels
- Bookmarks and relationships between objects in the report
Day 2
- Introduction to measures and the purpose of their use
- Basic DAX expressions
- Conditional functions such as If/Switch/True
- Introduction to variables
- Creating and using “What If” parameters
- The most popular DAX expressions related to time
- Time ranges, calendar periods, points in time
- Introduction to bookmarks – filtering
- Homework to be completed in the form of a Power BI report
Day 3
- Discussion of reports independently completed by participants
- Principles of human perception
- Psychology knowledge helps create better reports
- Storytelling concept
- Small multiples, decomposition tree
- Drilling/Tooltips/Labels
- Bookmarks for organizing the page
- Non-standard templates and backgrounds
- Grouping, references, and duplicates
- Creating custom columns
- Merging and grouping queries
Day 4
- Popular business problems solved with DAX
- Measures as filters
- Using virtual tables
- Tables without relationships
- Datasets – refreshing/scheduling
- Creating applications in Power BI services
- Row-level security – roles to be assigned
