Portfolio - MD MERAJUDDIN

MD MERAJUDDIN

Data Aspirant

Resume

3

PowerBI Projects

1

Python Project

1

Excel Project

1

SQL Project

About Me

Hey there! I'm Md Merajuddin, and I'm all about decoding data to uncover hidden gems. Proficient in Excel, Power BI, SQL, and Python, I'm like a detective sniffing out insights from numbers.

My journey began with a bachelor's degree in economics, but I quickly realized my knack for data analysis was where my heart lay. While I may not have clocked in at a company yet, I've honed my skills through numerous business projects showcased in my portfolio. These projects serve as testament to my dedication, ingenuity, and ability to tackle real-world challenges head-on.

Driven by a relentless curiosity and a desire to make meaningful contributions, I'm eager to dive deeper into the realm of data analysis and forge impactful connections within the industry. Let's connect and make some magic happen!

Key Skills

Python

SQL

Problem solving

My Projects

AtliQ Business Insights - 360

Hotel Booking Analysis

Customer Performance Report

Lok Sabha Election Analysis - 2014 and 2019

AtliQ Hardwares Consumer Goods Analysis

Domain/Function: Consumer Goods Domain

Driving Insights and Growth for GoodCabs!

Domain/Function: Transportation & Mobility

Awards & Certificate

SQL Beginner to Advanced For Data Professionals

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

Excel: Mother of Business Intelligence

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/meraj-073004b7/

Call Me

+91 9875512645

GitHub

https://github.com/hypnoticmeraj?tab=repositories

PowerBI Project

AtliQ Business Insights - 360

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights.

View Project
Engagement

Intro page which shows all the 5 views and an option to direct jump to any of the view with its short description.

Finance view page where I have shown Profit & Loss statement with Top & Bottom Customers by Net Sales.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Python Project

Hotel Booking Analysis

This data set contains booking information for a city hotel and a resort hotel, and includes information such as when the booking was made, length of stay, the number of adults, children, and/or babies, and the number of available parking spaces, among other things. All personally identifying inform

View Project
on GitHUB

Hotel Booking Analysis using EDA on Jupyter Notebook

Project Details

Excel Project

Customer Performance Report

Develop an analytics system to monitor sales performance, analyze data and generate meaningiful reports for effective customer discount and business expansion.

Conditional formatting provides clear insights. It shows the Net Sales of customer for 2021 vs 2020.

Pivot table summarize and analyses data efficiently. Conditional formatting provides clear insights.

Project Details

Develop an analytics system to monitor sales performance, analyze data and generate reports for effective business decision.
Through the implementation of this sales analytics system business team will be able to track their performance against the targeted volumes and benchmarks.

PowerBI Project

Lok Sabha Election Analysis - 2014 and 2019

AtliQ Media is a private media company and they wanted to telecast a show on Lok Sabha elections 2014 in India. Unlike other channels they do not want to have a debate on who is going to win this election, they rather wanted to present insights from 2014 and 2019 elections without any bias.

View Project
Engagement

View Project
on GitHUB

Home page view of the dashboard which give access to users to directly jump to any page view just by clicking on the icon.

A table visual showing the list of winners from each constituency with runner up and vote margin, giving option to filter out year, state and category

Project Details

Live Interactive Dashboard

SQL Project

AtliQ Hardwares Consumer Goods Analysis

Domain/Function: Consumer Goods Domain

Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too. They want to expand their market in order regions as well.

View Project
Engagement

View Project
on GitHUB

View Project
on

Other Tools

Microsoft Power Point

Microsoft Power BI

In FY 2020 we had 245 unique products while in FY 2021 we have 334 unique products an increment of 36.33%.

ER diagram of our database which shows sales data for FY 2020 and 2021, along with other dimension tables such as dim_customer, dim_product, etc.

Project Details

Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.
However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.
Task: As an applicant, I tackled 10 ad hoc requests in the 'ad-hoc-requests.pdf' by running SQL queries to provide insights for top-level management. 📈

📁 Resources Provided:

- Dataset

- Metadata

- Hints

- Sample questions and Presentation

PowerBI Project

Driving Insights and Growth for GoodCabs!

Domain/Function: Transportation & Mobility

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Provides an in-depth analysis of city-specific metrics, showcasing key performance indicators such as Weekend vs Weekday trip demand, driver ratings,

Tracks performance against predefined targets, comparing actual metrics to goals. This page includes key visuals like most tripped cities actual vs ta

Project Details

Goodcabs, a cab service company established two years ago, has gained a strong foothold in the Indian market by focusing on tier-2 cities. Unlike other cab service providers, Goodcabs is committed to supporting local drivers, helping them make a sustainable living in their hometowns while ensuring excellent service to passengers. With operations in ten tier-2 cities across India, Goodcabs has set ambitious performance targets for 2024 to drive growth and improve passenger satisfaction.
As part of this initiative, the Goodcabs management team aims to assess the company’s performance across key metrics, including trip volume, passenger satisfaction, repeat passenger rate, trip distribution, and the balance between new and repeat passengers.