Designing use cases with business units
Developing performance-optimized dashboards
Usability analysis of existing dashboards and optimization
Structuring reporting requirements
Further development of the central data warehouse architecture (Microsoft Fabric)
Creating SQL queries and reports
Designing and developing analysis databases
System documentation
Tools/Skills:**
MS Power BI
DAX
MS Office 365
PowerQuery
M
MS SQL Server
SSIS
SSRS
Power Automate
Microsoft Fabric
Providing reports, dashboards and analyses
Enhancing existing reports and creating new data analyses
Migrating existing reports to Power BI
Preparing data according to data protection requirements for HR/Legal
Tools/Skills:**
MS Power BI
DAX
MS Office 365
PowerQuery
M
Power Automate
Confluence
SharePoint
SQL (MariaDB, MySQL, PostgreSQL, Oracle)
Identifying relevant data sources and stakeholders
Designing consolidation logic and data models
Developing dashboards and interactive visualizations
Implementing reporting structures in compliance with data protection regulations
Tools/Skills:**
MS Office 2013
SQL Server 2019
MDX
M
DAX
T-SQL
Power BI
SharePoint
SSIS
SSAS
SSRS
Building flows for integration of external market data into the BI system from requirements to deployment
Incident management and monitoring activities
Data analysis and mapping
Managing relationships with IT partners in India and Paris as well as with external agencies
Managing relationships with business stakeholders during the assignment
Leading improvement initiatives on the solution with partners
Actively participating in the technical migration from SAP BW to Microsoft BI
Rolling out and decommissioning tools
English communication and documentation management
Leading multiple topics with internal and external stakeholders
Tools/Skills:**
MS Office 2019/365
SQL Server
VBA
MDX
M
DAX
T-SQL
Power BI
SharePoint
Developing an Excel-based processing tool for master data maintenance
Connecting SharePoint data
Developing plausibility checks and validation procedures
Conducting user training and coaching
Tools/Skills:**
MS Excel
VBA
SharePoint
Improving Excel reporting and Access database
Developing VBA and SQL procedures
Rolling out and adapting solutions
Tools/Skills:**
MS Excel 2010
MS Access 2010
PL/2 AS400
VBA
Discover other experts with similar qualifications and experience