ARTI RAJENDRA AWALE

Data Analyst

[email protected] +91 7349422587

Resume

Hello, I am

ARTI RAJENDRA AWALE.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About Me

Hi, I’m Arti Rajendra Awale — a data enthusiast passionate about transforming raw data into meaningful insights.
I use tools like Power BI, SQL, and Excel to analyze trends, uncover patterns, and create impactful visualizations that tell compelling data stories. My work is driven by curiosity and a strong desire to solve real-world problems through data.

With a sharp attention to detail and a structured analytical approach, I aim to deliver insights that support smart, informed decisions. I’m excited to continue growing as a data analyst and contribute to teams that value data-driven thinking.

Thanks for visiting my portfolio — I look forward to connecting with you!

Key Skills

Microsoft Power BI

Advancced Excel

MySQL

Python

Curiosity and Continuous Learning

My Projects

Sales Analytics

Domain/Function: FMCG

Business Insights 360 Dashboard

Domain/Function: FMCG

OTT Merger Insights – Strategic Dashboard

Domain/Function: Media & Entertainment – OTT Streaming Services

AtliQ Hardwares – SQL Ad-hoc Analysis

Domain/Function: Retail & Consumer Electronics

My Experience

Data Analyst – Project-Based Experience

Self-Initiated & Academic Projects
2024 – Present

Applied SQL, Power BI, and Excel across multiple data analysis projects.
Performed data cleaning, transformation, and validation on raw datasets.
Built interactive dashboards to track KPIs and trends.
Conducted ad-hoc analysis to answer business-style questions.
Translated insights into clear, actionable findings.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Microsoft Fabric Mini: For Data Analysts

SQL Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/arti-awale

Call Me

+91 7349422587

GitHub

https://github.com/awalert08

Excel Project

Sales Analytics

Domain/Function: FMCG

Designed an interactive Excel dashboard for an FMCG company to analyze sales performance by region and product category using pivot tables, slicers, dynamic charts, and advanced formulas for actionable business insights.

View Project
on GitHUB

View Project
on Microsoft Excel (Office 365)

- Tracks customer net sales trends across multiple years. - Helps identify key contributors and growth patterns.

- - Compares actual sales with predefined targets at the country level. - Reveals performance gaps and areas for improvement.

Project Details

In this project, I worked with mock sales data from an FMCG company to build an intuitive and data-driven Excel dashboard. The aim was to identify trends in product sales, regional performance, and seasonal growth patterns for internal stakeholders.

I cleaned and structured the raw dataset and then used pivot tables to summarize key metrics, including Monthly Sales, Region-wise Revenue, and Top-Selling Products. With advanced Excel formulas, charts, and conditional formatting, I created a visually appealing dashboard that updated dynamically through slicers and dropdowns.

The dashboard enabled business users to quickly switch views by selecting regions, products, or timeframes, allowing them to identify underperforming areas and high-growth opportunities.

PowerBI Project

Business Insights 360 Dashboard

Domain/Function: FMCG

Built a comprehensive Power BI dashboard for AtliQ Hardwares, integrating multi-departmental data to deliver executive-level insights using Power Query, DAX, and advanced data modeling—enabling strategic, real-time business decisions.

View Project
Engagement

View Project
on GitHUB

Shows revenue, growth, and order volume by region and product, helping sales teams track performance and spot key trends.

Shows Net Sales, Gross margins, and Net Profit by region and month, helping leaders track financial health and forecast performance.

Project Details

This project involved building an end-to-end Business Intelligence solution for AtliQ Hardwares, a fictional B2B hardware manufacturing company. The objective was to empower the leadership team with data-driven insights and improve visibility into key business functions.

I started by integrating raw datasets from multiple departments and performed data cleaning and transformation using Power Query. Then, I created a structured star schema data model to optimize relationships and performance. Using DAX, I calculated critical metrics such as Total Revenue, Gross Profit Margin, Product Performance, and Customer Growth.

The dashboard was designed to be highly interactive, incorporating bookmarks, tooltips, and slicers to allow dynamic analysis across different dimensions like time, region, and product category. I deployed the report to the Power BI Service and configured row-level security to provide team-specific access.

Live Interactive Dashboard

PowerBI Project

OTT Merger Insights – Strategic Dashboard

Domain/Function: Media & Entertainment – OTT Streaming Services

Analyzed subscription trends, content types, and viewing behavior from two OTT platforms using Power BI to uncover insights and provide strategic recommendations for an upcoming merger.

View Project
Engagement

View Project
on GitHUB

Visualizes plan upgrades/downgrades, user flow, and monthly trends to uncover churn and pricing insights.Visualizes plan upgrades/downgrades, user flo

Tracks active/inactive users, watch time, and growth trends across city tiers and platforms.

Project Details

Designed and built an interactive Power BI dashboard for a strategic OTT platform merger (LioCinema + Jotstar).
Analyzed user behavior, subscription plans, churn patterns, and watch time across platforms.
Modeled data from multiple sources using Power Query and DAX for dynamic KPI calculations.
Identified key insights such as:-
High churn in Tier 2 & 3 cities
Strong upgrade behavior among the 18–34 age group,
Proposed strategies for pricing, plan bundling, and content targeting.
Dashboard enabled decision-makers to explore trends by age, city tier, plan type, and device.
Demonstrated strengths in data modeling, storytelling, and business-focused analysis.

Live Interactive Dashboard

SQL Project

AtliQ Hardwares – SQL Ad-hoc Analysis

Domain/Function: Retail & Consumer Electronics

Developed a complete SQL-based ad-hoc analysis and transformed insights into an interactive Power BI dashboard that highlights sales performance, product trends, customer behavior, manufacturing cost insights, and channel contributions for AtliQ Hardwares.

View Project
Engagement

View Project
on GitHUB

Displays how AtliQ’s product portfolio is distributed across segments. Notebooks and Accessories dominate the catalog, while Desktop, Storage, and Networking have limited offerings, highlighting potential gaps in assortment strategy.

Compares average discount levels across major customers. Flipkart and Ezone receive higher discounts than others, indicating differentiated pricing strategies that may influence margins and key account relationships.

Project Details

Started by understanding the business goal of evaluating a possible merger between LioCinema and Jotstar.
Identified what really matters for the decision, such as user growth, churn, watch time, subscription plans, and device usage.
Cleaned and prepared data from both platforms using Power Query by fixing inconsistencies in plans, city tiers, and dates.
Built a clear data model to connect user, subscription, and viewing data across platforms.
Created DAX measures to track churn, active users, average watch time, and upgrade or downgrade behavior.
Designed an interactive Power BI dashboard with filters for age group, city tier, plan type, and device.
Analyzed patterns that showed higher churn in Tier 2 and 3 cities and strong upgrade behavior among users aged 18–34.
Used these insights to suggest practical strategies for pricing, plan bundling, and content targeting to support merger decisions.