Managed to create a data warehouse and report KPI

it_user396720 - PeerSpot reviewer
10 people affected
4 people managed
4 month project

Project Description

Managed to create a data warehouse and report key performance indicators.

Converted SAS data format to CSV and then stored in MYSQL database, integrated 4 different sources into one single data warehouse using Data Integration Tool .

Challenges in project:- Data was not structured. Had missing connections to make a relational database. Data had to be cleaned and was large enough to handle by traditional database softwares.


Highlights

Support from colleagues

Difficulties

Management had to be convinced
data was not structured

Products Used

Technical Skills Used

  • SQL
  • OLTP
  • OLAP
  • RELATIONAL DATABASE
  • Text Parsing
  • Data Mining
  • Lubbock33.5779-101.855