Strategy Consulting
Power BI Desktop – Data-Modeling and Reporting Basics
Power BI Basics
Business Intelligence Tools such as Power BI can make day-to-day work enormously easier. Find out in this two-day seminar how you can use Power BI to automate your reporting quickly and efficiently and perform complex data analysis at the press of a button.
Your Benefits
By participating in this training, you will become familiar with the methods and philosophies of data modeling. You will learn how to connect different sources of data and process your business data efficiently for analysis and reporting so you can make considered decisions with your findings.
Contents & Key Learnings
Data-Modeling Basics
- Types and formats of data
- Relationships and cardinalities
- Structuring data
- Designing data models
Power BI Desktop basics
- Launching, settings, and options
- Overview of function characteristics
- Retrieving and transforming data
- Importing data from Access, Excel, and text files
- Working with queries
- Cleansing data
Developing data models
- Planning data models
- Creating and editing relationships in data models
- Performing calculations with DAX measures
- Developing scenarios with parameters
Creating reports
- Structural characteristics and principles of reports
- Visualization elements in the report design
- Creating reports from data models
- Using filter elements in reports
- Using DAX measures in reports
Format & Execution
- Classroom
- Presentation, discussion, application, exercises, transfer
Audience
This seminar is ideal for anyone who wishes to use Power BI Desktop as a core tool for analysis and reporting and has not previously had experience with it.