Amazing Reports and Dashboards with Excel Power View
4.7 (87 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,198 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Amazing Reports and Dashboards with Excel Power View to your Wishlist.

Add to Wishlist

Amazing Reports and Dashboards with Excel Power View

Learn to use the new Excel 2013 PowerView feature to create powerful interactive dashboards and analyze data.
4.7 (87 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,198 students enrolled
Created by Ian Littlejohn
Last updated 6/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 8 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Introduction to Power View
  • Learn to create different forms of Tables
  • Learn to create Column, Bar and Line Charts
  • Analyze data with Pie and Scatterplot Charts
  • Visualize Data Geographically
  • Learn About Filters and Advanced Filters
  • Create Relationships Between Tables
  • Create Interactive Dashboards
View Curriculum
Requirements
  • Excel 2013 with PowerView
Description

Join the 1% of Excel users who know how to use the most powerful features and tools in Microsoft Excel

Excel Power View is a powerful new tool in Excel 2013 which will allow you to explore, visualize and present your data in ways you never knew possible.

Learn to use Power View to create powerful interactive graphical dashboards. Power View is an interactive data exploration, visualization and presentation experience that improves decision making and gives you strong insight in to your business.

Amazing Reports and Dashboards with Excel Power View is the second course to be released about Excel Business Intelligence. The Excel Business Intelligence suite of tools includes PivotTables, PowerPivot, Power View, PowerQuery, PowerMap and PowerBI.

Excel Business Intelligence skills and capabilities are in high demand as companies are using Excel to analyze their business data to generate new intelligence and insight. McKinsey Consulting recently released a report showing that approximately 1.5 million new management job positions are required in the United States with data analysis skills and capabilities.

This course introduces you to the Excel Power View interface, teaches you how to create tables and graphs, learn to easily filter data and ask questions of your data, perform powerful data analysis and develop interactive dashboards.

The course also includes how to create relationships between between two tables of data and how to easily create reports and visualizations from both data sources using simple drag and drop actions. The course teaches users how to easily create time based scatterplot and bubbleplot advanced visual analysis techniques.

This course is for any Excel user who develops management reporting or performs data analysis to gain new insight from data. Excel Power View is only available in specific versions of Excel 2013 so first confirm that you have the correct version of Excel.

The course includes two downloadable training datafiles and currently has 23 video lectures showing how to use Excel Power View.

Who is the target audience?
  • Business users who analyse data and create management reports
  • Excel users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
02:25:42
+
Introduction to PowerView
5 Lectures 10:53

This presentation provides you with an overview and an understanding of the course content.

Preview 01:46

About Excel Power View
02:37

This step by step guide will show you how to activate Excel Power View in Excel 2013

Activating Excel Power View
1 page

Please download the Excel training data set. This will allow you to copy the lectures and demonstrations that are in the course.

Download the Training Data
00:04

In this lesson we learn to create the data structure in Excel to be able to analyze our data using Power View and PivotTables.

Correctly Structure Your Data
06:26
+
Creating a PowerView Report
8 Lectures 45:02
Introduction to the First Section
00:28

Learn to add a new Power View canvas to Excel. This lessons shows you how to add a new Power View canvas.

Insert a New Canvas
03:47

Learn to create your first table on PowerView.
Create a Table
04:33

Learn the PowerView menu options and how they affect your dashboards
PowerView Menu Options
09:31

Learn to use the Tiles feature to easily and quickly filter and view your data.
Preview 03:55

Learn to easily create different types and formats of Tables in PowerView.
Different Table Types
04:52

Easily create different methods of aggregation such as average, distinct count, count, max and min
Changing the Method of Calculation
08:11

Pop Outs and Filtering Tables
09:45
+
Graphs and Visualizations
8 Lectures 01:00:05
Introduction to Graphs and Visualizations
00:32

Learn to create effective column charts in Power View.

Create a Column Chart
12:01

Learn to create effective bar charts in Power View.

Create a Bar Chart
05:39

Learn to use Line graphs to display trends in data.

Preview 14:38

Create Piecharts to display percentage contributions in your data.

Creating Pie Charts
06:11

Learn to create maps and geographical analysis in Power View.

Geographical Mapping
07:15

Scatterplots are a powerful data analysis tool allowing the user to identify correlations and outliers in data. Scatterplots easily allow managers to identify and understand data points that require focus and attention.

Create a Scatterplot Chart
08:15

Understanding how scatterplots change over time provides new insight and intelligence from data.

Preview 05:34
+
Data Relationships
5 Lectures 19:45
Introduction to Data Relationships
00:15

Please download the attached spreadsheet for the training data under the supplementary materials section.

Download the Power View World Bank Indicators spreadsheet
00:04

Learn to create relationships between one or more tables of data in Excel. Power View develops reports and visualizations from the linked tables of data.

Creating Data Relationships
06:27

Develop reports and visualizations from tables with relationships in Power View.

Creating Graphs with Data Relationships
05:11

Learn to create powerful scatterplot visualizations from tables with relationships in Power View

Creating Scatterplots with Data Relationships
07:47
+
Interactive Dashboards
2 Lectures 08:35
Introduction to Interactive Dashboards
00:12

Create powerful interactive dashboards in Power View

Creating Interactive Dashboards
08:23
+
Conclusion
1 Lecture 00:17
Conclusion
00:17
About the Instructor
Ian Littlejohn
4.4 Average rating
1,619 Reviews
9,969 Students
11 Courses
Excel Power Tools, Power BI and Google Data Studio Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio.  Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query,  Power BI and Google Data Studio.

Ian has been training learners on these powerful technologies for over 10 years making it easy for business users 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 and Google Data Studio 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.