Excel Power Tools for Data Analysis

Description

Nicky BullPrashan S. M. Karunaratne

Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data.

Excel's ease and flexibility have long made it a tool of choice for doing data analysis, but it does have some inherent limitations: for one, truly "big" data simply does not fit in a spreadsheet and for another, the process of importing and cleaning data can be a repetitive, time-consuming and error-prone. Over the last few years, Microsoft have worked on transforming the end-to-end experience for analysts, and Excel has undergone a major upgrade with the inclusion of Power Query and Power Pivot.

Read more.

Career Relevance by Data Role

The techniques and tools covered in Excel Power Tools for Data Analysis are most similar to the requirements found in Business Analyst job advertisements.


Similarity Scores (Out of 100)