Portfolio - Rabin Anto V

PowerBI Project

Telecom Data Analytics

AtliQo is one of the leading telecom providers in India and launched it’s 5G plans in May 2022 along with other telecom providers, The target audience of this dashboard is top-level management - hence the dashboard should be self-explanatory and easy to understand

View Project
Engagement

Other Tools

Power BI

MySQL

Excel

Power Query

This report primarily focuses on revenue, Average Revenue Per User (ARPU), Total Active Users (TAU), and Total Active User Sessions (TAUS).

This report primarily centers on monthly revenue, categorized by city and segmented by various subscription plans.

Project Details

Revenue is declined by 0.5 % compared to the previous network, which is mainly caused by Delhi, Chennai, Ahmedabad cities.
Even though there is a decline in the revenue, ARPU (Average revenue per user) has increased from 190.2 to 211.3 rupees.
AtliQo maintains third position in the market always without any change.
Plan 1,2 and 11 are the highly performing plans among all the plans
Pune has 18% growth in active users despite having 55% increase in the unsubscribed users

Live Interactive Dashboard

PowerBI Project

Cricket Player Performance Dashboard

In the dynamic world of cricket, the performance of players plays a crucial role in shaping a team's success. This Dashboard delves into a comprehensive analysis of individual player statistics across three key categories: Batsmen, Bowlers, and Finishers

View Project
Engagement

Other Tools

Excel

Python

Pandas

Web Scraping

cricket player performance in three key categories: Batsmen, Bowlers, and Finishers to assist in selecting the best XI.

This Dashboard offers data-driven insights for assembling the dream XI, optimizing team performance, and harnessing diverse skills of cricket players

Project Details

This cricket player performance analysis portfolio offers a thorough exploration of player statistics, helping enthusiasts and selectors make informed decisions. The dream XI represents a blend of talent, expertise, and the ability to impact the game, providing the best chance for victory. It is a testament to the rich diversity of skills in the world of cricket, and the potential for success when harnessed effectively.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Business Insights 360 is a powerful dashboard created using Microsoft Power BI. This multi-functional dashboard has been customized to provide AtliQ Hardware with valuable insights into their different departments such as Finance, Sales, Marketing and Supply Chain.

View Project
Engagement

Other Tools

MySQL

Figma

Power BI

Excel

Welcome to Business Insights 360! Navigate finance, sales, marketing, supply chain, and executive views with real-time data freshness.

Strategic dashboard for high-level insights, performance summaries, and critical KPIs to guide top-level decision-making.

Project Details

•Customized Dashboard: Developed a multi-functional Power BI dashboard to specifically meet AtliQ Hardware's needs, allowing them to gain insights into their various departments.

•Data Integration: Data was sourced from disparate locations, including Excel/CSV files and a MySQL database, and seamlessly integrated into Power BI for comprehensive analysis.

•Data Model and Visualizations: A robust data model was developed within Power BI, enabling the creation of visually appealing and interactive visualizations to represent key performance indicators (KPIs).

•Performance Optimization: The dashboard's performance was significantly improved using DAX Studio, resulting in a 5% increase in report efficiency.

•Data-Driven Decisions: AtliQ Hardware can now analyze trends across different departments, empowering them to make data-driven decisions.

Live Interactive Dashboard

PowerBI Project

AtliQ Supply Chain Data Analysis

AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodra. They want to expand to other metro/tier1 cities in the next 2 years.

Other Tools

Excel

Figma

Power BI

MySQL

All the Key Metrics (OT%, IF%, OTIF%) are far behind the target On an average, orders are delayed 0.42 days from the agreed date of delivery

There is no noticeable improvements in any of the key metrics in the last few months There is a huge gap in IF% for most of the customers.

Project Details

AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers on a daily basis so that they can respond swiftly to these issues.

The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘on-time delivery (OT) %’, ‘In-full delivery (IF) %’ and OnTime in full (OTIF) % of the customer orders on a daily basis against the target service level set for each customer.

Live Interactive Dashboard

PowerBI Project

Nap Queen Sleep Amazon Stream Marketing Analysis

Based on the provided data, we have focused our analysis on sales data during each marketing campaign period. Unfortunately, data pertaining to sales before and after each campaign has not been provided.

View Project
Engagement

Other Tools

MySQL

EXCEL

Power BI

Nap Queen Sleep Amazon Stream Marketing Analysis

Based on our thorough analysis of the sales data, we have identifled a notable trend in mattress purchases during the hours around 11 AM.

Based on the provided data, the product "Bhamboo Charcoal Mattress Twin Size" has shown the highest growth in sales during the campaign period

Project Details

The campaign has garnered significant ad clicks (6735) and impressions (646k),
indicating a strong level of interest and visibility. The cost per conversion of
$24.27 and cost per click of $1.17 are also reasonable, indicating an efficient use
of advertising budget. To further optimize the marketing strategy for the "Anula Mattress Twin XL
size 6 inch" product and maximize the return on investment. Regularly monitor campaign performance metrics and iterate the strategy
based on data insights. Be agile and adaptive to market dynamics and
customer behavior. Mobile-Friendly Experience: Given the increasing use of mobile devices, influencer Marketing: Collaborate with relevant influencers in the home and bedding niche to promote the product and expand its reach to a wider
audience continuously analyze data, track progress, and adapt the strategy based on
customer

Live Interactive Dashboard

Excel Project

AtliQ Sales and finance Report

AtliQ Hardware is a prominent company that supplies computer hardware and peripherals to clients worldwide. My responsibility involved creating sales reports to analyze its market performance for the years 2019, 2020, and 2021.

View Project
on GitHUB

Other Tools

Pivot tabe

power query

Condition Formating

Lookups

A customer net sales performance report for the years 2019, 2020, and 2021, along with the growth % of net sales from 2020 to 2021.

A market performance vs the actual target report for the year 2021 and the percentage deficit of actual target as compared to 2021. Previous

Project Details

Thorough Analysis: I conducted a comprehensive examination of net sales performance, analyzing data across multiple dimensions, including year, customer, market, product, growth, and division.

• Target Alignment: Ensured alignment with strategic objectives by closely scrutinizing market performance against predefined targets.

• In-Depth Insights: Generated comprehensive insights illuminating critical aspects of sales operations.

• Tools Used: Employed MS Excel, utilizing tools like Pivot Tables, Power Pivot, and Conditional Formatting.

Hello, I am

Rabin Anto V

1

5

About

Technical

My

Telecom Data Analytics

Cricket Player Performance Dashboard

Business Insights 360

AtliQ Supply Chain Data Analysis

Nap Queen Sleep Amazon Stream Marketing Analysis

AtliQ Sales and finance Report

Awards

Contact Me

Email

Github

Linkedin

Call

Rabin Anto V

Download Resume