Power BI Expert

The project aims to migrate the company's existing Power BI Premium environment to Microsoft Fabric. This migration includes switching existing data models, reports, and dashboards to the new platform to benefit from the extended features and improved performance of Microsoft Fabric. The solution is deployed in various regions worldwide to provide a consistent reporting and analytics environment for all locations.

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

Multiple Power BI semantic models need to be deployed automatically in parallel to different regions (USA, Switzerland, Germany, Austria) during deployment. The key requirement is that no downtime can occur during deployment.

Planning and implementing a workflow, developing DevOps pipelines, creating Power BI pipelines, conducting requirements analysis and designing the solution architecture.

The company built a global profit and loss reporting for its clients. Each country had different source systems that were consolidated in Power BI. Various timesheet systems and ERP systems were linked and loaded into a semantic data model. Based on this data, a unified global report was created.

Requirements analysis, data acquisition, data preparation, creation of the semantic data model, implementing security and access controls, integration and consolidation, testing and validation, automating deployment, report creation, training and documentation.

A Power BI app was planned, created, and published for a uniform design (CI) of all reports, including access design.

Requirements analysis, solution design, app design, publishing, access design.

For the conveyor system, the client created a Power BI data model. After the reporting went live, users complained about poor performance in the reports. The goal was to analyze and speed up the data model so that acceptance of the self-service solution would not suffer.

Performance analysis of tabular data models, performance optimization in the tabular data model, DAX measure optimization.

Since the introduction of Power BI, there were no standards for using data sources for Power BI in the company. The SSAS cube, Excel or a relational database were used in parts. In this context, a standard data source for Power BI was created. The goal was to review all data models for content and switch them to the harmonized standard data source.

As-is analysis of Power BI reports and data models, performance analysis of tabular data models, performance optimization in the tabular data model.

Weekly sales figures from online shops were prepared in Excel and presented to management. The Excel reports were very time-consuming to maintain and somewhat outdated. With the introduction of Power BI, the reports should get a new design and bring more interactivity to meetings.

Requirements analysis, design and development of tabular data model, creation of Power BI reports & dashboards, implementation of row-level security, preparing KPIs and measures in DAX.

Sustainable products are becoming increasingly important to customers and retail groups. Manual Excel reports are to be replaced by standard SSRS reports. The reporting should not only include standard reports but also spread a self-service BI culture. Microsoft Power BI was introduced for self-service BI requirements. The entire reporting landscape is supplied with data from a data warehouse.

ETL development, data model development, preparing KPIs and measures in DAX, data modeling in Power BI, report creation, permission design for Power BI Report Server.

To support the merger of two large telecom companies, the different data warehouse systems need to be consolidated. This requires strategic consulting on architecture and technology, as well as downstream project-based work. The goal is a comprehensive consolidation of existing warehouse solutions within both companies and a rebuild in certain areas.

Introducing Power BI as a self-service solution. Creating Power BI data models. Implementing a forecasting logic with DAX. Requirements analysis, designing and implementing online performance requirements, close cooperation with departments, implementing ETL processes and standard reports, writing documentation and concepts. Designing and building reporting capabilities with Power BI, developing analytical solutions for departments on the analytical platform, training and coaching client employees in Power BI, creating management-level reports and dashboards, connecting and integrating various data sources to the analysis front-end, advising departments on self-service possibilities of the analytical platform.

Implementation of a new ERP system. A custom solution was replaced.

Requirements analysis, process capturing, solution design, custom reporting (batch traceability), customizing, user training.

For operational business, ERP software SAP Business One was implemented for various clients and adapted to their needs. Adjustments were done mainly in C# and SQL queries. For each project, individual reports were developed with the client and created in SQL, Crystal Reports, or Coresuite layout.

Installation and administration of Microsoft SQL Server, SSRS (purchase analysis, sales analysis, inventory metrics), customizing SAP Business One, installation and administration of Coresuite Cube.