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 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.
Who is this course for?
This course equips data analysts and Excel power users with Business Intelligence knowledge and best practices.
What will I learn in this course?
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.
What prerequisites do I need?
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.
What version is required?
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.
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.