Project Details

This project encompasses two main dimensions: Sales Analytics and Finance Analytics.

In sales analytics, the Customer Performance Report analyzes sales data to closely monitor and assess customer sales operations. It assists in the determination of optimal customer discounts and negotiations with customers. The market performance vs sales target helps compare market performance against predefined sales targets, pinpointing potential opportunities in international markets.

Simultaneously, the Financial Analytics component focuses on generating Profit and Loss (P&L) Reports categorized by both fiscal year and months, as well as by markets. The objective here is to assess financial performance and contribute valuable insights for decision-making, thus forming the basis for budgeting, forecasting, and aligning financial planning with strategic objectives.

Skills used : Pivot Table, Power Query, DAX, Conditional Formatting

Project Details

Atliq Hardware is a company dealing with the manufacturing of computers and its peripherals having operations in various countries.
Designed a multi-functional Power BI dashboard to analyze sales trends for AtliQ Hardware across the global market, by gathering data from 2 different sources (Excel/CSV files and a SQL database). Analyzing various parameters and trends and keeping a close eye on essential key performance indicators (KPIs). Building various views for various departments like the Finance View, Sales View, Marketing View, and Supply Chain View.

Key Business Metrics that are focused upon: Net invoice sales, Net sales, Pre and post-invoice deductions, Gross margin, Net margin/profit, Net Error, Absolute Error, and Forecast accuracy.

Structuring and organizing data by Data Modeling to create relationships, and establish a framework for effective data analysis and reporting.

Skills Used: ETL using Power Query, Establishing data model relationships, DAX.

Live Interactive Dashboard

Project Details

AtliQ Grands owns multiple five-star hotels across India and has been in the hospitality industry for the past 20 years. Due to strategic moves by other competitors and ineffective decision-making in management, AtliQ Grands is losing its market share and revenue in the luxury/business hotels category. My purpose in designing a BI dashboard is to
1. Closely monitor and assess their booking operations and overall revenue performance.
2. Analyzing key hospitality business metrics like OCC%, RevPar, ADR etc while keeping a close eye on essential KPIs.
3. Building various views like the Revenue View, Booking View, and Executive View to have a more detailed analysis of the incoming data.

Analyzed that with an increase of 13% in bookings and a reduction of 5% in cancellation rate, revenue increased by 17%.

Skills used: ETL using Power Query, Data Modeling, DAX.

Live Interactive Dashboard