Powered by
Codebasics DA Bootcamp

Mohd Sofiyan

Data Analyst

+91 8886768482 [email protected]

Resume

Hello, I am

Mohd Sofiyan.

2

Excel Projects

3

PowerBI Projects

1

SQL Project

About Me

Welcome to my portfolio! I'm passionate about turning raw data into useful insights. With a bachelors degree in commerce with computers, I discovered my knack for analyzing data and decided to dive deeper into it.

I've taught myself Excel, PowerBI, and SQL, which help me analyze tricky datasets and draw valuable conclusions.

While I haven't worked professionally yet, I've tackled many projects that have strengthened my skills and showcased what I can do, all detailed in my portfolio.

I love learning and thrive in fast-paced environments where I can use my analytical skills to solve real problems. I'm always eager to grow and excited about making decisions based on data.

Thanks for checking out my portfolio! I'm looking forward to connecting with recruiters who value the power of data.

Key Skills

My SQL

SQL

Python

Tableau

Google Tools

Microsoft SQL Server

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Scam Awareness Course

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Introduction to Career Skills in Data Analytics

Introduction to Career Skills in Data Analytics

Bravo Award

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.

[email protected]

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

+ 91 8886768482

https://github.com/sofiyan-smasher

Excel Project

Sales Analytics (FMCG) Excel

I've developed two reports for the sales team to evaluate customer performance and assess market performance compared to targets. The first report provides insights into individual customer performance across various metrics, allowing the team to identify trends and areas for improvement.

View Project
Engagement

View Project
on GitHUB

Sales Analytics (FMCG) Excel

Customer Performance Report: This report shows how much each customer has sold over the years.

Sales Analytics (FMCG) Excel

Market Performance vs. Target Report: This report allows stakeholders to evaluate how well a country is performing compared to the targets that have

Project Details

This project involves the creation of a comprehensive sales report utilizing Excel pivot tables. The aim is to provide businesses with valuable insights into effective customer discounts, thereby facilitating negotiations with consumers. Additionally, the report will help identify potential opportunities for business expansion in promising countries. By leveraging the generated reports, businesses will gain actionable insights and recommendations to optimize their sales strategies, improve customer satisfaction, and ultimately maximize revenue generation.

PowerBI Project

AtliQ Hardware BI Dashboard for Finance, Sales, Marketing, and Supply chain.

AtliQ Hardware, a consumer electronics enterprise, is currently undergoing rapid expansion. Despite this growth, it faces challenges in competitive positioning due to reliance on conventional data management practices, primarily utilizing Excel for reporting purposes. To address this, my objective

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

My SQL

DAX Studio

AtliQ Hardware BI Dashboard for Finance, Sales, Marketing, and Supply chain.

A user-empathetic landing page in a dashboard design prioritizes user needs, featuring a clear purpose statement and intuitive layout. Personalization

AtliQ Hardware BI Dashboard for Finance, Sales, Marketing, and Supply chain.

Data modeling involving 10+ tables entails structuring a database to represent complex relationships and data dependencies across multiple entities.

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

Excel Project

Personal Expenses Report

This Excel project presents a comprehensive monthly expenses report, meticulously designed to track and analyze financial data. With clear visualizations and interactive features, it offers insights into spending patterns, budget allocation, and expense trends.

View Project
on GitHUB

Personal Expenses Report

Efficiently tracks expenditures in key categories like Housing, Food, and Transportation, providing concise insights into financial management.

Personal Expenses Report

A detailed Excel tool analyzing monthly spending across Housing, Food, and Transportation. Offers a clear view of budget allocation.

Project Details

This Excel project offers an insightful glimpse into personal or organizational finances through a meticulously crafted monthly expenses report. Divided into essential categories including Housing, Food, and Transportation, this report provides a comprehensive overview of expenditure patterns and budget management.

The Housing section delineates costs related to rent, mortgage payments, utilities, and maintenance, shedding light on the largest portion of monthly expenses. Meanwhile, the Food category captures expenditures on groceries, dining out, and other culinary expenses, highlighting trends in dietary habits and culinary preferences.

In the Transportation category, costs associated with commuting, vehicle maintenance, and public transportation are meticulously tracked, facilitating analysis of travel expenses and potential cost-saving measures.

PowerBI Project

AtliQ Mart Supply Chain

I led the development of a Power BI dashboard designed to revolutionize our supply chain operations by tracking crucial Key Performance Indicators (KPIs). This tool enabled us to dive deep into our processes, providing real-time insights that were previously

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

AtliQ Mart Supply Chain

Atliq Mart's supply chain management system, designed to optimize operational efficiency and visibility.

AtliQ Mart Supply Chain

This screenshot presents a sophisticated data modeling interface featuring seven meticulously designed tables.

Project Details

Optimizing Supply Chain Efficiency with Power BI

In a strategic initiative to enhance operational visibility and drive cost efficiency within supply chain operations, I developed a tailored Power BI dashboard. This project was aimed at harnessing the power of data analytics to monitor critical Key Performance Indicators (KPIs) in real-time, facilitating swift and informed decision-making processes.
The dashboard provided a granular view of the supply chain's performance, enabling the identification of bottlenecks and inefficiencies. Through detailed analysis, I uncovered opportunities for potential cost savings of up to 20% in expansion investments. This was achieved by leveraging data-driven insights to pinpoint areas where resources could be optimized, leading to more strategic investment decisions.

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis - Chain of Hotels

Utilizing Power BI, I crafted a detailed dashboard for market analysis, uncovering trends and areas for improvement. Insights gleaned led to targeted strategies, projecting a 20% increase in revenue and market share. This proactive approach promises to revitalize business performance.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Hospitality Analysis - Chain of Hotels

The dashboard showcases dynamic visuals, including pie charts for market share distribution, line graphs tracking revenue trends.

Hospitality Analysis - Chain of Hotels

This screenshot presents a sophisticated data modeling interface featuring seven meticulously designed tables.

Project Details

In response to declining market share and revenue, I undertook the initiative to develop a robust Power BI dashboard. This dashboard served as a pivotal tool in dissecting market dynamics and revenue patterns, enabling a deeper understanding of underlying trends.

Through meticulous analysis and visualization of key metrics, actionable insights were unearthed, paving the way for strategic business improvements. By identifying areas of inefficiency and untapped opportunities, the dashboard facilitated informed decision-making processes.

Live Interactive Dashboard

SQL Project

Forecast Accuracy 21 vs 20

Using MySQL and SQL, this project analyzed inventory variations between fiscal years 2020 and 2021. It involved SQL queries, stored procedures, views, and functions to extract, transform, and analyze data, providing actionable insights for inventory management optimization.

View Project
Engagement

View Project
on GitHUB

Forecast Accuracy 21 vs 20

Output report screenshot

Forecast Accuracy 21 vs 20

Output report screenshot

Project Details

The Inventory Forecast Analysis project utilized MySQL and SQL to examine variations between fiscal years 2020 and 2021. Through SQL queries, stored procedures, views, and functions, the project aimed to provide insights into inventory trends and optimize management strategies.

Methodology:

Data Collection: Gathered data on inventory levels, sales figures, and relevant metrics for fiscal years 2020 and 2021 from the database.

Database Design: Designed a MySQL database schema to efficiently store inventory, sales, and product information.

Query Development: Crafted SQL queries to aggregate, transform, and analyze data, focusing on calculating variances and identifying trends.

Stored Procedures: Created procedures to encapsulate complex SQL logic, streamlining repetitive tasks and improving maintainability.

Views: Generated views to provide simplified representations of data subsets, enhancing accessibility without needing detailed knowledge of the database schema.