Knowledge base

Search
Microsoft provides users with a tool to do advanced analytics while abstracting for users the hassle of technology and infrastructure.
Bart Van Der Vurst's picture
Bart Van Der Vurst
At the time of writing SQL Server 2016 is in preview (CTP 3.1). We will discuss some of the most interesting changes to this new release from a BI perspective. For a full list of changes, I refer to the official SQL Server 2016 website: http://www...
Davy Knuysen's picture
Davy Knuysen
Introduction Power BI is the collective term from Microsoft for an organization-wide Self-service business intelligence (BI) infrastructure. Power BI empowers end users and provides tools to take care of an end-to-end business intelligence scenario...
Saar Gillis's picture
Saar Gillis
Introduction Drilling across different fact tables is a very important technique when analyzing data from a data warehouse. It gives us the possibility to analyze facts from different fact tables using conformed dimensions. When using Analysis...
Koen Verbeeck's picture
Koen Verbeeck
Testing ETL projects - used for Extracting data, Transforming it according to reporting requirements and Loading it into the data warehouse - is very complex because of many reasons. Typically huge amounts of data are handled and data comes often...
Davy Knuysen's picture
Davy Knuysen
The real challenge of a Datawarehouse project is to get Master Data or so-called categorical-type dimension attributes correct.
Bruno Ingham's picture
Bruno Ingham
Introduction SQL Server Integration Services (SSIS) is the popular ETL (Extraction, Transformation & Loading) solution of the Microsoft BI Suite. With the introduction of SQL Server 2005, Microsoft completely reshaped the way data loads could be...
Tony Robyn's picture
Tony Robyn
Microsoft Office SharePoint Server 2010 is a versatile product. It enables people to work together in one environment where they can easily store and share information with others and also search for business information - regardless of who created...
Nico Verbaenen's picture
Nico Verbaenen
Introduction In newly-released version of SQL Server, SQL Server 2012, a whole new approach to multi-dimensional analysis-like Business Intelligence is introduced. This is just one of the many new features. For a complete overview of new BI related...
Bruno Ingham's picture
Bruno Ingham
Microsoft released SQL Server 2012, this version offers some interesting new functionality in Business intelligence & Data Warehousing.
Bruno Ingham's picture
Bruno Ingham

Pages