Oil and Gas Data Marts



Project Video :


Problem Statement
Visual KPI's and Data Dictionary
Executive Summary & Problems That Occurred
Suggestions
Final Data Model
Create Databases and Staging Tables
Setting the pace: Create a New Project & New SSIS Package
Create Connection Managers
Create Staging Tables and Populate Tables
Create and Populate ODS Tables (Dictionary Tables)
Create and Load Data Warehouse Staging Tables
Create and Load Dimension Tables
Create and Load Fact Tables