MS Powerview: The Power to Know, Transform and Visualize Your Data

MS Powerview: The Power to Know, Transform and Visualize Your Data

27
Jul
VENUE: EITSC Training Hub, 19F Philippine AxaLife Center, Sen. Gil Puyat cor Tindalo St.
Trainings

Overview

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.


Objectives

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.


Course Outline

  • What is Power View
    • Business Intelligence The Self-Service Way
    • How To Enable the Power View add-in
    • About The Power View Canvas
  • Power View Tables
    • Inserting, Removing, and Modifying a Table
    • Types of Data
    • Aggregating Data
  • Advanced Tables
    • Matrix Tables
    • Drilling Down and with Matrix Tables
    • Card Visualizations
    • Key Performance Indicators (KPI)
  • Power View Data Filters
    • Adding Filters
    • Filtering Different Data Types
    • Visualization-Level Filters
  • Power View Charting Basics
    • Creating Charts
    • Basic Chart Modification
    • Basic Chart Types
    • Enhancing Charts
    • Drilling Down with Charts
    • Adding Chart Filters
    • Creating Geographical Type Presentation in Power View
  • Advanced Charting Features
    • Multiple Charts
    • Scatter Charts
    • Bubble Charts
    • Creating Animation Over Timelines
  • Interactive Data Selection
    • Tiles
    • Slicers
    • Charts as Filters
  • Images and Presentation
    • Titles
    • Adding Text Boxes
    • Altering the Font
    • Adding Images


Prerequisites

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. 


Technical Data

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.