Please enable JavaScript.
Coggle requires JavaScript to display documents.
Granite Equipment Cost Variance BI Project - Coggle Diagram
Granite Equipment Cost Variance BI Project
Themes :
YTD, MTD Analysis
Variance, Revenue, and Cost
Account Level Analysis
Location Hierarchy Analysis
Equipment Category / Rate Group Analysis
Documented Requirements
Company Level XoX Time Analysis w/ lots of slicers (P1)
Org Hierarchy Analysis (P1)
GL Equipment Account Analysis (P1)
Equipment Category / Rate Group Analysis (P1)
Drill to Asset Level Variance detail for all 3 pages listed above (P1)
Variance Trending Over Time (P1)
Key Influencers for Variance
Over Under Exception Report
Management Equipment Report (MER) - Not really BI. Possible Power BI Report Builder
Asset Level Variance Analysis
Shop Overhead Cost Analysis
Cost and Revenue Account Comparison (Financial Style Report?)
Variance Forecasting - Simple Line Plot Arima forecast (P1)
Average Fleet Age and Costs
Phase 1
Primary Dashboard Page
Location Hierarchy Analysis (Group / Region / Area / Office)
Equipment Account Level Analysis
Equipment Category / Rate Group Analysis
Variance Trending / Forecasting
Drill to Revenue, Cost, Variance by Asset
Data Sources
Spreadsheet / Warehoused Historical Data
SSAS Cubes
Granite Colors
Granite Green #00693C
Granite Yellow #FFB612
Future Phase
Variance Time Series Forecasting
Manager Level Analysis
RLS
Design
Iteration 1 - 12/2/2020
XTD Dashboard
Drill-Through Example
Location Hierarchy Analysis
Future Phase / Additional Scope Items
Rev, Cost, Variance Forecast by Region from E1
Equipment cost assigned to each BU (may need to navigate GL Postings to find monthly costs)
Asset Utilization Data from E1