Welcome to my data portfolio! Here, I document a summary of my projects in the data field.
Hi, I'm Varun Rana! I'm a Data Analyst with a background in Computer Science and professional experience transforming raw data into actionable business insights. I enjoy solving real-world business problems using data and have built a strong foundation in SQL, Python, Power BI, Tableau, Excel, and data visualization.
In my current role as a Research Analyst at Highspring LLC, I've designed automated reporting solutions, built interactive dashboards, analyzed large datasets, and developed workflow automation tools that reduced manual reporting efforts by over 55%. I've also evaluated thousands of AI-generated responses, performed root cause analysis, and collaborated with cross-functional teams to improve data quality, reporting accuracy, and operational efficiency.
Beyond my professional experience, I enjoy working on end-to-end analytics projects that involve data cleaning, exploratory data analysis, dashboard development, and business intelligence. I'm passionate about continuously learning new technologies, improving my analytical skills, and using data-driven insights to help organizations make better decisions.
Whether working independently or collaborating with a team, I'm driven by curiosity, problem-solving, and the opportunity to turn complex data into meaningful, impactful solutions.
My CV in pdf.
| Project Link | Area of Analysis | Project Description |
|---|---|---|
| 💡 Data Analyst Job Market Analysis | SQL, PostgreSQL, Data Analysis, Data Visualization, Data Cleaning | This project analyzes the data analyst job market in India using SQL to uncover top-paying jobs, in-demand skills, salary trends, and the most valuable skills to learn. It demonstrates advanced SQL techniques including CTEs, JOINs, aggregations, and analytical queries to generate actionable insights from real-world job posting data. |
| 🍽️ Restaurant Sales Analysis Using SQL | SQL Server, SQL, Data Analysis, Data Visualization | This project analyzes restaurant sales, customer behavior, revenue trends, and menu performance using SQL. It demonstrates advanced SQL techniques including JOINs, CTEs, aggregate functions, and business-focused analytical queries to uncover actionable insights from real-world transactional restaurant data. |
| Project Link | Tool | Project Description | Dashboard |
|---|---|---|---|
| 📊 E-Commerce Return Analysis Dashboard | Power BI, DAX, Power Query, Excel | An interactive Power BI dashboard that analyzes 100,000+ e-commerce orders to identify return trends, revenue loss, customer behavior, product performance, and operational inefficiencies. Showcases data cleaning, star schema modeling, DAX measures, KPI development, and business intelligence to deliver actionable insights for reducing product returns. | Dashboard |
| 📊 Blinkit Sales Analysis Dashboard | Power BI, SQL, DAX, Power Query, Excel | An interactive Power BI dashboard that analyzes Blinkit sales data to uncover revenue trends, customer purchasing behavior, product performance, and outlet-wise insights. Demonstrates expertise in data cleaning, data modeling, DAX calculations, KPI development, and business intelligence through dynamic visualizations and actionable business insights. | Dashboard |
| Project Link | Area | Project Description | Libraries |
|---|---|---|---|
| ⛽️ Fuel Economy | Data Wrangling & EDA | Analysis on vehicles’ fuel economy in 2008 and 2018 to understand usage of alternative sources of fuel, changes in greenhouse gas and smog ratings over the decade, and vehicle features associated with better fuel economy. | pandas, matplotlib |
| 🌤 Explore Weather Trends | Time-series analysis | In this time-series analysis, I use moving average method to analyze local and global temperature data and compare the temperature trends where I live to overall global temperature trends. | pandas, matplotlib |
- LinkedIn: @tvarunranahere
- Email: varunranapro@gmail.com