Portfolio - Mohamed Arshad kader | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Mohamed Arshad kader

Data Aspirant

1

Excel
Project

3

PowerBI
Projects

About

Me

Welcome to my Portfolio! I'm a future-focused Data Analyst driven by a passion for unraveling insights from complex datasets. Despite earning a degree in aeronautical engineering, my natural proclivity for data analysis led me to master Power BI, Excel, and SQL with ease. While my professional journey is in its early stages, my portfolio showcases a series of impactful business projects. These ventures not only spotlight my analytical skills but also demonstrate my ability to apply data insights to real-world scenarios. Explore my portfolio below for a firsthand look at how I've turned raw data into actionable business solutions, showcasing my potential impact on your team. I'm eager to bring my skills and passion for data analysis to your organization. Let's connect and explore how I can contribute to your team's success

Technical

Skills

Excel

PowerBI

SQL

Figma

My

Projects

Business Insight 360

Business Insight 360

Business Insights 360 is a comprehensive Power BI dashboard designed to empower AtliQ Hardware with actionable insights across Finance, Sales, Marketing, and Supply Chain. This repository houses the project files and documentation.

Sales and Finance Analytics

Sales and Finance Analytics

This project introduced me to the deeper side of Advanced Excel and the realm of sales data, through which I gained proficiency in Excel's powerful tools for extracting insights from raw data

HR Analytics

In this project, we will take a REAL dataset for employee presence from a company called AtliIn this end-to-end data analytics project, we will take REAL dataset for employee presence from a company called AtliQ and perform data analysis in Power BIIn this end-to-end data analytics project, we will

Strategic Insights for Mitron Bank's New Credit Card Line

Strategic Insights for Mitron Bank's New Credit Card Line

The objective is to analyze this data and provide actionable, data-driven recommendations to guide Mitron Bank in tailoring the new credit cards to customer needs and market trends

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

Contact Me

Linkedin

https://www.linkedin.com/in/mohamedarshadkaderk/

Mohamed Arshad kader

Data Aspirant

PowerBI Project

Business Insight 360

Business Insights 360 is a comprehensive Power BI dashboard designed to empower AtliQ Hardware with actionable insights across Finance, Sales, Marketing, and Supply Chain. This repository houses the project files and documentation.

View Project
Engagement

Business Insight 360

Finance

Business Insight 360

Sales

Project Details

The project is divided into Five sections wherein the main highlights are:

Finance View: Detailed financial analysis, including revenue, expenses, and profit margins.

Sales View: Insights into product and customer performance.

Marketing View: Analytics to enhance marketing strategy.

Supply Chain View: Optimization metrics for efficient supply chain management.

Executive View: Metrics critical for top-level decision-makers.

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

This project introduced me to the deeper side of Advanced Excel and the realm of sales data, through which I gained proficiency in Excel's powerful tools for extracting insights from raw data

Sales and Finance Analytics

Customer Performance Report

Sales and Finance Analytics

Market Performance vs Target Report

Project Details

📈 Sales Analytics Purpose:
Empowering businesses to monitor, evaluate, and enhance their sales activities and outcomes. Unveiling sales patterns, tracking essential performance indicators, and driving informed decisions. Determining effective customer discounts, facilitating negotiations, and identifying expansion opportunities in potential markets.

📊 Finance Analytics Purpose
Evaluating financial performance, aiding decision-making, and fostering stakeholder communication. Benchmarking against industry peers, historical periods, and establishing the foundation for budgeting and forecasting. Aligning financial planning with strategic objectives and instilling confidence in the organization's financial outlook.

𝗦𝗸𝗶𝗹𝗹𝘀 𝗚𝗮𝗶𝗻𝗲𝗱:
> I learned how to work with data, use specific tools like Power Query, Power Pivot, and DAX, and generate insightful reports
> Proficient in ETL methodology (Extract, Transform, Load).
> Skillful in creating date tables using Power Query.

PowerBI Project

HR Analytics

In this project, we will take a REAL dataset for employee presence from a company called AtliIn this end-to-end data analytics project, we will take REAL dataset for employee presence from a company called AtliQ and perform data analysis in Power BIIn this end-to-end data analytics project, we will

Other Tools

Excel

HR Analytics

Presence Insights

Project Details

The project is divided into several sections wherein the main highlights are:

1. We focus on 3 KPIs essentially and their performance.
2. Working preference of people between WFH and WFO.
3. How much percentage of people are present in a given week or day?
4. Preferred day of WFH.
5. Sick leave percentage

Live Interactive Dashboard

PowerBI Project

Strategic Insights for Mitron Bank's New Credit Card Line

The objective is to analyze this data and provide actionable, data-driven recommendations to guide Mitron Bank in tailoring the new credit cards to customer needs and market trends

Strategic Insights for Mitron Bank's New Credit Card Line

Demographics

Strategic Insights for Mitron Bank's New Credit Card Line

Spend Analysis

Project Details

In the Mitron Bank Credit Card Expansion, our aim was to diversify offerings and boost market presence.

Key findings:
1. Spending trends: Bills, Groceries, Electronics dominate, with Mumbai leading.
2. Income impact: Salaried IT, Business Owners, Other Salaried are top spenders.
3. Age preferences: 25-34, 21-24 focus on Entertainment, Apparel, Travel.
4. City dynamics: Mumbai leads, diverse patterns in Delhi NCR, Bengaluru, Chennai.
5. Gender & marital impact: Males, married individuals prominent card users

Live Interactive Dashboard

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.