What you'll learn:
- Build a repeatable query in Power BI that reloads next month's file in one click, instead of redoing the import
- Filter rows, change data types, remove and reorder columns, and add calculated columns in the Query Editor
- Write conditional IF rules in the Query Editor to categorize your data without touching DAX
- Merge two tables on a matching column, and append separate files into one table ready for modelling
- Group and summarize data with Group By, and build custom calculations inside the query Find and fix broken data with Query Editor Diagnostics
- Load data from SQL Server, CSV and text files, web pages, XML, JSON and published Power BI datasets
This course contains the use of artificial intelligence.
Every lesson in this course is written, created and recorded by me. AI is used only to help produce supporting images and written materials around the lessons.
Most Power BI reports fail before a single chart is drawn. The data arrives in three files with different column names, the dates are stored as text, and half the rows are duplicates. This course is about that half of the job.
You will work entirely in the Power BI Query Editor: connect to a source, shape it, clean it, and save the steps, so that next month's file loads the same way in one click.
WHAT YOU WILL BUILD
Basic transformations - filter rows, change data types, remove and reorder columns, and add calculated columns
Advanced transformations - merge two tables on a matching column, append separate files into one table, group and summarize, and write custom calculations
Conditional rules - categorize your data with IF logic in the Query Editor, without touching DAX
Data cleansing - find and fix broken data with Query Editor Diagnostics, before it reaches your model
Connect to data sources - SQL Server, CSV and text files, web pages, XML, JSON and published Power BI datasets
Power BI Service dataflows - move your queries into the Service so a whole team reuses the same cleaned data
Every section sets a practical activity and then walks through the answer on video, and eleven training data files mean you are working on exactly the data I am.
MEET YOUR INSTRUCTOR
I have been training business people to work with data since 2008, and publishing on Udemy since 2013. I now have 16 live courses, more than 450,000 enrolments and more than 139,000 reviews, averaging 4.6. This course is rated 4.6 from 4,235 ratings.
I specialise in teaching business users the analysis methods behind the tools - Microsoft Excel, Copilot in Excel, Microsoft Power BI, Looker Studio and Amazon QuickSight. I teach the analysis, not just the software.
WHAT STUDENTS ARE SAYING
"Step by step process allowed me to understand stuff immensely"
"I have learned a lot about power BI on this learning and I now have a better understanding about it"
"I had basic PBI knowledge, this course helped me to improve my current skills. Professional, understandable and clear communication with a lot of great examples which can be used for my work on daily basis. Thank you !!!"
Ready to stop rebuilding the same import every month? Start with the first transformation and see how much of your reporting time you get back.
