Power BI Consultant in Germany

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide contextual business information.

Development of an AI agent with Function/Tool Calling for secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Build-up of automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and service principal, as well as integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

Focus areas: knowledge transfer, reporting, cost analysis Tasks

• Ensure knowledge transfer from the outgoing controller
• Document key controlling processes
• Operational controlling (cash flow planning, reporting)
• Simplify the cost center structure to improve cost analysis Results
• Transparent knowledge transfer and sustainable documentation of controlling processes
• Improved cost analysis and more efficient reporting

• IT consulting
• Power Platform & Databricks
• AI software development (custom software)
• Commercial responsibility for the company

• Built a Python pipeline that converts lectionary web content into structured daily JSON, applying liturgical-calendar rules for accurate weekday and Sunday coverage.
• Shipped a read-only FastAPI REST API with shared Pydantic models and delivered a Kirundi-first web client for browser and mobile use.
• Owned the data layer and backend architecture, collaborating closely on system architecture and interfaces while automating refreshes with GitHub Actions and validating the ETL with pytest.
• Impact: Created a reliable, API-driven source of truth for daily Bible readings in Kirundi, enabling consistent access to previously unstructured content.

• Evaluate, design, and implement Power BI solutions for Cat4 reporting, significantly improving reporting efficiency, accuracy, and stakeholder visibility.
• Develop and maintain robust data integration interfaces between Cat4 and Power BI, eliminating manual processing bottlenecks.
• Configure and continuously optimise Power BI reports to deliver sharper management insights and support data-driven decision-making.
• Ensure full GDPR data protection compliance across Power BI reports, proactively identifying and mitigating risks.
• Acquired in-depth product knowledge of CAT4, a globally deployed enterprise platform, enabling effective requirements analysis, solution design, and seamless Power BI integration across client environments.
• Developed and integrated scalable reporting templates within the CAT4 product interface, delivering new product features and enhancing data visualisation, reporting efficiency, and stakeholder visibility across global users.
• Trained and mentored staff on Power BI configuration and best practices, accelerating adoption and embedding a data-driven culture.
• Prepared clear technical documentation and delivered hands-on demonstrations to end users and clients, ensuring smooth adoption and confident use of Power BI solutions integrated with CAT4.
• Researched and recommended licensing strategies for cost-effective and scalable Power BI deployment.

SKILLS - BI & Visualisation: Power BI (Desktop, Service, Report Builder), DAX, Power Query

Project and Product Management Tool: CAT4

• KPI dashboards for inventory and goods received quality control & testing ETL, dataset, dataflows and report development, complex DAX solutions

Data sources: Dataverse, RDB, Excel

Tools: ETL, data modeling, data flows, Power Query, M, Power BI, complex DAX

• Capacity: 25%

• Analysis of web and campaign performance to derive actionable insights for marketing and growth optimization
• Implementation and maintenance of tag management solutions to ensure reliable and consistent data collection
• Continuous development and optimization of reporting structures with a focus on scalability and data quality
• Conducting regular deep-dive analyses and leading monthly stakeholder sessions to present findings and align on optimization measures
• Designing and managing end-to-end data flows from data collection to visualization
• Tools: GA4, Google Tag Manager, Looker Studio, Airbyte, BigQuery

• Performance optimization and centralization of reporting by creating data models using SSMS (SQL) & SSAS (DAX) and integrating data via SSIS
• Optimizing and extending the current PowerBI dataset (in parallel until the SSAS data model is ready)
• Expanding current reports (migrating reporting to SSAS source after building the SSAS data model)
• Conducting regression analyses, cohort analyses, price/quantity analyses, and strategy project success analyses
• Training internal team members

• Planning, steering, and monitoring the Corporate Responsibility Tech Enablement project for IT
• Concept and implementation of the EUDR (EU Deforestation Regulation)
• Concept and implementation of the Eco-Design Regulation
• Continued support of projects within the Corporate Responsibility strategy
• Definition and review of guidelines (e.g. governance, success metrics) and, if needed, analysis of issues and their solutions
• Overall project management, marketing, communication, and quality assurance for the projects
• Creation of the project plan including timeline/roadmap, budget, and resources
• Ensuring compliance with budget and deadlines
• Defining guidelines for project control, methods, and priorities
• Planning and tracking resources and effort, also together with other IT teams
• Evaluation of projects and preparation of results (reporting to management)
• Identification and reduction of risks
• Regular communication with stakeholders
• Steering internal and external stakeholders and service providers (Jira, Confluence, backlog management, task tracking, SharePoint, MS 365 platform etc.)
• Development of standards and process automation

Label: Azure Cloud, Jira, Confluence, Power BI, SAP BW, AWS, Miro, Bee360, Draw.io, SharePoint, MS 365 platform, Trello etc.

• Data / product analysis & visualisation in Tableau Desktop
• Stakeholder Management

• In-depth forensics of old and new data sources
• Enhancing existing reports and creating new data analyses
• Data preparation from source systems and semantic models
• Azure DevOps integration
• Tools/Skills: MS-PowerBI, DAX, MS-Office 365, PowerQuery, M, PowerAutomate, Redmine, SharePoint, SQL (T-SQL, Oracle), MS Fabric

The project aims to migrate the company's existing Power BI Premium environment to Microsoft Fabric. This migration includes moving the existing data models, reports, and dashboards to the new platform to take advantage of the extended features and improved performance of Microsoft Fabric. The solution will be deployed in various regions worldwide to ensure a unified and consistent reporting and analytics environment for all locations.

Requirements analysis, migration planning, data migration, adapting reports and dashboards, testing and validation, training and support, deployment and monitoring, regional rollout.

• Migrated sales reporting to Power BI
• Trained the department in Power Query and DAX
• Set up a data warehouse for optimal data processing

• Created Power BI reports and data models
• Connected existing reports to new data sources
• Structured and selected foundational data
• Developed KPIs