- • Jun 24, 2026 · Live Remote Online, 10:00 AM–6:00 PM ET
- • Jul 29, 2026 · Live Remote Online, 10:00 AM–6:00 PM ET
- • Sep 2, 2026 · Live Remote Online, 10:00 AM–6:00 PM ET
Data Model Design using Power BI Desktop – Level 2
Course Duration
1 Day
Audience
Employees of federal, state and local governments; and businesses working with the government.
Prerequisites
No prerequisites required.
Course Description
This is the second course in the 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.
Course Outline
- Unit 1: Understanding Power BI Data Queries
- Unit 2: Creating and Transforming Data Models
- Unit 3: Data Transformations
- Unit 4: Accessing Additional Data Sources
- Unit 5: DAX Calculated Columns and Measures
- Unit 6: Introduction to the M Language
Frequently Asked Questions
What does the Data Model Design using Power BI Desktop – Level 2 course cover?
This course covers Data Model Design using Power BI Desktop – Level 2 training and best practices. IT Dojo delivers it as live instructor-led training with an emphasis on practical skills for government and DoD professionals.
How long is IT Dojo's Data Model Design using Power BI Desktop – Level 2 training?
IT Dojo's Data Model Design using Power BI Desktop – Level 2 training is 1 Day. It is available as live remote online instruction or on-site at your facility. All sessions are instructor-led with small class sizes to ensure individual attention.
Is this course available as live remote online training?
Yes. IT Dojo offers Data Model Design using Power BI Desktop – Level 2 as live remote online training. A certified instructor leads the session in real time. Students interact via chat or microphone. Classes are kept small (typically no more than 16 students) to ensure engagement. On-site delivery at your government facility or contractor location is also available.
Who should attend this course?
Employees of federal, state and local governments; and businesses working with the government.
Does IT Dojo offer this training on-site at government or DoD facilities?
Yes. IT Dojo delivers Data Model Design using Power BI Desktop – Level 2 on-site at government agencies, DoD commands, military installations, and contractor facilities. On-site training is ideal for teams of four or more and can be customized to your organization's specific environment and mission requirements. Contact IT Dojo to schedule.
How do I register for this course?
IT Dojo training is employer sponsored. Your organization registers and pays for seats. To schedule Data Model Design using Power BI Desktop – Level 2 for your team, contact IT Dojo via the Request Training form or call 757-216-3656. IT Dojo will work with your contracting officer, training coordinator, or program office to set up the course.