Portfolio - Anupama B K | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Anupama B K

Data Aspirant

EMAIL

[email protected]

Download CV

About Me

Exploring the why behind the numbers, one dataset at a time.

2

PowerBI Projects

1

Excel Project

Key Skills

Microsoft Excel

Power BI

Power Query

ETL

DAX

My Projects

My Experience

Way2Wealth Pvt Ltd. - Project Intern

Developed skills in equity market research, fundamental and technical financial analysis, and technical report writing.
Used 6 years of historical data to perform correlation (–0.55) and regression analysis (R² = 44.6%) using Excel.

A.C. Venkatesha & Co. - Intern

Supported monthly closing activities by processing ~100 GST compliant invoices using Tally Gold, ensuring accurate input tax credit recording.
Reconciled banking transactions ranging over a 6-month period, helping reduce ledger discrepancies and streamline audit readiness.

Awards & Certificate

Excel: Mother of Business Intelligence

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

Fundamentals of Financial Management Certification | SWAYAM

Fundamentals of Financial Management Certification | SWAYAM

Accounting Fundamentals | Corporate Finance Institute

Accounting Fundamentals | Corporate Finance Institute

Let's Work Together!

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.

EMAIL

[email protected]

LinkedIn

https://www.linkedin.com/in/anupamabk24

GitHub

https://github.com/anu-gith/Portfolio_Projects

PowerBI Project

OTT Merger Analysis

Domain/Function: Data Analysis

Extracting strategic insights to support merger decision between two popular OTT companies. Exploring key performance and behavioural insights to support the upcoming Liocinema-Jotstar merger. Analysing user growth, content consumption, inactivity, and plan movement across both platforms

View Project
Engagement

View Project
on GitHUB

OTT Merger Analysis

Engagement is broad-based across user segments for Jotstar, while Watch time is heavily concentrated for Liocinema.

OTT Merger Analysis

The age group 18-34 years drive nearly 45% of the revenue earned through subscription.

Project Details

Executed complete ETL process with Power BI for analysis of Content library analysis, Subscriber growth,
Upgrade/downgrade behaviour analysis across age, subscription plan & city tiers for 2 OTT Domain Companies through a
live dashboard.
Identified that users in the top 10th percentile drive a significant share of total watch time.
Recognized that the age group 18-34 years drive nearly 45% of the revenue earned through subscription.

Live Interactive Dashboard

Excel Project

AN ANALYSIS ON DIGITAL LITERACY: A DATA DRIVEN PERSPECTIVE An Analysis on Digital Literacy: A Data Driven Perspective

Domain/Function: Data Analysis

Analysis on the digital literacy knowledge of rural and semi-rural population before and after training sessions and its impact on employment status of the population.

View Project
Engagement

View Project
on GitHUB

AN ANALYSIS ON DIGITAL LITERACY: A DATA DRIVEN PERSPECTIVE An Analysis on Digital Literacy: A Data Driven Perspective

Total difference between pre-training (25.17) and post-training scores (60.24) is significant, showing huge improvements due to training sessions.

AN ANALYSIS ON DIGITAL LITERACY: A DATA DRIVEN PERSPECTIVE An Analysis on Digital Literacy: A Data Driven Perspective

Younger age groups have more level of engagement, due to higher focus levels on the content and curriculum of training sessions.

Project Details

Several government agencies and programs, non-profit organizations and even
corporations as a part of their CSR initiative have been making efforts to provide the
necessary resources and training programs to make rural and semi-rural populations
more digitally literate. This data analysis project is a step towards understanding the
efficiency of these programs.
Analyses like these can be used by the organizations or resource persons who are actively
participating in the digital literacy programs. It helps to understand how well the training
materials are being communicated to the population, how to distinguish between
different sectors of the population such as age and educational background in order to
make the sessions more engaging and effective for each group.

PowerBI Project

HR Analytics Dashboard

Domain/Function: Data Analysis

Analysis of the attendance data of employees over a period of 3 months to extract insights such as - 🔹 Employee presence percentage 🔹 Work from home percentage 🔹 Sick leaves percentage

View Project
Engagement

View Project
on GitHUB

HR Analytics Dashboard

KPI Analysis % of Presence of employees over time % of opting Work From Home over time % of Sick Leaves among employees over time

HR Analytics Dashboard

Observations derived from analysis.

Project Details

The primary objective of the analysis is to extract insights about the attendance patterns of employees over a period of three months. The main KPIs of this analysis include:
KPIs
% of Presence of employees over time
% of opting Work From Home over time
% of Sick Leaves among employees over time

Tools used:
🔸 Power Query to clean and transform the data
🔸 DAX functions to create measures that help in defining the KPIs and help in deeper analysis
🔸 Power BI visualizations to present the insights effectively through dashboard.