p
philippdreher1

Philipp Dreher

@philippdreher1

Data Dashboards and Automation, Excel VBA, Tableau, KPI Reporting

Germany
German, English, French, Italian, Spanish
About me
Ich bin Philipp Dreher, ein in Deutschland ansässiger Datenspezialist, der Ineffizienzen in Reporting, Datenfragmentierung und fehlende verwertbare Erkenntnisse löst. Ich entwickle Excel KPI-Dashboards und Tableau-Dashboards, die mehrere Datenquellen zentralisieren, Datenverarbeitung automatisieren und Echtzeit-Transparenz schaffen. Mit fortgeschrittenem Excel (VBA, Makros), Datenmodellierung und strukturierter Analyse ersetze ich manuelle Prozesse durch skalierbare, zuverlässige Systeme, verbessere Datenqualität, reduziere Reporting-Zeiten und ermögliche fundierte Entscheidungen.... Read more

Skills

p
philippdreher1
Philipp Dreher
Offline • 
Average response time: 1 hour

See my services

Data Dashboards
I will create dynamic excel KPI dashboard with automated reporting and data insights
From$60 / projectMore details
Data Dashboards
I will create interactive tableau dashboard with data visualization, business insights
From$50 / projectMore details

Work experience

Freelancer.com

Data Analyst & Dashboard Developer

Freelancer.com • Freelance

Apr 2018 - Present • 8 yrs 1 mo

Design and implementation of Excel KPI dashboards and Tableau dashboards to address data fragmentation, inconsistent reporting, and limited performance visibility. Developed automated reporting frameworks using advanced Excel (VBA, macros, Power Query, and complex formulas) to streamline data extraction, transformation, and loading (ETL) processes. Integrated multiple data sources into structured data models, enabling centralized reporting and real-time KPI tracking. Built dynamic dashboards with interactive filters, slicers, and drill down capabilities to support in-depth analysis and faster decision making. Reduced manual reporting effort and error rates by replacing repetitive workflows with automated, rule based systems. Optimized large datasets for performance and scalability, ensuring fast processing and accurate outputs. Delivered client-focused solutions tailored to specific business needs, including sales tracking, financial reporting, and operational performance monitoring. Ensured data consistency, validation, and usability across all reporting layers, improving transparency and actionable insights. Collaborated with clients to translate business requirements into technical solutions, enhancing reporting efficiency, accuracy, and overall data-driven strategy execution.