Rüdiger Kohl
Data Analyst, Data Engineer, Controller, Reporting Manager
Experience
Data Analyst and Reporting Manager
Energieversroger
Implemented Power BI reporting for various departments at an energy provider. Agile project: responsible for organizing and coordinating with departments and IT, and regularly presented interim steps and results to project management.
Trainer for Data Analysts
Große Einkaufsorganisation
I train employees and other interested individuals to become data analysts. Topics:
- Databases
- Workflows and pipelines with KNIME
- Visualizations with Power BI
- Machine learning
Trainer
4 Source
Trainer
Bechtle IT-Systemhaus
Management Reporting
Bergbauunternehmen
- Data transformations for a new mainframe system using PowerQuery
Employee
BiBA Moden
- Built management reporting in Excel without VBA using txt, csv and dbf files as source.
- Goal: update with a single click.
- Created comprehensive reports for external and internal sales, purchasing, warehouse, controlling, managers, and executive management.
Management Reporting
Various energy companies
- Data transformation and aggregation from different data sources using Power Query in Excel and Power BI.
Management Reporting
Various small businesses
- Set up simple reporting for gas stations or SMEs.
Trainer
Econvolution IT Systemhaus
Trainer
Europa Apotheek
Trainer
Gothaer Versicherungen
Employee
H.J. Heinz GmbH
- Developing management reporting with Business Objects.
- Comprehensive reporting for field and office staff, managers, and executive management
Trainer
IFM Institut
Employee
L'Oréal GmbH
- Developing management reporting with Business Objects, SAP BW, Excel, and Access.
- Comprehensive reporting for field and office staff, marketing, category management, market research, managers, executive management, and board of directors
Freelance Lecturer
Local Universities
- Topic: Office 365
Management Reporting
Medium-sized automotive supplier
- Set up a sample report in Power BI and Power BI Cloud.
- Created views for Power BI Mobile.
Management Reporting
Medium-sized AI bot provider
- Built a value stream analysis in Power BI (100 fields, 350 conditional formats)
Management Reporting
Medium-sized machinery manufacturer
- Created a transformation table in Power Query to import data from SAP tables into a new CRM
Management Reporting
Medium-sized package manufacturer
- Developed visuals and dashboards in Power BI, trained users.
Management Reporting
Medium-sized, globally operating plant manufacturer
- Took over an ongoing reporting project after staff turnover.
- Analyzed existing reports in Excel and Power BI.
- Performed extensive analysis and adaptation of Power Queries (Power BI's ETL tool), Excel scripts, and SQL queries.
- Reduced complexity by analyzing existing connections and removing intermediate steps.
- Established stable reporting.
Management Reporting
Mid-sized energy company
- Built Power Query tools for easier import into Excel.
- Trained participants.
- Switched to visuals in Power BI
Management Reporting
Mid-sized manufacturing company
- Migrated an existing report to Power BI
Trainer
SRS Dresden
Trainer
Stadtsparkasse Dresden
Industrial clerk apprenticeship
Thyssen Steel AG
Management Reporting
Global consumer goods manufacturer
- Built a new Power BI reporting system using existing databases.
- Created management views.
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Retail (1.5 years) and Energy (0.5 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (1.5 years) and Business Intelligence (0.5 years).
Summary
I am a Data Analyst, Controller, Business Analyst, Data Engineer, and Reporting Manager all in one. Since 2008, I've been freelancing in training and project work. I can quickly learn new topics and tailor my approach to different audiences. Many clients I've worked with keep coming back to me.
I have specialized in the following tools: KNIME, Apache HOP, Power BI, Power Query, Excel, Apache Superset, SQL, and Python
Skills
Building Management Reporting Using Excel, Powerquery, Powerbi
Operational And Data Analyses
Etl Using Existing Tools In The Company (Powerquery, Excel)
Conducting User Training: Courses For Word, Excel, Powerpoint, Powerbi, Powerquery, Teams, Onenote From Beginner To Advanced Levels
Conducting User Training: Freelance Instructor For Local Universities (Topic: Office 365)
Conducting User Training: 'First-choice Trainer' For Various Regional It Agencies
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, Clubs, Web Apps
Sql: Extensive Knowledge, Phpmyadmin, Bigquery, Sqlite
Python: Basic Knowledge (Pandas, Seaborn). Mainly Etl
Linux Mint, Opensuse, Windows: Very Good User Know-how
Microsoft Teams: All Aspects Of Digital Collaboration
Jira, Confluence, Miro: Basic Knowledge
Languages
Education
HTW Dresen
Diploma in Business Administration (FH) · Business Administration (Business Management) · Dresden, Germany · 2.3
Specialized in management and organization, as well as marketing and market research
Leuphana University Lüneburg
Master of Public Health · Public Health · Lüneburg, Germany · 2
Specialized in occupational health management
Thyssen Stahl AG
Industrial Clerk · Germany
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Rüdiger based?
What languages does Rüdiger speak?
How many years of experience does Rüdiger have?
What roles would Rüdiger be best suited for?
What is Rüdiger's latest experience?
What companies has Rüdiger worked for in recent years?
Which industries is Rüdiger most experienced in?
Which business areas is Rüdiger most experienced in?
What is Rüdiger's education?
What is the availability of Rüdiger?
What is the rate of Rüdiger?
How to hire Rüdiger?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Analyst and Reporting Manager
Nearby freelancers
Professionals working in or nearby Moers, Germany