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.
What you'll learn
Data transformation from different sources is key when working in Excel. In this course, Business Intelligence Workflow with Excel, 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
Course FAQ
This course equips data analysts and Excel power users with Business Intelligence knowledge and best practices.
Learn how Power Query is an easy-to-use, yet powerful tool to import data into Excel, and cleanse and transform data without having to write any code. Then study Cube functions which help to pull data from Analysis Services into Excel.
You likely already know your way around Excel but if you have only ever imported data into Excel by copy and pasting data from different sources, prepare to be blown away by this advanced-level course.
If you're using Excel 2010 or 2013, then you can download Power Query as a separate free add-on. If you're using Excel 2016 or later, then don't worry - you already have Power Query.
About the author
Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work... more