Business Intelligence

QlikView Tips & Tricks: The Link Table

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”(…)

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

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(…)

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

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(…)

SQL Server 2012: new features for Integration Services (SSIS)

Like the others products of SQL server 2012, Integration Services has a lot of new features and enhancements.