Project Details

AtliQ Hardware, a global player in hardware solutions, specializes in offering top-of-the-line products, such as laptops, mice, and processors to customers worldwide.

📃 Project Overview
"Sales and Finance Analytics" is all about harnessing the power of Excel to gain deep insights into our business operations. With a focus on sales and finance, to enhance our decision-making processes and drive growth.

🛠️Key Learnings
- Power Query: Extract, Transform, and Load (ETL) for pristine data preparation.
- Conditional Formatting: Adding visual clarity to your insights.
- Power Pivot: Data modelling and relationship building between dimension and fact tables.
- DAX: Crafting calculated columns & measures for data mastery.
- Pivot Tables: Unravelling complex data for actionable insights.

Sales Report
- Customer Performance Report
- Market vs. Targets: Understand how we're doing in each market.
- Top Products: Discover what's selling best to boost profits.

Project Details

AtliQ Hardware is a hardware manufacturing company that sells various products to customers across different countries and regions. As a rapidly growing company, AtliQ Hardware faced the challenge of efficiently collecting and analyzing data from diverse sources such as SQL databases, Excel sheets, and CSV files. These hurdles potentially impeded their ability to make informed business decisions for sustained expansion and take timely corrective actions. Test - Developed an interactive report providing invaluable insights across finance, sales, marketing, supply chain, and executive teams, using the provided mock-up dashboards as a reference.

📋Project Execution- The project execution involved multiple steps:
💠 Connecting MySQL Database with Power BI
💠 Data Validation and Data Transformation
💠 Creating Calculated Columns
💠 Data Modeling
💠 Building and Designing the Dashboards
💠 Data Validation & Stakeholder Feedback Implementation

Live Interactive Dashboard

Project Details

The Hospitality Domain Project Challenge, created by Codebasics in collaboration with AtliQ, is an exciting opportunity for data enthusiasts to dive into the world of hospitality analytics. The challenge involves analyzing a dataset related to the hospitality industry to create a comprehensive Power BI dashboard that provides valuable insights into key performance indicators (KPIs) such as Revenue Per Available Room (RevPAR), Average Daily Rate (ADR), and Direct Sales Revenue per Night (DSRN).
The project aims to help hotel management teams make informed decisions by visualizing trends and patterns in hotel revenue, occupancy rates, and customer behaviour. By leveraging Power BI, participants can create interactive dashboards that enable users to explore data, identify areas for improvement, and optimize operations to increase profitability.

Live Interactive Dashboard

Project Details

🤖 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰: Analyzing the dataset provided by Atli Hardware to extract valuable insights regarding sales, market trends, customer behaviour, and supply chain forecasting.

🤖 𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭: The project involves conducting a comprehensive analysis of the dataset supplied by AtliQ Hardware. The primary objective is to derive valuable insights concerning sales performance, top markets, products and customers and many more useful insights.

🤖 𝐓𝐨𝐨𝐥𝐬 𝐔𝐬𝐞𝐝: MySQL, Excel, Canva

🤖 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬:

- Sales optimization
- Identification of new growth opportunities
- Market trend analysis
- Understanding customer behaviour

Project Details

Project Overview

Objective: To build a Power BI dashboard that delivers real-time sales insights for a hardware supplier.

Structure: The project consists of 9 lectures totalling approximately 3 hours and 11 minutes of content. It covers various stages of data analysis including:
Problem Statement
Data Discovery
Data Analysis Using SQL
Data Cleaning & ETL (Extract, Transform, Load)
Dashboard Creation
Stakeholder Feedback
Report Publishing
Mobile Dashboard Access
Version Updates Based on Feedback

Participants will gain insights into how data analysis projects are executed in large organizations, which can enhance their resumes and prepare them for careers in data analysis. The course emphasizes practical skills and real-world applications rather than just theoretical knowledge.

Live Interactive Dashboard

Project Details

Project Overview

Objective: To understand and improve workforce dynamics through data-driven analysis.
Content: The project includes a series of free learning resources, including datasets and instructional materials, which facilitate hands-on experience with HR analytics.

Learning Components
Data Collection: Participants learn how to gather relevant HR data.
Data Analysis: The project emphasizes techniques for analyzing workforce data to derive insights.
Visualization: Learners are trained to visualize data effectively to communicate findings to stakeholders.


Resource
The project is supported by various resources, including downloadable datasets, instructional videos, and a dedicated YouTube playlist that outlines the project in detail. These materials are intended for educational purposes only and are not for commercial use

Live Interactive Dashboard