Tag: Excel

When Power Query was first introduced early in 2013 it was known as the Data Explorer. In some ways, Data Explorer was a better name. The primary job of Power Query is to enable Excel users to examine data, decide what values need to be imported into Excel, and then complete the import process. If […]

Solving Linear System and Linear Optimization Equations Using Microsoft Excel and MATLAB In the previous instalment on linear systems we saw that Excel can easily invert a modest-sized matrix and find solutions to a set of simultaneous linear equations. In the real world, a place I allude to frequently and try to avoid as much as […]

In the previous segment, we saw how to write DAX statements in Excel to query Power Pivot Data. In this segment, we will take a first look at the SUMMARIZE function. While the DAX queries discussed here could be executed in the Management Studio against an Analysis Services tabular mode database, here we will be […]

Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]

Linear Regression using Microsoft Excel – Part 3 Interpreting the Results of a Linear Regression At first glance, the summary report for an Excel Linear Regression might seem to be a hodgepodge of cryptic numbers. In fact, the basic Excel summary report is pretty typical. The first thing we might take a look at is […]