Powered by
Codebasics DA Bootcamp

Hello, I am

Albert Grzegorczyk

Administration Specialist

Resume

3

PowerBI
Projects

About

Me

111

Key

Skills

PowerBI

SQL

MySQL

Advanced Excel

My

Projects

Bussines Insights 360

Bussines Insights 360

Domain/Function: Sales Analytics

AtliQ Hardware encountered constraints when handling data in Excel. Goal: Transition from Excel to Power BI to gain understanding. Aim: Attain understanding in the realms of finance, sales, and supply chain. Quantity: 1.8 million entries. Software: SQL, Power BI, Excel, DAX Studio.

AtliQ Grands Hospitality Analysis

AtliQ Grands Hospitality Analysis

Domain/Function: Hospitality Analysis

Created a Power BI dashboard for AtliQ Grands. The goal: help a declining 5-star hotel chain regain market share by identifying underperforming hotels and improving financial and logistic decisions.

Freelancing Analysis

Freelancing Analysis

Domain/Function: Freelancing Analysis

Created an interactive Power BI dashboard using freelancing data from Kaggle. It shows global trends in hourly rates, ratings, and experience by country, skill, and gender. Great tool for career planning or freelance benchmarking.

My

Experience

Specjalista ds. Administracji, PZU. 12.2025-obecnie

● Przy pomocy PowerQuery zautomatyzowałem proces rozliczania faktur oraz raportowania kluczowych informacji o wykonanych usługach.

● Zbudowałem zautomatyzowany raport przy pomocy PowerQuery oraz PowerPivot, który ułatwia planowanie oraz zarządzanie budżetem przeznaczonym na delegacje służbowe.

Koordynator ds. Operacyjncyh, PZU. 06.2023-12.2024

● Przy pomocy Excela oraz miar statystycznych utworzyłem plik pomagający wyliczyć zapotrzebowanie na roboczogodziny konsultantów, dzięki czemu zredukowałem koszty generowane przez zespół.

● Tworzyłem zestawienia oraz raporty wspomagające bieżącą pracę zespołu, pod kątem jakości, wykrywania nieprawidłowości oraz terminowości wykonywanych zadań.

Konsulant w Zespole Zamykania Kosztów, PZU. 11.2022-06.2023

● Zoptymalizowałem proces rozliczania faktur, redukując czas rozliczenia pojedynczej faktury z 6 minut do 3.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

Contact Me

Email

[email protected]

Linkedin

https://www.linkedin.com/in/albert-grzegorczyk-73b113371/

Call

+48 793990386

Albert Grzegorczyk

Administration Specialist

Download Resume

Resume

PowerBI Project

Bussines Insights 360

Domain/Function: Sales Analytics

AtliQ Hardware encountered constraints when handling data in Excel. Goal: Transition from Excel to Power BI to gain understanding. Aim: Attain understanding in the realms of finance, sales, and supply chain. Quantity: 1.8 million entries. Software: SQL, Power BI, Excel, DAX Studio.

View Project
Engagement

Other Tools

SQL

Bussines Insights 360

Established realtions between tables

Bussines Insights 360

Home View that allows to shwitch between desired view for analysis

Project Details

This (Power BI + SQL + EXCEL) Project is about AtliQ Hardware, a global consumer electronics firm, facing operational challenges due to reliance on Excel for data analysis. In a few countries, this resulted in substantial losses. Senior executives plan to invest in a data analytics project utilizing last year's data to drive performance improvement.

📈Financial View: Delve deep into the Profit and Loss statements, analyze the trends in Net Sales Performance, and conduct an examination of top-performing Products and Customers using various criteria.

💼Sales View: Immerse yourself in the performance of both Customers and Products.

📣Marketing View: Uncover insights into Product Performance, and scrutinize Market, Regional, and Customer Performances.

🚚Supply Chain View: Investigate the accuracy of forecasts, Net Errors, Absolute Errors, etc.

🤵Executive view: Integrated view of key insights for executives

Live Interactive Dashboard

PowerBI Project

AtliQ Grands Hospitality Analysis

Domain/Function: Hospitality Analysis

Created a Power BI dashboard for AtliQ Grands. The goal: help a declining 5-star hotel chain regain market share by identifying underperforming hotels and improving financial and logistic decisions.

View Project
Engagement

AtliQ Grands Hospitality Analysis

Overall Analysis Quick view of hotel performance: revenue, occupancy, ratings, trends, and weakest hotels for example AtliQ Seasons.

AtliQ Grands Hospitality Analysis

Logistic Analysis Shows booking distribution by room class and platform. Helps detect empty rooms and high cancellation sources.

Project Details

AtliQ Grands is a 5-star hotel chain in India facing declining market share and revenue due to poor strategic decisions and competitive pressure. I created a comprehensive Power BI dashboard featuring three key reports to support data-driven decision-making:
🔹 Overall Analysis – offers a quick overview of hotel performance, helping identify trends and highlight low-performing locations like AtliQ Seasons.
🔹 Finance Analysis – tracks key metrics like RevPAR, ADR, and Occupancy Rate. A matrix view flags hotels with declining profitability (e.g., AtliQ Grands in July).
🔹 Logistic Analysis – helps manage vacant rooms and optimize booking distribution by room type and platform.
This project showcases my ability to turn raw data into actionable business insights through clear and intuitive dashboard design.

Live Interactive Dashboard

PowerBI Project

Freelancing Analysis

Domain/Function: Freelancing Analysis

Created an interactive Power BI dashboard using freelancing data from Kaggle. It shows global trends in hourly rates, ratings, and experience by country, skill, and gender. Great tool for career planning or freelance benchmarking.

View Project
Engagement

Freelancing Analysis

Explore global freelance trends by rating, gender, and country. Includes hourly rates, experience, and interactive benchmarking.

Freelancing Analysis

Explore global freelance trends by rating, gender, and country. Includes hourly rates, experience, and interactive benchmarking.

Project Details

I built an interactive Power BI dashboard using freelancing data from Urvish Ahir’s Kaggle dataset. The goal was to analyze global trends in hourly rates, ratings, experience, and gender pay gaps across various countries and skills. The dashboard features key KPIs, dynamic filters (by country, skill, gender, and more), and clear visuals to help users explore how freelancers are valued worldwide. One of the most useful insights? The hourly rate distribution chart, which helps users benchmark their rates or find high-paying freelance niches. Whether you're considering a career shift or want to optimize your freelance strategy, this dashboard delivers valuable, data-driven guidance.

Live Interactive Dashboard