top of page
PROJECTS
Useful systems, shown through real outcomes
Explore practical Excel and Power BI work—from business reporting and quality systems to finance, HR, risk, and live-data analytics.
Fleet Performance Dashboard
I was tasked with creating an Excel dashboard to monitor the performance of a fleet of 50 vehicles across multiple regions. The dashboard must include:
- Fuel consumption per vehicle
- Maintenance cost trends
- Vehicle utilization rates
- Alerts for overdue services
- Revenue per Region
- Vehicle Asset cost per day Vs Average Revenue per day
Result: Consolidated 12 vehicle data sources into a single live dashboard. The operations team now reviews fleet performance in under 5 minutes instead of compiling manual weekly reports — saving an estimated 3–4 hours per week.
Time taken: 7 days
- Fuel consumption per vehicle
- Maintenance cost trends
- Vehicle utilization rates
- Alerts for overdue services
- Revenue per Region
- Vehicle Asset cost per day Vs Average Revenue per day
Result: Consolidated 12 vehicle data sources into a single live dashboard. The operations team now reviews fleet performance in under 5 minutes instead of compiling manual weekly reports — saving an estimated 3–4 hours per week.
Time taken: 7 days
Finance Tracker
This task was the creation of a personal finance dashboard in Excel that combines all major financial areas into one structured reporting flow. The workbook is designed to collect and organize assets (Vermögen), debts (Schulden), income (Einnahmen), fixed monthly costs (Fixkosten), and variable costs (Variable Kosten) in separate input sheets, then calculate totals automatically and feed them into a dashboard. The goal is to give a quick overview of key financial indicators such as net worth, monthly surplus, emergency fund, total debt, and expense distribution.
The file was built as a multi-sheet Excel model with a clear input-to-dashboard structure.
So the workbook follows a classic logic:
Input sheets → Totals/Subtotals → Evaluation sheet → Dashboard
Result: Replaced a multi-tab manual bookkeeping system with automated calculations and visual summaries. Monthly financial overview now updates instantly, reducing end-of-month reconciliation time by roughly 70%.
Time taken: 11 days
The file was built as a multi-sheet Excel model with a clear input-to-dashboard structure.
So the workbook follows a classic logic:
Input sheets → Totals/Subtotals → Evaluation sheet → Dashboard
Result: Replaced a multi-tab manual bookkeeping system with automated calculations and visual summaries. Monthly financial overview now updates instantly, reducing end-of-month reconciliation time by roughly 70%.
Time taken: 11 days
Oil prices dashboard
Scope of project
Creation of an interactive Power BI Oil Prices Analysis dashboard to track historical oil price development and its relationship to market events, interest rates, volatility, and OPEC production.
Task and expectation
Build a professional, easy-to-use report with filters and KPIs that lets users quickly analyze price trends, drivers, and changes over time for both management overview and deeper analysis.
Result: Live connection to price feed data with automated daily refresh. Eliminated manual price tracking and gave the team a real-time market view filterable by region and commodity — turning a daily 30-minute task into a zero-effort automated process.
Time taken: 10 days
Creation of an interactive Power BI Oil Prices Analysis dashboard to track historical oil price development and its relationship to market events, interest rates, volatility, and OPEC production.
Task and expectation
Build a professional, easy-to-use report with filters and KPIs that lets users quickly analyze price trends, drivers, and changes over time for both management overview and deeper analysis.
Result: Live connection to price feed data with automated daily refresh. Eliminated manual price tracking and gave the team a real-time market view filterable by region and commodity — turning a daily 30-minute task into a zero-effort automated process.
Time taken: 10 days
Executive Performance Hub
I was helping creating a dynamic, interactive dashboard within provided existing Excel spreadsheet. Lot of P&L sheets and inputs that needed to consolidated and nicely adjusted into interactive dashboard.
Scope of work
- Design and create an interactive dashboard in Excel.
- Clean up existing graphs in the spreadsheet.
Result: Unified KPIs from sales, operations, and finance into one executive view with drill-through capability. Board reporting preparation dropped from a full day of manual consolidation to under an hour.
Time taken: 3 days
Scope of work
- Design and create an interactive dashboard in Excel.
- Clean up existing graphs in the spreadsheet.
Result: Unified KPIs from sales, operations, and finance into one executive view with drill-through capability. Board reporting preparation dropped from a full day of manual consolidation to under an hour.
Time taken: 3 days
Quality System Metrics Dashboards
Scope of project
Development of an interactive Quality System Metrics dashboard in Power BI to consolidate and monitor Deviations, CAPAs, and Change Controls in one reporting solution.
Task and expectation
Build a dashboard that accepts raw QEdge Excel exports, automatically cleans and structures the data, and presents key metrics side by side for fast analysis of created, closed, overdue, and open items, including trends, contributors, and status comparisons.
The solution was delivered in 5 days.
Development of an interactive Quality System Metrics dashboard in Power BI to consolidate and monitor Deviations, CAPAs, and Change Controls in one reporting solution.
Task and expectation
Build a dashboard that accepts raw QEdge Excel exports, automatically cleans and structures the data, and presents key metrics side by side for fast analysis of created, closed, overdue, and open items, including trends, contributors, and status comparisons.
The solution was delivered in 5 days.
Risk Management Analytics
Scope of project
Development of a fully interactive Risk Management dashboard in Power BI to monitor risks across departments, including controls, mitigation plans, and target values.
Task and expectation
Build a clear and professional report that shows how many risks each department has and visualizes high, medium, and low risks by category, so users can quickly identify critical areas and track mitigation status.
The solution was delivered in 4 days.
Development of a fully interactive Risk Management dashboard in Power BI to monitor risks across departments, including controls, mitigation plans, and target values.
Task and expectation
Build a clear and professional report that shows how many risks each department has and visualizes high, medium, and low risks by category, so users can quickly identify critical areas and track mitigation status.
The solution was delivered in 4 days.
Spa Manager Executive Dashboard
Scope of project
Development of a Spa Manager Executive Dashboard to monitor key spa performance metrics, including MTD revenue, plan vs. actual, payroll, productivity, retail performance, treatment KPIs, and P&L indicators.
Task and expectation
Build a compact executive Exxcel report that gives management a quick view of financial performance, daily trends, category mix, and short-term operational results, so they can track whether the spa is on track against budget and monthly targets.
The solution was delivered in 10 days.
Development of a Spa Manager Executive Dashboard to monitor key spa performance metrics, including MTD revenue, plan vs. actual, payroll, productivity, retail performance, treatment KPIs, and P&L indicators.
Task and expectation
Build a compact executive Exxcel report that gives management a quick view of financial performance, daily trends, category mix, and short-term operational results, so they can track whether the spa is on track against budget and monthly targets.
The solution was delivered in 10 days.
HR Interactive dashboard
Scope of project
Development of an interactive Executive HR Dashboard to monitor key workforce metrics such as active headcount, leavers, attrition, tenure, salary, workforce composition, and turnover trends.
Task and expectation
Build a clear HR reporting solution with filters for job category, unified job title, job level, location, department, and year, allowing users to analyze leavers, attrition by role/category, top job titles, workforce split, marital status, and common leaving reasons in one place.
The solution was delivered in 4 days.
Development of an interactive Executive HR Dashboard to monitor key workforce metrics such as active headcount, leavers, attrition, tenure, salary, workforce composition, and turnover trends.
Task and expectation
Build a clear HR reporting solution with filters for job category, unified job title, job level, location, department, and year, allowing users to analyze leavers, attrition by role/category, top job titles, workforce split, marital status, and common leaving reasons in one place.
The solution was delivered in 4 days.
Spotify/Streaming History Dashboard
Scope of project
Development of an interactive music streaming analytics dashboard to analyze personal listening history, including artists, albums, tracks, listening time, and discovery patterns.
Task and expectation
Build a modern report that turns raw streaming history into clear insights such as most played content, monthly and hourly listening trends, accumulated activity, and artist discovery over time.
The solution was delivered in 5 days.
Development of an interactive music streaming analytics dashboard to analyze personal listening history, including artists, albums, tracks, listening time, and discovery patterns.
Task and expectation
Build a modern report that turns raw streaming history into clear insights such as most played content, monthly and hourly listening trends, accumulated activity, and artist discovery over time.
The solution was delivered in 5 days.
Ultimate Guitar Executive Dashboard
Scope of project
Development of an interactive guitar/music content dashboard to analyze songs, artists, tabs, chords, views, ratings, and content trends across decades.
Task and expectation
Build a professional dashboard that helps users quickly identify most popular songs, recently added tabs, top daily content, type distribution, and view trends over time through dynamic filters and ranked visuals.
The solution was delivered in 7 days.
Development of an interactive guitar/music content dashboard to analyze songs, artists, tabs, chords, views, ratings, and content trends across decades.
Task and expectation
Build a professional dashboard that helps users quickly identify most popular songs, recently added tabs, top daily content, type distribution, and view trends over time through dynamic filters and ranked visuals.
The solution was delivered in 7 days.
Global COVID-19 Dashboard
Scope of project
Development of an interactive global COVID-19 dashboard to monitor cases, deaths, tests, vaccinations, and geographic spread across continents and countries.
Task and expectation
Build a report that allows users to filter by region and explore key KPIs, daily developments, and map-based comparisons for a fast executive overview and deeper analysis of pandemic trends.
The solution was delivered in 15 days.
Development of an interactive global COVID-19 dashboard to monitor cases, deaths, tests, vaccinations, and geographic spread across continents and countries.
Task and expectation
Build a report that allows users to filter by region and explore key KPIs, daily developments, and map-based comparisons for a fast executive overview and deeper analysis of pandemic trends.
The solution was delivered in 15 days.
Latest Earthquakes dashboard
Scope of project
Development of an interactive Latest Earthquakes dashboard in Power BI to monitor recent global earthquakes, with focus on location, magnitude, frequency, depth, and regional activity. Data is live from ETH Zurich, Swiss.
Task and expectation
Build a clear and dynamic report that lets users filter earthquakes by region, country, magnitude range, and date, while providing a quick overview of total quakes, weekly activity, average depth, average magnitude, and the most active regions worldwide.
The solution was delivered in 10 days.
Development of an interactive Latest Earthquakes dashboard in Power BI to monitor recent global earthquakes, with focus on location, magnitude, frequency, depth, and regional activity. Data is live from ETH Zurich, Swiss.
Task and expectation
Build a clear and dynamic report that lets users filter earthquakes by region, country, magnitude range, and date, while providing a quick overview of total quakes, weekly activity, average depth, average magnitude, and the most active regions worldwide.
The solution was delivered in 10 days.
Annual Financial Statements
Scope of project
Development of an interactive Annual Financial Statements Excel (Macro triggered) dashboard/tool to present the full financial picture of a business across Profit & Loss, Balance Sheet, Cash Flow Statement, and Owner’s Equity in one structured reporting solution.
Task and expectation
Build a professional and easy-to-use report that lets users review current vs. previous period values, percentage changes, and key financial components with supporting visuals, navigation, and transaction input options for faster financial analysis and reporting.
The solution was delivered in 15 days.
Development of an interactive Annual Financial Statements Excel (Macro triggered) dashboard/tool to present the full financial picture of a business across Profit & Loss, Balance Sheet, Cash Flow Statement, and Owner’s Equity in one structured reporting solution.
Task and expectation
Build a professional and easy-to-use report that lets users review current vs. previous period values, percentage changes, and key financial components with supporting visuals, navigation, and transaction input options for faster financial analysis and reporting.
The solution was delivered in 15 days.
bottom of page