Powered by
Codebasics DA Bootcamp

Latika

Data Aspirant

+91 9560538138 [email protected]

Resume

Hello, I am

Latika.

2

PowerBI Projects

1

Excel Project

About Me

Welcome! I'm Latika Verma, an aspiring Data Analyst with a passion for making sense of data. I have a Bachelor's degree in Computer Science and am currently working as an Associate Software Engineer. However, my heart lies in data analytics.

I am skilled in using Excel, Power BI, SQL, and Python to analyze data and uncover valuable insights. I enjoy turning complex data into clear, actionable information that helps drive decisions.

My goal is to use my skills to create data-driven solutions and make a positive impact. I'm excited to connect with professionals and organizations that value the power of data. Let's transform data into success together!

Key Skills

Python

SQL

My Projects

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.

[email protected]

https://www.linkedin.com/in/latika-verma-20729b167/

+ 91 9560538138

PowerBI Project

AtliQ Hospitality

Domain/Function: AtliQ Hospitality

The project aims to identify weaknesses and analyze revenue trends for luxury and business-class hotels. This involves data cleaning, modeling, and DAX functions. The goal is to help the AtliQ revenue team increase bookings by 20%.

View Project
Engagement

AtliQ Hospitality

This visualization displays revenue data segmented by city and platform status. It provides valuable insights into areas where revenue performance is

AtliQ Hospitality

This view includes a table and visualizations of weekend and weekday bookings at Atliq Hotel. The third visualization highlights the weeks with the hi

Project Details

The objective of this project is to identify where the business is failing and analyze the revenue trends for
luxury and business-class hotels.
• The project involves data cleaning, data modeling, and the use of DAX functions.
• This analysis aims to assist the AtliQ revenue team in increasing their bookings by 20%.

Project video

Live Interactive Dashboard

PowerBI Project

Supply Chain

Domain/Function: Supply Chain

AtliQ Mart will track daily 'On-Time Delivery (OT) %', 'In-Full Delivery (IF) %', and 'On-Time In-Full (OTIF) %' to resolve service issues and meet targets before expanding to new cities.

Monitoring these KPIs daily allows the Supply Chain team to quickly identify and resolve issues, ensuring that service levels meet targets.

By improving these metrics, AtliQ Mart aims to enhance customer satisfaction and reliability.

Project Details

AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts 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 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 daily basis against the target service level set for each customer.

Live Interactive Dashboard

Excel Project

Sales

Domain/Function: Sales

Analyzed revenue trends to identify key factors driving performance, including top customers, products, and regions. Shared valuable insights with the team to optimize strategies.

View Project
on GitHUB

Assisted the team in analyzing revenue trends based on various factors, including top customers, products, and geographic regions.

The screenshot presents an analysis of technological trends across various years, states, and product categories.

Project Details

Developed a comprehensive profit trends report that provides insights into the most profitable categories and customers over a 4 year period.
By utilizing Power Query Editor for data cleaning and visualization techniques such as charts, cards, tables, and filters.
Created a clear and actionable representation to identify key categories, profit drivers, and high-value customers.