Why take this course
If you work with data processing and analysis, this training will provide you with a comprehensive introduction to all phases of creating a modern report in Power BI. You’ll gain the essential skills for data visualization, performing basic operations, and effectively preparing business reports.
What you’ll learn
- Prepare reports that present business information.
- Understand the principles of data transformation.
- Learn the basic formulas of the DAX language.
- Gain a solid foundation for further self-development in data analysis.
Who is this course for
This course is intended for anyone involved in data processing and analysis, creating reports, and automating reporting-related processes.
Topics covered
- Introduction to Power BI
- General overview
- Purspose and usage of Power BI Desktop and Power BI Services
- Key elements and structure of Power BI desktop as an authoring tool
- Concept of Relations between tables – Star Schema/ Fact & Dimensions
2. Data Sourcing and Modeling in Power Query
- Key functions and operations with Power Query
- Data ingestion and Transformation
- Formatting, Creating and Combining
- Data Model creation
3. Data visualization
- Visualization types
- Filters and Slicers
- Visualization Formatting
- Conditional formatting
- Themes and custom visuals
4. DAX language
- Calculating Measures
- Creating Calculations for Visualization
- Calculated Tables and Columns
- Time Intelligence
- Most popular DAX expressions in action
5. Data storytelling – how to create a good report
- Report Navigation / Descriptions/ Good practices
- From general to specific
- Drill-down / Drill-through
- Relationships between visualizations
6. Publishing and sharing report
- Overview of Power BI services
- Publishing and sharing report or dataset
- Editing / Reworking / Saving a published report
- Creating a dashboard
