Reports and Dashboards with Excel Power View
|
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, Power Pivot, Power View, Power Query, Power Map 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.
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.
WHAT'S IN THE COURSE?
- 2 hours of content, 23 lectures, 2 downloadable training data files
- 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
COURSE REQUIREMENTS:
Excel 2013 with Power View
Excel 2013 with Power View
/
- 1
- 2
- 3
- 4
- 5
This instructor is an excellent teacher. This is the second course I have bought by this instructor and he is extremely precise and explain with great clarity. I am extremely satisfied with this course and this has pivoted me to another level to be able to massage my data and be more insightful of my numbers. Thank you again for such a great course
/
- 1
- 2
- 3
- 4
- 5
/
- 1
- 2
- 3
- 4
- 5
Fantastic work by Ian. Have bought most of his courses. Each course adds some wow factor and impresses us with the power of Power View. Great tool and free too and can be utilized in any organization
/
- 1
- 2
- 3
- 4
- 5
/
- 1
- 2
- 3
- 4
- 5
This is an excellent overview of the Power View feature. Gives you what you need to get started using it with your own data.
/
- 1
- 2
- 3
- 4
- 5
/
- 1
- 2
- 3
- 4
- 5
Perfect for Beginner to Intermediate. Explains all you need to use Excel PowerView effortlessly. Great job.
/
- 1
- 2
- 3
- 4
- 5
/
- 1
- 2
- 3
- 4
- 5
Ian has definitely put together a wonderful course on working with Power View in Excel 2013. This is newbie friendly as Ian walks you through in detail about each and every step that has to be taken to build the report. He goes to the extent of explaining how to clean up the raw data before you create all those tables and charts from the data. Seriously! It's worth it.
/
- 1
- 2
- 3
- 4
- 5
- 0
- 1
- 2
- 3
- 4