Portfolio - Karthikeya Anusury | Codebasics

Powered by
Codebasics DA Bootcamp

Karthikeya Anusury

Data Aspirant

EMAIL

[email protected]

PHONE

+353 873635297

About Me

Welcome! I’m a Data Analyst & Engineer Turning Data into Impact.
With over 3 years of hands-on experience, I specialize in transforming complex datasets into strategic insights that fuel business growth. My expertise spans across SQL, Python, Power BI, DAX, AWS, and Azure Data Platforms — enabling me to build scalable data pipelines and intuitive dashboards that drive informed decision-making. I’ve delivered high-impact solutions across industries, known for collaborating seamlessly with cross-functional teams to bring data to the heart of business strategy. I’m currently open to full-time Data Analytics roles and internship opportunities in Ireland, where I can apply my analytical mindset, technical skills, and business acumen to make a measurable difference.

2

PowerBI Projects

1

SQL Project

Key Skills

Python

SQL

PowerBI

Excel

AWS

Git

API

MySQL

SSMS

SSAS

MongoDB

Docker

Google Sheets

Data Wrangling

Data Visualization

Microsoft Azure

ETL

OOP

My Projects

My Experience

• Utilized advanced SQL for transforming unstructured datasets to a structured format, resulting in an increase in data

reliability and enhanced business decision-making.

• Collaborated with cross-functional teams to develop and maintain Microsoft Power BI dashboards, enhancing efficiency

in data visualization and facilitating data-driven decision-making.

• Conducted data validation and quality checks, improving accuracy and reducing reporting errors by 25%.

• Streamlined data cleaning and data preparation processes for large datasets in Excel using advanced functions and

pivot tables, reducing inconsistencies and improving data accuracy by 25%.

• Participated in Agile ceremonies and worked closely with developers and QA to align features with business objectives.

• Engaged in review meetings and stand-up calls with stakeholders and senior management, providing accurate KPIs

for performance reports to enhance decision-making and project alignment.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

AWS Cloud Technical Essentials

AWS Cloud Technical Essentials

Python for Data Science, AI & Development

Python for Data Science, AI & Development

Introduction to Data Engineering

Introduction to Data Engineering

Programming for Everybody (Getting Started with Python)

Programming for Everybody (Getting Started with Python)

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]

Call Me

+353 873635297

LinkedIn

https://www.linkedin.com/in/karthik-anusury

GitHub

https://github.com/AnusuryKarthikeya

PowerBI Project

AtliQ Mart - Supply Chain Analysis

Domain/Function: Supply Chain

AtliQ Mart, an FMCG manufacturer in Gujarat, faced customer retention issues due to inconsistent delivery performance—specifically delays and incomplete shipments. To address this, the supply chain analytics team developed a Power BI dashboard to monitor On-Time (OT%), In-Full (IF%), and On-Time In-

View Project
on GitHUB

AtliQ Mart - Supply Chain Analysis

Data Model

AtliQ Mart - Supply Chain Analysis

PowerBI Dashboard

Project Details

AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India, currently operational in Surat, Ahmedabad, and Vadodara. They plan to expand to other metro and Tier 1 cities in the next two years.

However, a few key customers did not renew their annual contracts due to service issues. Some essential products were either not delivered on time or not delivered in full consistently, leading to poor customer experience.

The management wants to resolve this before expansion and requested the supply chain analytics team to track ' On Time' and 'In Full' delivery service levels daily to respond swiftly to issues.

Live Interactive Dashboard

PowerBI Project

Hospitatlity Revenue Booking Trends PowerBI Dashboard

Domain/Function: Hospitality

This project presents a comprehensive Hospitality Analytics Dashboard that provides valuable insights into hotel performance across multiple cities. Built using a dataset covering May to July, the dashboard allows users to analyze key performance indicators (KPIs) such as Revenue, Occupancy %, ADR,

View Project
on GitHUB

Other Tools

Power Query

Hospitatlity Revenue Booking Trends PowerBI Dashboard

Data model

Hospitatlity Revenue Booking Trends PowerBI Dashboard

Power BI Dashboard

Project Details

Key Metrics Visualized:
Revenue: Total revenue across hotels
RevPAR (Revenue Per Available Room)
ADR (Average Daily Rate)
Occupancy %
DSRN (Daily Sold Room Nights)
Realisation %
Revenue by Hotel Category (Luxury vs. Business)
Trends Over Time (by Week)
Performance by City and Property
Realisation % and ADR by Booking Platform
Weekday vs. Weekend Metrics

Live Interactive Dashboard

SQL Project

COVID-19 Global Health Trends Using SQL

Domain/Function: Health Care

This project focuses on exploring and analyzing global COVID-19 data using SQL. It utilizes two key datasets — CovidDeaths and CovidVaccinations — to uncover trends in infection rates, death percentages, and vaccination progress across countries and continents

View Project
on GitHUB

COVID-19 Global Health Trends Using SQL

SQL Queries

COVID-19 Global Health Trends Using SQL

SQL Queries

Project Details

Project Overview:
This project focuses on exploring and analyzing global COVID-19 data using SQL. It utilizes two key datasets — CovidDeaths and CovidVaccinations — to uncover trends in infection rates, death percentages, and vaccination progress across countries and continents. The analysis is performed using SQL queries aimed at answering real-world questions about the pandemic's impact. The final result offers insights that could support public health decision-making and awareness.

Tools & Technologies Used:
SQL Server (or compatible relational databases like PostgreSQL or MySQL)
Public COVID-19 Datasets from Our World in Data

Datasets Used:
CovidDeaths
CovidVaccinations

Key Analysis Topics:
Trends in total cases and deaths across countries
Death percentages relative to reported cases
Infection rates by population
Countries with the highest impact (deaths, cases, infection percentage)