Infrastructure at your Service

Category Archives: Business Intelligence

David Barbarin

Les 24 heures du PASS (24HOP) – édition francophone

By | Business Intelligence, Database management, Development & Performance, Technology Survey | No Comments

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre 2016. L’idée est plutôt simple: proposer une série de 24 webinaires gratuits de 10h jusqu’à 22h (heure française)  pendant 2 jours. C’est l’occasion de recevoir et d’échanger les dernières informations autour de l’administration et du développement des bases de données, des nouvelles tendances côté Business Intelligence…

 
Read More
Stéphane Haby

SQL Server 2016: new tools management strategy

By | Business Intelligence, Database Administration & Monitoring, Database management | No Comments

A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools for SQL Server on a single web page: https://msdn.microsoft.com/en-us/library/mt238365.aspx As DBA, this page is absolutely to be marked in your browser. The two major tools, SQL Server Management Studio (SSMS) and SQL Server Data Tool (SSDT), are…

 
Read More
Matthieu Munch

Oracle Data Integrator – The EL-T tool from Oracle

By | Business Intelligence | No Comments

Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful and that allows the integration of data coming from another sources.  Agility of use Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. Here is an example of…

 
Read More
Franck Pachot

DBA, turkeys and NoSQL hype

By | Business Intelligence, Database management | No Comments

We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can’t imagine processing data seriously without it. And the technologies that come with NoSQL brings back the problem that we have solved with SQL databases. But can’t we ignore what is currently going on. Behind the Big Data buzzwords there are real requirements. And if we refuse to listen to them, we will not have…

 
Read More
Microsoft Team

SharePoint 2013 – Office 365 & Power BI

By | Business Intelligence | No Comments

Quick reminder of what is SharePoint 2013 and Office 365 SharePoint 2013 SharePoint 2013 is a collaborative platform that allows organizations to increase the efficiency of their business processes. link: https://technet.microsoft.com/en-us/library/cc303422.aspx Office 365 with SharePoint 2013 This is the Online version of SharePoint 2013. When you sign in to Office 365, or your organization’s corporate intranet site, you’ll see links to Newsfeed, OneDrive, and Sites in the global navigation bar. These are your entry points…

 
Read More
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