Portfolio - Vishwash Chauhan

Hello, I am

Vishwash Chauhan

Data Aspirant

About Me.

Driven and analytical, I'm an aspiring Data Analyst eager to leverage my strong foundation in Excel, Power BI, SQL, and Python to extract meaningful insights and drive data-informed decisions. My Bachelor's in Commerce has equipped me with a robust business acumen, allowing me to understand data within a broader strategic context. While I'm new to formal organizational experience, my portfolio showcases several business projects where I've successfully applied these skills to deliver tangible results. Explore my work below to see how I can contribute to your team's success.

1

Excel Project

2

PowerBI Projects

1

SQL Project

Skills.

Exel

Power BI

SQL

DBMS

Python

Communication Skills

Statistics

Analytical Skills

Projects.

Awards & Certificate.

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Contact.

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.

Download CV

[email protected]

Call Me

+91 8894036700

https://www.linkedin.com/in/vishwash-chauhan-2bb1591b2/

GitHub

https://github.com/Vishwash-chauhan

PowerBI Project

Business Insights 360

Domain/Function: Business Insights

Implementing Power BI for AtliQ Hardware enables advanced analytics, transforming Excel data into actionable insights for informed decision-making, empowering rapid expansion and competitive edge in the consumer electronics market.

View Project
Engagement

View Project
on GitHUB

The user-empathetic landing page briefly describes the various views in the report and includes an information and support page.

Data modelling involving 10+ tables. Used snowflake schema for data modeling.

Project Details

𝗧𝗵𝗲 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲: AtliQ Technologies, an electronics firm, needed to move beyond Excel-based data analysis. 😓

𝗧𝗵𝗲 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻: Developed a Power BI solution to extract key insights from over 1 million records for Finance, Sales, Marketing, Supply Chain, and Executive stakeholders. ✨

𝗞𝗲𝘆 𝗧𝗲𝗰𝗵𝗻𝗼𝗹𝗼𝗴𝗶𝗲𝘀 & 𝗧𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀:

⭐Power BI Desktop
⭐SQL
⭐Excel
⭐DAX Studio
⭐Data ETL
⭐Transformation (Power Query)
⭐DAX Measures
⭐Calculated Columns
⭐KPI Indicators
⭐Dynamic Titles
⭐Bookmarks
⭐Toggle Buttons
⭐Conditional Formatting
⭐File Optimization
⭐Data Validation
⭐Publishing to Power BI Services ☁️

𝐒𝐍𝐎𝐖𝐅𝐋𝐀𝐊𝐄 𝐒𝐂𝐇𝐄𝐌𝐀❄ was implemented for data modelling.

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights

Domain/Function: Consumer Goods

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

View Project
on Canva

Visual representation of the various locations of AtliQ Executive Stores within the APAC region.

Comparing sales data across the years to determine the highest and lowest performing months.

Project Details

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task:
I reviewed 'ad-hoc-requests.pdf' with 10 business queries.
Crafted and executed SQL queries.
Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Employed Power BI for impactful visualizations. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and communication skills.

PowerBI Project

Hospitality Insights

Domain/Function: Hospitality

𝗜 𝗿𝗲𝗰𝗲𝗻𝘁𝗹𝘆 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲𝗱 𝗮𝗻 𝗲𝘅𝗰𝗶𝘁𝗶𝗻𝗴 𝗵𝗼𝘀𝗽𝗶𝘁𝗮𝗹𝗶𝘁𝘆 𝗱𝗮𝘁𝗮 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝘄𝗵𝗲𝗿𝗲 𝗜 𝗯𝘂𝗶𝗹𝘁 𝗮 𝗰𝗼𝗺𝗽𝗿𝗲𝗵𝗲𝗻𝘀𝗶𝘃𝗲 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗳𝗼𝗿 𝗮 𝗵𝗼𝘁𝗲𝗹 𝗰𝗵𝗮𝗶𝗻. 📈 This involved meticulously cleaning and analyzing approximately 135,000 bookings

View Project
Engagement

View Project
on GitHUB

The dashboard features various KPIs, filters, and charts, enabling users to easily navigate and access desired information.

Semantic Model, of the data consiting of 5 tables, in star schema, consiting of fact tables and dimention tables.

Project Details

This involved meticulously cleaning and analyzing approximately 135,000 bookings from 25 hotels, structuring the data across 5 tables in a star schema (fact bookings and various dimension tables) to extract meaningful insights. 💡

During this project, I learned:

How to handle and clean large datasets, specifically around 135,000 booking records. 📊

The practical application of star schema design for efficient data analysis in a real-world scenario. 🌟

𝗗𝗲𝗲𝗽 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗶𝗻𝘁𝗼 𝗸𝗲𝘆 𝗵𝗼𝘀𝗽𝗶𝘁𝗮𝗹𝗶𝘁𝘆 𝗺𝗲𝘁𝗿𝗶𝗰𝘀 𝘀𝘂𝗰𝗵 𝗮𝘀: 🏨

RevPAR (Revenue Per Available Room)

DSRN (Daily Sellable Room Nights)

ADR (Average Daily Rate)

Live Interactive Dashboard

Excel Project

Excel Sales And Finance Analytics

Domain/Function: Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

View Project
on

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

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

Project Details

This project involved developing a sales analysis dashboard using Excel pivot tables and Power Query. The resulting reports provide businesses with actionable insights to optimize customer discount strategies, inform customer negotiations, and identify high-potential markets for expansion. By leveraging these reports, businesses can enhance sales strategies, improve customer satisfaction, and drive revenue growth.

Key skills demonstrated include: Pivot Tables, Power Query, basic DAX, Conditional Formatting, report design, and understanding of sales domain metrics.

Ultimately, this project equips businesses with the tools to effectively monitor, analyze, and improve their sales performance, enabling them to capitalize on opportunities and maintain a competitive edge.