By using AdventureWorks2022 Dataset I have built a Sales Data Mart using (SQL Server Integration Services SSIS) SQL Server involves leveraging the capabilities of Integration Services (SSIS) and the Modeling of SQL Server, This Data mart offers several benefits, making them valuable components in the main purpose of data management and analytics wi

The project involves building a comprehensive data warehouse from the AdventureWorks2022 source system, creating staging and dimensional tables, and Designing a Tabular model using a combination of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI, and creating a report with SSRS

Self-practice on SQL-Server

Simple sql server reports on AdventureWorks2022 DB

No description available

SQL Server Paginated Reports on Sales Orders based on AdventureWorks2022 database

Data Analysis for the SQL Server AdventureWorks2022 database with Python and Pandas

Developed a Sales Data Mart using SQL Server Integration Services (SSIS) and SQL Server, leveraging AdventureWorks2022 Dataset for online sales analysis.

This project demonstrates how to use Full Text Search in Microsoft SQL Server, utilizing the Northwind and AdventureWorks2022 databases.

An intermediate SQL Server project demonstrating complex JOINs, CTEs, window functions, and analytical queries on the AdventureWorks2022 database, designed to reflect real-world Business Intelligence reporting scenarios.

T-SQL inventory analytics case study on AdventureWorks2022 (SQL Server), focused on inventory, turnover, working capital, safety stock, reorder points, ABC classification, and demand patterns. It applies structured analytical logic using CTEs, window functions, rolling calculations, and statistical methods

Solved SQL queries based on the AdventureWorks2022 sample database as part of my first internship assignment. Covers 42 business-related questions involving customers, orders, products, employees, and suppliers. Executed and tested in SQL Server Management Studio using real-world relational data scenarios.

This project implements a comprehensive backup and recovery strategy for the AdventureWorks2022 database using SQL Server Agent jobs. The solution ensures data protection through scheduled full, differential, and transaction log backups with point-in-time recovery capabilities.

Proyecto realizado para el programa digitalers. Implicó la utilización del dataset AdventureWorks2022, la extracción de los datos se realizó a través de SQL Server Management Studio 20, y la conformación de tableros a través de Power BI Desktop.

Power BI project built on the AdventureWorks2022 SQL Server database. Includes interactive dashboards, DAX measures, and data modeling for sales, customers, and product performance analysis. Designed for real-world BI scenarios with drill-down functionality, version control, and best-practice data visualization techniques.