Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
Philipp Dreher
@philippdreher1
Data Dashboards and Automation, Excel VBA, Tableau, KPI Reporting
Allemagne
Allemand, Anglais, Français, Italien, Espagnol
À propos de moi
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.
Compétences
Philipp Dreher
hors ligne •
Temps de réponse moyen de 1 heure
Voir mes services
Tableaux de bord des données
I will create dynamic excel KPI dashboard with automated reporting and data insights
Tableaux de bord des données
I will create interactive tableau dashboard with data visualization, business insights
Expérience professionnelle
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.
