Outline
- SQL + Reporting Project (SQL, SSMS, SSRS, Visual Studio)
- ETL (Python, SQL, API, Kaggle Datasets)
- Desktop CRUD Application (C#, .NET)
- PowerBI Dashboard (PowerBI)
Building SQL Database, populating data, and creating reports using SSRS
Technologies: SQL Server (SSMS), SSRS (via Visual Studio)
Custom SQL Database Schema
SQL code for Table Creation, Data Population and Custom Views Provided
Completed Orders (Totals) Report
Order Fulfillment and Inventory Managers can check the completed orders, highlighting any potential issues in fulfillment.
Orders By Categories
Department Managers and Sales Teams can track the performance of different departments, identifying high-performing areas and those needing improvement.
Simulates a basic ETL Pipeline application, combining data from various sources, applying some data cleaning and quality checks before loading the data into an SQL Database.
- Extracts customer, product, order, and payment data from a local SQL Server database.
- Extracts additional customer details from a CSV file (
Shop Customer Data.csv). - Extracts public user data from a dummy API (
https://dummyjson.com/users). - Transforms the API JSON response into a flattened pandas DataFrame. Standardizes all column names to lowercase for consistency.
- Merges all datasets together using DataFrame index alignment.
- Outputs a cleaned and merged customer DataFrame ready for analysis
- Loads the DataFrame into an SQL Server Database
Before vs After
Tech Stack: C#, ASP.NET, SQL Server A simple app that allows users to input, store, and retrieve Customer data from the database.
Features:
- User input forms
- SQL-based data storage and queries
Tech Stack: Power BI, SQL Server
Project Description:
Interactive dashboard built using SQL data connected to Power BI.
Features:
- Real-time insights
- Slicers for filtering
- KPIs and summary metrics
