In July, Microsoft announced plans for a public preview of a new suite of business intelligence tools, known as Power BI for Office 365. On September 25, Microsoft added a few new capabilities to that ...

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet. There are several ways to find duplicates in a Microsoft Excel sheet. You ...

Triggering drill through in a Power BI visual isn’t obvious and might be totally missed. Instead, add a drill through button that displays drill through instructions. Adding drill through functions to ...

In this post, we will show you how to split Data into Rows using Power Query. While exporting data from other systems or sources, you may encounter situations when the data is stored in a format where ...

Excel’s Power Query is a powerful tool that enables users to transform and manage data with ease. However, to truly harness its capabilities and streamline your workflow, it’s crucial to understand ...

Microsoft has some seriously powerful tools for data management, and they’re not as scary as they might seem. We learned this ourselves during our hands-on with the Complete Big Data & Power BI Bundle ...