This project demonstrates how to perform data modeling and analysis using Microsoft Excel's Power Pivot and Power Query features. The goal of the project is to combine and analyze data from multiple ...

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...

When you import data from a relational database like SQL Server in Power BI you have the option of entering your own SQL query to use as a starting point: Here’s the M code for a query that does this: ...

If you want to be a true spreadsheet power user, you need to learn about the Power Query and Power Pivot features in Excel. While you can get a lot done with Excel alone, using these built-in “Power” ...

Excel is more than just a spreadsheet tool; it is a comprehensive platform for data analysis and business intelligence. By using its advanced tools—Power Query, Power Pivot, and DAX—you can elevate ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...