Portfolio - Lohitha Mada

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardwares, a fast-growing consumer electronics company, faces challenges competing due to reliance on Excel for reporting. My goal is to implement Power BI dashboard for advanced analytics to provide actionable insights, boost decision-making, and drive better business performance.

View Project
Engagement

View Project
on GitHUB

This is the main dashboard page, serving as a central hub for users to navigate to various sections

Data modelling involving 10+ tables

Project Details

Developed a robust Power BI dashboard for AtliQ Hardware, delivering valuable insights across finance, sales, marketing, and supply chain areas. Applied data modeling, visualization best practices, and advanced analytics to empower data-driven decision-making and support the company’s growth objectives.

𝗞𝗲𝘆 𝗦𝗸𝗶𝗹𝗹𝘀 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗱:
- Power Query: Basic and advanced operations
- DAX formulas: Basic to complex
- Data modeling with over 10 tables
- Selecting and formatting effective visuals
- Using bookmarks and deploying in Power BI service

Live Interactive Dashboard

SQL Project

Ad-Hoc Consumer Goods Analysis for AtliQ Hardwares

Domain/Function: Customer Goods

AtliQ Hardwares, a top computer hardware company, struggled with data-driven decision-making. To address this, they needed a detailed report using SQL for data analysis.

View Project
Engagement

View Project
on GitHUB

View Project
on

Other Tools

POWER BI

PPT

Ad-Hoc Consumer Goods Analysis for AtliQ Hardwares

These are the Ad-Hoc requests from the client and its data model

Visual Representation of the Gross price of AtliQ harware, Month-wise

Project Details

Atliq Hardwares, a leading computer hardware producer with a global reach, recognized the need for data-driven decision-making and decided to expand its analytics team by hiring junior analysts. Data Analytics Director Tony Sharma initiated a SQL challenge focused on 10 ad hoc business requests to identify candidates technical and soft skills, aiming to find those capable of delivering insights for informed decision-making aligned with the company’s goals.

𝗠𝘆 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
✅ Used MySQL to execute queries and extract the required data.
✅ Utilized Power BI to transform the data into clear and impactful visualizations.
✅ Created a engaging PowerPoint presentation to effectively communicate insights.
✅ Provided actionable insights to support the management team in making data-driven decision.

PowerBI Project

Shield Insurance Business Insights

Domain/Function: Insurance

Analyzed Shield Insurance’s data from Nov 2022 to Apr 2023 to support data-driven decisions. Shield Insurance offers comprehensive plans for all ages and businesses, prioritizing customer satisfaction and security to ensure clients feel safe and protected.

View Project
Engagement

View Project
on GitHUB

Other Tools

POWER POINT

Dashboard home page where users can navigate to different views for analysis

Overview displaying Shield Insurance’s performance and key KPIs

Project Details

This project involved analyzing over 26,000 rows of data on sales, customer demographics, and revenue trends for Shield Insurance across five major cities. The aim was to identify key revenue drivers and deliver actionable insights to enhance customer acquisition and sales performance using Power BI, Power Query, and DAX.

𝗠𝘆 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
✅ Created an interactive Power BI dashboard to show performance gaps and areas for improvement.
✅ Analyzed over 26,000 rows of data on sales, customer demographics, and revenue trends for Shield Insurance across five major cities.
✅ Found key factors driving revenue and shared insights to help improve customer acquisition and sales.
✅ Gave insights and recommendations to help boost digital engagement and support Shield Insurance’s growth.

Project video

Live Interactive Dashboard

Excel Project

Excel Analytics: Sales & Financial Performance

Domain/Function: Sales & Finance

Developed Excel reports for AtliQ Hardwares, analyzing half a million records to boost sales strategies and financial performance. This project enables the business to track sales, uncover growth opportunities, and make smarter decisions for improved performance in a dynamic market.

View Project
on GitHUB

Excel Analytics: Sales & Financial Performance

Customer Performance Report: Provides net sales performance of individual customer across years.

Market Performance: Provide stakeholders to assess the country's performance across multiple years and compare it against set targets.

Project Details

In this project, I created sales and finance reports in Excel to help businesses make better decisions. The sales reports provided insights into customer performance, market trends, and discount strategies, helping businesses negotiate and find new expansion opportunities. The finance reports showed key financial details like P&L by fiscal year, month, and market.

𝗦𝗸𝗶𝗹𝗹𝘀 𝗹𝗲𝗮𝗿𝗻𝗲𝗱:
- Creating Pivot Tables
- Using Power Query for data transformation
- Basic DAX for data modeling
- Applying Conditional Formatting
- Beautifying reports
- Analyzing sales and financial data

These reports help businesses improve their sales strategies, understand financial performance, and stay competitive.

Excel Project

Coffee Shop Sales Analysis

Domain/Function: Sales

This project showcases an in-depth data analysis of coffee shop sales using Excel. The analysis provides insights about sales trends, identifying busiest days of sales, product performance.

View Project
on GitHUB

Other Tools

Power Point

Coffee Shop Sales Dashboard

Key Findings from the Coffee Shop Sales Analysis.

Project Details

Conducted an in-depth analysis of coffee shop sales using Excel, uncovering sales trends, identifying peak sales days, and evaluating product performance to derive actionable insights.

𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗚𝗮𝗶𝗻𝗲𝗱:
- Analyzed sales trends for Maven Roasters in the first half of 2023, identifying the top-performing store in terms of revenue and determining the peak sales days.
- Evaluated product performance, noting the top-selling product categories and assessing the impact on overall revenue.
- Assessed daily and hourly sales patterns, highlighting the busiest days and times for foot traffic and sales.
- Business Insight Communication
- Problem Solving

Hello, I am

Lohitha Mada

2

2

1

About

Key

My

Business Insights 360

Ad-Hoc Consumer Goods Analysis for AtliQ Hardwares

Shield Insurance Business Insights

Excel Analytics: Sales & Financial Performance

Coffee Shop Sales Analysis

Awards

Contact Me

Email

Github

Linkedin

Lohitha Mada

Download Resume