Portfolio - Sk Sahim Iqbal

Excel Project

AtliQ Technologies Sales Insights

Domain/Function: Business Intelligence, Financial Data Analysis, Market Trends, Forecasting

Developed a comprehensive sales and financial insights dashboard for AtliQ Technologies. Applied ETL methods, Power Query, and Power Pivot to analyze customer trends, market performance, and P&L reports, delivering clear, actionable business insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

MS Excel

Power Query

Power Pivot

Data Cleaning

Report Preparation

Data Modeling

Customer Performance Report: Excel report analyzing multi-year customer sales trends, identifying high-growth accounts and revenue drivers.

Market Performance vs Target Report: Excel report comparing sales vs targets across markets, highlighting gaps to inform strategic planning.

Project Details

Developed an interactive sales and financial performance dashboard for AtliQ Technologies, delivering clear, actionable insights to support strategic planning.
Key contributions include:
->Sales Analysis: Conducted multi-year trend analysis and compared market performance against sales targets to identify growth opportunities.
->Financial Reporting: Built detailed Profit and Loss (P&L) reports segmented by fiscal years, months, and markets for benchmarking and forecasting.
->ETL Processes: Utilized Power Query to clean data, create date tables, and derive fiscal calendars for accurate time-based analysis.
->Data Modeling: Designed robust data model relationships using Power Pivot to ensure consistency and reliability of insights.
->User-Centric Reporting: Focused on creating intuitive, well-structured reports aligned with business objectives to enhance decision-making.

Python Project

Brightness Control Using Hand Gestures

Domain/Function: Computer Vision

Designed a robust computer vision model in Python/OpenCV to detect hand gestures for dynamic brightness control with over 95% test precision. Enabled hands-free brightness adjustment by recognizing index-thumb movement, improving accessibility for ~80% of surveyed users.

View Project
Engagement

View Project
on GitHUB

Other Tools

Python

Computer Vision

Open CV

Hand Tracking Modules

Sample of the Code

Results After Execution

Project Details

Developed a Python-based solution utilizing OpenCV and Mediapipe for real-time hand gesture recognition to control screen brightness within a 0–100 range. By detecting the distance between index finger and thumb, the system enables intuitive, contactless adjustment of brightness levels. Integrated with system brightness controls to ensure seamless operation. Demonstrates proficiency in computer vision, gesture recognition, and user-focused interface design, addressing practical challenges through innovative technology.

PowerBI Project

Business Insights 360

Domain/Function: Data Analytics & Visualization

Developed “Business Insights 360,” a Power BI dashboard for AtliQ Hardware to replace Excel-based reporting with clear, interactive, department-level insights that improve data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Power Query

Data Cleaning

Data Modeling

Interactive Home Page Of the Power BI Project

Data modeling performed to generate valuable insights

Project Details

Created Business Insights 360, a comprehensive Power BI dashboard for AtliQ Hardware to replace fragmented Excel reporting with a single, reliable source of truth. Delivered interactive views across Finance, Sales, Marketing, Supply Chain, and Executive KPIs to support faster, more informed leadership decisions. Applied Power BI Desktop, Service, DAX, SQL, Excel, and M language to build structured data models, dynamic visuals, bookmarks, and drill-throughs for intuitive navigation. Strengthened skills in data cleaning, modeling, and business storytelling. Focused on translating complex data into clear, actionable insights that drive strategic planning and improve organizational performance.

Live Interactive Dashboard

PowerBI Project

Live Weather Dashboard

Domain/Function: Business Intelligence , Data Analytics , Data Visualization

Built a fully dynamic and interactive weather dashboard in Power BI using real-time data from a weather API. Parsed JSON directly (no CSVs), visualized air quality, temperature, humidity, wind, and more across 7 cities. Auto-refresh enabled via Power BI Service.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Web API Connector

JSON Formatter / Viewer

Power Query Editor

This is the main view of the dashboard, displaying key performance indicators, air quality metrics, and other relevant weather parameters for analysis

This is the data modeling view, where I structured and related tables extracted from the JSON API response to enable accurate and efficient analysis.

Project Details

I built a live weather and air quality dashboard in Power BI using a web-based API, avoiding static CSV files. I connected to the API using the Web connector and transformed the JSON response into structured tables. The dashboard tracks key metrics—temperature, humidity, wind speed, UV index, pressure, precipitation, visibility—for seven Indian cities. It also includes AQI insights like PM10, PM2.5, CO, NO₂, O₃, and SO₂, with color-coded indicators. Dynamic visuals update based on the selected city, including sunrise/sunset and changing weather icons. The dashboard is hosted on Power BI Service with automatic refresh, so users always view the latest data without manual updates.

Hello, I am

Sk Sahim Iqbal

1

1

2

About

Key

My

AtliQ Technologies Sales Insights

Brightness Control Using Hand Gestures

Business Insights 360

Live Weather Dashboard

Awards

Contact Me

Email

Github

Linkedin

Call

Sk Sahim Iqbal

Download Resume