Project Details

𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭: AtliQ Technologies, a thriving hardware company specializing in peripherals, faced a significant challenge in LATIN AMERICA. Their quest? To rectify the issue through data-driven decision-making.

𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐕𝐢𝐞𝐰: Analyzed crucial KPI indicators such as Net Sales, Gross Margin %, and Net Profit %. Created a comprehensive P & L Statement with YOY growth.

𝐒𝐚𝐥𝐞𝐬 𝐕𝐢𝐞𝐰: Explored Customer Performance based on Net Sales and Gross Margin.

𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 𝐕𝐢𝐞𝐰: Enhanced Marketing insights with segment performance and Net Profit metrics.

𝐒𝐮𝐩𝐩𝐥𝐲 𝐂𝐡𝐚𝐢𝐧 𝐕𝐢𝐞𝐰: Surveyed the variance of Actual Sales and Forecast accuracy.

𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐯𝐞 𝐕𝐢𝐞𝐰: Examined Yearly Trends by Revenue, GM %, NP % & Market Share %. Listed the TOP 5 Customers & Products by Revenue Contribution.

Project video

Project Details

AtliQ Grands have been in the hospitality industry for the past 20 years. Due to 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.

Dashboard contains below views:
➡️Performance Overview
➡️ Revenue Overview
➡️ Booking Overview

Project video

Project Details

🎯 Project Introduction:
"Sports Basics" is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

🎯 Project Objective:
The objective is to craft a comprehensive dashboard analyzing IPL data for 2021 to 2023.

🔎 Power BI Dashboard Overview:
✅ Home View: A landing page with icons to navigate to different views.
✅Player Type View: Includes Opener, Anchor, All Rounder, Finisher, Bowler.
✅Winner View: Orange Cap, Purple Cap and winner for last 3 year
✅TOP N View: Provides primary insights of TOP N players of different category
✅Prediction View: Includes live IPL 2024 top runs and top wicket takers data along with Table rankings.
✅Playing 11 View: People can select their playing XI and see the overall performance of the selected team.

Project video

Project Details

𝐂𝐥𝐢𝐞𝐧𝐭: Atliq Hardware, a leading computer hardware producer in India with a global presence.
𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: Lack of sufficient insights for quick and informed decision-making at the top level of management.
𝐒𝐨𝐥𝐮𝐭𝐢𝐨𝐧:Conducted data analysis on nearly 2 million records in the consumer goods domain.
𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐂𝐨𝐦𝐩𝐚𝐫𝐢𝐬𝐨𝐧:Evaluated company performance against competitors.
𝐏𝐫𝐨𝐝𝐮𝐜𝐭 𝐒𝐞𝐠𝐦𝐞𝐧𝐭𝐬:Analyzed different product segments.
𝐒𝐚𝐥𝐞𝐬 𝐂𝐨𝐦𝐩𝐚𝐫𝐢𝐬𝐨𝐧 (𝟐𝟎𝟐𝟎 𝐯𝐬. 𝟐𝟎𝟐𝟏):Identified trends and changes in sales.
𝐂𝐨𝐬𝐭 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:Identified highest and lowest cost products.
𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧:Created a presentation to effectively communicate analysis and insights to top-level management.
Provided actionable insights for data-informed decision-making. Empowered management with a deeper understanding of the company's performance and market positioning.
𝐓𝐨𝐨𝐥𝐬 𝐔𝐬𝐞𝐝:
-SQL for data querying and analysis

Project video

Project Details

Shield Insurance seeks to enhance its data-driven decision-making capabilities by implementing a dashboard solution that provides actionable insights into key performance metrics.
To evaluate the effectiveness of this initiative, Shield Insurance is considering a collaboration with AtliQ Technologies.
Before committing to a full-scale project, Shield Insurance requires a pilot project to be developed in Power BI. This pilot project will serve as a proof of concept, demonstrating AtliQ Technologies' ability to meet Shield Insurance's specific needs.
The success of this pilot project will determine the potential for a larger partnership and the full deployment of the dashboard solution.

Project video