DW - Data Warehousing & Modeling

Business Intelligence in the Social Sector

Plaatshouder

In 2011, startte OCMW Brugge met een nieuw data warehouse. De focus van de eerste iteratie lag op HR rapportering & analyse gebaseerd op data vanuit de operationele HR toepassing InfoHos. De applicatie bevat informatie rond het arbeidscontract, locatie van tewerkstelling, werkregime, kostcenter, afwezigheid en ziekte en loonadministratie. In volgende phases wordt gewerkt rond werkdrukmeting, uitbetalingen en operationele performantie-indicatoren. Alle informatie wordt ge-extraheerd en getransformeerd naar het data warehouse. Daar wordt het verrijkt met budgetcijfers en omgezet naar FTE berekeningen, rekening houdend met deeltijdse arbeid. Verschillende types rapporten worden daarna aangemaakt : gaande van top management informatie via Analysis Services 2008 tot meer operationele rapporten voor management doorheen alle lagen van de organisatie via Reporting Services 2008.

Business Intelligence op een SAP-systeem, zonder gebruik van SAP Business Warehouse

Plaatshouder

element61 heeft een uitgebreide BI oplossing gebouwd voor Vandeputte Safety. De voornaamste uitdaging van dit project bestond erin om data rechtstreeks uit een SAP ERP systeem op te laden in een Microsoft BI oplossing zonder de SAP BW oplossing te gebruiken. Het project was zeer succesvol, werd op tijd en binnen budget geleverd en ondersteunt 100+ eindgebruikers in hun dagelijkse rapporteringsbehoeften.

From batch to real-time reporting and analytics

afbeelding van Bart Van Der Vurst

With the emergence of digitization and IoT, it becomes crucial for some companies to enable faster decision making through faster data insights. Gone are the days when everyone can wait for hours or days to look at insights and performance dashboards.

In this insight, we have proven that providing these real-time insights means a change in system architecture for many business intelligence teams. In our expert opinion, we concluded that a best-practice real-time architecture consists of two main building blocks: a receiving end-point to receive the data streams and a real-time analytics layer to transform the data.

We conclude that getting started with real-time analytics isn't complex: all leading vendors as well as open-source providers offer a serious of proven solutions and as solutions are offered through the cloud, they start with no investments needed (pay-as-you-go basis).

R language

R, also called GNU S, is an open-source language and environment designed for statistical computing and graphics. Although it's been existing for 20 years, R remains the most popular statistical programming language used today. R is both a language as well as an environment. To access both, one needs the environment installed on its computer or server. 

Data Lake

A data lake is an important element of the buzzwords related to Big Data and Advanced Analytics. A data lake is a storage repository in which we hold raw data in its native format; this can be structured (e.g. entire source data-tables), semi-structured, and unstructured (e.g., photos, tweets) data. 

10 Oct 2016 Monday
Over the last years, SQL Server Days has become a household name in the European SQL Server Community . For the 9 th successive year the Belgian SQL Server User Group (SQLUG.BE vzw) and Microsoft are teaming up to organize the Belgian SQL Server...

Process mining

Process mining can be described as the search to discover strategic information and extracting patterns in bigger databases by making use of process patterns. In this process, users are "digging” into the data and make use of visual process techniques. It helps enterprises and analysts to visualize understand the essential information out of massive quantities of data.

CDO - Chief Data Officer

Big Data business opportunities, data security, privacy, and others are too big not to be discussed at the C-level. A CDO or chief data officer is a leader role within the organization responsible for organization-wide governance and utilization of data and information, via data capturing, processing, analysis, data mining, information trading and other.

Pagina's

Abonneren op RSS - DW - Data Warehousing & Modeling