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.
I had the chance to attend SQLDay 2025 in Wrocław, one of the largest Microsoft Data Platform conferences in Central Europe. The event gathers a wide range of professionals, from database administrators to data engineers and Power BI developers. The first day was fully dedicated to pre-conference workshops. The general sessions are scheduled for the following two days. In this…
Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich. It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI, machine learning, vector processing, analytics and transaction processing across data in Data Lake and MySQL databases. It was also great to share…
L’historisation des données, processus clé d’un projet BI, consiste à conserver et gérer différentes versions des données pour permettre l’analyse historique, la traçabilité et le suivi des tendances. 1 – Pourquoi historiser ? L’historisation répond à des questions clés : Selon les besoins du client, l’historisation peut ne pas être nécessaire si l’analyse historique ou les tendances ne sont pas prioritaires. 2…
1 Introduction At the 2024 edition of Microsoft Ignite, two key themes dominated the stage: Artificial Intelligence (AI) and Security. These pillars reflect the current and future technological landscape. Staying true to its innovative legacy, Microsoft unveiled Microsoft Foundry, a unified platform designed to simplify the design, customization, and management of AI solutions. In this article, I’ll share my hands-on…
1 Introduction Hello, Readers! Recently, I was tasked with preparing a demo for Power BI Report Server. Everything proceeded smoothly until I reached the step of deploying a report to the server, where I encountered an interesting authentication challenge that highlights the complexities of working with mixed domain environments. The report deployment phase revealed an unexpected authentication error that required…
Contexte : Mon client travail dans le domaine des échanges de marchandises et ressources primaires et son métier repose sur l’utilisation de différents outils informatiques pour faire ses affaires. Dans le but de consolider ses données afin de pouvoir générer des rapports d’activités globaux, dbi-Services a été sollicité pour réaliser un Data Warehouse (DWH) et d’aider à la mise en…
1 Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the “Unable to create Azure container” error. This article will guide you through a straightforward solution, aiming to save you time and prevent similar frustrations in the future. 2 Context The logic of the example is quite simple and consists of…
1 Introduction Recently, a colleague approached me, saying, “Hey Nicolas, I’m thinking of going for the PL-300 (Microsoft Power BI Data Analyst Associate) certification. Do you have any advice on how to pass it with confidence?” As knowledge sharing is one of the core values at dbi services, both internally and externally, I thought it might be helpful to share…
1 Introduction Dear Readers, Recently, I encountered the ‘Microsoft.ACE.OLEDB.16.0 Provider is Not Registered’ error while working on a data extraction task using SSIS. In this article, I’ll share how to fix this issue and also guide you through: 2 Context In a recent project, I had to migrate SSIS packages from SQL Server 2017 to SQL Server 2022. Many of…
Introduction Dear Readers, This post serves as an introduction to a six-part series focused on the Integration Runtime (IR) within Azure Data Factory (ADF). Over the course of these six articles, you’ll gain essential knowledge and practical skills to choose and implement the right Integration Runtime for your specific requirements. Each article will explore different aspects of IR, providing you…
Introduction Dear Readers, This article marks my first blog post. I am both excited and eager to share my experience of tackling a challenging issue encountered while developing a custom API for Microsoft Business Central to enable data extraction for Power BI reports. I hope this article will be informative and help others avoid the pitfalls I faced. Context As…
Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards. Once the report is published, the data presented by the report…
