Learn how to prepare and format data in Power BI® for professional looking reports.
It’s a known fact that raw data loaded into Power BI® is hardly ever report-ready and requires ‘cleaning’ to make it useable.
Unnecessary rows and columns need to be removed, data that isn’t required needs to be filtered out, dates are never in the right format and often aren’t even dates, columns require splitting or merging, ‘weird’ characters must be removed. These are just a few examples of what is meant by data cleaning.
If you’ve mastered the basics of Power BI® and the phrase ‘it’s taking too long’ describes how you feel about the time it takes to get your raw data into the right format for your reports, this training is for you.
Learning Objectives
- You will be able to review managing query steps.
- You will be able to explain applying filters.
- You will be able to discuss cleaning database data.
- You will be able to identify calculations without formulas.
Agenda
- An Introduction to the Power BI® Query Editor
- Managing Query Steps
- Removing Columns From Your Imported Data
- Splitting a Single Column Into Multiple Columns
- Applying Filters
- Cleaning Date-Based Data
- Cleaning Text-Based Data
- Calculations Without Formulas - the Power of the Query Editor Ribbon
- Unpivot - the Hidden Gem and Unsung Hero of the Query Editor
Speakers
Mike Thomas,
theexceltrainer.co.uk- UK-based IT trainer with a career spanning 30+ years
- Delivered thousands of courses and produced hundreds of written and video-based tutorials
- Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI
- A fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries, including healthcare, pharmaceutical, and public sector
- Designs and develops Microsoft Office®-based solutions that automate key business tasks and processes
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, HR professionals, analysts, controllers, and accountants.
