Portfolio - Jaison James

Excel Project

Sales and Finance Analytics

Excel based data analytics project that focuses on sales and finance domains. This project uses a combination of Power Pivot, Power Query on top of the regular pivot table.

View Project
Engagement

View Project
on GitHUB

Summarizing market performance with targets to with visual cues to identify products that falls behind the target.

Summarizing customer performance during the Fiscal Years 2019, 2020, 2021 with a comparison between Fiscal Year 2021 vs 2020.

Project Details

Sales Report :
Project objective:
1. Create a customer performance report
2. Conduct a comprehensive comparison between market performance and sales targets

Finance Report :
Project objective:
1. Create Profit and Loss (P&L) reports by Fiscal Year & Months
2. Create Profit and Loss (P&L) reports by Markets

PowerBI Project

Business Insights 360

A comprehensive dashboard that enables data driven decision making covering five major views, Finance, Sales, Marketing, Supply chain and Executive to translate insights from data.

View Project
Engagement

Other Tools

SQL

Home Page of the dashboard which contains some crucial information at the bottom and provides an easy access to the other views.

Finance view with key financial metrics at a glance. Graphs to monitor metric trends in a Fiscal year with slicers to fine tune analytics.

Project Details

AtliQ hardware is a consumer goods electronics company having operations in various countries. Their business is growing rapidly and they still rely on excel files for data analytics. Excel files are hard to consume and not effective in generating insights. Also due to the lack of effective analytics the company faced a major loss in Latin America.

The Business Insights 360 dashboard created using power bi tackles the problem head on as it provides comprehensive insights on different business perspectives like finance, sales, marketing, supply chain and executive considering their corresponding metrics.

Live Interactive Dashboard

PowerBI Project

Hospitality Domain Analytics

A Power BI project embedded with crucial metrics relevant to providing data driven insights to the revenue team of AtliQ Grands. The dashboard was designed with a principle of quality over quantity.

View Project
Engagement

Star Schema data modelling of the data tables.

Main Page of the dashboard that highlights key metrics, their Week over Week change, Weekly trends and filters to control the data.

Project Details

This project aims to leverage a hospitality analytics dashboard built using Power BI to address the following objectives:
1) Incorporate key metrics such as RevPAR, ADR, Avg. Rating, Occupation %, and DSRN to lead into data driven decision making.
2) Empower stakeholders with data-driven insights to make informed decisions.
3) Increase revenue and regain market share in the luxury/business hotels category.

The Power BI dashboard offers a range of features to facilitate data analysis, including interactive visuals, customizable filters, and the ability to drill down into specific performance metrics.

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

SQL Analytics: Delving into 10 ad-hoc queries, unveiling key insights for Atliq Hardwares—a Consumer Goods powerhouse. Data-driven decisions, one query at a time!

View Project
Engagement

View Project
on GitHUB

Number of products per segment sorted and visualized.

Gross sales contribution per channel which was obtained using window functions.

Project Details

This project tackles 10 adhoc questions using a blend of essential SQL concepts:

1️⃣ Joins
2️⃣ Aggregate Functions
3️⃣ GroupBy
4️⃣ SubQueries
5️⃣ Common Table Expressions (CTEs)
6️⃣ Window Functions
7️⃣ User Defined Function
8️⃣ Dense Rank()

The insights generated paved the way for quick and informed decision-making by stakeholders.

SQL Project

Finance and Supply chain analytics

A collection of Finance and Supply chain SQL queries that would generate crucial domain specific reports, utilizing the concepts of stored procedure, joins, temporary tables etc.

View Project
Engagement

View Project
on GitHUB

Stored Procedure that returns the market badge (Gold or Silver) for a given market.

Stored Procedure which generates the monthly gross sales report for any given customer.

Project Details

Embark on a comprehensive exploration of the intersection between finance and supply chain with this engaging hands-on project. Delve into the intricacies of SQL, leveraging advanced concepts such as stored procedures and temporary tables to craft insightful reports. Tailored specifically for the finance and supply chain domains, these reports offer a nuanced understanding of key aspects. Uncover valuable insights and enhance decision-making through a practical application of SQL in this dynamic project.

Python Project

Hotel Data Analytics

Embark on a data-driven journey with this Python project, employing the renowned pandas framework to extract and analyze crucial insights for AtliQ Grands, a prominent player in the thriving hospitality industry.

View Project
Engagement

View Project
on GitHUB

An Excerpt from the jupyter notebook that shows the number of bookings per platform.

A jupyter notebook excerpt that shows the outlier removal process used in the project.

Project Details

This project provides an exciting data-driven expedition through the corridors of the hospitality industry with this Python project, strategically leveraging the widely acclaimed pandas framework. In this immersive endeavor, the focus is squarely on AtliQ Grands, a distinguished force within the hospitality landscape. The utilization of pandas, a robust data manipulation and analysis library in Python, enables the extraction and comprehensive analysis of pivotal insights that are paramount to AtliQ Grands' sustained success.

At the core of this project lies the ambition to delve deep into the rich tapestry of data associated with AtliQ Grands, unraveling patterns, trends, and intrinsic metrics that can significantly shape strategic decisions and operational efficiencies. By harnessing the power of pandas, the project offers a sophisticated approach to data exploration, affording a nuanced understanding of the intricate dynamics within the hospitality sector.

Hello, I am

Jaison James

1

2

2

1

About

Key

My

Sales and Finance Analytics

Business Insights 360

Hospitality Domain Analytics

Consumer Goods Analytics

Finance and Supply chain analytics

Hotel Data Analytics

Awards

Contact Me

Email

Github

Linkedin

Call

Jaison James

Download Resume