Implementing a Data Mart to Analyze Marketing Conversions

1. Brief summary about the Data Mart
2. Creating New Database step by step by using GUI
3. Understand each table and Denormalize the Data
4. When and Why to Use Denormalization?
5. How does the client want to analyze the data?
6. Designing the Dimensional Model
7. What are Slowly Changing Dimensions and Merge Statement ?
8. Creating Dimension Tables
9. Creating Fact Table and Populating data
10. Creating the Stored Procedure
Marketing Conversions Database Diagram GIFs in SSMS