Time: 10:00 AM - 11:30 AM (PT)
Duration: 90 Minutes
Webinar Type: Live Webinar
Speaker: Mike Thomas
Date : Thursday, July 18, 2024
Course Description:
It's a known fact that raw data loaded into Power BI is hardly ever "report-ready" and requires "cleaning" to make it usable. 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, and "weird" characters must be removed. These are just a few examples of what is meant by data cleaning.
In this comprehensive course, you will learn how to transform messy data into pristine, report-ready datasets using Power BI Query Editor. We will cover essential skills such as managing query steps, splitting and merging columns, applying filters, and cleaning date and text-based data. Additionally, you'll discover powerful features like calculations without complex formulas and the "Unpivot" function, the hidden gem of the Query Editor. By the end of this course, you will be equipped with the tools and techniques needed to efficiently clean and restructure your data, ensuring your reports are accurate and insightful.
Why Should You Attend?
Unlock the full potential of your data with our comprehensive webinar on Power BI Query Editor! Learn how to swiftly clean and restructure less-than-ideal data, combine multiple datasets seamlessly, and create additional columns effortlessly without complex formulas. This session will empower you to handle data challenges efficiently, transforming messy data into actionable insights. Mastering these skills will save you time and enhance your data analysis capabilities, allowing you to make more informed decisions with ease.
Learning Objective:
How to create simple solutions to quickly clean and restructure less-than ideal data
How to combine data from multiple datasets
How to create additional columns without complex formulas
Area Covered In The Webinar:
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
Who Will Benefit?
Payroll Supervisors and Personnel
Payroll Consultants
Payroll Service Providers
Public Accountants
Internal Auditors
Tax Compliance Officers
Enrolled Agents
Employee Benefits Administrators
Officers and Managers with Payroll or Tax Compliance Oversight
Company/Business Owners
Managers/Supervisors
Public Agency Managers
Audit and Compliance Personnel /Risk Managers
Instructor Profile:
In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.
Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
