Rüdiger Kohl
Freelancer – Data Engineering and Management Reporting Consultant
Experience
Trainer
4 Source
Trainer
Bechtle IT-Systemhaus
Management Reporting
Mining Company
- Data transformations for a new mainframe system using PowerQuery
Employee
BiBA Moden
- Development of management reporting in Excel without VBA using txt, csv, and dbf files as a basis.
- Goal: Refresh with one click.
- Extensive reporting created for external and internal sales, purchasing, inventory, controlling, managers, and executive management
Management Reporting
Various energy companies
- Data transformation and aggregation from different data sources using PowerQuery in Excel and PowerBI
Management Reporting
Diverse Kleinunternehmen
- Setting up a basic reporting system for gas stations or SMEs
Trainer
Econvolution IT Systemhaus
Trainer
Europa Apotheek
Trainer
Gothaer Versicherungen
Employee
H.J. Heinz GmbH
- Setting up management reporting with Business Objects.
- Extensive reporting for field and internal service, managers, and executive management
Trainer
IFM Institute
Employee
L'Oréal GmbH
- Set up management reporting using Business Objects, SAP BW, Excel, and Access.
- Comprehensive reporting for external and internal sales, marketing, category management, market research, executives, senior management, and board members.
Freelance Instructor
Local universities
- Topic: Office 365
Management Reporting
Mid-sized auto supplier
- Created a sample report in Power BI and Power BI Cloud.
- Developed views for Power BI Mobile.
Management Reporting
Mid-sized AI bot provider
- Built a value stream analysis in Power BI with 100 fields and 350 conditional formats
Management Reporting
Medium-sized machine manufacturer
- Built a transformation table in PowerQuery to import data from SAP tables into a new CRM
Management Reporting
Medium-sized packaging manufacturer
- Created visuals and dashboards in PowerBI, trained users.
Management Reporting
Medium-sized, globally active plant manufacturer
- Took over an ongoing reporting project after staff turnover.
- Analyzed existing reports in Excel and PowerBI.
- Performed extensive analysis and adaptation of PowerQueries (PowerBI's ETL tool), Excel scripts and SQL queries.
- Reduced complexity by analyzing existing connections and removing intermediate steps.
- Built a stable reporting system.
Management Reporting
Medium-sized energy company
- Developed PowerQuery tools for simplified import into Excel.
- Trained participants.
- Switched to visuals in PowerBI.
Management Reporting
Medium-sized manufacturing company
- Migrated an existing reporting system to PowerBI
Trainer
SRS Dresden
Trainer
Stadtsparkasse Dresden
Apprenticeship as industrial clerk
Thyssen Stahl AG
Management Reporting
Global consumer goods manufacturer
- Set up a new Power BI reporting using existing databases.
- Created management views.
Skills
Setup Of Management Reporting Using Excel, Powerquery, Powerbi
Operational And Data Analysis
Etl Using Existing Company Tools (Powerquery, Excel)
Conducting User Training: Courses For Word, Excel, Powerpoint, Powerbi, Powerquery, Teams, Onenote From Beginner To Advanced Level
Conducting User Training: Freelance Lecturer For Local Universities (Topic: Office 365)
Conducting User Training: "Trainer Of Choice" For Various Regional It Providers
Powerbi: Interactive Management Reporting Dashboards
Powerquery: Etl
Sql: Phpmyadmin, Bigquery, Sqlite
Excel: Management Reporting Dashboards
Powerpoint: Interactive Presentations
Word: Documentation And Manual Creation Skills With Hyperlinks
Html5, Css, Javascript: Websites For Small Businesses, Associations, Web Apps
Sql: Extensive Knowledge, Phpmyadmin, Bigquery; Sqlite
Python: Basic Knowledge (Pandas, Seaborn), Primarily Etl
Linux Mint, Opensuse, Windows: Very Good User Know-how
Microsoft Teams: All Aspects Of Digital Collaboration
Jira, Confluence; Mira: Basic Knowledge
Languages
Education
Diploma in Business Administration (FH) · Business Administration (Commercial Clerk) · Dresden, Germany
Master of Public Health · Public Health · Lüneburg, Germany
Thyssen Stahl AG
Industrial Clerk · Germany
Similar Freelancers
Discover other experts with similar qualifications and experience