Ardo Corporate Datawarehouse Ardo decided to embark mid-2016 to implement a comprehensive Business Intelligence program.
ZEB Business Intelligence in Fashion Retail The goal of the project was to replace the existing data warehouse with a more future proof, reliable and state of the art enterprise data warehouse built upon the latest SOL Server technologies.
Recommended books Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 This book is a very detailed introduction to DAX, the powerful language behind Power Pivot and Power BI. Due to it's clear writing style, the book is an excellent starting point for beginners. However, even DAX pros will get value out of this book. Jeudi, 22 décembre 2016
Recommended books Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions Window functions are a special construct in the SQL language that allow you to easily calculate more complex requirements, such as year-to-date calculations, moving averages, percentiles and so on. Jeudi, 22 décembre 2016
Recommended books Star Schema The Complete Reference One of the best books around on dimensional modelling. Adamson takes you onto a tour around the different types of dimensions and fact tables and clearly explains how to design them and how to construct your ETL. At least as good as the Kimball books. Jeudi, 22 décembre 2016
USG People Management Dashboard for Performance Management in Staffing The Corporate USG People Data Warehouse is based on multitude data sources (back- and front-office). The decision support system is used by virtually all management levels in the organization in order to get a complementary overview of the performance of the USG Group. USG country management can retrieve financial and operational details on their country performance.
Echo Group Implementation of an end-to-end Performance Management solution Echo relied on element61 for their Performance Management strategy. element61defined a roadmap that formed the basis for the implementation of a BI and a CPM solution. This project, executed in close collaboration with the Echo team, won the BI Vision Award and the Best Finance Team Award.
Reynders Label Printing Implementation of a BI-Saas solution for production reporting & analysis Reynders was looking for a BI solution to replace their inadequate Excel reporting solution. element61 built a Microsoft SQL Server based BI solution in a SaaS architecture. The scope was to provide a reporting and analysis environment focusing on the production data of their printing presses.
Vlaamse Vervoersmaatschappij De Lijn (VVM) Integrated Performance Management in the Public Sector Over recent years, De Lijn has deployed a large scaled data warehouse environment, currently serving over 300 users. The Business Intelligence environment on top of the data warehouse is used for reporting & analysis on subject areas like personnel behavior (driver productivity, employee sickness behavior, overtime worked, employee scheduling), ticketing information (both for operational and marketing purposes), vehicle operations (GPS data, driven kilometers, maintenance, fuel consumption, vehicle cost per vehicle age), financial data (budgets versus actual, subsidies from the government, money going to subcontracting…) and vehicle road accidents.
Vandeputte Safety Business Intelligence on top of SAP, without using SAP Business Warehouse element61 has delivered a comprehensive BI project on behalf of Vandeputte Safety. The main challenge in this project was to extract data from an SAP ECC 6.0 ERP system, without using the intermediate SAP Business Warehouse layer, using a Microsoft SSIS solution.