Training

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.