Self-Service Business Intelligence at your fingertips! That is Power View. Its interactive environment is designed to enable regular Excel users up to power users in creating engaging and compelling data visualization. The stories that are hidden behind numbers can now be made to surface using the powerful visual techniques found in Power View.
Participants will be able to use Power View to gain insights on data stories, and transform their work into discovery experiences after the completion of this hands-on training . The Microsoft Power View is an Excel 2013 add-in, which enables interactive data exploration, visualization, and presentation experience for users at all skill levels. By consolidating data in tables, matrices, maps, and a variety of charts, users create interactive views that visualize the underlying stories behind the numbers and presented in both geographical 2D and 3D formats. Powerful options for this data exploration include timelines that allow for animation of data over time.
Participants will be able to learn and understand Excel Data Models, Set-up Relationships among data modes, create Power View “worksheets” and be able to insert map-based representation of their data models, adding animation to charts and data slicers, as well as viewing summary information using a host of charting tools available.
Prospective participants must have been using MS Excel 2013 or higher version, and must have at least 1 year continuous use of MS Excel 2007 up to 2016. No programming skills are required.
Previous experience designing Excel charts and graphs and maps is helpful but not required.
Power View is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016. In this workshop, Excel 2013 will be used. Power View is also available in MS 2010.