Portfolio - Danish Akhtar | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Danish Akhtar

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

I’m an aspiring Data Analyst passionate about turning raw data into meaningful insights that support better business decisions. I work with Excel, Power BI, SQL, and Python to clean, analyze, visualize, and interpret data.
My journey into analytics began with a bachelor’s degree in arts, where I discovered my strengths in analytical thinking, problem-solving, and working with data. I’ve since built my technical skills through hands-on learning and multiple end-to-end projects showcased in my portfolio.
I also have practical experience as a Data Entry & Data Processing Associate on a CBIC audit project, where I handled GST-related data, downloaded and consolidated information from internal government portals, matched records, performed data validation, and maintained accurate documentation using Excel and Word.
I’m now looking to transition my data-handling experience and analytical skills into a professional Data Analyst role, where I can contribute to data-driven decision-making

Key

Skills

Excel

Power BI

SQL

Python

Effetctive comunication

stakeholder mangement

My

Projects

Sales Analytics

Sales Analytics

Domain/Function: FMCG

Create 2 project for the sales team which will help then to evaluate customer performance and understand their market performance with respect to their target.

Title: Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Title: Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance, Sales, Marketing and Supply Chain

Designed and deployed an end-to-end Power BI analytics solution for AtliQ Hardware', migrating critical business reporting from disparate Excel sheets to an automated data model.
Built dynamic DAX measures and interactive dashboards to track high-priority KPIs across revenue, regional distribution

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals

CB Cert

Soft Skills Bootcamp: Communication, Productivity & Personal Branding

Contact Me

Email

[email protected]

Github

https://github.com/Alphacoder00

Linkedin

https://www.linkedin.com/in/danish-a-526b6220a/

Call

+91 7348305529

Danish Akhtar

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics

Domain/Function: FMCG

Create 2 project for the sales team which will help then to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Sales Analytics

*Customer Performance Report: Provides a clear view of each customer’s net sales performance across multiple years, helping identify sales trends, growth patterns, and high-performing customers.

Sales Analytics

Customer Performance Report: Provides a clear view of each customer’s net sales performance across multiple years, helping identify sales trends, growth patterns, and high-performing customers.

Project Details

In this project, I developed an Excel-based Sales Analysis Report to help businesses monitor and evaluate sales performance, identify effective customer discount strategies, support pricing negotiations, and discover potential expansion opportunities in high-performing markets.
The report converts raw sales data into meaningful insights and actionable recommendations, enabling businesses to optimize sales strategies, improve customer satisfaction, identify growth opportunities, and maximize revenue. Key Skills & Learnings

1. Excel Pivot Tables for data summarization and analysis
2. Power Query for data cleaning and transformation
3. Basic DAX for analytical calculations
4. Conditional Formatting to highlight key trends and performance
5. Report Design & Beautification for clear and professional reporting
6. Sales Domain Metrics to measure and evaluate sales performance

Overall, this project strengthened my ability to analyze sales data and transform

PowerBI Project

Title: Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance, Sales, Marketing and Supply Chain

Designed and deployed an end-to-end Power BI analytics solution for AtliQ Hardware', migrating critical business reporting from disparate Excel sheets to an automated data model. Built dynamic DAX measures and interactive dashboards to track high-priority KPIs across revenue, regional distribution

View Project
Engagement

Title: Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Title: Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modelling involving 10+ tables

Project Details

Building a single BI report for Sales, Marketing, Finance, and Executive teams is a data modeling and UX challenge, not just a charting task.

I developed an end-to-end Power BI solution to serve as a unified source of truth across all four departments.

Core Focus Areas:
• Robust Data Modeling: Structured 10+ tables into a clean star schema.
• User-Centric Design: Intuitive layouts tailored for rapid decision-making.
• Drillable Insights: Macro KPIs down to granular root-cause analysis.

Technical Execution:
• Power Query: Advanced data cleaning, unpivoting, and schema transformations.
• DAX Layer: Custom time-intelligence measures, dynamic ratios, and KPI logic.
• Interactive UI: Bookmarks and navigation states for a clutter-free canvas.
• Deployment: Published to Power BI Service with scheduled automated refreshes.

Live Interactive Dashboard

Already have an account? Sign in

or