Featured resource
2025 Tech Upskilling Playbook
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Check it out
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Business Intelligence Workflow with Excel 2019

This course equips data analysts and Excel power users with the Business Intelligence knowledge and best practices required to import data into Excel from different data sources, clean the data, and transform this data into any desired format.

Amruta Mahajan - Pluralsight course - Business Intelligence Workflow with Excel 2019
Amruta Mahajan
What you'll learn

Data transformation from different sources if key when working in Excel. In this course, Business Intelligence Workflow with Excel 2019, you will be equipped with Business Intelligence knowledge, tools, and best practices required to import data into Excel from different data sources, clean the data, and transform this data into any desired format. First, you will see how Power Query is an easy-to-use, yet powerful tool to import data from different sources. Next, you will learn how Power Query can cleanse and transform data without having to write any code. Then, you will also study What-if analysis which allows users to use several data sets in one or more formulas to explore various results. Finally, you will study Cube functions which help to pull data from Analysis Services into Excel. When you are finished with this course, you will have an understanding of the insertion and transformation process data goes through when imported into Excel.

Table of contents

About the author
Amruta Mahajan - Pluralsight course - Business Intelligence Workflow with Excel 2019
Amruta Mahajan

Amruta is a data Analyst & Excel VBA ninja who's worked with market leaders in Finance & Consumer Goods. She is passionate about sharing her gift for data manipulation and visualization.

Get access now

Sign up to get immediate access to this course plus thousands more you can watch anytime, anywhere.

Get started with Pluralsight