Power BI Projects Portfolio

This repository is a portfolio of Power BI projects focused on turning raw data into clear, decision-oriented insights.

The projects combine data preparation, modeling, DAX, and interactive dashboard design across different analytical domains.

---

Overview

The portfolio currently includes:

1. Premier League Player Statistics

Folder: PL_ Player_ Stats

Project focus:
Analysis of player-level performance data from the 2023/24 Premier League season, with emphasis on player profiles, finishing, playmaking, and drill-through analysis.

Highlights:

• data cleaning in Python and Jupyter
• Power BI dashboard with interactive filtering
• performance comparison using goals, assists, xG, and xAG
• player-level drill-through reporting

2. Urban Bike Sharing Analytics Dashboard

Folder: BikeSharing_Project

Project focus:
Analysis of New York City bike-sharing demand using Citi Bike trip data enriched with historical weather data.

Highlights:

• multi-file data preparation in Power Query
• demand analysis by time, rider type, geography, and weather
• interactive Power BI report across multiple analytical pages
• combination of trip and weather data for deeper contextual insights

3. Online Retail Performance Dashboard

Folder: OnlineRetail_Project

Project focus:
Analysis of online retail transaction data to understand sales performance, customer behavior, and seasonal demand patterns.

Highlights:

• Power Query preparation of multi-sheet retail transaction data
• customer segmentation and order-frequency analysis
• revenue analysis by country, product, and time
• interactive Power BI pages focused on executive, customer, and seasonality views

---

Tools and Technologies

• Power BI
• DAX
• Power Query
• Python
• Jupyter Notebook
• CSV and JSON data sources
• Data modeling and dashboard design

---

How To Explore

Each project folder typically contains:

• a project-specific README.md
• the Power BI report file (.pbix)
• source or processed data files
• screenshots of the dashboard
• notebooks or supporting files when relevant

---

Author

Michal Cervenka
Aspiring Data Analyst / BI Analyst

• Location: Brno
• LinkedIn: Michal Cervenka
• Email: cervenka.michal12@gmail.com

---

This repository continues to grow as new Power BI projects are added.