Analyzing Data with Power BI Desktop is a course in the full Power BI workflow, from preparing data in Power Query, designing a data model and writing DAX to building interactive dashboards and publishing them to the Power BI Service. It suits staff who report from Excel, team leaders and IT teams, and you leave with a sales dashboard built from raw data.
Many organisations keep their data spread across Excel workbooks, CSV files and several databases. Every month end, staff copy, paste and reformat the same reports, figures from different departments do not match, and managers do not see the big picture in time. Power BI Desktop brings this data into a single model, cleans it automatically and produces interactive reports that update themselves when the data changes.
This course takes learners through the whole data analysis workflow in Power BI Desktop. It starts with connecting to data sources and transforming data in Power Query, then designs a star schema data model and writes DAX, from basic measures and CALCULATE to time intelligence and visual calculations. Learners then design dashboards that are easy to read and interact with, and publish them to the Power BI Service with refresh, gateway, app and row-level security settings. It closes with a project that builds a sales report from raw data all the way to sharing it with users. (3 days, 6 hours per day, 18 hours in total, Beginner to Intermediate level.)
Course Details
This course is the 2026 edition of Analyzing Data with Power BI Desktop, rewritten for the current Power BI Desktop. It runs for 3 days, 6 hours per day (18 hours in total, 09:00-16:00), as lectures with labs on a single sales dataset throughout. Beginner to Intermediate level. Day one prepares data with Power Query, day two designs the data model and writes DAX, and
day three designs dashboards and publishes them to the Power BI Service with refresh, gateway, apps and row-level security. The course focuses on a complete foundation for data analysis; learners who want to go deeper into DAX or Power BI's AI features can continue with the institute's DAX and Power BI with AI courses. Learners take home the sample datasets and the Power BI files for every lab.
Section 1: Lab: Getting Started with Power BI Desktop
Section 2: Lab: Connecting to Data Sources
Section 3: Lab: Transforming and Cleaning Data with Power Query
Section 4: Lab: Combining Data and Reshaping Tables
Section 5: Parameters, the M Language and Maintainable Queries
Section 6: Lab: Designing a Star Schema Data Model
Section 7: Lab: Getting Started with DAX
Section 8: Lab: CALCULATE and Filter Context
Section 9: Lab: Time Intelligence
Section 10: Visual Calculations and Tools for Writing DAX
Section 11: Lab: Designing Readable Dashboards
Section 12: Lab: Interactive Reports
Section 13: Lab: Publishing to the Power BI Service
Section 14: Refresh, Gateway and Row-Level Security
Section 15: Workshop: A Sales Report from Raw Data to Sharing
DAX (Data Analysis Expressions) is the formula language of Power BI, used to create measures and calculated columns. It looks like Excel formulas but works on tables and columns rather than cells, and a measure's result changes with the filters the user applies in the report, such as slicers or clicks on a chart. The key to DAX is understanding filter context and the CALCULATE function, which this course practises through business questions such as sales against target and share of sales.
Create a date table with a continuous run of dates, mark it as the model's date table and relate it to your sales table. Then write a measure with TOTALYTD, for example TOTALYTD([Sales], 'Date'[Date]), or use CALCULATE with DATESYTD. If your organisation uses a fiscal year, pass the year-end date as an extra argument. For a running total that only applies inside one visual, you can use a visual calculation instead of adding a measure to the model.
Power BI Desktop is a free Windows application where you connect to data, transform it, build the model and measures and design reports. The Power BI Service is the cloud platform where you publish reports, organise workspaces, create apps, share content, schedule refresh through a gateway and apply row-level security. Sharing in the Service needs a Pro licence or organisational capacity. The usual workflow is to build in Desktop and then publish to the Service.
It suits staff and analysts who report from Excel, team leaders who track figures with dashboards, teachers, lecturers, students and IT teams who look after reports for their organisation. You should be confident with Excel, including PivotTables, and understand tables, rows and columns. No previous Power BI experience is needed, and some SQL knowledge is helpful.
You will be able to connect to Excel, CSV, folders and databases, prepare and combine data in Power Query, design a star schema model, write DAX including CALCULATE and time intelligence, build dashboards with drillthrough, tooltips and bookmarks, and publish them through the Power BI Service with refresh, a gateway and row-level security. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.
Yes. It can be run in-house for your team, with examples adapted to your own work, such as building dashboards from the sales data or reports your team already uses. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
As a system grows and several teams work on it, a single monolithic application tends to become hard to change, slow to deploy and liable to fail as a whole when one part breaks. Microservices architecture splits the system into smaller services that can be…
Many teams still email attachments back and forth until nobody knows which file is the latest, arrange meetings through several chat apps and collect survey answers on paper. Google Workspace brings Gmail, Calendar, Drive, Docs, Sheets, Slides, Forms, Meet…
Many organisations keep their core data in Excel, from customer and product registers to staff records and sales. As the data grows and several people enter it, the same problems keep appearing: numbers stored as text, duplicates, inconsistent spelling,…
