Based on the files provided, here is a brief description of your project to be told in an interview.
Student Depression Analysis Project
This project involves a comprehensive analysis of student mental health, specifically focusing on
identifying factors contributing to depression. I used SQL to clean and transform the raw data,
performing tasks such as data type conversions, handling missing values, and creating new features
like an age_group column. I also normalized the Gender and Depression columns to ensure
consistency for a more efficient analysis.
Following the data preparation phase, I utilized Tableau to visualize the findings. The dashboard I
created provides insights into the correlation between various factors and depression levels among
students. Key metrics and visualizations include:
Depression rate by gender and age group: Analyzing how depression prevalence varies
across different demographics.
Relationship between depression and academic pressure, study satisfaction, and sleep
duration: Examining the impact of these factors on student mental health.
Correlation with lifestyle factors: Investigating the influence of dietary habits, study hours,
and financial stress.
Impact of family history and suicidal thoughts: Exploring the link between these critical
indicators and depression.
This project demonstrates my proficiency in the entire data analysis pipeline, from data cleaning and
manipulation using SQL to data visualization and insight generation using Tableau. The ultimate
goal was to uncover actionable insights that could help educational institutions and health
professionals better understand and address student depression.
Based on the files provided, here is a brief description of your project to be told in an interview.
SuperStore Sales Analysis Project
This project focuses on a comprehensive analysis of sales data for a SuperStore. The main objective
was to extract key business insights from the raw dataset to inform strategic decisions.
I used Power BI to clean, model, and visualize the data. The process involved:
Data Cleaning: I addressed data inconsistencies and prepared the dataset for analysis.
Data Modeling: I created relationships between different tables (if any) to ensure a robust
data model.
DAX Measures: I wrote DAX (Data Analysis Expressions) formulas to calculate key metrics,
such as sales over time, profitability, and return rates.
The resulting Power BI dashboard provides a detailed, interactive view of the SuperStore's
performance, highlighting important trends and patterns. The visualizations include:
Sales and Profit Analysis: Tracking sales and profit over time to identify seasonal trends and
performance highs and lows.
Geographic Breakdown: Visualizing sales performance by region and state to understand
which areas are most profitable.
Product Performance: Analyzing sales and profit by product category and sub-category to
identify top-selling and low-performing items.
Customer Segmentation: Reviewing sales data by customer segment (e.g., Consumer,
Corporate) to tailor marketing strategies.
This project showcases my ability to handle the entire business intelligence workflow, from data
preparation to building an interactive dashboard that provides actionable insights for business
stakeholders
Based on the files provided, here is a brief description of your project to be told in an interview.
Coffee Shop Sales Analysis
This project involves a detailed analysis of a coffee shop's sales data to identify key performance
drivers and provide actionable business insights. The primary goal was to transform raw transaction
data into a clear and informative dashboard.
My process included:
Data Preparation: I cleaned and structured the raw sales data, which included transactions,
product details, and store locations. I extracted key information like the day of the week and
hour of the day from timestamps to analyze sales patterns.
Data Analysis: I used pivot tables and other analytical methods to aggregate data and
calculate key metrics such as total sales, transaction count, and quantity sold. This allowed
me to break down performance by categories like product type, time of day, and store
location.
Visualization: I created a dashboard to present the findings visually. The dashboard
highlights important trends, such as:
o Daily and hourly sales patterns: Identifying peak hours and days for sales.
o Top-performing products and categories: Pinpointing the most popular items.
o Sales distribution across different store locations: Comparing the performance of
each store.
This project demonstrates my ability to work with real-world business data, from initial cleaning and
analysis to creating insightful and visually compelling reports that can help a business make
informed decisions.
