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.4 (50 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.
931 students enrolled
$20
Take This Course
  • Lectures 29
  • Contents Video: 2.5 hours
    Other: 6 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2014 English

Course 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.

What are the requirements?

  • Excel 2013 with PowerView

What am I going to get from this course?

  • 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

What is the target audience?

  • Business users who analyse data and create management reports
  • Excel users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to PowerView
01:46

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

About Excel Power View
Article
1 page

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

Article

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

06:26

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

Section 2: Creating a PowerView Report
Introduction to the First Section
Article
03:47

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

04:33
Learn to create your first table on PowerView.
09:31
Learn the PowerView menu options and how they affect your dashboards
03:55
Learn to use the Tiles feature to easily and quickly filter and view your data.
04:52
Learn to easily create different types and formats of Tables in PowerView.
08:11
Easily create different methods of aggregation such as average, distinct count, count, max and min
Pop Outs and Filtering Tables
09:45
Section 3: Graphs and Visualizations
Introduction to Graphs and Visualizations
Article
12:01

Learn to create effective column charts in Power View.

05:39

Learn to create effective bar charts in Power View.

14:38

Learn to use Line graphs to display trends in data.

06:11

Create Piecharts to display percentage contributions in your data.

07:15

Learn to create maps and geographical analysis in Power View.

08: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.

05:34

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

Section 4: Data Relationships
Introduction to Data Relationships
Article
Article

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

06:27

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.

05:11

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

07:47

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

Section 5: Interactive Dashboards
Introduction to Interactive Dashboards
Article
08:23

Create powerful interactive dashboards in Power View

Section 6: Conclusion
Conclusion
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ian Littlejohn, Excel Business Intelligence 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 and PowerView.

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.

Ready to start learning?
Take This Course