Project Details

Designed and developed a Power BI dashboard to monitor and analyze gas consumption trends across UCLan Preston Campus buildings, utilizing advanced color-coding techniques to visually highlight high-consumption areas. Generated insights into key performance indicators (KPIs) such as Total Gas Consumption vs. Last Year's Consumption, Max Consumption Month, and Peak Consumption periods. Conducted in-depth analysis of monthly gas consumption trends, leveraging statistical forecasting to predict usage for the next 12 months and identifying seasonal consumption patterns, with lower usage during summer and increased consumption in colder months.

Live Interactive Dashboard

Project Details

1)Developed an interactive dashboard using
transaction and customer data from a SQL database,
to provide real-time insights.
2) Streamlined data processing & analysis to monitor
key performance metrics and trends.
3) Shared actionable insights with stakeholders based
on dashboard findings to support decision-making
processes.

Live Interactive Dashboard

Project Details

The Business Insights 360 dashboard is designed to enable better decision-making across all levels of an organization. By consolidating key data from sales, finance, marketing, and supply chain operations, it provides a centralized platform for performance monitoring. This integrated view allows stakeholders to identify trends, risks, and opportunities in real time, driving quicker and more informed decisions.The interactive nature of the dashboard encourages collaboration across departments, ensuring that all areas of the business are aligned with strategic goals. By visualizing data in an intuitive way, the dashboard makes it easier for teams to track progress, set realistic targets, and improve operational efficiency.In essence, Business Insights 360 helps businesses move from reactive to proactive decision-making, using data to predict future performance and optimize processes across departments.

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” 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 with insights from their historical data.
Workflow steps:
1. Data collection and exploration, create a Date table in Power Query.
2. Data load to Power BI and initial validation.
3. Data Transformation in Power Query.
4. Data Modelling and creating calculated columns.
5. Creating measures using the DAX language.
6. Build Executive

Live Interactive Dashboard

Project Details

Problem Statement:
AtliQ is a fast-growing hardware company that sells various products to customers in many countries through various channels, including retail, direct sales, and distributor networks, both online and in brick-and-mortar stores. To support its growth and make data-driven decisions, AtliQ needs a data analytics team.
Workflow steps:
 ETL (Extract, Transform, Load) in excel.
 Solution design thought process.
 Creating connections among tables using data modelling.
 Adding the Date table using Power Query(M language).
 Functional knowledge in Sales, Finance and Profit & Loss.
 Creating Customer performance report.
 Creating Market performance vs Target report.
 Creating P&L reports by year, quarters and months.
 Further analysis of the given data by solving the assignment problems.