Powered by
Codebasics Bootcamp

Akula Bhargavi

Data Aspirant

Hello, I am

Akula Bhargavi.

1

Excel Project

5

PowerBI Projects

About Me

Hello!!!

"Welcome to my portfolio!

I'm excited to embark on a journey toward a career in data analysis. With a background in civil engineering and a strong grasp of statistics, I bring a unique blend of skills to the table, poised for precise problem-solving and data-driven insights.

I strive to fuel business growth with actionable insights. Proficient in SQL, Power BI, and advanced Excel, I'm passionate about collaborating with industry experts and providing innovative perspectives in dynamic data analysis. As my professional journey begins to unfold, my portfolio showcases impactful business projects, revealing my ability to transform raw data into actionable insights and make a meaningful impact through analytics.

Let's connect and explore how we can leverage our skills to drive innovation and success together!

Key Skills

Excel

PowerBI

Sql

statistical knowledge

stakeholder management

effective communication

presentation skills

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

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

Python For Beginner and Intermediate Learners

Data Analytics Bootcamp 3.0: With Practical Job Assistance + AI for Data Analysts

Scam Awareness Course

virtual internship

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.

https://www.linkedin.com/in/akula-bhargavi/

Excel Project

Sales and Finance Analytics Project of Atliq Hardwares(FMCG)

This project aims to provide a thorough examination of the company's financial well-being and its position in the market. This entails creating various reports, including "Customer Net Sales Performance" and "Market Performance vs. Target," utilizing a blend of fundamental and advanced Excel.

View Project
Engagement

Sales and Finance Analytics Project of Atliq Hardwares(FMCG)

The report summarizes the annual net sales performance for each customer.

Sales and Finance Analytics Project of Atliq Hardwares(FMCG)

This report enables stakeholders to assess the country's performance across several years and compare it with predetermined targets.

Project Details

In this project, I utilized Excel pivot tables to create a comprehensive sales report. This report equips businesses with the ability to fine-tune customer discounts, streamline negotiations, and pinpoint expansion opportunities in promising countries. The generated reports offer practical insights and suggestions to help businesses refine sales strategies, elevate customer satisfaction, and optimize revenue generation.

Throughout this project, I gained proficiency in:

Pivot table implementation
Power Query utilization
Basics of DAX
Conditional Formatting techniques
Enhancing report aesthetics
Understanding key sales metrics

this project aims to empower businesses with tools for monitoring, evaluating, and enhancing sales efforts. Through sales data analysis, businesses can unveil opportunities, drive growth, and stay competitive in a dynamic market.

PowerBI Project

Atliq Business Insights 360

AtliQ Hardware, a swiftly growing consumer electronics company, faces challenges in competing with data-driven rivals due to a dependency on Excel for most of its reports. The goal is to shift data from Excel to Power BI, enabling insightful and informed decision-making.

View Project
Engagement

Atliq Business Insights 360

Crafting a user-engaging landing page is a crucial component of integrating it into our dashboard design.

Atliq Business Insights 360

Data modelling involving 10+ tables

Project Details

This project integrates Power BI, SQL, and Excel to address operational issues at AtliQ Hardware, a leading global electronics company. Heavy dependency on Excel for data analysis resulted in significant losses in some regions. To remedy this, senior management is launching a data analytics project using the previous year's data to enhance performance.
Finance View: Displays profit and loss (GM, NP, NS) and performance trends.
Sales View: Highlights customer and product performance, unit economics, and NS/GM% metrics.
Marketing View: Focuses on region and product performance, unit economics, and NS/GM% metrics.
Supply Chain View: Features forecast accuracy, Net Error, trends, and key metrics by customers and products.
Executive View: Showcases competitor market share, trends, revenue by division and channel, and top 5 customers.

Live Interactive Dashboard

PowerBI Project

Providing Insights to the Revenue Team - Hospitality Analysis

AtliQ Grands adopts data-driven strategies for market share and revenue revival. I've crafted metrics, dashboards, and insightful solutions for strategic success in the hospitality sector.

View Project
Engagement

Providing Insights to the Revenue Team - Hospitality Analysis

Dashboards Home Page

Providing Insights to the Revenue Team - Hospitality Analysis

Data Model

Project Details

My dashboard insights aid AtliQ Grands in refining sales tactics, elevating customer satisfaction, and optimizing revenue amid hospitality industry competition.

I utilized:

Power Query for data connection and transformation
Star schema for data modeling
Basic DAX and calculated columns
Hospitality-specific metrics
Various charts and tooltip feature

Market share recommendations:

• Employ a dynamic pricing strategy for weekdays/weekends and business/leisure segments.
• Continuously analyze booking trends and customer preferences for informed decision-making.
• Leverage price elasticity for peak season pricing.
• Enhance customer satisfaction through online review analysis.
• Implement dynamic pricing for revenue optimization across all properties and platforms.

These insights empower AtliQ Grands to elevate revenue, tailor promotions effectively, and stay competitive.

Live Interactive Dashboard

PowerBI Project

Shield Insurance

I utilized Power BI to dissect Shield Insurance's customer behavior and sales trends. My data analytics internship culminated in a comprehensive end-to-end project, where I meticulously analyzed provided CSV files, showcasing my proficiency in extracting meaningful insights from complex datasets.

View Project
Engagement

Shield Insurance

The homepage serves as a visual gateway, offering a panoramic view of diverse pages that facilitate the exploration of pivotal insights.

Shield Insurance

Diagram view

Project Details

Utilized Power BI to conduct a thorough examination of Shield Insurance, delving into revenue streams, customer interactions, sales modes, and age group dynamics. Crafted a comprehensive report that paved the way for strategic decision-making and actionable suggestions, ultimately contributing to an anticipated 8-10% uptick in revenue and an augmented market footprint through data-driven insights.

Live Interactive Dashboard

PowerBI Project

Sales Analysis Dashboard

Leverage sales data analysis to pinpoint top-selling products, revenue metrics, and trends, empowering informed business decisions for growth and competitiveness.

View Project
Engagement

Sales Analysis Dashboard

This sales data dashboard snapshot provides a clear and intuitive overview, empowering informed decision-making for enhanced outcomes.

Sales Analysis Dashboard

This sales data dashboard snapshot provides a clear and intuitive overview, empowering informed decision-making for enhanced outcomes.

Project Details

Project Aim: Scrutinizing sales data to draw valuable insights for savvy decision-making in a business context.

⚒ Tool Used: Power BI for data transformation and visualization, incorporating DAX functions to formulate calculated measures and columns.

🎯 Key Performance Metrics:
Total Revenue: Monitoring the cumulative sales figures.
Total Quantity: Keeping track of the overall volume of products sold.
Profit Margin: Assessing profitability measures.

Also analyzed-
✔Sales by Month
✔Top 5 Best Selling Products
✔Hourly Sales trend
✔Top 5 Cities by Sales Count
✔Top 5 Products by Sales Count

Live Interactive Dashboard

PowerBI Project

HR ATTRITION EMPLOYEE DASHBOARD

introducing the "HR Analytics Navigator": Revolutionizing HR decision-making through advanced data refinement and visualization techniques, elevating workforce insights for strategic empowerment. 🚀

View Project
Engagement

HR ATTRITION EMPLOYEE DASHBOARD

home page

HR ATTRITION EMPLOYEE DASHBOARD

Demographics view

Project Details

📊 Data Visualizations:
✔ Kpi's
✔ Donut chart
✔ Stacked column chart
✔ funnel
✔ clustered bar chart
✔ pie chart
✔ line chart
✔ table

🔎Key Findings:
🔆 Total Attrition count 237 at the rate of 16%
🔆 Active Employees 1233 at the rate of 84%
🔆 Job Role Count 9
🔆 Average Monthly Income 6.50k
🔆 Hourly Rate 65.89
🔆 Male employees are more likely (63.29%) than Female employees (36.71%).
🔆 Life Sciences has the highest number of employees and Human Resources has the lowest.
🔆 The highest attrition is from the Research and Development (R&D) department followed by the Sales and Human Resource department.

Live Interactive Dashboard

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.