I’m Nagendra Vallepu
a Power BI Developer. Data Analyst. Business Analyst.

Lio & Jotstar Merger Analysis

This project, part of Codebasics Resume Project Challenge #14, delivers a comprehensive OTT merger analysis between LioCinema and Jotstar, two of India’s major players in the telecom and streaming space. The objective was to uncover platform-specific insights, user behavior patterns, and content performance trends to support a strategic merger decision, aiming to establish a unified platform that leads the Indian OTT landscape.

Objective

To equip Lio’s executive team with actionable insights about both LioCinema and Jotstar by analyzing subscriber behavior, content dynamics, upgrade/downgrade patterns, and overall platform health. This empowers stakeholders to make data-backed decisions for optimizing post-merger strategies.

Highlights

🔶Subscriber & Revenue Overview: Combined user base of 228K, with active users accounting for 61% and a paid user share of 42%. Total revenue stands at ₹14M, reflecting a steady growth with an 18.07% monthly increase.
🔶Subscription Trends & Dynamics: Analysis of monthly subscriber acquisition, upgrade/downgrade behavior, and retention vs churn rates. Notably, 80% of paid users come from LioCinema, showcasing its strong monetization strategy.
🔶Churn & Retention Metrics: LioCinema and Jotstar show strong retention rates of 88.6% and 93.9%, respectively, with visible churn drop-offs through content and pricing strategies.
🔶Content Library Insights: A total of 3,610 content assets were analyzed, revealing dominance in movie and series formats, with average runtimes of 94.2 minutes. Genres like drama, action, and comedy drive the highest viewership.
🔶User Engagement & Watch Time: Total watch time crossed 26.7M hours, with average watch time per user at 117.2 hours. Tier-1 cities and younger demographics (18-34) were key drivers of engagement, especially on mobile and smart TVs.
🔶Upgrade & Downgrade Patterns: Deep dive into subscription transition patterns showed VIP plans having the highest ARPPU (₹261.8) but facing a steady drop in user share, prompting review of pricing and content bundling.
🔶Device & Age-Wise Consumption Trends: Mobile remains the top device for content consumption. Viewership is highest among the 25–34 age group, while older segments show higher inactivity, guiding future targeting strategies.
🔶Revenue Growth & Distribution: Jotstar leads in ARPPU (₹261.8) vs. LioCinema (₹92.6), though LioCinema leads in total active paid users. This contrast highlights opportunities in merging content strength with subscriber scale.

Conclusion

This project enables Lio’s management to understand the unique strengths and growth levers of both platforms. .
By providing deep insights into user behavior, content preferences, and financial performance, the analysis supports a smooth and profitable merger.
It positions the future Lio-Jotstar platform to dominate the Indian OTT market with a strong foundation of strategic intelligence.

Comprehensive Analysis of India's EV Market

This project, part of Codebasics Resume Project Challenge #12, provides insights to AtliQ Motors for their electric vehicle (EV) launch in India. It involves a comprehensive analysis of key market metrics, regional insights, manufacturer performance, seasonal trends, and future projections to support AtliQ Motors' strategic decision-making

Objective

To deliver actionable insights for AtliQ Motors regarding the electric vehicle market in India. This analysis helps the company understand the market landscape, identify growth opportunities, and forecast future trends, aiding their EV launch strategy.

Highlights

🔶Comprehensive Sales Overview: Analysis of quarterly and monthly EV sales in India, focusing on trends in 2-wheeler and 4-wheeler segments.
🔶Manufacturer Performance: Insights into the performance of key EV manufacturers, highlighting top performers and their contributions to the market.
🔶Regional Insights: State-wise analysis of EV sales, penetration rates, and revenue to identify regions with high adoption potential.
🔶Seasonal Sales Trends: Evaluation of seasonal patterns in sales, supported by metrics like year-over-year (YoY) growth, EV-PCS ratio, and CO2 savings.
🔶Correlation Coefficient Analysis: Identifying correlations between public charging station (PCS) availability and EV sales to understand regional market dynamics.
🔶Future Projections: Forecasts for EV sales, revenue, and penetration rates by 2030, helping AtliQ Motors gauge market potential and prioritize investment.
🔶Top Manufacturers and States: Analysis of leading manufacturers like OLA Electric, TVS, and Ather, along with top-performing states such as Maharashtra and Karnataka.
🔶Projected EV Penetration by 2030: Projections of EV sales and penetration rates across different states and vehicle categories.
🔶Revenue Growth Forecast: Estimations of revenue growth for top states and manufacturers, providing AtliQ Motors with strategic insights for their market entry.

Conclusion

This project equips AtliQ Motors with a detailed understanding of the Indian EV market, including current trends and future projections.
By offering data-driven insights into regional performance, manufacturer contributions, and market growth forecasts, this analysis supports AtliQ Motors in making informed decisions for their electric vehicle launch in India, ensuring they are well-positioned to capture market share in the evolving landscape.

Business Insights 360

Business Insight 360 is a comprehensive analytics solution designed to provide key performance insights across multiple business domains, including Finance, Sales, Marketing, and Supply Chain.
The project leverages Power BI for creating dynamic visualizations and utilizes DAX Studio for optimizing DAX queries and enhancing report performance.

Objective

To develop an intuitive dashboard that consolidates key business metrics for executives and decision-makers, providing actionable insights into net sales, gross margins, customer performance, product analysis, and operational efficiency across regions and categories.

Highlights

🔶Consolidated Business Insights: Developed dashboards for Finance, Sales, Marketing, Supply Chain, and Executive views to provide holistic insights into business performance.
🔶Optimized Performance: Used DAX Studio to improve query performance, reducing report load time and enhancing user experience.
🔶Benchmarking: Incorporated filters for comparing key metrics such as net sales and gross margin against last year’s performance and target benchmarks.
🔶Regional Performance Analysis: Provided sub-region performance metrics, highlighting net sales, gross margins, and net profit trends for different geographies.
🔶Customer and Product Insights: Top and bottom customers and products analyzed based on net sales, helping identify key drivers of revenue and areas for improvement.
🔶Performance Matrix: Visualized the gross margin percentage and net profit performance by product category and customer, facilitating targeted marketing and sales strategies.
🔶Forecast Accuracy and Net Error Tracking: Implemented forecast accuracy metrics and net error tracking for the Supply Chain, helping mitigate inventory-related risks like excess stock and out-of-stock issues.
🔶User-friendly Filters: Dynamic filters for regions, customers, products, and time periods, allowing users to drill down into specific metrics and perform detailed comparisons.
🔶Risk Management: Key performance indicators, such as forecast accuracy and risk profiles for excess inventory and out-of-stock issues, are tracked and analyzed for better supply chain management.

Conclusion

The Business Insight 360 project delivers a powerful, data-driven solution for business leaders, offering comprehensive insights into various aspects of company performance.
By leveraging DAX Studio for query optimization, the dashboard ensures efficient performance, empowering users to make informed, data-backed decisions.
This project showcases the ability to handle complex data sets, optimize performance, and create impactful visualizations for enterprise-wide analysis.

AtliQ Hardware: Finance and Supply Chain Analytics

This project focuses on using MySQL to perform detailed finance and supply chain analysis for AtliQ Hardware.
The project covers critical business areas such as sales performance, market dynamics, and customer behavior, while also providing valuable insights to forecast supply chain trends.

Objective

To leverage MySQL for analyzing AtliQ Hardware’s complex datasets, providing actionable insights into sales performance, identifying top markets and products, and improving supply chain efficiency through advanced data analysis.

Highlights

🔶Sales Performance Analysis: Generated reports detailing individual product sales for Croma India, allowing for performance tracking throughout the fiscal year.
🔶Top 5 Reports: Created detailed reports on the top 5 markets, customers, and products based on net sales for the fiscal year 2021, helping identify key revenue drivers.
🔶Market Share Insights: Analyzed market share percentages across regions like APAX, LATAM, and NA, with Amazon leading in multiple areas.
🔶Customer Segmentation: Generated reports on customer net sales percentages in different regions, providing insights into customer behavior and regional preferences.
🔶Yearly Sales Report: Created a yearly gross sales report for Croma India, identifying fiscal year performance trends.
🔶Supply Chain Forecasting: Provided forecasts for supply chain trends, helping AtliQ Hardware optimize inventory management and reduce excess stock.

Conclusion

The AtliQ Hardware: Finance & Supply Chain Analytics project provides crucial business insights through MySQL-based data analysis.
The project not only enhances the understanding of sales performance, customer behavior, and market dynamics but also contributes to improving supply chain efficiency.
This data-driven approach enables AtliQ Hardware to make informed decisions, optimize operations, and drive future growth.

AtliQ Hardware: Sales & Finance Analysis

This project focused on analysing the sales and financial performance of AtliQ Hardware across different regions, products, and customers using Excel.
The project highlights key trends in net sales, market share, and performance against targets, offering a comprehensive view of the company's business metrics.

Objective

To analyze AtliQ Hardware’s sales and finance data using Excel, providing actionable insights into customer and product performance, market trends, and overall financial health across multiple regions.
The goal is to help the company assess sales performance, identify top and bottom products, and improve strategic decision-making.

Highlights

🔶Net Sales Performance: Analyzed net sales for top customers like Amazon, AtliQ Exclusive, and Flipkart, highlighting significant growth from 2019 to 2021.
🔶Product Performance Analysis: Identified the top 10 products by sales growth, with the AQ Smash 2 and AQ Mx NB achieving the highest growth rates.
🔶Regional Performance Evaluation: Provided region-wise sales data, revealing India as the largest market, with sales of ₹161.3M in 2021.
🔶Comparison Against Targets: Highlighted market performance against 2021 targets, showing regions such as the USA and India slightly underperforming, while others like South Korea and Philippines showed strong growth.
🔶Division-Level Sales: Detailed the sales performance of major divisions, including N&S, P&A, and PC, which collectively grew by over 200% from 2020 to 2021.
🔶Customer Segmentation: Analyzed sales for top customers, including Amazon and AtliQ eStore, and identified trends in customer purchase behavior.
🔶Financial Metrics Overview: Provided a comprehensive financial analysis, including gross sales, performance against target percentages, and top markets for AtliQ Hardware.

Conclusion

This Sales & Finance Analysis project offers a detailed look into the company’s financial and sales performance using Excel.
By providing insights into key metrics such as top-performing products, regional market trends, and financial targets, this project supports AtliQ Hardware in making data-driven decisions that can drive growth and improve operational efficiency.

Exploring Workforce Dynamics through HR Analytics

This project leverages Tableau and SQL to create an HR analytics dashboard, providing key insights into employee attrition, satisfaction ratings, and workforce demographics.
The dashboard presents critical HR metrics in a visually intuitive format, enabling data-driven decisions for human resources management.

Objective

To analyze HR data and develop a comprehensive Tableau dashboard that tracks employee count, attrition rates, satisfaction levels, and other key metrics.
The goal is to provide actionable insights to improve employee retention and overall organizational performance.

Highlights

🔶Employee Count and Attrition Rate: Displayed the total employee count (1,470) and an attrition rate of 16.12%, offering insights into workforce size and turnover
🔶Attrition by Department and Gender: Analyzed department-wise and gender-wise attrition, showing that R&D had the highest attrition (56.12%), with male employees accounting for 150 of the attritions​
🔶Employee Age Group Distribution: Visualized employee count by age group, with the largest group being 30-33 years old.
🔶Job Satisfaction Analysis: Provided job satisfaction ratings across various roles, indicating that research scientists had the highest satisfaction, while sales representatives showed lower satisfaction
🔶Attrition by Education Field: Identified attrition rates based on employees' education backgrounds, with life sciences and medical fields showing the highest turnover​.
🔶SQL Query Integration: Used SQL queries to calculate key metrics like employee count, average age, attrition rate, and department-wise attrition, ensuring data accuracy and consistency across the dashboard​.
🔶Job Role Satisfaction Crosstab: Implemented a crosstab query in SQL to present job satisfaction levels by job role, facilitating a detailed understanding of employee morale.

Conclusion

The HR Analytics Dashboard provides a powerful visual and data-driven solution for tracking key HR metrics.
By combining Tableau’s visualization capabilities with SQL-based data queries, the dashboard enables HR managers to make informed decisions to improve employee retention, enhance satisfaction, and address workforce challenges efficiently.
This project demonstrates the effective use of data analytics for HR management and decision-making.

Digital Marketo to Their New Office.

Nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in iis qui facit eorum claritatem. Investigationes demonstraverunt lectores legere me lius quod ii legunt saepius. Claritas est etiam processus dynamicus, qui sequitur mutationem consuetudium lectorum.

Nobis eleifend option conguenes.

Mauris tempor, orci id pellentesque convallis, massa mi congue eros, sed posuere massa nunc quis dui. Integer ornare varius mi, in vehicula orci scelerisque sed. Fusce a massa nisi. Curabitur sit amet suscipit nisl. Sed eget nisl laoreet, suscipit enim nec, viverra eros. Nunc imperdiet risus leo, in rutrum erat dignissim id.

Ut rhoncus vestibulum facilisis. Duis et lorem vitae ligula cursus venenatis. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc vitae nisi tortor. Morbi leo nulla, posuere vel lectus a, egestas posuere lacus. Fusce eleifend hendrerit bibendum. Morbi nec efficitur ex.

Mauris tempor, orci id pellentesque.

Nulla non ligula vel nisi blandit egestas vel eget leo. Praesent fringilla dapibus dignissim. Pellentesque quis quam enim. Vestibulum ultrices, leo id suscipit efficitur, odio lorem rhoncus dolor, a facilisis neque mi ut ex. Quisque tempor urna a nisi pretium, a pretium massa tristique. Nullam in aliquam diam. Maecenas at nibh gravida, ornare eros non, commodo ligula. Sed efficitur sollicitudin auctor. Quisque nec imperdiet purus, in ornare odio. Quisque odio felis, vestibulum et.