Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Business Intelligence Workflow with Excel

via Pluralsight

Overview

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

Taught by

Amruta Mahajan

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Business Intelligence Workflow with Excel

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free