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

Ad-hoc Analysis

▲ Analytics and Reporting in Planview Enterprise


Catalog Image.png Ad-hoc Analysis (formerly known as Insight Analytics) is targeted at users who want to carry out data exploration and analysis. It provides modeled data sources, into which data from the Planview Enterprise One transactional database is processed. These data sources are in the form of either Tabular Models or OLAP cubes. Two different consumption options are available for these model and cube datasources:
  • Users can connect to the models and cubes using an Add-In in Microsoft Excel and use the pivot table capabilities in Microsoft Excel to analyze the data that is staged in the model/cube
  • Power BI can be used to consume Ad-Hoc Analysis Tabular Model data (Planview Enterprise 14 and Enterprise One onwards)
 

Understanding Power BI Icon.png

Learn About Ad-hoc Analysis

Click here to learn more about Connecting to the Ad-Hoc Analysis data sources, visualizing Data and the Deployment Process and watch a video illustrating the ease of use and power of Ad-Hoc Analysis and learn about the cubes and deployment process.


Understanding Power BI Icon.png Understanding Power BI Icon.png Understanding Power BI Icon.png Understanding Power BI Icon.png
Excel, or Power BI, are the analysis and visualization tools that are used to connect to the Ad-Hoc Analysis cubes and models to develop analytics and outputs. Watch a video showcasing using Excel to explore and visualize data from the Ad-Hoc Analysis cubes Ad-Hoc Analysis provides a number of cubes and tabular models that address specific data areas within Planview Enterprise. These out-of-the-box cubes need to be aligned, and potentially extended, to ensure that they contain the data required for analysis and visualization In order for customers to see their configured data points in Ad-Hoc analysis the cubes/models must be aligned, a process carried out by the Planview Consulting Global Reporting Services (GRS) team Ad-Hoc analysis visualizations created using Excel can be shared with other stakeholders

View How-to, Product Help, E-learning and Best Practice Content