Data Model Design using Power BI (Level 2)

What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.

    Aug 18 2021

    Date: 08/18/2021 - 08/18/2021 (Wednesday - Wednesday) | 10:00 AM - 6:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Data Model Design using Power BI (Level 2)

    August 18, 2021 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Sep 17 2021

    Date: 09/17/2021 - 09/17/2021 (Friday - Friday) | 10:00 AM - 6:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Data Model Design using Power BI (Level 2)

    September 17, 2021 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Oct 13 2021

    Date: 10/13/2021 - 10/13/2021 (Wednesday - Wednesday) | 10:00 AM - 6:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Data Model Design using Power BI (Level 2)

    October 13, 2021 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 10 2021

    Date: 11/10/2021 - 11/10/2021 (Wednesday - Wednesday) | 11:00 AM - 7:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Data Model Design using Power BI (Level 2)

    November 10, 2021 | 11:00 AM - 7:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Dec 8 2021

    Date: 12/08/2021 - 12/08/2021 (Wednesday - Wednesday) | 11:00 AM - 7:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Data Model Design using Power BI (Level 2)

    December 8, 2021 | 11:00 AM - 7:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

Lesson 1: Understanding BI Data

  • Business Intelligence Data
  • Data Source Types
  • Power BI Data Sources

Lesson 2: Creating Data Models

  • Power BI Query Import Options
  • Planning a Data Model – Flat File
  • Planning Power BI Data Queries
  • Planning a Data Model – Database
  • Planning a Data Model – Hybrid

Lesson 3: Customizing Data Models

  • Query Editor Transformations
  • Applied Steps
  • Merging & Appending Queries
  • Understanding the Data Modeling Tool

Lesson 4: Power BI Functions – DAX Measures

  • DAX Measures
  • Creating Measures
  • Best Practices

Lesson 5: Using Dates Correctly

  • Building Data Tables
  • Building Hierarchies

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

Data Analysis using Power BI Desktop – Level 1 – Report Builder

Ready to Jumpstart Your IT Career?

CONTACT US NOW!