Your Cart Is Empty
Home > Technical Courses > > Data Model Design using Power BI Desktop Level 2
Learn to use Power Query to build scalable data models through self-service data design.
Using fundamental concepts of Self-Service Data Model Design, students will use Power Query to extract, transform, and load data to create manageable and scalable data models. This course is designed for Report Builders who are ready to create custom data models. Students will also receive an introduction to the M Language as well as Data Analytic expressions (DAX).
Category
ID
Duration
Level
Price
Power BI
13950
1 Day(s)
Intermediate
$695.00
Objectives
In this course, you will learn how to: • Understand Power BI Data Queries • Create and Transform Data Models • Use Data Transformations • Assess Additional Data Sources • Use DAX Calculated Columns and Measures • Become familiar with the M Language
Lesson 1: Understanding Power BI Data Queries • Overview of Power BI Queries • Power Query • Data Sources Lesson 2: Creating and Transforming Data Models • Understanding a Basic Data Model • Creating the Initial Data Query • Converting Raw Data into a Data Model Lesson 3: Data Transformations • Query Editor Transformations • Altering the Data • Creating new Data • Refreshing Data Lesson 4: Accessing Additional Data Sources • Using an Access database • Creating a Hybrid Data Model • Working with Data Lesson 5: DAX Calculated Columns and Measures • Review of Calculated Columns • Power BI Measures • Evaluation Context • Optimize Model Performance • Date Tables Lesson 6: Introduction to the M Language • Power BI Functions: M Language • M Language Syntax • Adding Columns
Questions?
The knowledge and skills that the learner should have before attending this course are as follows: • Data Analysis using Power BI Desktop – Level 1 – Report Builder
Data Model Design using Power BI Desktop Level 2
Class Schedule
Live Online
Course Overview
Training Delivery Methods
With Productivity Point, you will have a spectrum of delivery methods to choose from... when where and how you like it. Whether it's in a classroom or online, we have a delivery option to meets your needs.
Classroom Live
Classroom Virtual
Private Group
On Demand
Classroom Live Training
Get in-person, hands-on instruction with live lab exercises taught by subject matter experts who deliver authorized and industry-leading content.
With classrooms in almost every major U.S. city, Productivity Point has something for users of every level, so you can earn the most popular industry certifications. You get hands-on learning experience with live lab exercises taught by experienced instructors. We proudly advocate our learning services to be hosted by the best-qualified trainers in terms of technical knowledge and teaching skills.
Classroom Virtual Training
Prefer to have a dedicated classroom for your virtual experience? Attend live, hands- on training via remote instructor from one of Productivity Point’s multiple locations.
Enjoy a focused and professional training environment, including all technical equipment provided along with administrative and technical support at your fingertips. With over 150 locations to choose from, review our course catalog or contact your personal Productivity Point Account Manager to see if the course you have in mind is delivered at one of our dedicated virtual classrooms in your area.
Live Online Training
Blend the best from traditional face-to-face instructor-led training with the latest in conferencing technology.
Private Group Training
Your private group classroom experience will not only take place in the location of your choice (including any of our training centers), but you will enjoy the following amenities:
On-Demand Learning
On-Demand is an IT training solution designed around your schedule, budget, and learning needs. Combining high-quality video, reading, and knowledge checks in a self-paced format, On-Demand helps you build skills as your schedule allows—all at once or five minutes at a time.
With On-Demand, you learn at your own pace and in the convenience of your own space.
With Learn at your own pace…
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com