by Nate Moore | Jan 25, 2016 | Business Intelligence, Excel 2013
As you add more fields to a table in Power View, the data becomes messier and harder to understand. A Power View Matrix is the solution, and that’s the topic in Excel Video 492. Watch how to change a table to a matrix, how a matrix adds a values and columns area to...
by Nate Moore | Jan 18, 2016 | Business Intelligence, Excel 2013
The theory is that when you use the Excel Data Model, all of the calculations and aggregations you need can be built into the model. That’s great when it works, but if you need to make calculations, Excel Video 491 shows you how easy it is to do aggregations in Power...
by Nate Moore | Jan 11, 2016 | Business Intelligence, Excel 2013
Excel Video 490 is an introduction to the basics of Power View tables. We’ll create and delete tables, resize and move tables, add and remove columns, and reorder columns. The idea is that Power View is a way to quickly visualize and understand data. You may not...
by Nate Moore | Jan 4, 2016 | Business Intelligence, Excel 2013
Happy 2016 Everybody! If you’re watching these videos as they’re released at mooresolutionsinc.com, this is the first Excel Video of 2016. We’ll hit 500 Excel Videos this year in not too many weeks. I have a celebration planned with a free giveaway, so stay tuned. In...
