Sarthak Bora
Transforming raw data into actionable insights through advanced analytics, visualization, and machine learning
Projects Completed
Technical Skills
Actionable Insights
Tools Mastered
About Me
Passionate about turning data into decisions
👋 Who I Am
I'm a data analyst who enjoys transforming raw, messy data into clear insights that support smarter decisions. I work across data cleaning, exploratory data analysis, and visualization, using tools like Python, SQL, and BI platforms. My approach focuses on understanding the story behind the data and communicating insights in a clear, actionable way.
Personal Usage: Preferred Learning Platforms
AI Tools · Online Edtech Platforms · Books / Guides · YouTube · LeetCode / HackerRank
🧠How I Approach Data Problems
My analytical workflow and decision-making process
- • Start by understanding the business goal behind the data
- • Clean and validate data to ensure accuracy
- • Explore trends and patterns through EDA
- • Apply statistical or ML techniques when relevant
- • Present insights in a clear, business-friendly format
Technical Arsenal
Tools and technologies I work with daily
Programming Languages
Data & Analytics Tools
Core Competencies
Featured Projects
Real-world data challenges solved with measurable impact
Retail Sales Analysis
Comprehensive sales analysis revealing revenue patterns and category performance
What I Did
- • Cleaned and transformed 10,000+ sales records
- • Built interactive Power BI dashboards
- • Analyzed category-wise revenue trends
- • Identified seasonal demand patterns
Key Insights
Discovered top 3 categories generating 67% of revenue. Identified Q4 sales spike of 34%, enabling optimized inventory planning and 15% reduction in stockouts.
BikeDekho Sales Analysis
Customer behavior analysis for strategic marketing decisions
What I Did
- • Processed 5,000+ customer purchase records
- • Performed demographic segmentation analysis
- • Created gender-based buying behavior insights
- • Built Excel dashboard with pivot tables
Key Insights
Revealed 58% male vs 42% female customer split with distinct price preferences. Found age group 25-34 accounts for 45% of purchases, enabling targeted marketing campaigns that increased conversion by 22%.
Data Cleaning in SQL
Advanced SQL techniques for data quality and query optimization
What I Did
- • Cleaned 50,000+ row housing dataset
- • Removed duplicates and handled null values
- • Standardized date formats and addresses
- • Optimized complex JOIN queries
Key Insights
Improved query performance by 65% through indexing and optimization. Uncovered 2,300+ duplicate records (4.6% of data) affecting report accuracy. Created reusable SQL procedures for ongoing data quality maintenance.
Market Trend Analysis
Time series analysis of market trends with visualization showing seasonal patterns and forecasting future demand.
Customer Segmentation
K-means clustering algorithm to segment customers into distinct groups for targeted marketing strategies.
Professional Journey
My data analytics career path
Seeking Data Analyst Role
Full-time / Contract / Freelance
Actively seeking opportunities to apply my data analysis skills in a dynamic team environment. Open to roles in business intelligence, data analytics, or data science.
Data Analytics Intern
Labmentix
Assisted in data collection, cleaning, and analysis across multiple projects. Created visualizations and reports to support business decisions. Gained hands-on experience with industry-standard tools including Python, SQL, and Power BI.
Certifications & Training
Self-paced Learning & Professional Development
Completed comprehensive courses in Python, SQL, Artificial Intelligence Fundamentals, and Data Visualization. Built portfolio projects demonstrating practical skills in data analysis and business intelligence.
Certifications
Professional credentials and continuous learning
Let's Connect
Have a project or opportunity? Let's discuss!