by Nate Moore | Feb 9, 2016 | Business Intelligence, Excel 2013
Power View Tiles are another way to filter and display data, as you will see in Excel Video 494. I’ll show you how to add a tile to a visualization and demonstrate how tiles are like a container. Visualizations contained in the container are filtered by the tile, but...
by Nate Moore | Feb 1, 2016 | Business Intelligence, Excel 2013
Drilling Up and Down in a Power View Matrix is one of the advantages of a Power View Matrix compared to a Power View Table, and that’s the topic of Excel Video 493. It’s easy to add multiple fields to the rows and columns areas in a Power View Matrix, but the...
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...
