“Numbers have an important story to tell. They rely on you to give them a clear and convincing voice.” ― Stephen Few


The dashboard design is most of the times considered as the cherry on top of the cake on a BI Project, in fact, it is one of the main factors that define the success of a BI project since it has the biggest impact on the end-user experience.



Regarding the lack of knowledge about our employees and their skills, an internal project was developed using Microsoft technologies, more specifically Visual Studio and PowerBI. This article expects to demonstrate how this development was accomplished.



The BIML (Business Intelligence Markup Language) allows the automatic creation of SSIS identical packages by simplifying the set of repetitive tasks performed in the extraction process of different source systems. Thus, it reduces the time of extraction of the sources and increases coherence between all packages. Four phases can define this process: 




This article attempts to explain how to first create and configure MDS and afterwards create a simple SSIS package to load data from an independent source, load it to a staging table and finally load it to MDS.




>     Using just the Azure Machine Learning, it is not possible to predict in a timeline.

>     This solution comes with the need to predict bookings for n periods in the future. The solution with ML only allows to predict the next period.



As companies grow, lines between data consumer and data owner may become blurred for any user, department or system that requires and shares information. Questions arise – who is responsible for this data and who must provide it at the right time – in order to stop data redundancy, maintain its integrity, avoid process delays and reduce work overlapping.



The interaction between Man-Machine is not something new these days. As time goes by, new systems are developed making the machines capable of performing tasks performed by humans.



During the past few years, with regular technological developments, companies have felt the need to reinvent themselves, in order to respond to an increasingly competitive market and to avoid potential issues committed in the past. To do so, they have started investing in solutions for management support and integrating tools to help drive strategic decisions.




IBM Cognos Workspace enables users to assemble and explore all types of data in any time horizon through a dynamic, highly personalized interface. Cognos Workspace is a web product for creating interactive workspaces using IBM Cognos content, as well as external data sources, according to your specific information needs.



With recourse to master data services

In Business Intelligence projects, it is sometimes necessary to develop substantial amounts of SSRS reports with the same structure, changing the dimensions and/or the measures to use. For these situations, taking into consideration the reports maintenance efforts and performance, it has been developed a solution for this problem.


This article is based on a dashboard implementation for audit a Cognos portal and to manage the daily run cubes process. The implementation scope is to understand the BI Portal usage and check the daily cubes run process, their performance and SLA. For this implementation, we used the Tableau Desktop tool. Below, we will detail each development process and applications.


Business Intelligence is just a coined expression to distinguish a set of concepts, methods and technologies built many years ago from other Decision Support Systems. So let us forget about all of those too many fancy words for a moment. They are all mainly used with the same goal:


>     Decision making supported by technologies.


Currently, many topics have been gaining further relevance in the CEO’s agenda, including the theme of the Internet of Things, a concept that has been brought and discussed by their most top leadership, and nowadays has also an increasingly relevance in the consumer space.