Search

Business Intelligence Program

Aminolabs has evolved a lot over the last few years. Because of these changes they needed to completely revise their Microsoft Business Intelligence solution.

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

Information Dashboard Design: Displaying Data for At-a-Glance Monitoring

This is probably Stephen Few's most popular book. It clearly explains how to design dashboards for optimal communication of the data and it also shows you lots of examples of badly designed dashboards and how to improve them.

Jeudi, 22 décembre 2016

Recommended books

Show Me the Numbers: Designing Tables and Graphs to Enlighten

Stephen Few is one of the world's most well-known gurus on data visualization. In this book, he gives a clear overview on how to format tables and matrices and how to design your visualizations for optimal communication. A must read for every business intelligence professional!

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

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

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

Mobile Reports in Microsoft SQL Server Reporting Services 2016

Mobile business intelligence has been part of everyone’s business intelligence roadmaps for quite some time now. However, until recently, Microsoft didn’t have a solid offering in its SQL Server BI stack that could tackle the specific needs of displaying reports and dashboards on mobile devices. With SQL Server 2016, Microsoft aims to change all this.

Mardi, 15 novembre 2016

Financial Consolidation with SAP BPC

SAP BPC replaced the former Cognos application (Frango). The project consisted out of a standard consolidation application with 2 differentiators: we added an analytical dimension to allow segmentation and on the other hand the inter-company matching application, an integral part of the consolidation on BPC, allows for matching on invoice level.

Migration OutlookSoft 4.2 to SAP BPC MS 7

As the first release of OutlookSoft (now SAP BPC) under the SAP branding had more integration and compatability with Microsoft Office 2007, SES decided to migrate from the version 4 of OutlookSoft CPM (called Everest) to SAP BPC 7 for the Microsoft platform. This migration consisted not only in migrating the different applications, but also the migration of the DTS packages built on SQL Server 2000 to SSIS packages in SQL Server 2008.