Migration of Tableau dashboards to Power BI, including transfer of KPI logic
Reconstruction and optimization of ETL pipelines in Microsoft Fabric with Dataflows and PySpark, including cost optimization
Design and implementation of a Medallion architecture (Bronze, Silver, Gold)
Establishment of governance standards and creation of documentation
Close collaboration with stakeholders to define and validate reporting requirements
Onboarding of business units into the self-service data platform
Successfully migrated reports to Power BI
Medallion architecture established as the foundation for self-service BI
Data processing times significantly reduced through optimized pipelines and PySpark in Fabric
Business units enabled to create their own reports in Power BI
Development of Power BI dashboards and apps for supply chain and management reporting
Consolidation of data from SQL Server, Snowflake, Databricks, and SAP into Microsoft Fabric
Expansion and optimization of the Data Warehouse
Development of high-performance ETL workflows with Dataflow, SQL scripts, and PySpark
Harmonization of KPIs for standardized reporting
Strengthening of data governance structures (access rights, roles, data quality, RLS)
Training of users in the use of Power BI
Proof of concept for real-time reporting with Apache Kafka in Power BI
Requirements analysis with business departments
Proof of concept for real-time reporting with Apache Kafka in Fabric and Power BI
Successful consolidation of heterogeneous data sources in Microsoft Fabric
Development of Power BI dashboards for management and supply chain reporting
Setup of a test environment in Microsoft Fabric to evaluate functions and architectural approaches
Development of initial ETL processes in Fabric for data source integration
Design and validation of a Medallion architecture as the foundation for a future self-service data platform
Creation of POC reports in Power BI to demonstrate the platform’s capabilities
Documentation of results and derivation of recommendations for a potential rollout
Estimation and analysis of costs as well as capacity management within the Fabric evaluation
Proof of feasibility of Fabric & Power BI as a future-proof analytics platform
Establishment of a pilot framework as the foundation for potential organization-wide adoption
Creation of Power BI reports with parameters, slicers, bookmarks, and complex DAX calculations
Execution of detailed analyses on product and customer performance (e.g., ABC analyses, cohort analyses, CLV, conversion rates)
Modeling of data structures using Star Schema and Snowflake Schema
Development and optimization of ETL pipelines (SQL, Python, Power Query) for consolidating data from multiple source systems
Documentation in Confluence
Management of user roles, permissions, and workspaces in Power BI Service
Training of Power BI power users in applying best practices
Setup of custom validation rules and automated notifications
Reduced processing time by 40% through refactoring of a complex ETL pipeline
Delivery of management dashboards
Development and maintenance of Power BI dashboards for controlling and management
Implementation of advanced features in Power BI (DAX measures, parameters, interactions with slicers and bookmarks)
Modeling of data marts to optimize storage and query performance
Creation and optimization of ETL pipelines with Python, Oracle SQL (views, tables, PL/SQL), and Power Query / Dataflows
Development of monitoring dashboards with predefined automated notifications in Power BI
Adaptation of data governance structures (role and permission concepts)
Training of end users in the use of Power BI dashboards and in building Power BI reports
Development of high-performance and user-friendly dashboards
Performance optimization through efficient data models and optimized ETL pipelines
Creation of interactive Power BI reports
Reconstruction and optimization of the Data Warehouse to accelerate data provisioning and reduce storage requirements
Optimization of existing Power BI reports to shorten loading and response times
15x acceleration of Power BI reports through optimization of the Data Warehouse and reports
I have extensive expertise in Microsoft Fabric and Power BI, building agile and optimized data solutions across multiple industries such as energy, logistics, entertainment, automotive, and telecommunications. I design Medallion architectures, streamline ETL pipelines with PySpark and SQL, and excel at consolidating heterogeneous data sources for self-service BI and real-time reporting.
I focus on delivering measurable improvements, reducing processing times and establishing efficient data governance. My background in data science and applied mathematics, along with several key certifications, underpins my ability to translate complex requirements into simple, impactful analytics solutions.
Discover other experts with similar qualifications and experience
2025 © FRATCH.IO GmbH. All rights reserved.