sas analytics readytorun data discovery & data ......sas analytics rtr: definition and goal...
TRANSCRIPT
SAS Analytics ReadyToRun
Data Discovery & Data Exploration
to everyone
28th april 2016
Copyright © 2016. Blue BI Srl www.bluebi.it
26/04/2016 Blue BI s.r.l. 2
The most common business requirements frequently arising from the customers:
CIO o Our reporting systems are too much complex/slow o Users keep asking «ad hoc» reports o Data management in our organisation is complex o Data quality is not certified, we do not have a real company DataWarehouse o We are interested in Big Data
Business Users We only have operational reports able to describe an event but not to disclose it in advance We would like to have flexible tools to create our reports quickly and indipendently To get a report from IT takes time When we are out of the office we can’t access and share data
The most common business requirements
26/04/2016 3
To meet these requirements is then necessary to invest in new BI&Analytcs tools, BUT, when it comes to the implementation perspective, many times other questions arise:
How to meet these requirements
We have a limited budget / time / resources
We want to avoid risks and get «Quick wins»
We do not want to add IT assets and complexity
Costs must be certain and fixed
Blue BI s.r.l.
SAS Analytics RtR: Definition and Goal
26/04/2016 4
The SAS RtR is a suite of ready-to-run Business Analytics solutions, developed by Blue BI with the aim of answering these questions providing:
To everyone
In short times
In a simplified mode
A B
Small Medium Enterprises Business Units / User Groups
a powerful and scalable decision making support system.
Predefined Analytics and Data Models
On the Cloud
Blue BI s.r.l.
26/04/2016 5
Hosting in the Cloud
SOFTWARE
BEST ANALTYCS PRACTICES
SERVICES
Comprehensive range of functional components available within “SAS® Visual Analytics”.
Preconfigured Analytics modules based on the most common Best Analytics Practices “Cross Industry” and “Industry Specific” containing:
Performance Indicators
Extended dictionary of measures
Flexible Tools for data sourcing
Scalable approach by mean of a modular components
Specific deployment approach looking to quick results
End to End Services:
• Cloud infrastructure (IaaS) • Implementation & Customization • Maintenance & Support
SAS RtR: Rapid deployment of Best Analytics Practises
SAS Analytics RtR: Contents
Blue BI s.r.l.
26/04/2016 6
Main Features: In-memory analytics Autocharting Forecasting Dashboarding & Interactive reporting Publishing Geo Localisation iPad® and Mobile apps Flexible and scalable implementation options
with Blue BI SAS Analytics RtR
SAS Analytics RtR: SAS Visual Analytics features
Blue BI s.r.l.
26/04/2016 7
SAS RtR - Pharma Life Sciences industry modules
Sales&Marketing
Internal sales analysis from ERP and
external from territory/national IMS data
Sales Performance Analysis
accordingly with the sales organization
levels
Time line Sales Objectives analysis
CRM Analytics, Sales & Field Force
Effectiveness.
GeoMarketing via Georeferred data
analysis
Sales Forecast
Sales Forecast model by Internal /
External sales - Product / Territory /
Region / Account:
• Time series analysis
• Regression indexes
• Trend discovery and visualization
• Visual correlation analysis
• What if analysis
Additional Modules
Finance
• Planning & Budgeting processes
• Credit Recovery management
Supply Chain
• Backorders and stock outs analysis
• Production forecast and forecast
accuracy
SAS Analytics RtR: Best Analytics Practises
Blue BI s.r.l.
26/04/2016 8
SAS RtR Cross KPI Cross Industry modules
Sales KPI’s
Sales
• ABC analysis
• Budget and sales volume deviation
• Theoretical sales deviation vs
budget
• Incidence of Credit notes vs sales
• Sales deviation vs period
• Gross margin
Orders
• Orders check by period
• Delivery accuracy
• Flexibility index
• Back orders analysis
Industrial KPI’s
Procurement and raw material Stock
• Stock trends
• Price/evaluation analysis
Investments
• «Capex» by company
• Investment orders (from budget to payments)
Production
• Budget
• Transactions
• Planning
• Work centre capacity
• Production Efficiency
Human Resources
• Full Time Equivalent analysis
• Headcount
Debits/Credits Analysis
Credits • Aging by date/period
• DSO analysis
• Incidence of total DSO vs past due
• Credit trend analysis
Debits
• Aging by date/period
• DPO analysis
• Incidence of total DPO vs past due
• Dedit trend analysis
Sales Forecast
Sales Forecast model by Internal /
External sales - Product / Territory /
Region / Account:
• Time series analysis
• Regression indexes
• Trend discovery and visualization
• Visual correlation analysis
• What if analysis
SAS Analytics RtR: Best Analytics Practises
Blue BI s.r.l.
26/04/2016 Blue BI s.r.l 9
SAS Analytics RtR: Report example
26/04/2016 Blue BI s.r.l 10
SAS Analytics RtR: Report example
26/04/2016 Blue BI s.r.l 11
SAS Analytics RtR: Report example
26/04/2016 Blue BI s.r.l 12
SAS Analytics RtR: Report example
26/04/2016 13
Service set up o Infrastructure in the Cloud (IaaS) o SAS Visual Analytics installation/configuration o SAS RtR modules installation o Activity plan
SAS Analytics RtR: Services
Deployment steps
Selected modules implementation o Delta analysis and set up completion o ETL procedure definition o Training o Deployment
On going management o Business continuity o Corrective maintenance o Security
Blue BI s.r.l.
26/04/2016 14
Speed o Guided recognition and analysis of the business requirements o Fast deployment o Preconfigured analytics o Easy customization
SAS Analytics RtR: Benefits
Simplicity o None or limited impact on the IT o Infrastructure and application scalability o Less management complexity o Quick and certain results
Economy o Lower implementation times and efforts o Fixed and all inclusive costs
A B
Blue BI s.r.l.
15
Blue BI : Mission & Expertise
Blue BI s.r.l. 26/04/2016
Blue BI is a growing company that provides IT consulting in the Business Intelligence & Analytics environment. Our mission is turn data into actionable insights: we help organisations to take faster and smarter decisions and tackle the most complex business issues. Blue BI offers a comprehensive set of Business Intelligence end to end services, from POC’s to Application Management, in the following areas:
Reporting & Dashboarding Analytics Corporate Performance Management Predictive /Big Data GeoMarketing Internet of Things
Our organisation is formed by a group of professionals with more than ten years of experience, located in our offices of Milan, Turin, Vicenza and Rome.
[email protected] [email protected]
www.bluebi.it
Q&A and Contacts
Milano
Via Caldera, 21 20153 Milano
Torino
Corso Filippo Turati, 10 10128 Torino
Roma
Via Giambattista Vico, 31 00196 Roma
Vicenza
Via Vecchia Ferriera, 13 36100 Vicenza