Project Details

AtliQ Hardware has experienced significant growth in recent years, prompting a strategic decision to implement data analytics through PowerBI within their operations. By harnessing PowerBI, AtliQ aims to provide stakeholders with actionable insights across finance, sales, marketing, and supply chain domains, driving informed decision-making.

By implementing data analytics, AtliQ seeks to elevate its competitive edge and establish itself as an industry leader. By leveraging real-time analytics, AtliQ aims to tackle critical business decisions head-on. From optimizing financial performance to refining marketing strategies, PowerBI will serve as the cornerstone for data-driven solutions.

This strategic decision reflects AtliQ's proactive approach to business development, setting the stage for sustained growth and success in the years to come.

Live Interactive Dashboard

Project Details

The Cricket Data Analytics🏏 project is made on T-20 Cricket World Cup 2022 Data. We used bright data web scraping to collect data from espncricinfo website then we performed some data transformation and cleaning in pandas, followed by building dashboards in Power BI.These dashboards can be used to analyse the data of the matches played in the world cup. We can also choose our best playing 11 from the pool of players playing the world cup.

Steps Involved in this Project-
1. Requirement Scoping
2. Data Collection using Web Scraping from ESPN Cricinfo website
3. Data Cleaning and Preprocessing in Pandas
4. Data Transformation in Power Query
5. Data Modelling and Building Parameters in Power BI using DAX
6. Building the Dashboard in Power BI

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 market share and revenue in the luxury/business hotels category. As a strategic move, Atliq Grands has decided to incorporate “Business and Data Intelligence” to regain market share and revenue.

Objective of this Project-
1. Familiarise yourself with the provided data and a mock-up dashboard and understand various terminologies and KPIs.
2. Created the metrics according to the metric list.
3. Create a dashboard according to the mock-up provided

Live Interactive Dashboard

Project Details

The project's goal is to collect the data from the bank database, clean the data, explore the required data with respect to company requirements, and then analyze the good loans, bad loans, bank amount funded, bank profit, bank loss, etc and create a dashboard using Power BI wrt KPIs.

Task Performed:
Step 1: Collect the necessary details about the Bank loan analysis report by the client.
Step 2: (Explore Process) Fletch the data from the client Database to "MS SQL Server".
Step 3: (Transform Process) Analyze, Clean, and extract the required data according to "Key Performance Indicators (KPIs)".
Step 4: Deal with the null, missing, and error data to project requirements using "MS SQL Server or Excel".
Step 5: (Load Process) Load the clean and transform data into a Power BI
Step 6: Create a Dashboard according to the requirement in Power BI

Objective:
1. Better decision-making w.r.t good vs bad loans
2. Category-wise analysis like type, purpose, grade, and verification s

Live Interactive Dashboard