Thomas R.-BI Consultant and Power BI Developer

Focus:

Consulting in reporting and project management for Power BI

Goal:

Creation of IT application dashboards for business areas

Activities:

• Technical consulting and support in managing and coordinating an existing reporting setup
• Structured collection, analysis, and preparation of business reporting requirements
• Technical coordination with defined internal contacts
• Design and optimization of Power BI reports to improve data analysis
• Development of concepts and recommendations for the further development of an efficient and transparent reporting system
• Support in the user-friendly visualization of relevant company KPIs as a basis for decision-making

Tools/Skills: MS-PowerBI, DAX, MS-Office 365, PowerQuery M, BCS

Renewable Energy

Focus:

BI consulting and Power BI / MS-Fabric / ETL development

Goal:

Development of a cloud solution in MS-Fabric

Activities:

• Create transparency around data quality and define a reliable data architecture
• Clear, well-founded definition of KPIs, reports, and visualizations
• Development of high-performance, analytically meaningful data models based on the star schema or the bottom-up Kimball approach as a foundation for Power BI
• Planning, implementation, testing, and deployment of RLS and OLS for the user group
• Provision of meaningful, user-focused dashboards.
• Data migration, transformation, and modeling (concept and development)
• Visualization in PowerBI and creation, further development, and improvement of existing BI reports
• Documentation, knowledge transfer, MS-SQL, Oracle, Power Query, Power BI

Tools/Skills: MS-PowerBI, DAX, MS-Office 365, PowerQuery M, PowerAutomate, SharePoint, SQL (MS-SQL, Oracle), MS Fabric, pySpark, KQL

Telecommunications

Focus:

BI consulting and Power BI development

Goal:

Expansion and optimization of existing Power BI reporting

Activities:

• In-depth forensics of old and new data sources
• Further development of existing reports and creation of new data analyses
• Data preparation (star schema) from source systems and semantic models
• Integration of RLS to restrict data visibility for users outside the department
• Integration of Azure DevOps

Tools/Skills: MS-PowerBI, DAX, MS-Office 365, PowerQuery, M, PowerAutomate, Redmine, SharePoint, SQL (T-SQL, Oracle), MS Fabric

PPE Personal Protective Equipment

Focus:

Conducting a sales potential analysis for Germany

Objective:

Identifying sales weaknesses and sales controlling

Activities:

• Researching, modeling, preparing and calculating potential data
• Geographical allocation / cleansing of the customer base
• Aggregating and regionalizing sales
• Generating regional sales territories (routing, based on customer and potential shares, etc.)
• Cartographic and tabular presentation of results, result documentation
• Deriving recommended measures to increase market penetration

Tools/Skills: MS-PowerBI, Power Query, M, DAX, M, Jet-SQL (MS-Access), GfK RegioGraph

Telecommunications

Focus:

BI consulting and Power BI development

Objective:

Building a reporting platform with Microsoft Power BI

Activities:

• Providing reports, dashboards and analyses
• Further developing existing reports and creating new data analyses
• Migrating existing reports to Power BI
• Creating semantic models and datasets according to the star schema
• Preparing data in accordance with data protection requirements for HR/Jus and internal training on handling personal data
• Setting up RLS for data visibility when using data from HR
• NPS, target group selection, evaluation

Tools/Skills: MS-PowerBI, DAX, MS-Office 365, PowerQuery, M, PowerAutomate, Confluence, SharePoint, SQL (MariaDB, MySQL, PostgreSQL, Oracle)

Cosmetics industry

Focus:

Data quality assurance, ETL/CUBE loading procedures, reporting

Goal:

Migration from SAP BW to Microsoft BI, ensuring data quality

Responsibilities:

• Monitoring ETL processes, test and validation procedures
• Developing new CUBE loads for the D-A-CH region
• Reporting with MS-Excel, SSRS and Power BI
• Creating datasets/semantic models based on star schema for division-specific BI teams
• Authorization management (Active Directory)

Tools/Skills: MS-Office 2019/365, SQL-Server, VBA, MDX, M, DAX, T-SQL, PowerBI, SharePoint

Logistics

Focus:

Reporting & database adjustments

Goal:

Improvement of Excel reporting and Access database

Responsibilities:

• Development of VBA and SQL procedures
• Rollout and adjustments

Tools/Skills: MS-Excel 2010, MS-Access 2010, PL/2 AS400, VBA

Ophthalmic care

Focus:

Regional potential analyses for an operational ophthalmology center on the Lower Rhine

Goals:

Expansion of the surgical services, estimation of market coverage

Responsibilities:

• Derivation / validation of market potential, research (DeStatis, GfK, mb-research)
• Data preparation, imports, calculations and reporting.
• Visualization with desktop mapping software RegioGraph
• Reporting, address research and validation (established physicians), geocoding
• Competitive environment

Tools / Skills: Data storage with MS-Access, visualization with RegioGraph, reporting with MS-Excel

Educational institution

Focus:

Maintenance and ensuring the functionality of databases

Objectives:

Taking over the existing database environment after the death of the previous provider

Activities:

• Maintenance, assistance, user support
• Integration of new tasks and procedures for third-party forms
• Definition of permissions, stored procedure definition
• Automation of exam registrations with BAMF

Tools / Skills MS-SQL-Server, MS-Access 2007 with ADP connection, T-SQL

Crafts

Recruitment

Mechanical Engineering

Consumer Electronics

Industry

Self-employed IT consultant since 2005