Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Business Intelligence with Excel 2013 to your Wishlist.

Add to Wishlist

Business Intelligence with Excel 2013

Learn to use Power Query, Power Pivot, Pivot Tables, Power View and Power Map to create powerful reports and dashboards
Bestselling
4.6 (117 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,339 students enrolled
Created by Ian Littlejohn
Last updated 11/2016
English
$150
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 10 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn the new Business Intelligence technologies in Excel 2013
Analyze data and create reports in a fraction of the time of spreadsheets
Learn to manage millions of rows of data in Power Pivot
Create new powerful calculations, KPIs and Key Metrics
Create new table relationships for reporting and dashboards
Use Power View to create interactive dashboards and analyzing data
Learn to use Power Query to import, merge, clean and transform data
Use Power Map to visualize and analyze geographical data
View Curriculum
Requirements
  • Be familiar with Excel
Description

Business Intelligence with Excel 2013

Excel 2013 is a game changer for any Excel user. Excel 2013 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2013.

In this course we learn the following:

Power Query

  • Cleaning up Data
  • Merging Data
  • Appending Data
  • Grouping Data
  • Loading data to PowerPivot

Power Pivot

  • Create relationships between Tables
  • Manage millions of rows of data
  • Custom Calculations, Key Metrics and KPIs
  • Analyzing Data with Pivot Tables
  • Analyzing Date data

Power View

  • Creating Tables and Cards
  • Visualizing data with Graphs
  • Creating Interactive dashboards
  • Filter and Ask Questions of your Data
  • Powerful data analysis with ScatterPlots and BubblePlots
  • Visualize Geographical data and maps
Power Map
  • Mapping Data with Power Map
  • Changing the Method of Visualization
  • Changing the Method of Aggregation
  • Mapping Data over Time
  • Creating Tours

This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.

Who is the target audience?
  • Excel 2013 users
  • People who do reporting and create dashboards
  • People who analyze data and create new insight
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 42 Lectures Collapse All 42 Lectures 03:54:39
+
Introduction
2 Lectures 05:19

Welcome to the Business Intelligence Technologies for Excel 2013. This course will provide a comprehensive overview of Power Query, Power Pivot, Power View and Power Map.

Preview 02:59

In this lesson we will cover how to activate the add-ins for Power Query, Power Pivot, Power View and Power Map.

Activating Add Ins for Excel 2013
02:20
+
Working with Power Query
11 Lectures 01:01:06
Introduction to Power Query
00:50

In this lesson we review the menus and options for the Power Query interface.

Preview 08:39

Please click on the View Resources button to download the Power Query training data file.

Download the Training Data File
00:06

In this lesson we review how to easily transform data using the Power Query interface. Learn to remove columns, rename columns and replace values in data sources.

Cleaning and Transforming Data with Power Query
14:39

Click on the View Resource button to download the append training data sources.

Download the Append Training Data
00:06

Learn to easily append data sources with Power Query. Data sources need to have the same data structure to append data.

Appending Data with Power Query
09:22

Click on the View Resources button to view the Power Query merge function. Please download the training data files to follow the lesson.

Download the Merge Data Files
00:06

In this lesson we will learn to easily merge data from different data sources. This particularly useful for looking master data names and other attributes.

Merging Data with Power Query
08:53

Download the Sales Data Files
00:03

Learn to use the Group By function in Excel Power Query to create great summary tables. For example create a summary table that shows total sales, total profit and number of transactions by Customer.

Using the Group By Feature
08:06

In this lesson we will cover how to load data from Power Query into Power Pivot. This is particularity useful for loading data sources that are greater than 1 million rows that can not be loaded into Excel.

Loading Data into PowerPivot
10:14
+
Working with Power Pivot / Data Model
10 Lectures 01:16:06
Introduction to Power Pivot
01:24

Introduction and overview of Excel Power Pivot.

Preview 01:49

Please click on the View Resources button to download the Employee Master Training file to use in this section.

Download the Employee Master Training File
00:03

In this lesson we review how to easily load and import data into Excel Power Pivot.

Loading Data into Power Pivot
07:28

In this lesson we review how to create relationships between tables of data in Excel Power Pivot.

Creating Relationships in Power Pivot
03:42

In this lesson we will review how to analyze data that is in Excel Power Pivot using Excel Pivot Tables.

Preview 08:56

How to create calculated columns in Power Pivot

Creating Calculated Columns
12:11

In this lesson we review how to easily create powerful calculated fields in Power Pivot. Calculated fields allow the user to create new custom calculations, KPIs and Key Metrics.

Creating Calculated Fields
11:33

In this lesson we review how to use Pivot Tables and Pivot Charts to analyze and review Excel Power Pivot data.

Pivot Tables and Pivot Charts
14:29

In this lesson we create an interactive dashboard using Excel Pivot Tables and Pivot Charts using Power Pivot data.

Interactive Dashboards
14:31
+
Excel Power View
11 Lectures 01:09:12
Introduction to Power View
00:58

In this lesson we review the Excel Power View designer.

Introduction to Power View
04:12

This lesson teaches how to create tables of data in Excel Power View using simple drag and drop technologies. With tiles we show how to easily filter the data displayed in Excel Power View tables.

Tables and Tiles in Power View
08:15

Learn to create powerful column and bar visualizations using Power View graph types. Learn to use clustered, stacked and 100% graph types.

Column and Bar Visualizations
14:27

Learn to use the line graph to easily visualize time and trend data. Easily review how data changes and the movements over time.

Line Graph Visualization
05:55

In this lesson we will create a powerful fully interactive dashboard using tables and graphs using Excel Power View designer.

Preview 09:54

In this lesson we will learn to use the powerful Excel Power View filtering capabilities to ask questions of our data

Using Filters in Power View
06:03

Please click on the View Resources button to download the Sales training data file.

Download the Sales Training Data Source
00:03

In this lesson we will learn how to use Power View scatterplots to understand correlations between data. Scatterplots are a very powerful method of data analysis.

ScatterPlots in Power View
07:12

Learn to use the Time feature in Scatterplots to display how your data changes over time.

ScatterPlots over Time
04:24

Learn to use the powerful mapping and geographical analysis tools in Excel Power View.

Mapping Geographical Data
07:49
+
Power Map
7 Lectures 22:16
Introduction to Power Map
00:38

Introduction to the Excel Power Map geographic and mapping tool.

Preview 03:00

In this lesson we will learn to map geographic data in Excel Power Map.

Mapping your Geographical Data
03:39

Learn to change the method of visualization from clustered columns, stacked columns and hot spots in Excel Power Map.

Preview 05:31

Learn to view the changes and movements in data over time. Visualize the changes in your data on the Power Map.

Mapping over Time
01:42

Change the method of visualization from Sum, Average, Count, Distinct Count, Max and Min.

Changing the Method of Aggregation
04:43

Create video based tours of your data that has been created in Excel Power Map.

Creating Tours
03:03
+
Conclusion
1 Lecture 00:50

The conclusion to the course.

Conclusion
00:50
About the Instructor
4.4 Average rating
917 Reviews
6,547 Students
9 Courses
Excel Business Intelligence and Power BI Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and techniques making it easy for learners to harness the power of Excel PivotTables, PivotCharts, PowerPivot, Power Query, PowerView and Power BI.

Ian has been training learners on these powerful technologies for a number of years making it easy for the business user to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.

Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.

Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.

Report Abuse