Post by ATCG BI Team
Hong Wu et al
It's been a while since our last update. Our guys are being busy with wonderful projects like SAP HANA on BW, implementation of BI platform 4.1 etc. Don't be jealous.
Also, the ATCG Team is heading to the SAPPHIRE this year! Hope we can see you guys there.
Today, what you are about to experience is a journey by using Data Visualization over effective data model to bring out insights from large data sets. Yeah, visualizing the data the a headache.
Summary
It is always a dilemma for small/mid-size companies to choose right BI Solutions over cost and efficiency. Constrained by their business scale, it is not possible for them to adopt large BI platforms not only because of the tremendous amount of upfront cost but also the long implementation lifecycle. Today, we are introducing ATCG's light, rapid BI Solution called - AEES (ATCG Enterprise ERP System). It can also seamlessly integrate with all major BI front-end tools like: SAP Lumira, Predictive Analysis, Qilkview, Tableau etc.
Scenario
AEES in a Nutshell - A light, rapid ERP solutions for small/mid-size companies.
Link to the whitepaper.
Annual traffic data release by official authority is
extremely important for insurance companies to monitor and respond to the
market.
An insurance company just acquired large dataset on US car
crash 2011, however it is a monster table with 70000+ records, Excel hangs
every time when Analyst tries to “Pivot table” it, yeah, you bet! Pivot table -
old school data analysis techniques.
Then the company turns to ATCG Solutions for help. ATCG BI
Team loaded this big chunk of raw data into AEES, and contracture them into
three major business areas (also for most organizations): HR, Finance, and
Service Operation. It is a process to make the raw data “juicy” in a rapid and
affordable way compared to those heavy-weight solutions like S.. and Ora… (You
know what I’m talking about). But, it doesn’t stop there, it is needless to say
Mobility and Self-BI is the trend. To achieve this, ATCG BI Team helped the
company to design a semantic layer which is tailored into their needs. Last but
not least, with SAP’s cut-edge visualization tool – Lumira, now the Analyst can
enjoy the BI on the fly, yeah also that grande vanilla latte on the desk.
Showcase
Source Data
Name of Dataset: us_car_crash_data_2011.xlsx (72310 records
in total)
Source: The dataset is collection of data about people
involved in car accidents with fatalities, the final injuries, alcohol/drugs
tests, and other relevant data about the accident and the person. ** Original
Source ** Fatality Analysis Reporting System (FARS) Encyclopedia http://www-fars.nhtsa.dot.gov
Figure 1
Snapshot of the dataset
How Monster Table got visualized
Analysis Scenario
The Analyst starting a bird view of car crash statistics by
State, since he/she is mainly working for the western coast region, the size of
the bubble from California obviously draws attention. As following, a trend
analysis is being ran to tell the distribution over the month by gender:
By looking at this visualization, both Genders share the
same tendency, but we do see car crash reaches the peak in July and followed by
an increase till November. Thus the Analyst narrow down the time-frame to
continue explore the information.
Naturally, we will think poor road conditions and weather
conditions will cause more traffic accidents. However, this visualization
reveals that car crashes happened most in urban area under clear weather. In
this case, you can’t trust your gut feeling. To keep digging into the dataset,
Analyst adds more key elements like age, fatality into the visualization and it
ends up like this beautiful bubble charts like below:
Eventually, the story has been told. Driving carefully if
you were a 22-year-old person who are driving in urban area under clear weather
in California!!!
What it means to the insurance company, it brings out the
key information that will help them to prepare the peak of the insurance claim
in July, and set up different evaluations for customers, cases that fall into
those categories.
Numbers don’t lie.
Happy Visualizing!
For more information regarding AEES or any BI solutions please feel free to contact:
info@ATCGSolutions.com
