Uncovering insights on the leading cause of traffic fatalities with Modern Analytics ingredients from SAP
4 Top Chefs (in this case, Vendors) selected by Gartner faced off in an epic BI Bake-Off at the Gartner Data & Analytics Conference in Texas this Sunday.
The goal of the event was to provide attendees a unique opportunity to see modern BI and analytics tools in action and educate prospective buyers and influencers on key points of differentiation.
SAP, Microsoft, Tableau and Qlik were presented with the business question:
What is the leading cause of traffic fatalities and is it different by state, or age group, over time, holidays?
They were also asked for proactive advice: When not to drive? How to reduce teen deaths?
SAP Master Chef Matt Walsh boldly stepped up to the cooking station, armed with all the key ingredients for a show-stopping exploration of data discovery.
Let’s Get Cookin’
Ingredients (sample data set):
- S. Dept. of Transportation, NHTSA, Fatality Analysis Reporting System (available here)
- SAP used SAP BusinessObjects Lumira, the tool for Trusted Data Discovery in Modern BI scenarios
- And the must-have ingredient, a dash of #saltbae
What makes SAP unique is the ability to meet all analytics needs with integrated analytics in a single platform with an intersection of BI, Predictive and Planning capabilities.
The SAP BusinessObjects Analytics portfolio provides a comprehensive set of modern analytics capabilities, on premise and in the cloud, that work together to analyze data wherever it is.
SAP BusinessObjects Lumira offers:
- Best in-class security – both at the platform level and by leveraging security profiles directly in the source system
- Smart Self-service – by assisting business users during data prep and providing predictive capabilities during data visualization for business users
- Enterprise scalability – SAP BusinessObjects Lumira is a first-class citizen of the SAP BI Platform, with over 65k+ customers, some of which have deployed to serve over 100k users
Baking Directions with Key Ingredients (Key Differentiators)
Pre-heat oven to 360 degrees F (for a complete view of your business with analytics that can scale across all lines of business)
Demo look and feel – 3 minutes
In this dashboard, the KPI information is displayed on the left and Esri geospatial map analysis is in the middle. Insights include males having significantly more crashes than females, particularly males aged 19 – 29
Export of data – the user can click on Export Records icon on the top right of the chart export data to Excel.
On the top we have filters for state and year. Based on the filter selection, the data in the page is refreshed.
Visual discovery and dashboards empower business users to explore their own data and create visualizations and dashboards with limited IT support.
3. Self-service Data Preparation – 3 minutes
SAP BusinessObjects Lumira empowers business users to instantly access, combine, and transform data.
Use data in local files or connect SAP BusinessObjects Lumira with Microsoft Excel, CSV, text files, SAP HANA, BW, Query with SQL and best-in-class connectivity to Universes and more.
With access to multiple sources of data, business users can mash up trusted corporate data sources with additional data they may have to analyze specific business questions. In this case, we can join the accidents data and the distractions tables using state case and year column.
4. Dashboard Design & Storytelling
Using data visualizations to convey knowledge and information is great, but we want your data helping you tell stories. No need for coding or scripting – it’s drag and drop. You can even design your own infographic.
A key differentiator with SAP BusinessObjects Lumira is the ability to leverage SDKs in order to develop custom product extensions.
Business users can get creative and customize features, functions, chart types, data connectivity, and/or general look and feel. Custom extensions can take 2 forms:
- Visualization Extensions – custom chart types, visualizations, and business methodologies
- Data Access Extensions – new data sources, and improved data acquisition methods (onPrem, Cloud.. local and enterprise)
Check out this demo of a geospatial analytics custom extension called Visual Crossing by SAP’s Iver Van De Zand:
- Check out his blog and also the Analytics Extension Directory
5. Share the Information – 2 minutes
In this scenario, the Governor of the state is asking for a scheduled report on accidents in the states and they do not have direct access to the BI tool.
Most customers who have SAP BusinessObjects Lumira have purchased it as a part of a package. With a comprehensive analytics suite, leverage a tool like Crystal Reports to send that pixel perfect PDF report, or use the BI platform itself to schedule Excel of Flat files to be sent to an email address.
Many of the largest financial institutions like JPMorgan use this to send out hundreds of thousands of statements out a day!
You can also access SAP BusinessObjects Lumira stories on the iPad using SAP BusinessObjects Mobile, which provides data exploration and BI distribution in a single application.
6. Governance – 3 minutes
A major differentiator SAP brings to the table is governance. With the BI Platform, you give scale and trust for IT and management. Major cost savings are involved when IT only has one infrastructure to manage and can truly govern, audit and manage your BI platform to maintain one single version of the truth.
We have also embraced the new modern BI approach to leverage security from the source data itself, offering customers the best of both worlds
Here we are showcasing the modern BI approach by leveraging the security model in the source system – in this case, SAP HANA. We are making a Live connection to HANA, and only display the data meant for that user.
The source system has a number of different Analytic Privileges in it that define what information a user can see. This particular privilege says that users can only see information for the state of California
This ensures that the right user receives access to the correct set of information in the most efficient way possible. This is equally as important to the small departmental deployment of SAP BI as well as the giants like InfoSys who support 170k users!
7. Differentiator or Cool Innovation – 3 minutes
In this scenario, the governor’s office is tired of PDF and Excel reports and wants something more interactive. Maybe NHTSA doesn’t want to open up its on premise environment to external agencies like this.
This is a perfect use case for a hybrid analytics scenario where we leverage Machine Learning and dashboard automation functionality with “Build My Story” in SAP BusinessObjects Cloud:
Chef hats off to Matt Walsh for the epic Top Chef demo.
Don’t Forget Dessert!
Now that we’ve got your appetite going with this BI Bake-Off, don’t think we’re going to let you go hungry!
Don’t miss the freshest serving of the next askSAP Analytics Community Call, featuring Senior Vice President of Analytics, Mike Flannagan and Christian Frank of B.Braun.
On March 16th, we’re dishing out the Journey to the Cloud: SAP Strategy and Roadmap for Cloud and Hybrid Analytics Scenarios story. Get the latest on new features and functionality for SAP BusinessObjects Cloud and hybrid use cases for customers on premise with SAP BusinessObjects Enterprise.
Register now: https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&partnerref=Blog&eventid=1357344&sessionid=1&key=CE452730F0F830DAE599F37009F762F5®Tag=&sourcepage=register
Recording of 2017 with Innovative SAP BusinessObjects Analytics Solutions with the SAP BusinessObjects Lumira 2.0 Roadmap: