Power BI Data Model Design Using Power BI Desktop

Unlock the full potential of your data with our Power BI Data Model Design course using Power BI Desktop, tailored for data professionals seeking to enhance their reporting capabilities with advanced data modeling and seamless data import techniques.

Course Thumbnail

Essential Skills Gained

Checkmark

Understand Power Query for importing and cleaning data from diverse sources.

Checkmark

Design effective data models within Power BI for optimal data representation.

Checkmark

Implement DAX formulas for enhanced data analysis and time intelligence.

Checkmark

Apply data-driven decision-making through hands-on projects.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Data Analysts
  • BI Professionals
  • Analytics Consultants
  • Business Intelligence Developers

Description

Good Power BI reports need good data. Two of the more important features of Power BI are the data import and clean tools in Power Query and the data Model that holds the imported data. In this course we will explore Power Query and how it connects to over 100 data sources. We will clean and transform the raw data into a form useful for Power Bi Reporting. After this data is imported into the Power Bi Model we will explore DAX formulas to summarize data and to add time intelligence features. If you are using anything more than simple data sources you should consider this an important follow up to the Power BI reporting course.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Get Data in Power BI

  1. Connect to various data sources

  2. Enhance data retrieval performance

Clean, Transform, and Load Data in Power BI

  1. Utilize Power Query for data cleaning and preparation

  2. Profile columns and transform data types

  3. Explore the Power Query M Language

Design a Data Model in Power BI

  1. Develop common date tables

  2. Configure relationships and star schemas

  3. Select the appropriate data granularity

Add Measures to Power BI Desktop Models

  1. Create both simple and complex measures

  2. Understand the difference between calculated columns and measures

Optimize a Model for Performance in Power BI

  1. Review and enhance measure and relationship performance

  2. Optimize data models for improved performance

Manage Datasets in the Power BI Service

  1. Connect to on-premises data sources using a gateway

  2. Configure dataset refresh and optimize performance

Implement Row-Level Security in Power BI

  1. Configure row-level security for precise data access control

Perform Analytics in Power BI

  1. Explore statistical analysis and data grouping

  2. Utilize advanced analytics features such as Quick Insights and AI Insights

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.