The live session will start in...
This one-hour webinar with QA's Richard O'Brein will demonstrate and introduce some of Excel’s data analysis and data modelling tools. These tools make it easier to work with larger datasets and enable you to import data; clean and transform it using Power Query Editor; relate and model data using Power Pivot; and present and visualise it using PivotTables and PivotCharts.
- Importing data
- Transforming data using Power Query Editor
- Modelling data using relationships and simple DAX formulas in Power Pivot
- Visualising data using Excel’s PivotTable and PivotChart capabilities
Anyone wanting to gain an awareness of Excel’s ‘Power Tools’ – Power Query Editor and Power Pivot – and who wants to see how the tools can fit into a BI/MI and data analysis workflow, all from the familiar Excel environment and without having to invest in purchasing extra software. The tools are only available in Excel 2016 onwards.
Richard is one of the Principal Technical Learning Specialists in our Digital Productivity and Office Applications team, has worked for QA for over two decades, and has over three decades of experience as both an Excel user and an instructor. He is a Microsoft Certified Power BI Data Analyst, Microsoft Certified Trainer, and a Microsoft Office Specialist Master Instructor and teaches a wide range of software applications.