Project Details

AltiQ hardware is a company which has grown vastly in the recent years, and opened business all over the globe. It is a company which sells, computer and computer accessories through three mediums/channel
Retailers
Direct
Distributors
Recently the company has faced a unforeseen loss by opening store in America based on the surveys, intuition and some excel analysis and also the company’s competitors has handful of analytics team to perform analysis and make data driven decision. So, the AltiQ hardware has no other option other than building their analytics team for data driven insights and decisions in the future to survive better in the industry.

Live Interactive Dashboard

Project Details

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.

Live Interactive Dashboard

Project Details

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

Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance.
Importance of analyzing sales data: Identify sales patterns and track key performance indicators (KPIs).
Role of reports: Determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries.

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

Purpose of sales analytics: Evaluation of financial performance, support decision-making, and facilitate communication with stakeholders.

Project Details

Supply Chain Analytics:
Understanding of net error, absolute error, and forecasting errors.
Calculation of absolute error in supply chain forecasting to measure forecast errors' magnitude.
Generation and interpretation of forecast accuracy reports to evaluate supply chain forecasting performance.

Finance analytics:
Understanding of Business Model of a consumer goods company
Deep Understanding of Profit & Loss Statement

Creation of various automated reports using Stored Procedures:
Market Badge(Gold/Silver)
Top n customers by net sales
Top n products by net sales
Top n markets by net sales
Monthly gross sales report for customers
Top n products per division by qty sold

Creation of various views:
Sales preinvoice discount
Sales postinv discount
Net sales
Gross sales

Creation of other reports using CTE & WINDOW FUNCTION:
Net invoice sales amount
Top 3 products from each division by total quantity sold in a given year