Project Details

This project focuses on analyzing sales and financial data of AtliQ Hardwear using Excel. It provides insights into customer performance, market performance, and financial statements. The reports generated in this project aim to support decision-making processes and facilitate communication with stakeholders.

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.

Live Interactive Dashboard

Project Details

- Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs.
- Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client

Live Interactive Dashboard

Project Details

Employee demographics show peaks in the 34-36 age
range and lows in the 58-60 range. The analysis of
average monthly income highlights the highest salary for
Manufacturing Directors at 183 and the lowest in Human
Resources at 528. Marital status examination reveals a
prevalence of married employees, with Research and
Development having the highest count at 1,350 out of
2,883 employees. Attrition trends show a peak of 588
occurrences over the years. Implementing a star schema
and hierarchical drill-downs in Power BI enhances data
organization, dynamic filtering, and data exploration.
These insights empower HR professionals to optimize
workforce management strategies, fostering
organizational growth.

Project Details

The production company wants to plan their every move analytically based on data and have approached you for help with this new project. You have been provided with the data of the movies that have been released in the past three years. You must analyze the data set and draw meaningful insights that can help them start their new project.

Project Details

AtliQ Hardware is a company that Sells and Manufactures Hardware.They have Customers all over the world and Products under various categories. AtliQ Team use MS excel for data analysis but as the business expands globally company's Top management decides to use Power BI for data analytics. So Top management wanted the analytics team to Provide insights through SQl to make decisions and as later part of the Project a dashboard to be created for various key departments, so they can get insights on important metrics and make data driven Decisions

Live Interactive Dashboard