SUCCESS STORY

Established a centralized data warehouse for comprehensive information management

Industry

Healthcare

Country

Thailand

Company size

201 - 500 employees

Website

https://www.phc.co.th/

About Pacific Healthcare

Pacific Healthcare is well known for providing the best sales and marketing services within the healthcare industry; offering a wide variety of healthcare products and services through trusted partners and people that care about their communities.

Industry

Gas & Oil

Country

Us

Company size

45.000 employees

Website

About Halliburton

Halliburton Company is an American multinational corporation and the world’s second largest oil service company and responsible for most of the world’s largest fracking operations. The company helps customers maximize value throughout the lifecycle of the reservoir – from locating hydrocarbons and managing geological data, to drilling and formation evaluation, well construction and completion, and optimizing production throughout the life of the asset.

The Challenges

The customer’s data was stored in various disparate locations, making it challenging to query and collect data. Therefore, the client wanted to establish a data warehouse to centralize all the information in one place

The Solutions

  • Proposed to build crawlers to collect data from multiple sources, refine and format the data.
  • Inserted the data into a repository referred to as the data warehouse.
  • Utilized Power BI to visualize the data for end-users.
  • Created a website for employees can update and add data to the data warehouse

The Results

  • A warehouse database was established to store all kinds of relevant data such as sales, products, customers, etc
  • Employees could view reports and create new data from the data warehouse, making daily tasks smoother.
  • Allowed users to import data by uploading massive data from Excel files

Related Success Stories

Country:

United States

LogiGear delivered a suite of automated test cases that cut user acceptance time from days to hours

Country:

United Kingdom

Revamped website interface to a modern design in alignment with client specifications

Country:

United States

Collaborated with Orb Health to revamp healthcare platform for enhanced user experience and features.