Portfolio - Rishi Kumar

PowerBI Project

Business Insights 360

AtliQ Hardware, a consumer electronics firm, faces tough competition due to limited data usage, mainly relying on Excel for reports. My objective is to implement a robust Power BI analytics solution, enabling the company to gain crucial insights for smarter decision-making.

View Project
on GitHUB

Home Page

Finance View

Project Details

In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights - Consumer Goods Domain

Atliq Hardwares, a fictional company, is a major computer hardware maker in India and abroad. Yet, they lack quick insights for smart decisions. So, a SQL challenge is on the horizon to fill this data gap.

View Project
Engagement

View Project
on GitHUB

Ad-Hoc Requests along with Output & Insights Ad-Hoc Requests along with Output & Insights

Recommendations For Atliq Hardwares

Project Details

In the Sales Performance Enhancement project, our mission was to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business questions.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making.

Project video

PowerBI Project

Revenue Insights in the Hospitality Industry

AtliQ Grands, a prominent player in India's luxury hotel sector, faced market share and revenue decline amid stiff competition.The project not only addresses immediate challenges but lays a robust foundation for sustainable growth through data-driven decision-making in the hospitality industry.

View Project
Engagement

View Project
on GitHUB

Revenue Insights in the Hospitality Industry

Dashboard mockup

Data modelling

Project Details

AtliQ Grands, famed for its luxurious five-star hotels in India, faces declining market share and revenues in luxury and business segments. To combat this, the managing director initiates a strategic "Business and Data Intelligence" integration.

Key Focus Areas:

Creation of an interactive Power BI dashboard for real-time data analysis.
Implementation of vital hospitality domain metrics including RevPAR, ADR, DBRN, DSRN, and DURN.
Thorough analysis of historical data to identify revenue-enhancing opportunities.
Provision of actionable insights to inform pricing and occupancy decisions.
Throughout this project, I honed the following skills and knowledge:

Proficiency in Power BI for data visualization and analysis.
In-depth comprehension of key hospitality metrics and KPIs.
Data-driven decision-making methodologies for pricing and occupancy optimization.
Effective data presentation techniques to facilitate strategic decision-making.

Project video

Live Interactive Dashboard

Excel Project

AtliQ Hardwares Sales and Finance Analytics

Empower FMCG businesses with data-driven strategies for growth through actionable insights from comprehensive sales and financial analytics. Proficient in ETL, Power Query, Power Pivot, DAX, and user-centric report design. Objective: Provide in-depth analysis of financial health and market standing

View Project
Engagement

View Project
on GitHUB

AtliQ Hardwares Sales and Finance Analytics

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

The Customer Performance Report displays the yearly net sales performance for each customer.

Project Details

In this project, I've developed a comprehensive sales report using Excel pivot tables, serving as a vital resource for businesses to optimize customer discounts, streamline negotiations, and explore new market opportunities. The reports provide actionable insights to elevate sales strategies, enhance customer satisfaction, and drive revenue growth.

Throughout this endeavor, I've honed my skills in:

1. Utilizing pivot tables for advanced data analysis.
2. Harnessing Power Query's capabilities for efficient data processing.
3. Mastering the fundamentals of DAX (Data Analysis Expressions) for deeper insights.
4. Employing conditional formatting to enhance data presentation.
5. Enhancing report aesthetics for improved visual appeal.
6. Gaining proficiency in interpreting sales-related metrics.

This project aims to equip businesses with the necessary tools and knowledge to elevate their sales efforts. By leveraging sales data, companies can uncover growth opportunities

Hello, I am

Rishi Kumar

1

2

1

About

Technical

My

Business Insights 360

Ad-Hoc Insights - Consumer Goods Domain

Revenue Insights in the Hospitality Industry

AtliQ Hardwares Sales and Finance Analytics

Awards

Contact Me

Email

Github

Linkedin

Call

Rishi Kumar

Download Resume