06 / Data integration & reporting
Connect data sources and turn information into reports
I help businesses connect applications, automate information flows and produce useful reporting.
Common needs
- Data spread across several systems
- Manual imports, exports or email processing
- Power BI or Power Query reports requiring updates
- Operational reporting needs
Services
- Interfaces using Access, VBA and SQL
- Data imports, transformation and reconciliation
- Power BI, SSRS, Power Query and Excel reporting
- Office workflow automation
Technologies and practical experience
- Power BI, SSRS, Power Query and Excel/VBA reports backed by SQL databases.
- Data import, ETL-related preparation, SQL views and CMDB data quality checks.
- Interfaces between Access, Excel, Outlook, databases and business applications.
Examples: E.ON and Bavarian judiciary
Work included Access/Outlook EDIFACT processing at E.ON and SQL Server, Power BI and Office support in the Bavarian judiciary.