Facebook Pixel
Microsoft Certification Training
Search classes by keyword:
Search classes by category:
Microsoft Certification and Microsoft Training, Cisco Certification and MCSE Certification
Data Model Design Power BI space



Data Model Design using Power BI Desktop Training Course

Microsoft Data Model Design using Power BI Desktop - Level 2

Course Number: #CED-1623
Course Length: 1 day

Grants (discounts) are available for multiple students for the same or different courses.

Guaranteed to Run Guaranteed to Run


Upcoming Dates Class Times Class Format Quote
11/18 - 11/18, 2020Guaranteed to Run 10:00 AM - 6:00 PM ET
9:00 AM - 5:00 PM CT
7:00 AM - 3:00 PM PT
4:00 AM - 12:00 PM HT
Instructor-Led Quote
12/18 - 12/18, 2020 10:00 AM - 6:00 PM ET
9:00 AM - 5:00 PM CT
7:00 AM - 3:00 PM PT
4:00 AM - 12:00 PM HT
Instructor-Led Quote

Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

"Great MOC instructor, great atmosphere, I am speechless! WOW. Great camaraderie, new friendships, and a new view towards technology."

-David Frankfort, Houston, TX

This is the second course in the Power BI Desktop training series. What makes Power BI 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.

Prerequisite:

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

Course 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

CED Solutions is your best choice for Data Model Design Power BI, Data Model Design Power BI training, Data Model Design Power BI certification, Data Model Design Power BI boot camp, Data Model Design Power BI certification training, Data Model Design Power BI certification course, Data Model Design Power BI course, Data Model Design Power BI class.



Data Model Design Power BI space
Search classes by keyword:
Search classes by category:


Copyright © 2020 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.