Business Cases

Contact

Retail

Customer Situation

  • POS application to manage shop activity (sales of product)
  • Vanilla ETL to load into datawarehouse, aggregation of data from shop
  • Vanilla BI to run statistical reports and dashboard : monthly sales, product sale focus

Customer Business case

  • What does influence my sales?
  • How weather can influence sales on product?
  • If I can have some weather prediction, can I forecast my sales?

Success with Smart Data

  • Real time integration of data from POS loaded into Hadoop/Hbase
  • Data transfer to Spark to run real time cluster Analysis on sale product
  • Daily analysis of Sales with weather data : data analysis, cluster by product type
  • Maps visualization with sales and weather information
  • Maps visualization with sales and weather information
  • Daily prediction on sales based on weather forecast (up to 5 days)

Hospital

Hospital Situation

  • Hospital Management want to understand if there are correlation between days of the week, and / or weather, and pathology
  • Vanilla ETL to load Hospital data into datawarehouse, aggregation of data from various hospital
  • Vanilla BI to run statistical reports and dashboard : statistics by pathology, by sector

Customer Business case

  • What does influence some pathology?
  • How weather can influence some pathology?
  • How week-day, holiday and week-end can influence some pathologies?
  • Is there a model to predict number of case for some pathologies?

Success with Smart Data

  • Real time integration of data from Hospital loaded into Hadoop/Hbase
  • Real time integration of weather data
  • Data transfer to Spark to run Analysis on hospital data
  • Model to visualize cluster of data : pathology by patient type, increase of some pathologies correlated with weather evolution, correlation between week-day and pathologies, etc …
  • Maps visualization with patients/pathologies and weather information
  • Maps visualization with patients/pathologies and week-days
  • Weekly prediction on pathologies based on weather forecast (up to 5 days) and week days, per region

Purchase Industry

Customer Situation

  • Customer subscribe to a saas purchase platform to manage the different products he wants to buy from various supplier web site.
  • Vanilla BI to provide various reports and dashboard for customers on their monthly activity, activity trend on some products, etc …

Customer Business case

  • How to find the better price for my product using more data sources?
  • How social media comments on a product can influence its price?

Success with Smart Data

  • Real time data load process from legacy database into Hadoop HBase
  • Data collection from various web sites (catalogs, promotions)
  • Real time data integration from various data sources : social media, weather, price platform …
  • Data analysis with R and Spark: price position based on weather, social media interest, economical data
  • Maps visualization with sales and weather information
  • Price comparison and best price proposition : “now and tomorrow”

Pharmaceutical Industry

Customer Situation

  • Customer subscribe to a saas purchase platform to manage the different products he wants to buy from various supplier web site.
  • Vanilla BI to provide various reports and dashboard for customers on their monthly activity, activity trend on some products, etc …

Customer Business case

  • How to find the better price for my product using more data sources?
  • How social media comments on a product can influence its price?

Success with Smart Data

  • Real time data load process from legacy database into Hadoop HBase
  • Data collection from various web sites (catalogs, promotions)
  • Real time data integration from various data sources : social media, weather, price platform.
  • Data analysis with R and Spark: price position based on weather, social media interest, economical data
  • Price comparison and best price proposition : “now and tomorrow”

Finances

Customer Situation:

  • Customer want to evaluate risk on loan, to manage deficient loan. To achieve this objective, Bank need to have a flexible and reliable credit scoring program.
  • Vanilla ETL to load data into datawarehouse, aggregation of data from bank back office system
  • Vanilla BI to run statistical reports and dashboard : maps on loans, by customer categories, per loan type or status

Customer Business Case

  • What does impact customer delinquent loan?
  • If I can have some prediction on customers, can I forecast my deliquent loans?

Success with Smart Data

  • Real time integration of data from production system loaded into Hadoop/Hbase
  • Data transfer to Spark to run real time cluster Analysis on sale product
  • Maps visualization with customers & loans information
  • Daily prediction on risk (loan, operation, fraud) based on predictive model

Firemen

Firemen Situation

  • Firemen want to have activity forecast, and want to understand what is the relation between weather and some kind of intervention (fire, flash flood, …). To achieve this objective, Firemen need reliable analytics & predictive model, based on accurate kpi.
  • Vanilla ETL to load data into datawarehouse, aggregation of data from firemen back office system.
  • Vanilla BI to run statistical reports and dashboard : maps on kpi, by region, per intervention type.

Customer Business case

  • How weather can influence some events?
  • Is there a model to predict number of case for some intervention type?

Success with Smart Data

  • Real time integration of data from production system loaded into Hadoop/Hbase
  • Model to visualize cluster of data : intervention by type, increase of some intervention type correlated with weather evolution, correlation between week-day and events, etc …
  • Maps visualization with intervention type by region.
  • Daily prediction on intervention type based on predictive model.