adventureworks

How to model and partition data for Cosmos DB starting with the Adventure Works database.

End-to-end data platform: A PoC Data Platform project utilizing modern data stack (Spark, Airflow, DBT, Trino, Lightdash, Hive metastore, Minio, Postgres)

The sources (incl data) needed to generate the Adventure Works DW 2020 DAX training model as a PBIX file.

Basic to Complex SQL Server queries with Adventure Works database including window functions, triggers, string manipulation, user-defined functions, CTE, recursive CTE, DML and DDL

Importing AdventureWorks (SQL Server Sample Database) to Neo4j

A docker image using Microsoft's AdventureWorks (demo/sample) database pre-loaded and installed on SQL Server or Postgres.

Interactive documentation for a Microsoft SQL Server database

Repository for Adventure Works Sample Database Analysis

ETL process using Pentaho Data Integration (Kettle), for Sales and Purchases Datamarts from Adventureworks, as the final project from the Data Management course from the Big Data & Analytics Masters @ EAE class of 2021

An end-to-end Excel data analytics project using the AdventureWorks dataset. Built interactive sales dashboards using Power Query, Power Pivot, DAX, PivotTables, and slicers to analyze time trends, product performance, customer behavior, and profitability with clear business insights.

A Python/SQL breakdown of Adventure Works Cycles' demographic makeup, visualized with a Tableau dashboard

During my Summer Internship at Celebal Technologies, I worked on SQL projects to improve data management and search processes for a particular client. The main goal of these projects was to optimize database queries and ensure effective information retrieval.

🗃 SQL Server

RFM analysis on Adventure works database

This project aims to implement a robust ETL process using SQL Server Integration Services (SSIS) to extract data from the AdventureWorks database, transform it, and load it into a Data Warehouse named "Datawarehouse."

This is a repository created for the Analytics Engineering certification by Indicium Academy and Lighthouse Program.

SQL project using the Microsoft AdventureWorks2012 database to perform sales analysis and customer queries.

Interactive Power BI dashboard built on Adventure Works sales and returns data — featuring DAX measures, drill-through, AI visuals, and an app-like report experience.