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.
Data transformation from different sources if 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. Topics:
- Course Overview
- Importing Data from Different Data Sources
- Queries in Power Query
- Transform and Consolidate Data
- What-if Analysis
- Cube Functions