Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
   Drill (horizontal) and Cross (horizontal) Navigation and Analysis Exception Analysis  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  Data Analysis/OLAP  →   -  Basic Data Analysis Types- Building Blocks  → 

Time Trending Data Analysis

Time trending analysis includes period to period comparisons, across the periods and within a period analysis.

Apart from being an important analysis lever, time trending is also core to performance management. One always wants to see on how much needle is moving over time.

Period Analysis - Beginning OR End of Period

This is 'balance-sheet' kind of analysis, where you find out the status of various measures (for example the account balances, the number of offices, number of customers, number of defaults, number of patients in admission…) at the end OR beginning of a period (say end of month, beginning of quarter..)

During the period activity

This is a 'profit & loss' kind of analysis, where you find out the extent of activity done within a period. For example-- Sales Revenue measure, Number of patients admitted, number of festival package flat screen TVs. sold…….in given month, quarter, week…

Time Trending through Period to Period Comparison

This is typical business performance parameter. For example --the comparison of sales in the first quarter compared to first quarter last year OR the sales in the New Year season this year vs. last year

Time-Trending across a fixed vs. rolling period range

When you see the time-trend across the periods in the fixed time range. For example the revenue figures across twelve months in the calendar year (OR business performance year) OR when you do YTD (year to date) and MTD (month-to-date) analysis, where the starting point for your reference is beginning of the period.

The investment analysis typically uses the rolling period range, where the stock movement across last twelve months on the rolling basis is tracked. You can refer Time Dimension, to understand more facets of Time related analysis.

 

   Drill (horizontal) and Cross (horizontal) Navigation and Analysis Exception Analysis  
 
 

Was this page helpful?
 
 
More on Basic Data Analysis Types
Drill (horizontal) & Cross (horizontal) Navigation
Exception Analysis
Data Min-Max Analysis
Data Filtration Analysis
Pivoting, & Slicing & Dicing Analysis
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Leads Generation through advertising
Sales force density
Sales Leads Management SWOT
Variable Sales Cost
Sales Leads Management Concept
Read more...
  Customer Relationship Management
Customer Value and Profitability- BI
Customer Segmentation Data Management
Customer Satisfaction and Retention- Overview
Customer Value and Profitability Data Management
Customer Segmentation Actions
Read more...
  Human Resources & Leadership
Deliver Results
Lead diverse and collaborative teams
People become the way you treat them
Lead Change
Fostering Innovation
Read more...
 
 
Business Performance & Planning
Internal Info Assessment Report
A KPI should be simple -but it depends
Strategy Blueprint Information Gathering
Dashboard Health Checklist
Strategic Business Plan
Read more...
  Business Intelligence & Data Quality
A smart manager does not follow-up
Data Warehouse Infrastructure Considerations
Dimensional Model Schemas- Star, Snow-Flake
Object Level Data Quality Tracking
ODS- Operational Data Store
Read more...
  IT Vendors & Tools Management
Data Cleansing and Augmentation
OLAP Server administration
enterprise Reporting Server connectivity
Connectivity and Computing Support
Cascade standards & guidelines
Read more...