rpm the new bookmaster business intelligence presentation by venkat rajan (symphony) angela newman...
TRANSCRIPT
RPM the new
Bookmaster Business Intelligence
Presentationby
Venkat Rajan (Symphony)Angela Newman (IBS Bookmaster)
Introduction
RPM Overview
RPM Functionality
Bookmaster
Scenario
www.ibs.net3
www.ibs.net 3
Providing Enterprise-Wide Reporting and Analytics with Minimal IT Impact
Regional Reporting
Retail SFA Comp Other
RPM Application
Ad hoc Reporting MDX Compliant BI Tool
MDXXML.xlsXML
SymphonyRPM Analytic Server
1. Background2. Historical Problem Statement3. Solution4. Value
www.ibs.net4
www.ibs.net 4
SymphonyRPM is a Powerful, Highly Scalable Platform for Real-Time Closed-Loop Analytics
Dashboards Reports Alerts
Collaboration Decision Workflows
Decision Approval & Execution
SymphonyRPM Application Framework
Analytic Server
Integrated analytics and planning
On-the-fly real-time analytics
Rules engine separates model from data
Powerful guided analytics capability
Collaboration
Decision writeback
Approval workflows
“The SymphonyRPM approach enables a closer coupling of analytics and plan data with greater capabilities to couple the power of analytics, perform what-if analysis, and close the loop by saving the best outcome as plan data.”
John Haggerty Vice President and Research Fellow
AMR Research
www.ibs.net5
www.ibs.net 5
RPM Platform Differentiators vs. BI and Planning Tools
Feature/Function
Functional Planning & Optimization
Business Intelligence
SymphonyRPM
SQL Generation
Read Access
Reporting & Dashboards
Solution flexibility
Large Data Volumes
Complex Calculations
Collaboration
Modeling and What-if
Data Write Back
Merge actual/forecast
Structured analytics
www.ibs.net6
www.ibs.net 6
Dashboards
www.ibs.net7
www.ibs.net 7
Excel like Functionality
Charting
www.ibs.net9
www.ibs.net 9
Guided Analytics
www.ibs.net10
www.ibs.net 10
Lets talk about Bookmaster!
1
•All existing Bookmaster /BI reporting transported to new RPM BI
2
•Bookmaster Scenarios
3•Req
uests by you
www.ibs.net11
www.ibs.net 11
Bookmaster - Scenarios.
Sales• Type of Sales – Digital, Print on Demand, Subscriptions• Source of Order – Web order, EDI, eMail, Phone• Print on Demand by Location
Order Fulfillment• DIFOT = Delivered in full on time
Editorial Book Production• Stages / Cost types – budgets, variances, accruals, actuals,
CRM• Opportunities
www.ibs.net12
www.ibs.net 12
Bookmaster Dashboard - example
Configure the dashboard to your specifications
www.ibs.net13
www.ibs.net 13
Sales by Type of Sale
What are the changes between 2010 and 2011?
Break down by Type of sale
Break down by Period
Break down by Items/Titles
Selected Period Range
Drilling down to Type of sale by the Item/Title
www.ibs.net14
www.ibs.net 14
Sales - by type of Sale
8.37% Subscriptions
3.91% Digital
1.12% - Print on Demand
86.6% - Stock
16.11% - Digital
10.52% - Print on Demand
60.9% - Stock
12.47% - Subscriptions
Measure Digital Print On Demand Stock Subscriptions
Increase 12% 9.4% 4.1%
Decrease 25%
www.ibs.net15
www.ibs.net 15
Sales – Source of Order
Filter by Buying Group
Compare EDI and WEB orders for Big W Buying group
www.ibs.net16
www.ibs.net 16
Sales – Print on Demand by Location
Where is the consumer situated? Do we have a Printer in that area?
Country area
www.ibs.net17
www.ibs.net 17
DIFOT – Order Fullfilment
Are all our orders being delivered on time?
Drill down by Year and Period
Drill down by Title Hierarchy
Breakdown by period by year by Product Line
www.ibs.net18
www.ibs.net 18
Book Production – Cost Types by Project Detail
Drill down cost types within a period for a Project
Compare budget cost vs actual cost
Filter by Project
www.ibs.net19
www.ibs.net 19
Bookmaster
RPM - BI
Lets compare!
www.ibs.net20
www.ibs.net 20
CRM - Opportunities
Drill down by Title
Drill down by title by stage
Selection by Period
Source
Stages
Thank You