Discover Classes. Earn 10% Rewards.

Data Model Design using Power BI Desktop - Level 2 is unfortunately unavailable

Thankfully we have 2 other Microsoft Classes for you to choose from. Check our top choices below or see all classes for more options.

All Day Private Digital Photography for 1-6 People (Seattle)

Digital Photo Academy @ Cross Streets TBA, Seattle, WA

Unlock the secrets to stunning photography with a personalized, full-day session in Seattle. Capture breathtaking shots, master your camera settings, and elevate your post-capture skills with expert guidance from Digital Photo Academy instructors. Discover your unique photographic style and create portfolio-worthy images in this private, immersive experience.

(146) All levels 15 and older
$675
Attend
+6750 pts
Gift it!

Half Day Private Digital Photography for 1-6 People (Seattle)

Digital Photo Academy @ Cross Streets TBA, Seattle, WA

Unlock the full potential of your camera and capture stunning images with personalized instruction in Seattle. Discover the best settings for your camera, explore different photography genres, and enhance your post-capture workflow. Join us for a private session tailored to your needs and take your photography to the next level.

(146) All levels 15 and older
$375
Attend
+3750 pts
Gift it!
See all Microsoft classes Seattle

Data Model Design using Power BI Desktop - Level 2

  • All levels
  • 18 and older
  • $595
  • Earn 5,950 reward points
  • 1200 5th Ave, Seattle, WA
  • 8 hours

Start Dates (0)

  • $595
  • 8 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this microsoft training:

This is the second course in TLG Learning’s custom Power BI Desktop training series. 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.

Pre-requisite(s):

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

Outline:

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

Refund Policy

Open Enrollment Desktop Applications Classes -- You may reschedule or cancel your enrollment in a Desktop Applications class at no charge with at least five (5) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel your registration you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Open Enrollment Technical Training Classes with Level TT1, TT2 or TT3 Tech Pricing -- You may reschedule or cancel your enrollment in a Technical Training Class with Level TT1, TT2 or TT3 Tech Pricing at no charge with at least ten (10) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Reviews of Classes at TLG Learning (1)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 5950 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

TLG Learning

For over 20 years, TLG Learning has been trusted by premier companies and government agencies.

We provide complete learning solutions on Microsoft, F5 Networks, ITIL, Cisco, Citrix, CompTIA, VM Ware, Adobe, Project Management, Business Skills, and more.

During the past 3 years, 99% of over 10,000 TLG...

Read more about TLG Learning

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Seattle educator.

TLG Learning

TLG Learning

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Microsoft Office Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...