Power BI for Excel 2013 - Level 3 - Data Model Designers

Unlock the full potential of Power BI with our advanced course designed specifically for Data Model Designers aiming to master customized data models, database design, and DAX language for comprehensive data analysis.

Course Thumbnail

Essential Skills Gained

Checkmark

Design efficient data models using Power BI and Excel.

Checkmark

Implement database design concepts for diverse data sources.

Checkmark

Build customized data hierarchies for advanced analysis.

Checkmark

Utilize DAX language to enhance data model functionality.

Format

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

Audience

  • Data Model Designers
  • Business Analysts
  • Power BI Developers
  • Excel Power Users

Description

This is the third course in TLG Learning’s custom Power BI for Excel 2013 training series. What makes Power BI for Excel such a vast improvement over detailed Excel worksheets is the PowerPivot Data Model, which allows data to be pulled together from multiple tables and multiple databases. This course is designed for Power BI for Excel Designers who are ready to create custom data models for themselves and for other Power BI Designers. Topics covered include database design concepts, how to build both general purpose and customized data models, building data hierarchies, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1 : Understanding BI Data

  1. Business Intelligence Data Sources

  2. Data Source Types

  3. Table Roles

Lesson 2 : Creating Data Models

  1. Creating a Data Model - Excel

  2. Creating a Data Model - Database

  3. Creating the Data Model - Hybrid

Lesson 3 : Creating DAX Functions

  1. Review of Syntax and Calculated Columns

  2. Best Practices

  3. DAX Measures

  4. Creating Measures (Calculated Fields)

Lesson 4 : Dates and Hierarchies

  1. Building Data Tables

  2. Building Data Hierarchies

Lesson 5 : Shaping Reports

  1. Building Communication Worksheets

  2. Controlling Item Ordering

  3. PowerPivot Metadata

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.