How to Use Power Query to Import Hadoop Data into Excel
Aug 4,
2015
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 […]
How to Link Excel to MATLAB to Solve Complex Equations
Apr 28,
2015
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 […]
How to Write DAX Summary Queries In Excel Using PowerPivot: The SUMMARIZE Function
Feb 24,
2015
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 […]
Writing DAX Summary Queries Using PowerPivot and Excel QueryTable Objects
Feb 15,
2015
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 – How to Interpret the Results
Jan 18,
2015
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 […]