Achyut Golakiya

Data Analyst with ML Skills

[email protected] +49 17660378714

Resume

Hello, I am

Achyut Golakiya.

2

Excel
Projects

3

PowerBI
Projects

1

SQL
Project

About Me

Aspiring Data Analyst and BI Dashboard Developer with a background in IT and Electrical Engineering, currently pursuing a Master’s degree in Electrical and IT at OVGU Magdeburg. As a student research assistant, I focus on data science, business research projects, and developing BI dashboards. I am passionate about transforming raw data into actionable insights through visualization to solve challenges and drive meaningful outcomes.

🎯 Goal: Bridge the gap between raw data and impactful insights, making data-driven decisions clear and accessible.

🔍 What I Seek: An opportunity to apply my skills, tackle challenges, and contribute to teams valuing data-driven solutions.

💡 Belief: Data analysis isn’t just about tools; it’s about the “why” behind the data—understanding domains, solving problems, and aligning with stakeholder goals.

🌟 Value I Add: With adaptability, analytical thinking, and presentation skills, I bring a fresh perspective.

Key Skills

Python

Power BI

BI tools

Tableau

Excel

SQL

Advanced Microsoft Excel

Qlik

AI-based Forecasting

My Projects

Sales Analytics & P&L Reporting for AtliQ Hardware

Domain/Function: Finance/Accounting, Business Intelligence

Coffee Shop Dashboard

Domain/Function: Retail/Operations

Business Insights 360 Dashboard for AtliQ Hardware

Domain/Function: Business Analytics, Data Visualization, Financial Analysis, Sales Analytics, Supply Chain Optimization

Healthcare Dataset - Patients Waitlist Analysis

Domain/Function: Healthcare / Hospitality Analysis

CodeX - Provide Insights to the Marketing Team

Domain/Function: Food & Beverage Industry

AtliQ Mart Supply Chain Analysis

Domain/Function: Supply Chain Analytics

My Experience

OVGU, Magdeburg – Working Student (Data Analyst)
Feb 2024 – Dec 2024

Designed ETL workflows in the data warehouse (DWH), integrating 80–90% of dispersed data into a unified platform and improving data quality by 85%.
Built Power BI dashboards to analyze EV and ICE vehicle sales trends, providing insights to identify high-demand locations in Germany and India, aiding strategic business decisions.
Conducted data cleaning and transformation using Excel and SQL joins, ensuring precise calculations of NPV and IRR for project viability assessments.
Collaborated with research teams to align data analytics projects with business goals, enhancing the university's strategic initiatives.
Presented key findings through engaging visualizations and storytelling techniques, influencing research directions and decision-making.

AtliQ Technologies and Hardware, USA & India – Data Analyst Intern (Remote)
Nov 2023 – Jan 2024

Cleaned and standardized large HR datasets using Python and Excel, eliminating 100% of duplicates, transforming date formats, and mapping status values to enhance analysis consistency by 90%.
Designed ETL workflows using SQL and Power BI, converting de-normalized datasets into structured fact and dimension tables, resulting in an 85% improvement in data quality and integration.
Performed variance analysis in Excel and Power BI, identifying up to 95% of discrepancies in order and delivery quantities, and delivered actionable insights to stakeholders through detailed reports.

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

Python: Beginner to Advanced For Data Professionals

Tableau Mini

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Microsoft Fabric Mini: For Data Analysts

Crash Course on Python (Google)

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.

Mail Me

[email protected]

https://www.linkedin.com/in/achyut-golakiya-b133bb20b/

Call Me

+49 17660378714

GitHub

https://github.com/Golakiyaas

Excel Project

Sales Analytics & P&L Reporting for AtliQ Hardware

Domain/Function: Finance/Accounting, Business Intelligence

Automated financial data cleaning and report generation using Excel Power Query and DAX, reducing manual effort by over 4 hours weekly. Designed dynamic reports that allowed real-time financial insights.

View Project
on GitHUB

View Project
on

Overview of new products, highlighting key metrics and trends to track performance and market impact.

A visual comparison of market performance against targets that helps identify high-value customers and those who need additional attention, such as of

Project Details

Sales Report:
Objective:
1. Create a customer performance report.
2. Compare market performance with sales targets.

Purpose: Help businesses track and assess their sales performance.

Importance: Identifying sales trends and key metrics.

Report Role: Guide customer discount strategies, support negotiations, and highlight potential expansion opportunities in promising markets.

Finance Report:
Objective:
1. Generate Profit & Loss (P&L) reports for fiscal years and months.
2. Create P&L reports segmented by market.

Purpose: Assess financial performance, support decision-making, and improve communication with stakeholders.

Importance: Benchmarking against industry peers and historical data. Foundation for budgeting and forecasting.

Report Role: Align financial planning with company goals and boost confidence in financial forecasts.

Excel Project

Coffee Shop Dashboard

Domain/Function: Retail/Operations

This project involved creating an Excel-based interactive dashboard for a coffee shop, analysing online platform-sourced transactional data from January to June 2023. It identified key sales trends, customer behaviour, and product performance insights to optimize operations across multiple location.

View Project
Engagement

View Project
on Microsoft Excel

Interactive dashboard overview displaying transaction trends. Detailed slicer view for revenue and transaction segmentation by location.

Recommended analysis showing sales trends by time of day, product category performance, and peak transaction periods for optimizing store operations,

Project Details

This Coffee Shop Dashboard project used transactional data from an online platform (January-June 2023) to provide insights into sales, customer behavior, and product trends at three NYC locations. Data preparation involved cleaning and adding calculated fields like revenue and time metrics for detailed analysis. Excel Pivot Tables were used to identify trends such as monthly revenue growth, peak transaction times, and product performance. The dynamic dashboard featured interactive slicers and charts for easy exploration of key metrics. Insights included a 100% revenue growth, with Coffee (39% of total sales) as the top-selling category and Barista Espresso as the top-selling product. Morning hours (7-11 AM) accounted for 45% of daily transactions. These insights support optimization for better profitability.

Project video

PowerBI Project

Business Insights 360 Dashboard for AtliQ Hardware

Domain/Function: Business Analytics, Data Visualization, Financial Analysis, Sales Analytics, Supply Chain Optimization

Business Insights 360 is a comprehensive Power BI dashboard designed to analyze finance, sales, marketing, and supply chain metrics, providing stakeholders with actionable insights to enhance decision-making across various departments and drive strategic growth.

Other Tools

Excel

MySQL

DAX

User-empathetic landing page as a part of dashboard design

Data Model: Incorporating 10+ Tables

Project Details

The Business Insights 360 project presents a Power BI dashboard that aggregates key metrics from finance, sales, marketing, supply chain, and executive operations. By integrating data from Excel/CSV files and MySQL databases, this project offers real-time reporting and visualizations to improve business processes. Using techniques like data modeling and DAX calculations, the dashboard provides insights such as financial trends, customer and product performance, market trends, forecast accuracy, and error metrics. It helps stakeholders make informed decisions and aims to increase sales by 10%.

Project video

Live Interactive Dashboard

PowerBI Project

Healthcare Dataset - Patients Waitlist Analysis

Domain/Function: Healthcare / Hospitality Analysis

This Power BI project analyzes publicly available waitlist data for inpatient and outpatient categories. It provides insights into current waitlist trends, specialty-level details, and patient age profiles, enabling better healthcare decisions.

Other Tools

Excel

Summary dashboard showcasing waitlist trends and real-time insights.

Details Page of Granular Analysis: A deep dive into specialty-level and age profile analyses, offering nuanced insights for targeted improvements.

Project Details

This Power BI project focuses on analyzing healthcare waitlists using a public dataset. The data includes two categories:

1. Inpatient data: Patients admitted to the hospital for treatment.
2. Outpatient data: Patients receiving treatment without admission.

Objective:
1. Track real-time patient waitlists for efficient management.
2. Analyze historical trends in inpatient and outpatient categories for better planning.
3. Provide specialty and age-based insights for targeted improvements.

Steps Involved:
1. Data collection, cleaning, and transformation.
2. Developing interactive dashboards with clear metrics.
3. Ensuring data refresh and consistent updates.

Key Metrics:
1. Average median waitlist to measure system efficiency.
2. Current waitlist to track real-time patient flow.

The dashboard includes a summary page for trends and a detailed page for specialty and demographic analysis.

Project video

Live Interactive Dashboard

SQL Project

CodeX - Provide Insights to the Marketing Team

Domain/Function: Food & Beverage Industry

This project was created for CodeX, a German-based food & beverage company. It focused on transforming survey data from 10,000 customers in 10 Indian cities into valuable insights, using SQL queries and Power BI for analysis and visualization.

View Project
on GitHub

Other Tools

PowerPoint

Power BI

This page is specifically designed for consumer preferences, including ingredients, packaging and more.

Specifically designed for demographic information, including user preferences for gender, age group and marketing preferences related to energy drinks

Project Details

The CodeX energy drink survey collected data from 10,000 customers across 10 cities in India. As a Data Analyst, I used SQL queries to extract, aggregate, and transform the data, creating Views for automatic updates without requiring code changes. Power BI was used to visualize insights, providing actionable recommendations to CodeX’s marketing team for brand growth. These insights covered key demographics like age, gender, and preferences related to energy drinks, helping the team optimize their strategies. The survey results were designed to automatically refresh for seamless decision-making.

PowerBI Project

AtliQ Mart Supply Chain Analysis

Domain/Function: Supply Chain Analytics

Performed data analysis and designed a dashboard to track and improve service levels for AtliQ Mart, an FMCG manufacturer, using metrics like On-Time (OT%) and In-Full (IF%) deliveries, highlighting delays and production challenges.

View Project
on GitHUB

Other Tools

Excel

ChatGPT

The data model screenshot shows the relationships between order data, product details, delivery schedules, and customer targets.

Power BI dashboard providing visual insights into delivery performance, showing key metrics, and filtering options for order analysis.

Project Details

As part of the October Codebasics challenge, I conducted a detailed supply chain analysis for AtliQ Mart, focusing on key metrics like OT%, IF%, and OTIF%. I designed a Power BI dashboard to monitor and measure delivery performance for customers, uncovering major insights such as delays in deliveries, issues in production, and customer service impacts.