

- Location
- Hamilton, Ontario, Canada
- Bio
-
I am a motivated and detail-oriented with a strong interest in data analysis, project management, and problem-solving. Currently pursuing continuing education at McMaster University, I bring a background in healthcare and a growing skill set in tools such as Excel, SQL, PowerBI, Tableau, and Python. I thrive in collaborative environments, enjoy tackling real-world challenges. My goal is to gain hands-on experience, expand my professional network, and contribute meaningfully to team-based projects that drive innovation and value.
- Resume
- Krupa pandya F.pdf
- Portals
-
-
Vancouver, British Columbia, Canada
-
- Categories
- Data analysis Data modelling Data visualization Healthcare Public health
Skills
Socials
Latest feedback
Individual endorsement
Learner feedback



Individual endorsement
Learner feedback


Achievements



Recent projects
Work experience
Data Analyst
Magnus Analytica
October 2024 - Current
β’ Analyzed group benefits using SQL and Excel to generate insights and support client presentations. Collaborated with internal team
members and external advisors to translate business needs into analytical outputs.
β’ Analyzed complex datasets to inform business decisions for clients, employing Python and SQL to identify trends that led to a 15% increase in
campaign effectiveness.
β’ Built and maintained KPI dashboards using Power BI to enhance stakeholder reporting visibility.
β’ Implemented data-driven collaboration initiatives, increasing campaign outcome measurability by 20%.
Education
Psle certification, Data Analysis
McMaster University
May 2025 - July 2025
Post bachelor, Physiotherapy
RK University, India
October 2017 - March 2022
Personal projects
Amazon Sales Performance Analysis- E-commerce Analytics in Power BI
https://app.powerbi.com/groups/me/reports/b9612f4d-97a1-44e6-b3b8-7b269575953a/234ce185959dfd97edbd?experience=power-bi&clientSideAuth=0β’ Challenge- An e-commerce business was struggling with visibility into its product performance, customer trends, and profit margins across multiple categories and geographies.
β’ Approach: I developed an interactive Power BI dashboard using Amazon sales data, integrating multiple KPIs to uncover patterns in customer purchasing behavior, seasonal trends, and category profitability. The data was cleaned, normalized, and modeled for efficiency.
β’ Solutions and Insights:
ο§ Identified high-return but low-profit products, suggesting price optimization strategies and promotional revaluation.
ο§ Analyzed customer segments and top-selling regions, supporting targeted marketing and regional supply chain improvements.
ο§ Integrated trend lines, custom tooltips, and dynamic visuals to allow business managers to simulate scenarios and filter insights by time, region, and product type.
β’ Impact- Helped stakeholders improve inventory planning, campaign effectiveness, and pricing strategies, potentially increasing revenue and reducing unsold stock.
Sleep Quality Analysis Dashboard- Health and Lifestyle Data Analysis
https://app.powerbi.com/groups/me/reports/4d2e0ca2-ef08-4403-a362-ca012d706bc4/5adf30415f398d2d8e77?experience=power-bi&clientSideAuth=0β’ Challenge- Users tracking their sleep patterns through wearable devices lacked clear feedback on how lifestyle habits impacted their sleep quality.
β’ Approach- I built a detailed Power BI dashboard analyzing factors such as sleep duration, quality score, screen time before bed, caffeine intake, and physical activity. I performed data cleaning and created calculated measures to capture correlations and track improvement over time.
β’ Solutions and Insights:
ο§ Found a strong negative correlation between screen time and sleep quality, supporting behavioral change suggestions.
ο§ Identified patterns in weekend vs. weekday sleep habits, enabling users to set realistic improvement goals.
ο§ Created intuitive visuals to present health insights clearly, including a "Sleep Consistency Score" and a personalized progress tracker.
β’ Impact- Enabled individuals to visualize and improve their sleep hygiene, while offering a template that could support wellness programs or digital health applications.
Border Crossing Analysis Dashboard- US/ CANADA/ MEXICO
https://app.powerbi.com/groups/me/reports/4ea53136-8d59-4675-a093-301a3e154c8b/ad75b6f51ce04c08db31?experience=power-bi&clientSideAuth=0β’ Challenge- U.S. border authorities were facing inefficiencies in managing port operations, with frequent bottlenecks at high-traffic ports and underutilized staff at others.
β’ Approach- I analyzed historical border crossing data across land ports using Power BI, focusing on entry volume by vehicle type, date, and location. I cleaned and transformed the data using Power Query, creating a well- structured star schema for optimal performance.
β’ Solutions and Insights:
ο§ Identified peak crossing times and seasonal spikes, recommending data-backed staff reallocation to reduce waiting times.
ο§ Highlighted underutilized ports through traffic comparisons, enabling potential rerouting strategies or infrastructure planning.
ο§ Created an interactive dashboard with slicers, time filters, and drill-through reports for operational managers to track trends in real time.
ο§ Impact- My solution supported improved decision-making for border authorities, promoting efficient resource allocation, reduced congestion, and a better traveler experience.