Turning operational data into something people can decide on: business intelligence platforms, reporting, data warehousing, big data and the data engineering behind them. Our consultants share what they learned on analytics projects.
By Franck Pachot . I was looking at twitter analytics showing my top tweets in November and that puzzled me because tweets with the most ‘impressions’ and ‘engagement’ are related to events that had low audience in real. Any comment is welcome as it can help to understand why some events have low audience. Here it is. I’ve put my…
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…
By Franck Pachot . 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…
By Franck Pachot . Next Tuesday in Geneva I’m presenting Oracle In-Memory Column Store to Business Intelligence people at the Swiss BI Day After defining what is an analytic query, I show the different approaches to optimize that in Oracle, IMCS being the latest one. Here are some details about that slide. What is an analytic query? First definition –…
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…
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”…
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.…
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.
Like the others products of SQL server 2012, Integration Services has a lot of new features and enhancements.
