You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Malt Strategy
New report
Malt Tech Trends 2026
Gurpreet DhamiGD

Gurpreet Dhami

Business Analyst: Power BI, SSAS DAX, Databricks

On-demand
München, DE
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Gurpreet

Good day,

I am an Information Systems professional (B. Sc.) with experience in Business Intelligence, SAP, and Project Management.

I help you set up "real" self-service Business Intelligence. For this purpose, your data from various files, databases, and operational systems of all kinds will be transferred into an Enterprise Data Warehouse and visualized using Power BI, SAP Analytics Cloud, or SAP Lumira. I am currently supporting a leading global electronics champion in implementing this.

In addition, I am happy to assist you with the introduction or migration of IT systems such as Power BI, SAP S/4Hana, BOARD, etc. I will write migration and implementation concepts for you or help you review them to minimize project risks. I have already had the opportunity to conduct such reviews of migration and implementation concepts in the SAP environment for a large Bavarian automotive manufacturer, together with KPMG AG.

In implementation, I place great value on agile approaches and agile project management, so that you can see results quickly and provide feedback to minimize project risks and incrementally improve results.

I would be very pleased to accompany you on your projects.

Gurpreet Dhami

  • German

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • Anonym – Führender Europäischer Rüstungskonzern
    Power BI Consulting and Data Engineering
    DEFENSE AND MILITARY
    September 2023 - Today (2 years and 10 months)
    - Requirements gathering and analysis for cost center reporting
    - Creation and adjustment of ETL pipelines with 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 daily data updates of SSAS Tabular models on SQL Server Analysis Services
    - Consulting and support in adjusting various other reports
  • Anonym – Führender Europäischer Industriegase-konzern
    Development of a Power BI Report including ETL with Power Query M for SAP Authorization Management (RBAC Concept)
    CHEMICAL
    January 2023 - April 2023 (4 months)
    - Requirements gathering and analysis
    - Creation of dashboard mockups
    - Validation of the dashboard mockup
    - Identification of relevant data from existing exports
    - Data modeling as a star/galaxy schema
    - Creation of the ETL process with Power Query M
    - Creation of the Power BI report
    - Validation of the report
  • Anonym – Ein global führender Elektronikkonzern
    Development of a Power BI Report including ETL with MS SQL Server for SAP AR Process (Accounts Receivable)
    RETAIL (LARGE RETAILERS)
    October 2022 - February 2023 (5 months)
    Frankfurt am Main, Germany
    - Requirements gathering and analysis
    - Business-IT communication between involved stakeholders from various departments and subsidiaries of the group
    - Creation of dashboard mockups
    - Validation of the dashboard mockup with future users
    - Identification of relevant data from SAP ERP system
    - Data modeling as a star/galaxy schema
    - Creation of the ETL process with T-SQL on MS SQL Server 2017
    - Creation of the Power BI report
    - Validation of the report with future users
    - Optimization of joins for resource-efficient generation of report tables
Check out Gurpreet's experience

Recommendations

Be the first to recommend Gurpreet

Help this freelancer shine by sharing your experience working together.

Education

  • Management & Technology with specializations in Informatics (major) and Finance & Accounting
    Technische Universität München
    Management & Technology with specializations in Informatics (major) and Finance & Accounting
  • Information Systems
    Technische Universität München
    2017
    Information Systems
Check out Gurpreet's education

Certifications

Gurpreet's certifications are only visible to Malt Community members

Skill set (47)

Microsoft Power BI
Data Warehouse
SQL
SAC (SAP Analytics Cloud)
SAP BW/4HANA
SAP S/4HANA
SAP Lumira
SAP Business Objects
BOARD
Data Engineer
OLAP
Data Warehousing
SSAS
SSRS
Tabular
Azure Databricks
Controlling and Performance Management Systems
Treasury Management
Process Management
Agile Project Management
IT Architecture
Business Intelligence (BI) Strategy
IT Project Management
AI and Advanced Analytics
Marketing Analytics
Data integration (ETL, ELT and data warehousing)
Power Query
DAX
C#
Power BI
Snowflake
Data Analysis
Python
Tableau
Alteryx
Apache Spark
SAP R/3
SAP BusinessByDesign
CaseWare IDEA
ISPICIO_S
S/4HANA
SAP Business ByDesign
Java
VBA
Software Engineering
Data Engineering
Oracle 10g

Categories

  • BI Consultant
  • Business Analyst
  • ERP Consultant
  • Management Consultant
  • Strategy Consultant
  • Data Analyst
  • Data Engineer
  • Data Scientist