Welcome! Let’s uncover stories hidden in data
Embedded Files
I'm Sugandha saini
I'm Sugandha saini
A B.Tech Computer Science student and an aspiring Data Analyst with hands-on experience in Python, SQL, Excel, Power BI, and Machine Learning. I have worked on 15+ projects involving data cleaning, exploratory data analysis (EDA), dashboard development, and beginner-level ML applications. Passionate about transforming raw data into clear, story-driven insights, I enjoy building solutions that support smarter decision-making.
Core Skills
Core Skills
Analytics & BI: Power BI, Excel, Tableau (basic), DAX
Programming: Python (Pandas, NumPy, Scikit-learn), Jupyter
SQL: Joins, CTEs, Subqueries, Aggregations, MySQL
ML (keyword): EDA, feature engineering, regression/classification
AI Tools: ChatGPT, Gemini(summaries )
Data Viz & KPIs: Dashboarding, storytelling, metrics tracking
Projects
Projects
I’ve explored data through 15+ projects using Python, SQL, Power BI, Excel, and a touch of machine learning. A few of my favorites are highlighted below, and you’re always welcome to check out more of my journey on LinkedIn.
Customer Churn Prediction
Built ML models (logistic regression & random forest) to predict customer churn using Python. Created a Power BI dashboard to highlight high-risk customers.
Hotel Booking Analysis
Analyzed hotel booking trends, seasonal demand, and cancellations using Python & Power BI. Delivered insights into guest demographics and revenue optimization.
Automated Customer Feedback
Automated customer feedback collection and sentiment analysis using Power Automate, Excel, and Power BI. Reduced response delays by 35% with real-time alerts.
Global Layoffs Analysis (SQL EDA)
Cleaned and analyzed layoff data from 1,200+ companies using SQL. Visualized layoffs across industries, geography, and funding stage in Power BI.
Sales Insight Dashboard
Designed an end-to-end BI solution with SQL-based ETL, star schema modeling, and Power BI dashboards to track sales growth and top customers.
Brew & Bloom Café Dashboard
Analyzed café sales data to uncover peak hours, customer preferences, and product performance using interactive Power BI dashboards.
Experience
Experience
Business Analytics Intern — Cognifyz Technologies | Remote | Jun–Jul 2025
Business Analytics Intern — Cognifyz Technologies | Remote | Jun–Jul 2025
Worked on analyzing survey and business datasets using SQL & Python to identify patterns and customer journey insights. Supporting the creation of Power BI dashboards to automate reporting and improve decision-making efficiency. Gaining hands-on experience in applying data analytics techniques to real-world business problems.
Freelance Data Analyst — T’Qila Restaurant | Dehradun | Aug 2025 – Present
Freelance Data Analyst — T’Qila Restaurant | Dehradun | Aug 2025 – Present
Currently working on a freelance project inspired by my project Brew & Bloom, focused on analyzing café sales trends, optimizing the menu, and creating interactive dashboards. The work involves identifying peak hours and busy days, tracking product performance, and delivering insights to support data-driven decision-making.
Let’s Connect!
Let’s Connect!
Page updated
Google Sites
Report abuse