Infrastructure at your Service

Category Archives: Business Intelligence

Matthieu Munch

QlikView Tips & Tricks: The Link Table

By | Business Intelligence | No Comments

In this blog, I will show you how to bypass a “Synthetic Key” table in QlickView. Why bypassing a “Synthetic Key” table? If you have multiples links between two tables, QlikView generates automatically a “Synthetic Key” table. (here “$Syn 1” table). The QlikView best practice recommend to remove such kind of key table for a question of performance and “correctness” of the result. How to bypass this “Synthetic key” table? The “Link Table” is the…

 
Read More
Stéphane Haby

Office 2013 and SQL Server 2012: an integrated, powerful BI solution

By | Business Intelligence | No Comments

I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are PowerPivot and Power View? PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks. More information here. Power View is a feature of SQL Server 2012 Reporting Services Add-in…

 
Read More
Stéphane Haby

SQL Server 2012: new features for Reporting Services (SSRS)

By | Business Intelligence | No Comments

I decided to take some times in this cold February’s month to continue this small series. This time, I’m going to speak about Reporting Services (SSRS) and these new features.

Like my other article “SQL Server 2012: New features on Integration Services (SSIS)“, this article presents a summary from new features and enhancements for SQL 2012 Reporting Services.

 
Read More