Analytics Everywhere Updated for 2010
About “ Fortune 500 Consumer Goods ” » It is a global marketer of consumer and commercial products that touch the lives of people where they work, live and play. » Headquartered in a large Southeastern City. » Approximately 19,000 employees worldwide » NYSE: xyz More than 90 percent of U.S. households have at least one Fortune 500 Consumer Goods product.
Our Global Presence Percent of Percent of sales Region Live on in 2009 SAP US & Canada 75% 85% Europe 14% 0% APAC 6% 0% Latin America 5% 0%
Three Business Segments Office Channels & Customers Products Group $1,674.7 MM Home & Family Group $2,377.2 MM Tools, Hardware & Commercial Products Group $1,525.7 MM 2009 NWL Sales $5.6 billion
Home & Family 5 Global Business Units: - Culinary Lifestyles - Décor - Beauty & Style - Baby & Parenting Essentials - Rubbermaid Consumer
Office Products 4 Global Business Units: - Technology - Everyday Writing & Coloring - Fine Writing & Luxury Accessories - Markers, Highlighters, Art & Office Organization
Tools, Hardware & Commercial Products 4 Global Business Units: - Industrial Products & Services - Commercial Products - Construction Tools & Accessories - Hardware
“ Our Business Is Transforming ” » Becoming known for Brands That Matter™ » Investing in consumer-driven branding » Leveraging one global company to drive innovation and achieve scale efficiencies » Strengthening our financials with top-line, bottom-line and gross margin increases » Expanding our global footprint » SAP Successes & Future Releases ▪ Office Products – Live October 1, 2007* ▪ Home & Family – Live April 1, 2008* ▪ Tools & Hardware – Live August 1, 2009*** ▪ Cleaning & Organizational – Live April 1, 2010*** ▪ Décor – Scheduled July 2011 ▪ EMEA– Scheduled October 2011
Rewind to June 2008… So What About Reporting & Analytics? Running on SAP BI 3.5 No Plans to Upgrade Undefined Slow Speed To 100% BEx Reporting (All Excel Based) Content Market Poor Poor Performance Communication Many BI Issues Low Confidence Difficult Usability in Data Long & Costly No SAP Portal Email for BI Communication Method Lack of Inconsistent and/or Inaccurate Training Dashboards Data in BI vs. ERP Technology Implementation 3
Why Implement SAP BusinessObjects Tools? No question about SAP BusinessObjects being solidly engrained in the SAP BI Roadmap…so be very open to how we could leverage the platform Addresses multiple business groups (demographics) of users Very fast to implement with potentially enormous payback Instantly addresses ‘ Usability ’ and ‘ Communication ’ ‘ User adoption ’ is exponentially higher than previous applications Fortune 500 Consumer Good’s Information Needs Xcelsius dashboards “ net it out ” for management who do not have time to study large reports with piles of data and information Webi reports provide the ability for users to access information anywhere on the web from a company portal BusinessObjects Explorer provides easy and instantaneous data exploration capabilities for any casual user with no training required Mobile devices provide reach to information where typical application access does not exists These tools allow Newell to more easily define standard & ‘ approved ’ corporate reports to be used for all regions and business units 1
Formalize a Realistic and Actionable Roadmap To Follow 2008 2009 2010 2011 Technical Upgrade (Feb 09) Mature The Platform Reporting Upgrade (Sep 09) BIA (Apr 09) Address Performance Re-architect (Oct 09) Reconciliation Between ERP Improve User Confidence and BW (Oct 09) Communication Portal Improve Communication (Sep09) Roll Out Multiple Tools Take On Usability Xcelsius, WEBI, BO Explorer & Mobile Collaboration Tools Take On Usability Forums, Wiki, Stream work 11
Taking BI To The Next Performance Level - BWA 12
Improving End User Confidence & Communication BI Communication Portal ▪ One Communication ▪ Training Materials ▪ Release Details ▪ Data Availability Report Clarity Of Content ▪ Documentation of Pre- Configured Reports ▪ Search of Documentation 13
Determine The Most Appropriate BI Toolset/Application End User Request Know What To Measure What I Don ’ t Know Information Information Objective Delivery Discovery Time Type Of Critical? Discovery? Type Of View? Business Pre Search & Some-what Analytics / Configured Exploration defined KPI Report Type Of Analysis? Advanced Casual BI Tools BO Explorer Mobile Xcelsius BEx WEBI 14
Credit Dashboard Using Excel Before... 1
Credit Dashboard Using Xcelsius After... All Metrics Viewable On A Single Screen – Fully Interactive With Multiple Drop Downs 16
Dashboard Ability (S&OP) Using BEx Before… There was difficulty in presenting the overall business results for executives with just a few mouse clicks None of these reports There is no visualization were available through for overall view of how the the web using our SAP company is performing Portal There are dramatic ‘ ease There were multiple of use ’ issues with series of data layout multiple reports for the sheets and not a same basic use case consolidated view 1
Dashboard (S&OP) Using Xcelsius After… Select Different a Product Group and GBU Select Time Period Service & Demand KPIs Supply KPIs Other KPIs GBU window GBT window Actual vs. Target for GBU Actual vs. Target Performance by Region and Region 18
Typical Ad Hoc Analysis Using BEx Before… Some Key Constraints All Key Figures & Measures must be laid out on the report There is no flexibility to select only Key Figures that need to be displayed There is limited formatting compared to WEBI which has ‘ free form ’ formatting capability. 1
Ad Hoc Analysis Using Webi After… All table based reports easily converted into graphical representations of the same data values 1
Data Exploration & Discovery Using Business Explorer Accelerated Ask a simple question to see a result set that will show some core reports with your question ’ s answer… The data exploration Information Space will show key figures that relate to your question ’ s key item (i.e. sales by category) The results are categorized by a scoring system of highest to lowest. These Information Spaces are prebuilt by the BI Team using logic that would best correspond to the user ’ s original question 3
22
Mobile Reporting - Before » “ Hey, Matt…..is there a way you can easily provide me metrics like Line Fill, On Time Performance, and Perfect Order % without me always having to login to my laptop and digging for it? ” » “ Why can ’ t you just push something simply to my Blackberry so I can check it out on my way into work? ”
Mobile Reporting – The Next Wave » Mobile platforms will allow us to take ‘ snippets ’ of key information that may reside in larger dashboards and reports and push them directly to end users who only want to see pieces of information at any time wherever they may be » Blackberry, iPhone, iPad platforms will all be leveraged in this capacity 1
Summary and Recommendations Understand your company ’ s ‘ real ’ issues, not the hyperbole or simply the ‘ headlines ’ Do not underestimate the importance of “ Speed to Market ” Be very clear on where you want to focus and exactly what applications can get you there Categorize your end users into groups that can be mapped to the appropriate applications to deliver them analytics they can actually use and make decisions with Define a clear roadmap and communicate it to the masses – don ’ t surprise people (unless it ’ s a really good one) Understand that the SAP BI Platform is not just BW anymore You will need to seriously consider BWA, WEBI, Xcelsius, Explorer, Portal, Mobile as an application architecture to appease the masses
Recommend
More recommend