Power BI Essentials: Power BI for Data Transformation, Reporting and Analytics (TTDPB01)
- • Jul 27-28, 2026 · Live Remote Online
- • Sep 14-15, 2026 · Live Remote Online
Contact IT Dojo for current pricing, available dates, and a custom quote tailored to your team or organization.
Course Duration
2 Days
Audience
Employees of federal, state and local governments; and businesses working with the government.
Prerequisites
A general knowledge of database concepts (fields, records, relationships), awareness of key business priorities such as revenue and profitability, and familiarity with Excel.
Course Description
Power BI is a powerful tool for turning raw data into meaningful insights, making it an essential skill for professionals who work with reporting, analytics, and business intelligence. In this hands-on, expert-led course you will learn how to connect, clean, transform, and visualize data using Power BI's core features, building practical skills that allow you to structure data for analysis, create dynamic reports, and confidently work within the Power BI ecosystem. Power BI Essentials is a two-day, hands-on course designed for those new to Power BI. It walks you through basic workflows, from shaping and preparing data in Power Query Editor to building relationships in a data model and writing basic DAX calculations. You will learn to apply best practices for formatting reports, use slicers and filters to improve interactivity, and create drill-through pages for deeper insights. You will also explore how to enhance reports with hierarchies, tooltips, and calculated columns. As you progress, you will work with the Power BI Service to publish and share reports, set up refresh schedules, and manage workspaces effectively. By the end of the course you will have the confidence to clean and structure data efficiently, create compelling reports, and share them seamlessly across your organization.
Learning Objectives
- Connect and transform raw data using the Power Query Editor.
- Design interactive reports with advanced visualizations and filters.
- Write basic DAX calculations for meaningful insights.
- Build and enhance a data model with relationships, hierarchies, and a date table.
- Publish and manage reports on the Power BI Service.
Course Outline
Introduction to the Power BI Ecosystem
- What is Power BI and an overview of the Power BI ecosystem.
- Tour of Power BI Desktop and the Power Query Editor.
- The Extract, Transform, Load (ETL) process.
Transforming Data in the Power Query Editor
- Clean and transform raw data using the ribbon and mastering data types.
- Leveraging Applied Steps; finding nulls, blanks, and empties.
- Adding custom columns and removing unnecessary columns.
- Introduction to the 'M' language; merging and appending data sources.
Creating and Enhancing the Data Model
- What a data model is and why it is necessary.
- Reviewing and creating relationships; using basic DAX to add data.
- Introduction to filter context and DAX.
- Enhancing the semantic model: hierarchies, hidden fields, synonyms, descriptions.
- Creating and connecting a date table.
Creating a Report
- Formatting pages and using themes; choosing and placing visuals.
- Visual header controls and editing visual interactions.
- Slicers, the filter panel, and syncing slicers.
- Formatting tooltips, creating a tooltip page, and building a drill through.
- Evaluating page and visual performance.
Publishing and the Power BI Service
- Publishing a report and semantic model to a workspace.
- Tour of the Power BI Service and understanding workspaces.
- Editing privileges, creating a dashboard, and setting a refresh schedule.
- Creating an app, defining audiences, and publishing to an app.
Frequently Asked Questions
What does the Power BI Essentials (TTDPB01) course cover?
This course covers Power BI Essentials: Power BI for Data Transformation, Reporting and Analytics (TTDPB01) 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 Power BI Essentials (TTDPB01) training?
IT Dojo's Power BI Essentials (TTDPB01) training is 2 Days. 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.
How is this course different from the Microsoft PL-300 Power BI Data Analyst course?
Power BI Essentials (TTDPB01) is a two-day, vendor-neutral introduction that quickly gets new users productive with data transformation, modeling, reporting, and publishing. The Microsoft PL-300 course is a longer, certification-focused path aligned to the Power BI Data Analyst exam. IT Dojo offers both so you can choose the right depth for your team.
Is this course available as live remote online training?
Yes. IT Dojo offers Power BI Essentials (TTDPB01) 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.
Does IT Dojo offer this training on-site at government or DoD facilities?
Yes. IT Dojo delivers Power BI Essentials (TTDPB01) 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 Power BI Essentials (TTDPB01) 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.