Power View
Power View is a powerful new tool released by Microsoft for Excel 2013 which will allow you to explore, visualise and present your data in ways you never knew possible. Power View has been designed to bring Business Intelligence capabilities to the Excel user. Power View is a canvas that allows users to create interactive dashboards, visualizations and ask ad-hoc questions of their data using simple drag and drop interactions.
Power View provides a wide range of graphs and visualization technologies. The user is able to easily create Column, Bar, Line, Scatter, Pie and Mapping graphs. Power View also introduces exciting technology such as Vertical and Horizontal multiples that allow the user to gain new insight from their data.
Power View provides a wide range of graphs and visualization technologies. The user is able to easily create Column, Bar, Line, Scatter, Pie and Mapping graphs. Power View also introduces exciting technology such as Vertical and Horizontal multiples that allow the user to gain new insight from their data.
Power View's visualisation and presentation capabilities will bring your data to life, allowing you to quickly and easily aggregate your data for presentations that are guaranteed to impress your audience.
Workshop Content
Introduction to Power View Creating a Power View Report - insert a Power View canvas - create a table - understanding the Power View menu options - modifying the table - using tiles - different table types - changing the method of aggregation - pop outs and filtering tables Graphs and Visualisation - create a column chart - create a bar chart - create a line chart - create a line graph - create a pie chart - create a map - create a scatter chart - understanding changes over time - creating data relationships Creating Interactive Dashboards - filters and slicers |
Duration
1 day Requirements
Completion of Advanced Excel Your own laptop with Excel 2013, with Power View loaded. (If you do not have your own laptop, we can provide one for you to use for the course) Cost
R1 800 per person excluding VAT Price is for training in Gauteng. Price is for in-house training for 6 people or more. Valid until 31 December 2017. We are happy to discuss all your training needs and work with you to meet your requirements. |