Bi-kipedia Measure or metric A measure is a numeric expression, which can be used and displayed –by dimension- on reports and consist of base facts, aggregated values or mathematical functions. Thursday, 17 July 2014
Bi-kipedia Dimension table The attributes in a dimension table describe all the different specific properties or characteristics of this dimension. Most often -in a star schema- the dimension tables are de-normalized. Thursday, 17 July 2014
Bi-kipedia OLAP - Online Analytical Processing OLAP stands for On Line Analytical Processing. OLAP tools offer the possibility to look at the data in a multi-dimensional way. It gives users the power to analyze data from different angles (dimensions) quickly, as aggregates are often precalculated and stored. Interacting with data through the use of OLAP tools is also known as "slice and dice”. Thursday, 17 July 2014
Knowledge videos Microsoft BI PowerPivot DAX Time calculations : YTD In this webcast you will see how to create a DAX calculation that returns the Year To Date value. Thursday, 17 July 2014
Bi-kipedia Data Vault This is one method in which a database or data warehouse can be designed. Data sourced from different operational systems is stored in such a way that it can be completely traced in term of history. In the data vault architecture you can have three basic entities: hub, link and satellite. Thursday, 17 July 2014
Knowledge videos Microsoft PowerPivot DataFeed Source This webcast will show how to feed your PowerPivot data. Thursday, 17 July 2014
Bi-kipedia Dashboard A dashboard is an easy consumable BI user interface which can represent anything that is interesting to monitor or measure (mostly tactical or operational) in an integrated and visual way. Mostly the visualization of the data is done through interactive dials, sliders, check boxes, gauges, maps, traffic lights and other highly visual components. It records actuals performance and tells us how we are doing. A dashboard is not to be confused with a scorecard. Thursday, 17 July 2014
Bi-kipedia Data Integration Data integration is the collection of processes and tools, strategies and philosophies by which fragmented data assets are aligned to support business goals. Data integration from a technical point-of-view covers topics such as data federation, virtualization and service-oriented-architecture, but in the context of Performance Management or Business Intelligence, it is usually synonym to ETL (Extract-Transform-Load) or ELT-related activities. Thursday, 17 July 2014
Bi-kipedia In-memory In traditional querying, the tables and cubes that are being consulted are stored on disc. "in-memory” solutions load all the data into RAM memory, from where it is being accessed by the application.The advantage is the higher speed of querying and a reduced time of data modeling. Also structures are less predefined and easier to change. The approach obviously requires extra memory hardware requirements. Thursday, 17 July 2014
Webcasts Biobest "Business Intelligence in the Cloud" video-testimonial Biobest has been the first SME that deployed a Saas BI solution in the context of the "Lessius Mechelen - element61 EFRO - Agentschap Ondernemen "Business Intelligence in de Cloud voor de KMO" project. The technology used was Microsoft SQL Server Azure en Reporting Services Azure. Thursday, 17 July 2014