Skip to main content
If you are a Planview customer, sign in to enable additional content.
Planview Customer Success Center

Ad-hoc Analysis in Enterprise One (Power BI, Excel and SSAS)

 

Course Description

Ad-hoc Analysis (Power BI, Excel and SSAS) training for Planview Enterprise One - Portfolio and Resource Management (PRM) is an immersive, interactive class that teaches how organizations can perform dynamic analysis and create interactive reports on projects, resources, and financial data to meet the reporting needs of the organization.

This one-day course provides mastery of online analytical process (OLAP) reporting and interactive navigation capabilities to easily understand current and trend-based business performance, change parameters, and add metrics with the click of a button. Power BI allows non-technical users to create analytics and dashboards by themselves, without the need for technical report development skills or a technical understanding of the data structure. Users can create interactive dashboards with drill down functionality in minutes. This will allow you to quickly provide answers to analytical queries that are multi-dimensional in nature for complex analytical and ad hoc queries.

Additionally, students will schedule time with their Training Consultant for one-on-one coaching after the classroom learning.

 

Learning Objectives

At the end of this course students will learn how to:

  • Understand Ad-hoc Analysis Concepts and Data Sources (Tabular Models & Column Set Models)
  • Create and Deploy Reports with Power BI
  • Perform Ad-hoc Analysis using Microsoft Excel
  • Understand the data elements of the Tabular Models

 

Planview Enterprise One Ad-hoc Analysis Training Class.pdf

Audience

This class is ideal for advanced administrative users of PRM who will be responsible for creating custom reports on behalf of their organization or business unit.

Expert product knowledge required. 

3

Program Level

Advanced (Level 3)

Very technical class with highly detailed topics

1 day

Agenda

  • Introduction
  • Overview of Ad-hoc Analysis
  • Column Set Tabular Models
  • Create Reports with Power BI
  • Deploy Power BI Reports
  • Ad-hoc Analysis and the Excel Add-in: Download and Connect to the Excel Add-In
  • Connect Excel to a Data Table
  • Pivot Table Field List
  • Filter Data in Pivot Tables
  • Measure Unit Formatting

Class Duration: 2 Half-day Segments Virtual + 1 Hour Coaching

Prerequisites

  • Participants should have a good understanding of different attribute types (alternate structures, fields, sub-total columns, and calculated columns) available in PRM

  • Participants should be experienced in maintaining alternate structures and creating and maintaining the report tiles

  • Complete the Analytics and Reporting self-paced online course

  • Participants should have some experience in report creation

$1,350*

Cost

*Pricing for Open Enrollment training is $1,350 per person. 

Register for Open Enrollment classes here