Gurpreet Dhami - Power BI Consultant for Financial Analytics

🚀 FRATCH GPT 2.0 - Find freelancers with a single prompt. Now including price benchmarking.

Recommended expert

Munich, Germany

Check rate

Experience

May 2024 - Aug 2024

4 months

Anonymous – German building materials manufacturer

Creation of the profit center report and statistical metrics report
Gathering and analysis of requirements regarding the forecast for revenue and costs
Implementation of various time series analyses and optimization of forecasts
SAP process knowledge, SQL, Python
Python with various libraries for time series analysis and Machine Learning

Jan 2024 - Jan 2025

1 year 1 month

Anonymous – Leading European defense company

Consulting, performance optimization and support in the IBCS-compliant creation and adaptation of various reports, including the cost center report, Quality Management report and various reports in the areas of Finance, HR and Sales
Gathering and analysis of requirements regarding cost center reporting
Creation and adaptation of ETL pipelines using Pentaho Data Integration software and SQL
IBCS-compliant visualization of the cost center report with Power BI and Zebra BI
Consulting on a more performant technical implementation of incremental and rolling updates of very large and wide fact tables to optimize the daily data refresh of the SSAS Tabular models on SQL Server Analysis Services
Consulting and support in adapting various other reports
Knowledge of SAP ERP, Controlling, SQL, VertiPaq and Tabular Model development with DAX
MS Power BI Report Server, MS SQL Server Analysis Services, Oracle 19c database and Pentaho Data Integration, Tabular Editor 3, DAX Studio, Zebra BI, Power Shell, Jenkins

Jan 2024 - Jan 2025

1 year 1 month

Anonymous – Large German laboratory service provider

Consulting and support in replacing manual, Excel/PowerPoint-based profit center reporting with an automated IBCS-compliant Power BI reporting system, including connection to the on-premises SAP BW/4Hana system and other data sources
Gathering and analysis of requirements regarding profit center reporting
Creation and adaptation of ETL pipelines with SAP BW4Hana and SQL
MS Power BI, Tabular Editor 3, DAX Studio

Jan 2023 - Apr 2023

4 months

Anonymous – Leading European energy supply company

Introduction of Microsoft Power Automate (Process Advisor) as a Process Mining solution and implementation of a comprehensive operational Power BI report to analyze the SAP PM(EAM) and MM processes of two business units
Consulting on the technical requirements for securely integrating the new solution into the existing Azure Cloud IT infrastructure (firewall rules, Azure Storage Accounts, Access Management, Power BI REST API connection via Service Principal)
Gathering and analysis of requirements regarding the SAP Plant Maintenance/Enterprise Asset Maintenance and Materials Management processes to be examined
Coordination of data engineering for extracting the relevant tables and attributes from the SAP development, test and production systems
Implementation of the ETL process in Microsoft Azure Databricks with SQL and Python/PySpark
Modeling/visualization of the target process as a BPMN 2.0 model
Creation of views/visualization with the required filter configuration
Business analysis and presentation of findings to the business units
SAP process knowledge, Process Mining, Power Query M, Tabular Model development with DAX
MS Process Advisor/Minit Client, MS Azure Databricks, MS Power BI, Tabular Editor 3, DAX Studio, Azure Cloud services, QPR Enterprise Architect, Camunda Modeler

Jan 2023 - Apr 2023

4 months

Anonymous – Leading European industrial gases company

Development of a Power BI report including ETL with Power Query M for SAP authorization management (RBAC concept)
Requirements gathering and analysis
Creation of dashboard mockups and validation with future users
Identification of relevant data from existing exports
Modeling of data as a star/galaxy schema
Creation of the ETL process and the Power BI report
Validation of the report
Tabular Model development with DAX, SQL, Power Query M
MS Power BI, Tabular Editor 3, DAX Studio, Google Sheets

Jan 2022 - Jul 2022

7 months

Anonymous – A leading European insurance company

Redesign of an existing Power BI reporting system
Simplification and optimization of existing Power BI dashboards
Enabling true self-service BI for business users (drag and drop without technical knowledge)
Reduction of loading times to a maximum of 3 seconds
Improvement of compliance and data quality by eliminating manual imports
Cost optimization of data transfer between Power BI Cloud and local infrastructure
Data analysis, software and data engineering, SQL, Power Query M, DAX, C#
Power Platform (Power BI, Power Apps), Denodo, Snowflake, Power BI Helper, Tabular Editor, DAX Studio, ALM Toolkit, Excel, C# .NET 6.0 console app

Jan 2022 - Jul 2022

7 months

Anonymous – A globally leading electronics group

Development of a Power BI report including ETL with MS SQL Server for the SAP AR process (accounts receivable)
Requirements gathering and analysis
Business-IT communication between involved stakeholders from various departments and subsidiaries of the group
Creation of dashboard mockups and validation with future users
Identification of relevant data from the SAP ERP system
Modeling of data as a star/galaxy schema
Creation of the ETL process with T-SQL on MS SQL Server 2017
Creation of the Power BI report and optimization of joins for resource-efficient generation of report tables
Tabular model development with DAX, SQL/T-SQL, Power Query M
MS Power BI, Tabular Editor 3, DAX Studio, MS Visual Studio 2019, MS SQL Server Analysis Services (SSAS)

Jun 2018 - Aug 2019

1 year 3 months

Digital Finance Consulting – Advanced Data Analytics

KPMG AG WPG

Digital finance consulting with a focus on advanced data analytics

Mar 2018 - May 2018

3 months

KPMG AG WPG

Development of a prototype for performance management in a company for a webinar "Data-driven predictive planning in pharmaceutical companies"
Research and development of use cases for the planning process
Evaluation of the data analytics functionalities of the BOARD software
Creation of a data model and screens for demonstration
Data collection and integration with ETL tools (Power Query, Alteryx)
Training of machine learning models and implementation of time series analysis
Research activities on predicting shelf gaps and optimization potential for perishable goods
Technical implementation of big data machine learning pipelines with Apache Spark
Testing activities and technical consulting for CPM tool BOARD 10
Contribution to account management for a strategic corporate control system at a German commercial bank

Nov 2016 - Aug 2017

10 months

KPMG AG WPG

Contribution to quality assurance for SAP migration projects at a leading Bavarian automotive client (migration concepts, testing procedures, verification of data migration, customizing)
Support in account management
Preparation and delivery of onboarding workshops for interns and working students
Contribution to IT audits for various clients (review and analysis of IT system settings and processes)
Software acceptance testing of the SAP audit software Ispicio_S

Oct 2014 - Feb 2016

1 year 5 months

Capgemini GmbH

Contributed to a software engineering project for a network and service resource management system at a German telecommunications provider
Developed a multithreading Java tool to validate data models and import large CSV files into an Oracle 10g database
Developed show cases for the Digital Customer Experience Innovation Lab using open source platforms

Oct 2014 - Feb 2016

1 year 5 months

KPMG AG WPG

Analyzed and optimized the annual financial statement audit (Bachelor's thesis): market analysis of available automation solutions, functional analysis, and concepts for technical implementation
Implemented a Java solution for data cleansing to increase audit efficiency
Conducted market research on DSGVO/EU-GDPR software solutions
Implemented an Excel VBA solution to consolidate timesheets
Participated in IT audits (review and analysis of IT system settings and processes)

Industry experience

See where this freelancer has spent most of their professional time.

Experienced in Professional Services, Telecommunication, Manufacturing, Aerospace and Defense, Healthcare, and Automotive.

Professional Services

Telecommunication

Manufacturing

Aerospace and Defense

Healthcare

Automotive

Business area experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Finance, Audit, Quality Assurance, and Operations.

Information Technology

Business Intelligence

Finance

Audit

Quality Assurance

Operations

Skills

Data Modeling / Visualization
Data Modeling / Etl / Performance Optimization
Process Mining
Ibcs-Compliant Visualization Of Financial Data
Power Bi Performance Optimization
Programming / Automation
Visualization
Corporate Performance Planning Software
Job Automation
Forecasting
Planning And Visualization Of Processes & Architecture
Data Modeling / Etl
Operational Processes And Semantics Of Data Models
Microsoft Power Bi
Ms Power Bi Report Server (Self-Hosted)
Sql
Zebra Bi Ibcs Visuals
Microsoft Fabric/Azure Databricks/Apache Spark
Microsoft Process Advisor
Ms Sql Server, Oracle 19c, Postgres
Dax (Data Analysis Expressions), Ms Power Query M
Ms Sql Server Analysis Services (Ssas) Tabular
Tabular Editor 3, Dax Studio, Ms Vertipaq
Pentaho Data Integration
Microsoft Power Platform / Power Apps
Snowflake, Databricks, Denodo
Board
Python, Java, C#, Powershell
Jenkins Ci, Gitlab Cl
Machine Learning
Camunda Bpmn Modeler, Qpr Enterprise Architect
Snowflake, Denodo, Alteryx
Sap R/3, Sap S/4hana, Sap Businessbydesign
Sap Analytics Cloud
Sap Bw/4hana

Languages

German

Native

English

Advanced

Education

Apr 2018 - Sep 2022

Technical University München

Masterstudium Management & Technology (TUM-BWL) · Management & Technology · Munich, Germany

Apr 2017 - Dec 2017

Technische Universität München

Masterstudium der Wirtschaftsinformatik · Wirtschaftsinformatik · Munich, Germany

Jan 2016 - May 2016

Universität Halmstad

Erasmus+ Auslandssemester · Halmstad, Sweden

...and 1 more

Certifications & licenses

SAP Analytics Cloud (SAC) – Analyse, Planung und Integration

TH Brandenburg, SAP AG

SAP BW/4HANA - Datenfluss und BusinessObjects Berichtswesen

TH Brandenburg, SAP AG

SAP BW/4HANA - Datenmodellierung und BusinessObjects Lumira

TH Brandenburg, SAP AG

Geschäftsprozessintegration mit SAP S/4HANA 2020

TH Brandenburg, SAP AG

Badge Führung Durch Motivation Kompakt Kurs

FdM Training, TU München

Projektmanagement Kurs (nach Projekt Management Institut)

Hochschule München

Statistics

Experience

Total positions 12

Experience in Professional Services 3.5 y

Avg length 9 m

Longest experience 1 y 4 m

Expertise

Recent roles Digital Finance Consulting – Advanced Data Analytics

Main industries Professional Services, Telecommunication, Manufacturing

Main business areas Information Technology, Business Intelligence, Finance

Qualifications

Highest degree Master

Certifications earned 6

Profile

Member since

July 2023

Last update

September 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Gurpreet is based in Munich, Germany and can operate in on-site, hybrid, and remote work models.

Gurpreet speaks the following languages: German (Native), English (Advanced).

Gurpreet has at least 5 years of experience. During this time, Gurpreet has worked in at least 1 role and for 9 different companies. The average length of individual experience is 5 months. Note that Gurpreet may not have shared all experience and actually has more experience.

Based on recent experience, Gurpreet would be well-suited for roles such as: Digital Finance Consulting – Advanced Data Analytics.

In recent years, Gurpreet has worked for Anonymous – German building materials manufacturer, Anonymous – Leading European defense company, Anonymous – Large German laboratory service provider, Anonymous – Leading European energy supply company, and Anonymous – Leading European industrial gases company.

Gurpreet is most experienced in industries like Professional Services, Telecommunication, and Manufacturing. Gurpreet also has some experience in Aerospace and Defense, Healthcare, and Automotive.

Gurpreet is most experienced in business areas like Information Technology, Business Intelligence, and Audit. Gurpreet also has some experience in Finance, Quality Assurance, and Operations.

Gurpreet holds a Master in Management & Technology from Technical University München, a Master in Wirtschaftsinformatik from Technische Universität München and a Bachelor in Wirtschaftsinformatik from Hochschule München.

Gurpreet has 6 certificates. Among them, these include: SAP Analytics Cloud (SAC) – Analyse, Planung und Integration, SAP BW/4HANA - Datenfluss und BusinessObjects Berichtswesen, and SAP BW/4HANA - Datenmodellierung und BusinessObjects Lumira.

The availability of Gurpreet needs to be confirmed.

Daily rate distribution

0% 25% 50% 75% 100%

<€800 €800-880 €880-960 €960-1040 €1040-1120 €1120+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000

750

500

250

Daily rate avg. 980 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000

750

500

250

Median rate 960 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Calculated based on our freelancers’ daily rates as of 27 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.