Business Intelligence

SQLDay 2025 – Wrocław – Sessions

After a packed workshop day, the SQLDay conference officially kicked off on Tuesday with a series of sessions covering cloud, DevOps, Microsoft Fabric, AI, and more. Here is a short overview of the sessions I attended on the first day(…)

SQLDay 2025 – Wrocław – Workshops

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

Oracle Technology Roundtable for Digital Natives – Let’s have a look at AI, Cloud and HeatWave

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

L’historisation des données

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 : Quelle était(…)

Microsoft Foundry in Action: Building Smarter AI Solutions with Your Data

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

Save Report to Power BI Report Server: Resolving the ‘Unexpected Error Encountered’

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

Projet : Modélisation d’un Data Warehouse

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

Export Data to Azure Storage with SSIS: Solving the ‘Unable to Create Azure Blob Container’ Error

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

Ace Your Certification Exams with Confidence: A Proven Recipe for Success

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

Mastering SSIS with Excel – Resolving the ‘Microsoft.ACE.OLEDB.16.0 Provider is Not Registered’ Error

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: Migrating SSIS(…)