Welcome to ONLC Training Centers
Welcome to ONLC Training Centers


Power View and Power Map in Excel Level 1 Course Outline

 (2 days)
Version 2013

Overview
Microsoft Power View and Power Map are Excel add-ins that provide an interactive data exploration, visualization, and presentation experience for users at all skill levels. Pull your data together in tables, matrices, maps, and a variety of charts in an interactive view that brings your data to life. Using geographical data, you can create 2D and 3D maps. Including a time element will allow you to create timelines and movies that show the development of the data over time.

Excel Versions
Power View is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016. This course is taught using Excel 2013 software but the concepts are identical with Power Pivot implementations found in Excel 2010 and 2016 (or Office 365). Note: At this time, Power Map as an Excel 2013 add-in is only supported by Windows 7, Windows 8, and Windows Server 2008 R2

Target Student
This course is for individuals whose job responsibilities include creating advanced interactive reports, visualizations, dashboards and mapping.

Prerequisites
Excel Introduction or equivalent skills. Previous experience designing Excel charts and graphs and maps is helpful but not required.

Course Outline

Introduction to Power BI and Power View
     Self-Service Business Intelligence
     Enabling the Power View add-in
     Power View Canvas

Tables in Power View
     Adding, Deleting, and Modifying a Table
     Types of Data
     Data and Aggregations
     Enhancing Tables

Advanced Tables
     Matrix Tables
     Sorting and Drilling Down with Matrix Tables
     Card Visualizations
     Key Performance Indicators

Filtering Data in Power View
     Adding Filters
     Filtering Different Data Types
     Visualization-Level Filters

Charting Basics
     Creating Charts
     Basic Chart Modification
     Basic Chart Types
     Enhancing Charts
     Drilling Down with Charts
     Chart Filters

Advanced Charting
     Multiple Charts
     Scatter Charts
     Bubble Charts

Interactive Data Selection
     Tiles
     Slicers
     Charts as Filters

Images and Presentation
     Titles
     Adding Text Boxes
     Altering the Font
     Applying Report Backgrounds and Themes
     Adding Images

Mapping in Power View
     Adjusting Map Display
     Multi-Value Series
     Adding Tiles to Maps
     Multiple Maps
     Drilling Down Maps

Power Map Overview
     Running Power Map
     The Power Map Window
     The Power Map Ribbon
     Creating Tours
     Power Map Source Data
     Using the Task Panel (Layer Pane)
     Moving Around in Power Map

Map Types
     Bubble Maps
     Column Maps
     Heat Maps
     Region Maps

Presentation Options
     Settings View
     Power Map Themes
     Text Boxes
     Timelines
     Using Layers

Power Map Movies
     Creating a Movie
     Exporting a Movie

View outline in Word

BEV113

Attend hands-on, instructor-led Power View and Power Map in Excel Level 1 training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Analytics Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $995

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com