Admin

Customer Relationship Specialist

FREE CONSULTATION

CUSTOMER

Our client running a business on Telecom Industry and all his BI application were placed in Sisense software. He wanted to migrate the application from Sisense to Tableau Software due to following reasons,

  • Better Visualization and User-friendly such as Drop & Drag
  • Need data discovery (Story telling) in the visualization and wanted to produce Ad-hoc reports

CHALLENGE

In Sisense, data were not properly transformed so we need to do Data Model then only we pull that modelled data into the Tableau.For this process, we faced some following challenges,

  • To perform data model, tableau requires separate ETL tool for modelling data
  • Handling and developing multiple sheets are demanding

SOLUTION

1. To build a Data model, we suggest Informatica (ETL Tool) to pull data from Sisense and performed Data modelling based on their business model

2. Then we ingested the modelled data into the Tableau

3. All the screens in the legacy system (Sisense) were recreated in advanced dashboards using Tableau and new metrics also analyzed Some of our visuals are,

 

RESULTS

Recreated reports and visualization based on the metrics which was easy in drag & drop and user-friendly for all level business people and also the loading time was reduced by using Tableau package file (twbx) compare to Sisense packaged file

Technologies and Tools

  • MySQL Server 2016
  • CSV Files
  • ODBC Connectors
  • Tableau 12

MORE CASE STUDIES

BI FOR HEALTHCARE INDUSTRY

Our Client has a hospital at his own town and wanted to analyze their 5 years of Health care data to know more about their business flow for following metrics,

View

BI FOR MIGRATE APPLICATION FROM SISENSE TO TABLEAU FOR TELECOM INDUSTRY

Our client running a business on Telecom Industry and all his BI application were placed in Sisense software. He wanted to migrate the application from Sisense to Tableau Software due to following reasons

View

BI FOR FLIGHT DATA ANALYSIS

Our Client has Airline Operating company which was specializes in airline crew and flight schedule management solutions. They have a multiple carrier operating regions where they have multiple airlines. Due to some issues, they wanted to switch over their business into new location so they wanted business intelligence solutions to found out the most requested feature such as existing and potential customers along with some metrics.

View

BI for Paper Manufacturing Company

One of our client has a Paper Manufacturing Firm which manufacture wrapping papers for retails stores.

View

BI for Supermarket Store

Our Client has a well recognized Super market store has multiple products at multiple location and they wanted to predict their sales and market statistics which would allow their business to move on next level based on the analysis

View