Saurabh Tiwari

Data Aspirant

[email protected] +91 9907204699

Resume

Hello, I am

Saurabh Tiwari.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

I’m an aspiring data analyst with expertise in Power BI, SQL, MySQL, Excel. My Information Technology Engineering background led me to discover a deep passion for data analytics. Although I lack formal technical work experience, my internships and projects have allowed me to apply my skills effectively, solving real-world data challenges and delivering valuable insights.

I’ve created dynamic dashboards, built predictive models, and performed detailed analyses, showcasing my ability to turn complex data into actionable strategies. My portfolio reflects these achievements and my commitment to excellence.

With a strong work ethic and enthusiasm for data, I thrive on problem-solving and continuous learning. I’m excited to contribute my skills and passion to a team, driving impactful data-driven decisions and innovative solutions.

Key Skills

MYSQL

SQL

Stakeholder Management

My Projects

Finance and Sales Analytics

Domain/Function: Manufacturing

AtliQ Hotel : Hospitality Analysis

Domain/Function: Hospitality

Consumer Goods Ad-hoc Requests

Domain/Function: Consumer Goods

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/saurabh-tiwari-436a373b/

Call Me

+91 9907204699

Excel Project

Finance and Sales Analytics

Domain/Function: Manufacturing

Developed 2 reports, through data analysis which will help the business heads to understand their customer and market overall financial and sales performance.

View Project
Engagement

This report shows the Net sales Performance of the customers Year over Year and the change percentage between 2021vs2020.

This report shows the P&L report of the markets highlighting key metrics like Net Sales, COGS, Gross Margin, Gross Margin%

Project Details

I developed comprehensive Profit and Loss (P&L) and Sales reports for AtliQ Hardwares, providing critical insights into the company's financial and sales performance. The P&L reports illustrate revenues, costs, and profits over specific periods, enabling the company to identify the most profitable products, control expenses, and make informed decisions to enhance profitability. The Sales reports offer detailed insights into sales activities, highlighting trends, product performance, and regional distribution. These reports help AtliQ Hardwares understand customer preferences, track sales targets, and devise strategies to boost sales in specific areas or for particular products.

Things I Learned Doing This Project:
ETL (Extract, Transform, Load)
Power Query
Data Modeling
DAX (Data Analysis Expressions)
Pivot Table
Conditional Formatting
This project not only honed my technical skills but also deepened my understanding of how data-driven insights can drive business success

PowerBI Project

AtliQ Hotel : Hospitality Analysis

Domain/Function: Hospitality

This project exemplifies the transformative power of data in the hospitality industry by analyzing critical metrics such as Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, and DSRN, offering actionable insights for improved performance and decision-making.

View Project
Engagement

Other Tools

Excel

This dashboard is based on the mockup provided by AtliQ, with two additional views added.

This is an another page, providing key metrics by property and view insights through some filters categories.

Project Details

AtliQ Grands, a distinguished chain of five-star hotels with a 20-year legacy in India, faces challenges in market share and revenue within the luxury and business segments due to competitive pressures and management inefficiencies. To counteract this, the managing director is spearheading a strategic initiative to embed "Business and Data Intelligence" into operations, aiming to regain market share and drive revenue growth.

ACHIEVEMENTS:

🔶 Developed metrics as per the prescribed list.
🔶 Crafted a dashboard aligned with the stakeholder-provided mock-up.
🔶 Derived insights beyond the given metric list and dashboard specifications.
SKILLS UTILIZED:

🔶 Applied Power BI.
🔶 Utilized SQL.
🔶 Employed Excel.
🔶 Harnessed DAX Studio.

This initiative marks a pivotal step towards enhancing AtliQ Grands' competitive edge through advanced analytics and data-driven strategies.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Requests

Domain/Function: Consumer Goods

Queried and analyzed 10 SQL-based ad-hoc requests from the Director of Data Analytics, delivering actionable insights and detailed reports for each request.

View Project
Engagement

It shows the use of cte and Windows functions to get the total sold quantity ranked by each division.

It shows the use of a CASE statement to categorize data into quarters and calculate the total sold quantity for each quarter.

Project Details

As a candidate for the junior data analyst role at Atliq Hardware, I tackled a comprehensive SQL challenge set by Tony Sharma, the Director of Data Analytics. I reviewed the ‘ad-hoc-requests.pdf’ to understand 10 specific ad-hoc business questions and executed complex SQL queries to derive meaningful insights. I applied a range of advanced SQL techniques including subqueries, multiple joins, Common Table Expressions (CTEs), window functions, and aggregate functions to analyze data and uncover actionable insights. This challenge helped me enhance my skills in data extraction, transformation, and query optimization. I demonstrated proficiency in SQL performance tuning and data modeling, which resulted in actionable insights for informed decision-making.