Extraction of data from different Database sources, Transformation (unification and cleaning) of extracted data and laoding into the data warehouse and Analysing the data.
- Creating tables
- Populating tables
- Altering tables
- Finding and deleting duplicates in tables
- performing Calculations (Turnover, Amount of sales)