Powered by
Codebasics DA Bootcamp

Tapas Kumar Nayak

Data Analyst

[email protected]

Resume

Hello, I am

Tapas Kumar Nayak.

1

Excel Project

3

PowerBI Projects

About Me

I’m Tapas Kumar Nayak, an aspiring Data Analyst with a strong foundation in data analysis and a passion for turning data into actionable insights. I hold a Master’s in Computer Application, specializing in Data Science and Machine Learning, where I discovered my natural talent for working with data. My skills in Excel, Power BI, SQL, and Python allow me to analyze complex data sets and create visualizations that drive smart decision-making. While I may not have formal industry experience yet, I’ve completed several hands-on business projects showcased below, where I applied my skills to solve real-world problems. Each project demonstrates my ability to explore data, uncover trends, and deliver insights that add value. I’m eager to bring my analytical skills and dedication to a dynamic team, where I can contribute to data-driven success and continue growing as a data analyst.

Key Skills

Excel

Power BI

SQL

Python

Effective Communication

Stakeholder Management

My Projects

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/techytapas/

https://github.com/techytapas23

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

Created two detailed reports for the sales team, enabling them to evaluate customer performance and gain valuable insights into market trends, helping them align their strategies with target goals.

View Project
Engagement

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics(FMCG)

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I designed a comprehensive sales report using Excel pivot tables to help businesses make data-driven decisions on customer discounts, improve negotiations, and spot opportunities for expansion in high-potential markets. The generated reports deliver actionable insights that guide businesses in optimizing their sales strategies, increasing customer satisfaction, and driving revenue growth.

Through this project, I gained valuable skills, including:

Pivot Tables
Power Query
Basic DAX
Conditional Formatting
Report Design and Formatting
Sales Domain Metrics
My goal with this project was to equip businesses with the tools and insights they need to effectively monitor and improve sales performance. By analyzing sales data, businesses can uncover new opportunities, foster growth, and remain competitive in a constantly evolving market.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: FMCG

AtliQ Hardwares, a fast-growing consumer electronics company, is facing challenges in competing with other industry players who leverage data effectively. Currently, most of their reporting remains in Excel. My objective is to implement a robust analytics solution using Power BI, providing the comp

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modelling involving 10+ tables

Project Details

In this project, the objective was to create a unified report accessible by stakeholders from sales, marketing, finance, and the executive team. The primary focus was on:

Developing robust data models
Designing user-friendly, intuitive reports
Providing drillable insights for deeper analysis
Throughout the project, I gained hands-on experience in the following areas:

Power Query (basic and advanced techniques)
Basic and complex DAX formulas
Data modeling across 10+ tables
Selecting appropriate visuals and applying effective formatting
Dashboard design best practices
Using bookmarks for enhanced interactivity
Publishing reports on Power BI service
Incorporating stakeholder feedback into the design
Understanding key metrics in sales, marketing, finance, and supply chain
This project was a valuable learning experience, honing my technical skills in Power BI and improving my ability to deliver actionable insights across multiple business functions.

Live Interactive Dashboard

PowerBI Project

Personal Expense Tracking Dashboard

Domain/Function: Personal Finance

This Power BI dashboard tracks personal expenses over three months (Jan–Mar 2025), providing insights into spending patterns, payment methods, and major expense categories. It features interactive visuals, KPIs, filters, and comparative analysis, making expense tracking easy and insightful. 🚀

View Project
Engagement

View Project
on GitHUB

Personal Expense Tracking Dashboard

This is the Data model view of the project.

Personal Expense Tracking Dashboard

This is the Dashboard View of the project

Project Details

The Personal Expense Tracking Dashboard is a Power BI project designed to analyze and visualize daily expenses over three months (Jan–Mar 2025). It provides key insights into spending habits, major expense categories, and preferred payment methods.

The dashboard includes interactive visualizations such as bar charts for category-wise spending, pie charts for payment distribution, and stacked area charts for monthly trends. Key Performance Indicators (KPIs) track total spending, daily average expenses, and the highest spending category. Users can apply filters for date, category, payment method, and UPI apps to explore their financial data in detail.

This project involves data cleaning and transformation to ensure accuracy, with custom columns for deeper analysis. Future enhancements may include budget tracking, forecasting models, and overspending alerts. Built for learning and fun, this dashboard offers a data-driven approach to managing personal finances efficiently. 🚀

Live Interactive Dashboard

PowerBI Project

E-commerce Sales Analysis: Myntra Dataset

Domain/Function: E-commerce Analytics

This Power BI project analyzes Myntra's sales data, providing insights into sales trends, customer behavior, and product performance. It features interactive dashboards, KPIs, and filters to explore revenue, discounts, and top-selling brands, helping businesses make data-driven decisions. 🚀

View Project
Engagement

View Project
on GitHUB

E-commerce Sales Analysis: Myntra Dataset

This is the Dashboard of Myntra Sales data Analysis

E-commerce Sales Analysis: Myntra Dataset

This is the Data model view of the project

Project Details

E-commerce Sales Analysis: Myntra Dataset is a Power BI project designed to analyze Myntra’s sales performance, customer behavior, and product trends. Using an interactive dashboard, it provides insights into total sales, revenue distribution, and the impact of discounts on purchases.

The project includes data modeling, DAX calculations, and filters to explore data by brand, category, and time period. Key visualizations include bar charts for revenue by brand, donut charts for category distribution, and ribbon charts for year-over-year sales trends.

Users can analyze top-selling products, seasonal trends, and geographical sales distribution to gain valuable business insights. Future enhancements may include predictive analytics and customer segmentation to refine marketing strategies. This project showcases the power of data-driven decision-making in the e-commerce industry. 🚀

Live Interactive Dashboard