Hello!

I'm Shaun Mia



Data Analyst | AI Enthusiast

LinkedIn GitHub Resume

View Updated Portfolio

Shaun Mia

Data Analyst|AI Enthusiast

looking for an entry-level Data Analyst role

Mirpur-11, C Block, Dhaka, Bangladesh

Skills

SQL 80%
Power BI 85%
Advance Excel 80%
Python 80%
Machine Learning 80%
Data Visualization 85%
Statistical Analysis 80%

About

About Me

I am Shaun Mia, a dedicated data analyst with a passion for transforming raw data into meaningful insights. I hold a Bachelor's degree in Computer Science & Engineering and have hands-on experience in Excel, Power BI, Python, SQL, and machine learning. My work involves real-life projects, focusing on data visualization, statistical analysis, and dashboard creation. I am a fast learner and an AI enthusiast, always eager to explore new technologies and contribute to innovative solutions. My goal is to leverage my skills to drive data-driven decision-making in a dynamic organization.

  • Profile: Data Science & Analytics
  • Education: B.Sc. in Computer Science & Engineering
    Daffodil International University
  • Language: Bangla, English
  • Programming Languages: : C, C++,Python, HTML & CSS
  • Tools: : Excel, Power BI, SQL, Power Query, & AI Tools
  • Other Skills: Data Analysis, Data Visualization, Data Modeling, DAX, Analytical Thinking, Time Management, &Teamwork
  • Interest: Traveling,Photography, & Cooking

0 +   Projects completed

LinkedIn

Resume

Resume

Aspiring data analyst with a strong foundation in data analysis, visualization, and machine learning. Seeking to leverage technical skills and analytical expertise to drive data-driven insights and support organizational growth. .



Education


2020-2024

B.Sc. in CSE

Daffodil International University
2017-2018

Higher Secondary School

Shaikh Kamal College,Jamalpur

Download CV

View Updated Portfolio

PROJECTS

Projects

Here are sample Data Analytics projects utilizing Excel,Power BI, SQL, Python and Machine Learning (ML).

Power BI Project

Bangladesh Crime Data Analysis 2024

This project analyzes crime data across Bangladesh for 2024, providing insights into crime trends, regional distributions, and seasonal patterns. It leverages interactive visualizations to help inform crime prevention strategies. The dataset includes key crime categories such as theft, narcotics, and women & child repression.

Good Cabs Performance Analysis

The Goodcabs Performance Analysis project focuses on evaluating the company's operations in tier-2 cities across India. By analyzing key metrics like trip volume, passenger satisfaction, and repeat passenger rates, the project aims to provide actionable insights for performance improvement. The analysis is presented through a self-explanatory dashboard and a compelling presentation for the Chief of Operations, including SQL-based reports and additional business insights.

HR Analytics Dashboardd

The HR Analytics Dashboard is designed to provide HR teams with actionable insights into employee performance, satisfaction, demographics, and attrition trends. By integrating SQL-based HR data, this dashboard empowers data-driven decision-making, enabling HR teams to improve organizational performance.

Movies Analytics Dashboard

The Movies Analytics Dashboard is an interactive Power BI dashboard built to provide detailed insights into movie performance, actor demographics, financials, and industry trends. The dashboard leverages data from multiple tables to create a comprehensive view of movies, including performance metrics like revenue, budget, IMDb ratings, and actor contributions. By using DAX calculations and visualizations, this project helps stakeholders in the movie industry make data-driven decisions.

Netflix Data Analysis

This Netflix Data Analysis project provides interactive dashboards using Power BI to explore insights such as content trends, ratings, genre popularity, and regional statistics. It offers a visually engaging and data-driven approach to understanding Netflix's extensive catalog.

Dengue Diagnosis and Blood Parameters Analysis Dashboard

This dashboard provides a detailed analysis of dengue case data, focusing on age demographics, diagnostic trends, and key blood parameters. Designed in Power BI, it includes a series of pages that allow users to explore data through interactive visuals, slicers, and KPIs, making it easier to identify trends and potential risk factors in dengue diagnosis.

US Regional Sales Analysis Dashboard

This project provides a comprehensive analysis of sales performance across different regions in the U.S., using Power BI for data visualization and analysis. The dashboard delivers insights into total sales, profit, costs, and key customer and product metrics, offering decision-makers clear visibility into the business's regional and temporal performance.

Credit Card Financial Analysis

This project is a comprehensive analysis of credit card transactions and customer data, focusing on insights derived from two main perspectives: Transaction Report and Customer Report. The dashboard was created using SQL for data storage and manipulation, and Power BI for data visualization and analysis. The project integrates real-time data updates, calculated measures, and custom columns to provide actionable insights.

E-Commerce Sales Analysis

Developed an interactive Power BI dashboard for e-commerce sales, featuring key KPIs like total sales, profit, and average order value, with visualizations for monthly trends and category insights. The project showcases proficiency in data analysis and visualization, enabling actionable insights for business decision-making

Pizza Sales Report

This pizza sales report highlights top and bottom 5 pizzas by revenue, quantity, and total orders. It includes metrics like total revenue, average order value, total items sold, total orders, and average per order. Visualizations cover total orders by day and month (line charts), revenue by category, pizza size, and total items sold by category.

SQL Project

Consumer Goods Ad-Hoc

This project serves as a comprehensive SQL analysis in the Consumer Goods sector, specifically tailored to answer ad-hoc business requests. Each SQL query provides a focused insight that supports data-driven decisions, from understanding market reach to analyzing product costs and sales trends.

AIRBNB Outlier Detection and EDA

TThe AIRBNB Outlier Detection and EDA project involved analyzing Airbnb listings to identify anomalies in pricing, customer satisfaction, and other metrics.This SQL-based project provided insights through exploratory data analysis, helping to highlight patterns and outliers for better decision-making..

Cohort Analysis Using SQL

This analysis aims to perform cohort analysis on an online retail dataset to track customer purchasing behavior over time. By grouping customers based on their first purchase date, we can assess retention, revenue patterns, and engagement.

Pizza Sales Analysis Using SQL

The goal of this project is to analyze pizza sales data using SQL queries on multiple related tables. This will help reveal trends, revenue, customer preferences, and other key metrics.

RFM Segmentation on Sales Data

This project performs RFM (Recency, Frequency, Monetary) segmentation on sales data to categorize customers based on their purchasing behavior. The RFM model helps identify key customer segments such as Loyal Customers, Potential Churners, and Big Spenders.

Excel Project

HR Attrition Analysis Dashboard

HR Attrition Analysis Dashboard that provides insights into employee turnover trends. The dashboard features data transformation, visualization, and key metrics analysis using Power Query, Pivot Tables, and Excel.

Coffee Shop Sales Dashboard

The Coffee Shop Sales Dashboard offers a detailed analysis of sales performance in a coffee shop, focusing on product categories, sales trends, and customer behavior. This dashboard enables coffee shop owners to optimize their offerings and understand their business dynamics better.

Retail Sale Analysis Dashboard

The Retail Sale Analysis Dashboard evaluates sales performance across various regions, product categories, and time periods. It serves as a vital tool for retail managers to monitor sales trends, identify top-selling products, and make informed decisions.

Python Project

Food Delivery Cost Analysis Using Python

This project, Food Delivery Cost Analysis Using Python, explores the costs, discounts, and profitability within a food delivery dataset. Using Python for data cleaning, transformation, and visualization, the project provides insights into cost distribution, profit margins, and identifies areas for potential cost optimization.

Adult Income Analysis

This project analyzes the Adult Income dataset, examining demographic and employment factors associated with income levels (<=50K or>50K). The goal is to uncover socio-economic patterns and key factors influencing higher income, providing insights for policy-making, HR, and socio-economic research.

Airbnb Listings EDA

This project analyzes New York City's 2024 Airbnb listings, examining pricing, availability, and guest reviews through EDA and geospatial visualization to gain insights into the short-term rental market..

Amazon Rainforest Fire Data Analysis

The Amazon Rainforest Fire Data Analysis project examines forest fire data in Brazil's Amazon from 1998 to 2017, analyzing trends, seasonal patterns, and regional differences to uncover insights for improved fire management and understanding of ecological challenges.

Amazon Sales Analysis

This project involves an in-depth analysis of sales data to uncover insights into customer behavior, product performance, and sales trends. The analysis leverages various visualization techniques to represent data effectively and make informed decisions.

Customer Churn analysis

The Customer Churn Analysis project aims to identify the key factors contributing to customer churn and provide actionable insights to enhance customer retention. The analysis leverages various data science techniques, including exploratory data analysis, feature engineering, and machine learning modeling.

Fake News Detection Using ML

The spread of misinformation through online platforms is a growing concern. Fake news can have a significant negative impact on society, influencing public opinion and even swaying elections. This project aims to develop a machine learning model that can automatically classify news articles as real or fake, aiding users in discerning reliable information.

Google Play Store Apps Data Analysis

The purpose of this analysis is to explore, clean, and analyze the Google Play Store dataset to gain insights into app ratings, categories, reviews, and pricing. This project aims to answer various queries about the dataset and provide statistical insights and visualizations to help understand trends and patterns.

Heart Disease Analysis

This project analyzes a heart disease dataset to identify factors that influence the likelihood of heart disease. Using Python, we explore data patterns, visualize important features, and highlight the relationships between different health indicators.

Netflix & IMDB Data Analysis

This analysis of Netflix data provides insights into the distribution and growth of movies and TV shows on the platform. The project focuses on understanding content expansion by category and country, analyzing target demographics, and identifying the most popular genres and ratings across different regions.

Police Vehicle Checking Analysis

The purpose of this project is to analyze police vehicle stop data to uncover trends and insights, particularly focusing on gender disparities, violation types, search rates, and other factors that may affect the outcome of stops. Using Python for data analysis allows us to perform detailed data cleaning, filtering, grouping, and visualization, helping to understand how various factors influence police stops.

Spotify music analysis

This project explores Spotify's audio data to uncover trends in song popularity, duration, and genre characteristics over time. Through data cleaning, analysis, and visualization, we aim to gain insights into listener preferences and the evolution of music.

0 Achievements
0 Projects

More projects on Github


GitHub View Updated Portfolio

Contact

Contact ME

Below are the details to reach out to me!

Address

Mirpur-11, C Block, Dhaka, Bangladesh

Contact Number

+880 1976133731

Email Address

shaunmia.cse@gmail.com

Download Resume

Resume Link



Have a Question?

Click Here View Updated Portfolio