This project encompasses the complete data lifecycle, from data extraction and transformation to in-depth analysis and compelling visualizations. The process is divided into three main phases

💵Understanding the customer base of the DVD Rental database using SQL💰

Create and deploy an efficient data warehouse using Microsoft SQL Server tools, optimizing loading processes with SSIS for ETL workflows. Extend functionality with SSAS, SSRS, and pivot tables for in-depth analysis, enhancing insights through Power BI visualization.

SQL Pivot Table, Dynamic Variable, Store Procedures, Triggers

SQL Server PIVOT operation which rotates a table-valued expression. It turns the unique values in one column into multiple columns in the output and performs aggregations by SUM(), COUNT(), AVG(), MIN(), MAX() on any remaining column values.

TSQL training results and materials.

Develop and Deploy a Datawarehouse solution. Employed MS SQL Server Management Studio to build a data warehouse and increased data loading efficiency and Implemented MS SQL Integration Services (SSIS) to devise and execute ETL processes. BI II project, Building from the Data Warehouse a SSAS, SSRS, Analysis in pivot tables and Data Visualization

Database - Public Health Center Community Survey

A complete Bike stores data analysis project using SQL and Microsoft Excel.