Approach for implementing this project:
- Ingest initial set of tsv or csv files into staging tables
- Designed and loaded dimensional model for above data
- Perform data consistency & cleansing processes.
For Example: Empty values in ingestion files need to result in SQL Server column Nulls and Data type conversion
- Add supplemental data to model
- Design and create BI visualizations answering business questions