Training Categories Data Model Design using Power BI (Level 2)

Data Model Design using Power BI (Level 2)

Data Model Design using Power BI (Level 2) Course Details:

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.

    Apr 26 2023
    April 26, 2023 | 10:00 AM - 6:00 PM (EST) GTR

    Date: 04/26/2023 - 04/26/2023 (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)

    April 26, 2023 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    May 24 2023
    May 24, 2023 | 10:00 AM - 6:00 PM (EST) GTR

    Date: 05/24/2023 - 05/24/2023 (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)

    May 24, 2023 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jun 23 2023
    June 23 - 24, 2023 | 10:00 AM - 6:00 PM (EST)

    Date: 06/23/2023 - 06/24/2023 (Friday - Saturday) | 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)

    June 23 - 24, 2023 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jul 26 2023
    July 26, 2023 | 10:00 AM - 6:00 PM (EST)

    Date: 07/26/2023 - 07/26/2023 (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)

    July 26, 2023 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    Aug 30 2023
    August 30, 2023 | 10:00 AM - 6:00 PM (EST)

    Date: 08/30/2023 - 08/30/2023 (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 30, 2023 | 10:00 AM - 6: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!