Nandish C

Data Professional

[email protected] +91 9380350611

Resume

Hello, I am

Nandish C.

4

PowerBI
Projects

About Me

Welcome to my portfolio! I am a dedicated data analyst with one year of experience in using Excel, Power BI, SQL, and Python to uncover insights from data. While I hold a Master's degree in Data Science, my real strength lies in my natural ability to analyze data and transform it into actionable strategies.

Over the past year, I have worked as a data analyst, honing my skills and applying my knowledge to real-world business challenges. My portfolio showcases a variety of projects where I’ve demonstrated my capability to turn complex data into practical solutions, communicating findings in a clear and effective manner.

Eager to continue learning and passionate about leveraging data to drive informed decisions, I'm excited to contribute further to the field of data analytics. Explore my portfolio to see how I blend academic knowledge with hands-on experience to deliver impactful results.

Key Skills

Python

SQL

SSRS

My Projects

Business Insights 360

Domain/Function: Business360

IPL Players Analysis

Domain/Function: Sports

Blinkit Sales Analysis

Domain/Function: Retail

Nike Shoes Analysis

Domain/Function: Retail

My Experience

May 2023 - PRESENT
Sumathi Health Care Pvt Ltd (AVM Labs), Bangalore – Data Analyst

● Developed and maintained customized reports and dashboards in Power BI using SQL, to enhance strategic planning and informed decision-making, directly impacting organizational effectiveness.

● Automated SSRS report distribution via email, significantly reducing manual effort and providing stakeholders with timely insights into business performance, aiding data-driven decisions.

● Enhanced database efficiency and speed by optimizing SQL queries, creating stored procedures, and employing advanced Excel functions (XLOOKUP, VLOOKUP), leading to faster data analysis and improved decision-making across the company.

● Managed end-to-end data workflows, leveraging Power Query for transformation, optimizing data models, and deploying reports through Power BI services, resulting in superior report performance and data integrity across the organization.

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.

Mail Me

[email protected]

https://www.linkedin.com/in/nandish-c-615414230/

Call Me

+91 9380350611

PowerBI Project

Business Insights 360

Domain/Function: Business360

Business Insights 360 is a powerful dashboard created using Microsoft Power BI. This multi-functional dashboard has been customized to provide AtliQ Hardware with valuable insights into their different departments such as Finance, Sales, Marketing and Supply Chain.

The finance page in the Business 360 Power BI dashboard provides a snapshot of key financial metrics, including revenue, expenses, and profit margins.

The supply chain page in the Business 360 Power BI dashboard offers insights into the entire supply chain process, from inventory levels to supplier p

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

IPL Players Analysis

Domain/Function: Sports

I developed an IPL Player Analysis Dashboard in Power BI, showcasing key player metrics like runs, wickets, and strike rates. The dashboard features interactive filters and visualizations, enabling easy comparison of players and providing actionable insights for data-driven decisions.

Designed a 'Strongest Playing XI' page to select and visualize the best-performing players across roles, enhancing team selection strategi

Developed a 'Top Order Analysis' page to evaluate openers and key top-order batsmen, focusing on metrics like runs, strike rate, and consistency.

Project Details

The IPL Player Analysis Dashboard was created to provide comprehensive insights into player performances across different roles, aiding in informed decision-making. The dashboard features dedicated pages for openers, middle order, all-rounders, spinners, and fast bowlers, with a final page for selecting the best playing XI. The project focused on advanced data modeling, role-specific analysis, and interactive visualizations, allowing stakeholders to drill down into detailed metrics and compare player performances.

Key Learnings:

1. Power Query for data transformation
2. Complex DAX formulas for performance metrics
3. Multi-table data modeling
4. Role-specific visualization selection
5. User-centric dashboard design
6. Feedback integration from cricket analysts
7. Deployment in Power BI Service
8. Analysis of cricket metrics for data-driven decisions

Live Interactive Dashboard

PowerBI Project

Blinkit Sales Analysis

Domain/Function: Retail

Developed a Blinkit Sales Analysis Dashboard to analyze sales data across various metrics, including sales volume, location performance, and outlet details. The dashboard provides insights into trends, compares performance across regions, and supports strategic decision-making for sales and marketin

Developed a Blinkit Sales Analysis Dashboard to analyze sales data across various metrics, including sales volume, location performance, and outlet de

Project Details

The Blinkit Sales Analysis Dashboard was created to provide a comprehensive view of sales performance across different dimensions. This dashboard analyzes sales data by location, outlet, and other key metrics to support strategic decision-making. It includes features like visualizations of sales trends, comparisons between different regions, and insights into outlet performance and establishment years.

Key Learnings:

1. Advanced data visualization techniques in Power BI
2. Integration and transformation of complex datasets
3. Effective dashboard design for user engagement
4. Insights into retail and logistics metrics for business strategy

Live Interactive Dashboard

PowerBI Project

Nike Shoes Analysis

Domain/Function: Retail

Created a Nike Shoes Analysis Dashboard to evaluate sales performance, inventory levels, and customer preferences for Nike footwear. The dashboard features visualizations of sales trends, product popularity, and regional performance, aiding in strategic decision-making and inventory management.

Built a Nike Shoes Analysis Dashboard to track sales trends, inventory levels, and customer preferences, offering insights for better decision-making.

Project Details

The Nike Shoes Analysis Dashboard was designed to offer a comprehensive view of Nike footwear sales and inventory performance. This dashboard integrates various data sources to provide insights into sales trends, inventory levels, and customer preferences.

Key Learnings:

1. Advanced data visualization techniques for consumer goods
2. Integration of sales and inventory data for comprehensive analysis
3. Effective dashboard design to enhance user engagement and decision-making
4. Analysis of market trends and customer behavior for strategic planning