Infrastructure at your Service

Business Intelligence Archives - Blog dbi services

Matthieu Munch

Oracle Data Integrator – The EL-T tool from Oracle

By | Business Intelligence | One Comment

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
Microsoft Team

Recap SharePoint Event Paris 2015

By | Application integration & Middleware | No Comments

  Guillaume Meunier and I went to SharePoint Event 2015 in Paris on Saturday 30, May. This event was well organized and on time! We learned about the news features regarding SharePoint, related to B.I, SQL, governance, collaboration & Communication, Workflow and Process System. The sessions we followed are: How OneDrive Company revolutionized storing files in my business Almost all companies use the SMB file system and deployment networks on workstations to store and centralize…

Read More
Matthieu Munch

QlikView – Load data in QlikView / QlikSence – Best practice and trick

By | Entreprise content management | No Comments

In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your report: Database connector File connector a) Database connector: If your data are located in a database, you must use this…

Read More
Matthieu Munch

QlikSense – The easy way to create a QlikView report

By | Entreprise content management | No Comments

Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years. To make Business Intelligence even more accessible to Business users, the Qlik Company decided to add an additional product in its range. This product should be more accessible and easier to use to create…

Read More
Matthieu Munch

Birst: an attractive “all-in-one” Business Intelligence solution

By | Entreprise content management | 2 Comments

The review of the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms has revealed a new challenger that could become one of the leader of this market: Birst – an interesting “all-in-one” BI solution. Birst is an american company based in the Silicon Valley near San Francisco. Its SaaS (Software as a Service) BI solution mixes simplicity and power. Just a little reminder before going forward: a complete Business Intelligence solution has two kind…

Read More
Nathan Courtine

Master Data Services installation for SQL Server 2012

By | Database management | One Comment

This posting is a tutorial for installing Master Data Services on your Windows Server 2012. Microsoft SQL Server Master Data Services (MDS) is a Master Management product from Microsoft, code-named Bulldog. It is the rebranding of the Stratature MDM product, titled +EDM and acquired in June 2007 by Microsoft. Initially, it was integrated for the first time in Microsoft SQL Server 2008 as an additional installer. But since SQL Server 2012, Master Data Services is…

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