Analytics Use Cases of Our Clients

Pharma company Analytics Use Case

- All data required for analysis not in one place
- Each data sources required their reporting tools
- No tools that can be configured easily to analyze various data sources together
- Large data-sets
Phase I – simple tabular reporting
Phase II – visualizations and broader adoption
Phase III – connected to Essbase and simplified reporting architecture

Entertainment Company Analytics Use Case

Problem: To reduce Labor costs

- Labor costs are significant and difficult to estimate/manage

- How does weather affect ridership (a warm winter day VS stormy/rainy summer day)
- How does guest pattern vary through the day and the week
- How does the load-factor vary throughout the day
- What is the ride down-time by ride, by reason code
- Started with labor cost idea, extended to finance

IT Software Updates, Virus and Patching Analytics Use Case

Problem: Have 17,000 computers, management wants clear reporting on patch status across the geography, across teh divisions and by asset class.

- Use Landesk software to manage this process
- Each computer has a code, each country has a code, each update definition has a code. The codes and Description are not in the same table.
- Solved this problem by joining several tables and matching of respective code to region, country and manager names needed extra steps before reporting could be done

Logistics Company Analytics Use Case

Problem: Margins in the business are thin, they need visibility into every bit of a fairly complex business

- Import and sell bathroom fittings from South America and sell in the US

- Several providers, several buyers, thousands of SKUs

- Minimize inventory, increase inventory turns. You could lose money from delayed receivables, or one bad quality batch, or currency fluctuation.

- Speed is of essence in this case

- Visualization helped accelerate reporting, gave details on:
• Demand by product code
• Identify shipments at risk
• Customers that were slow paying had highest RTV
• Product profitability

Oil & Gas Analytics Use Case:

Problem: Better analytics and confidence about well data

- Visualize historical facility-level time-series data for commercial loan portfolio
- Visualize historical well data collected on permeability, porosity, and seismic attributes
- Graphical analysis of data subsets to help choose statistical models for predictive intelligence
- Provide additional visualization of MCS predictive models giving joint probabilities of (Perm, Poro) exceeding selected thresholds

Real Estate Lease Provider Analytics Use Case

- Analyzing and tracking lease obligations and expirations by month, quarter, year by client, by region
- Drive pricing decisions by doing what-if comparatives by comparing rental rates to market rates
- Client-property-lease term profitability analysis

Web Analytics Use Case

- Analyze results of A/B testing and multivariate analysis
- User analysis of website traffic by gender, age, demographic, affiliate, region etc.
- Channel, campaign and promo analysis
- Influencer analysis by analyzing connection profiles

Banking Analytics Use Case

- Visualize historical facility-level time-series data for commercial loan portfolio
- Conditional analysis to help estimate probability of default and loss given default by selected attributes such as risk rating, loan type, collateral type and industry sector

Healthcare Analytics Use Case
- Provide additional visualization of predictive model results to help specify bundled pricing of CABG treatment

Syntelli Solutions