Axel Berron
Microsoft Fabric & Power BI Developer
Experience
Microsoft Fabric & Power BI Developer
Energy Industry
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
Microsoft Fabric & Power BI Developer
International Logistics Corporation
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
Microsoft Fabric & Power BI Developer
Entertainment Industry
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
Power BI Developer
International Trade Corporation
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
Power BI Developer
Automotive Supplier Industry
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
Power BI Developer
Telecommunication
- Development of dashboards in Power BI for monitoring and analyzing the recommendation system
- Integration and optimization of ETL processes with Python and PostgreSQL
- Administration of Power BI Service workspaces as well as role and permission concepts
- Development of a notification dashboard for monitoring ETL and batch pipelines
- Handover and knowledge transfer of the developed dashboards and processes to an internal BI analyst
Power BI Developer
Pharmaceutical Industry
- Development of T-SQL-based ETL processes and data marts
- Creation of Power BI reports for 30M+ records
- Administration of Power BI Service including user and role management
- Performance optimization through efficient data modeling and DAX optimizations
Power BI Developer
Banking and Financial Services
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
Power BI Developer
Telecommunication
- Development of Power BI dashboards for sales and controlling analyses
- Creation and optimization of ETL pipelines
- Requirements analysis with business units to define relevant KPIs, reports, and data models
- Development of data marts in MS-SQL
BI Consultant & Data Analyst
Various Clients
- Creation of reports and analyses for international clients in industries such as healthcare, banking, and higher education
- Execution of cost analyses and forecasts to optimize IT systems
- Development of SQL-based ETL pipelines for data integration
- Development and delivery of dashboards with Tableau and Power BI
- Collaboration with clients’ IT departments to prepare and process infrastructure and business data
- Application of statistical methods to improve SEO analyses (on-page and off-page optimization)
- Analysis of web traffic and business KPIs (e.g., Customer Lifetime Value, Conversion Rate, Bounce Rate)
Skills
Power Bi Stack:
- Parameter
- Slicer
- Drillthrough
- Tooltips
- Row-level Security (Rls)
- Object-level Security (Ols)
- Power Bi Desktop
- Tabular Models
- Dax
- Tmdl
- Power Bi Service
- Power Query
- Tabular Editor
- Bravo
- Alm Toolkit
- Dax Studio
Microsoft Fabric Stack:
- Onelake
- Lakehouse
- Warehouse
- Dataflow
- Pipelines
- Real-time Analytics
- Notebooks
- Activator
- Cost Optimization & Capacity Management
- Databricks
- Sql
Technologies:
- Etl/elt
- Apache Spark (Pyspark)
- Databricks
- Power Apps
- Power Automate
- Azure Cloud
- Data Modeling
- Azure Devops
- Git
- Jira
- Confluence
- Apache Airflow
- Dbt
- Azure Data Factory
- Python
Databases:
- Oracle Sql
- Sql Server / Ms-sql
- Postgresql
- Azure Sql
- Snowflake
- Salesforce
- Star Schema
- Snowflake Schema
Frameworks:
- Scrum
- Agile
- Data Governance
- Best Practices For Performance & Security
Programming Languages:
- Python
- Bash Scripting
Languages
Education
Master in Data Science · Data Science
Bachelor in Applied Mathematics · Applied Mathematics
Certifications & licenses
Databricks Certified Associate Developer for Apache Spark 3.0
Microsoft Certified: Azure Data Scientist
Microsoft Certified: Fabric Data Engineer
Microsoft Certified: Power BI Data Analyst
Similar Freelancers
Discover other experts with similar qualifications and experience