Asim Ahmed | Data Analyst

01 — NTI Graduation Project

ADVENTURE
WORKS 2019

SQL Server & Power BI

End-to-end data analysis using the AdventureWorks2019 relational database. Built SQL Views to extract and clean data, then designed an interactive Power BI dashboard tracking Revenue, Profit Margins, and Order KPIs with full time-intelligence analysis.

SQL Server Power BI DAX Data Modeling KPI Dashboard

01Explored AdventureWorks2019 relational tables and mapped relationships

02Created SQL Views to join, filter, and optimize data before import

03Built a Calendar Table using DAX for Year-over-Year time intelligence

04Wrote complex DAX measures: Revenue, Profit Margins, Order Quantity

05Designed a multi-page dashboard for stakeholder performance tracking

02 — DEPI Project

SALES
DATA SET

Excel · Power Query · Pivot Tables

Comprehensive Excel-based analysis completed for DEPI. Handled the full data workflow — from raw data cleaning with Power Query to final visualization using Pivot Tables and Charts, identifying bottlenecks and delivering actionable business solutions.

Excel Power Query Pivot Tables Data Cleaning Business Insights

01Connected and cleaned raw data using Power Query, removed duplicates and nulls

02Standardized data formats to ensure 100% accuracy across the dataset

03Leveraged Pivot Tables for deep-dive regional & product trend analysis

04Selected optimal chart types (Bar, Line, Pie) for clear stakeholder communication

05Identified business bottlenecks and provided data-driven solutions

03 — DEPI Final Project NEW

OLIST
E-COMMERCE

Power BI · Business Analysis

Full business performance analysis of Barzilan E-Commerce (Olist dataset) — 95,128 orders, 92,318 customers, 2,893 sellers. Built a multi-dashboard Power BI report uncovering regional revenue concentration, payment method risks, customer retention crisis, and delivery performance.

Power BI DAX Data Modeling Star Schema E-Commerce Business Strategy

01Designed a Star Schema data model connecting 6 tables: orders, customers, sellers, products, payments, fact_orders_items

02Built Sales Dashboard: Revenue by City, Sales by Category, Monthly Payments, AOV (Avg. Order Value)

03Built Products Dashboard: Content Quality Audit, Weight vs Shipping Cost, Sales Volume vs Orders by Category

04Built Region Sales page with interactive map showing City by Revenue across 4,073 active cities

05Authored a full business report: 97% customer churn, debit card absence (1.5%), regional revenue concentration — with actionable strategies

// Key Business Findings

97%

Customer Churn

Customers don't return after first purchase — critical retention risk

80%+

Revenue from 3-4 States

Heavy concentration in SE Brazil — massive untapped regional growth

1.5%

Debit Card Usage

Missing payment rails excluding millions of Brazilian consumers

+25%

Revenue Potential

Fixing retention alone could grow annual revenue by 15–25%

04 — Supply Chain Analytics

SUPPLY CHAIN
DASHBOARDS

Power BI · DAX · Power Query

A comprehensive KPI dashboard for managing supply chain operations, sales, and inventory. Built a robust Star Schema data model linking inventory movements to actual sales transactions, with full regional breakdown of revenue and cost across all warehouse locations.

Power BI DAX Power Query Star Schema ETL Supply Chain

01

Sales & Profit Analysis: Monitored Total Revenue (2M), Gross Profit (655K), and COGS (1M) to identify the most profitable channels (Store vs Web).

02

Inventory Management: Tracked 17M units distributed across brands (Fjord, Nordmark, Eira, Polar) and locations (Main DC, Oslo, Bergen, Trondheim).

03

Regional Analysis: Used Decomposition Tree and Treemap to break down revenue and COGS accurately by region and sales geography.

04

Advanced Data Model (Star Schema): Linked Inventory Movements and Snapshots tables to Sales and Master data for seamless, accurate information flow.

ASIM
AHMED

SKILLS &
TOOLS

PROJECT
PORTFOLIO

EDUCATION &
EXPERIENCE

SERVICES

GET IN
TOUCH

ASIMAHMED

SKILLS &TOOLS

PROJECTPORTFOLIO