A Java-based Grocery Store Management System with separate Admin and User apps. Built using Swing and SQL Server, it supports product, customer, and employee management with a fully interactive UI.

SQL Analysis for orders Pizza Restaurant and Power BI Dashboard

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.

🏃🏻‍♂️ Personal Fitness Management System: Helps users track fitness routines, monitor progress, and manage food-intakes. It features a user-friendly interface, calorie tracking, manage workout activities, and data analysis tools. Built with Python, MySQL, and CustomTkinter.

MS SQL Database system created for "Restaurant Management". Developed in MS SQL Server 2019 Management Studio for 3rd grade(junior year) Database Systems course.

edX course Microsoft: DAT201x Querying Data with Transact-SQL

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

The task was given to assess my understanding of writing complex SQL queries as a recruitment process for data analyst position in Dcluttr.

The repository contains sample MS-SQL files from my work.

Microsoft SQL Server tools and utilities

to develop data pipeline using the EDA and advanced analytics/ MS SQL server, create customers.gold_reports and sales.gold_reports.