Business Intelligence Workflow with Excel

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.
Course info
Level
Advanced
Updated
Aug 6, 2020
Duration
1h 44m
Table of contents
Description
Course info
Level
Advanced
Updated
Aug 6, 2020
Duration
1h 44m
Description

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.

About the author
About the author

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.

More from the author
Troubleshooting Excel Formulas
Advanced
1h 25m
Dec 4, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is Amruta Mahajan, and welcome to my course, Business Intelligence Workflow with Excel. I have been a data analyst and Excel VBA developer for the last 10 years working on complex Excel‑based applications in Finance, software, and consumer goods industries. They say that the best camera is the one that's with you. The same can also be said of business intelligence tools. Most workplace PCs already have Excel installed, and you likely already know your way around it. In this course, we are going to look at all aspects of the business intelligence spectrum completely within Excel. We'll start by taking a closer look at PowerQuery that can be used to import data from various sources, both one time, as well as on an automated schedule. We will look at all the tools at our disposal for consolidating, shaping, and transforming all this data. We will do some what‑if analysis and scenario planning, and, finally, close the course out by looking at cube functions that help us freely move the data between what is known as Excel data model and individual Excel cells. By the end of the course, you will be able to not just import data from various sources, but also confidently and efficiently shape and transform it according to your needs. Before beginning the course, you should be familiar with the basics of Excel. I hope you'll join me on this journey to learn data analysis and representation in the Business Intelligence Workflow with Excel course, at Pluralsight.