Logistics

1/3

Industry

Logistic company

3 major busines units

1000 employees

Services

data cleansing

data modeling

data analysis

visualizations

consulting

training

Callenges

Complex SQL Server RDMS containing 1000+ tables and queries. Most of the users work exclusively with Excel.

Tools

Excel

Power Query

Power BI

SQL

Solution

Improving data integrity and quality. Development of a user-oriented reporting system for the operational units in planning and HR controlling. Development of datasets to support self-service dashboards and training of users. Reporting automation.

Data Source

RDBMS / CRMS

SQL Business Views

Lukanet

Excel

Records: 3M rows per year

Back