Bi-kipedia Base table A base table is a synonym for a fact table. It contains data stored at the lowest level of detail. In this way the information can be combined with a multitude of dimensional information. Jeudi, 17 juillet 2014
Bi-kipedia Master data Master data is the collection of the most important reference data within an organization.This is mostly limited to a certain set of entities, such as customers, products, financial accounts, suppliers, employees, … Next to the central government of this information, attention is given to the ownership and processes which maintain the data and ensure that master data can be used properly and consistently in all of the systems and databases of the organisation. Jeudi, 17 juillet 2014
Bi-kipedia SaaS - Software as a Service Software as a Service is an online service of software over the internet.The software is centrally hosted by a Saas provider and is accessible by users having a web browser. The user is hiring the services while the SaaS provider is responsible for installation, maintenance and upgrades of the software. The solution is typically available in a renting model.Increasingly also Business Intelligence and Corporate Performance Management solutions become available in a Saas Model. Jeudi, 17 juillet 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. Jeudi, 17 juillet 2014
Bi-kipedia Data Mart Data marts are usually smaller then data warehouses as they contain data about a specific subject area and designed to serve a particular community of users from the enterprise. Ideally a data mart is derived from or based on a data warehouse architecture, in order to ensure data consistency throughout the organisation. Jeudi, 17 juillet 2014
Bi-kipedia Data Warehouse Data Warehouses centrally store enterprise information, with a focus to help making strategic business decisions. The data warehouse usually gets its information out of operational systems (like ERP or CRM Systems) or databases used for daily business operations.The data is ordered and structured in a specific way to facilitate reporting and analysis. Due to its content and the long term storage of historical data, a data warehouse can become a powerful database within the organization. Jeudi, 17 juillet 2014
Bi-kipedia Data - Information Data is a gathering of factual and descriptive information which, within the context of data warehousing or business intelligence, is specifically designed to allow easy analysis and reporting of business information in order to support faster business decision making. Data can exist of measurements, words, properties or descriptions of objects relevant to the organisation. Jeudi, 17 juillet 2014
Webcasts Biobest "Business Intelligence in the Cloud" video-testimonial Realisation d'une solution de Business Intelligence hebergé pour un PME. Jeudi, 17 juillet 2014
Bi-kipedia ETL - Extraction, Transformation & Loading In order to be able to execute reporting or analysis in a fast manner it is often necessary to present the data in a separate user friendly data model which allows for good performance. An ETL solution is typically used to get the data into such a data model. ETL stands for Extraction, Transformation and Loading. This process extracts raw data from a source system, enriches it with certain logic and loads the transformed data into a new database environment. Jeudi, 17 juillet 2014
Bi-kipedia Data Lineage Data lineage is used to track and manage the data. It answers questions such as : Jeudi, 17 juillet 2014