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...
by Nate Moore | Dec 12, 2015 | Business Intelligence, Excel 2013
In Excel Video 488 I’ll show you a clever way to do Power View filtering using charts. Watch how I configure a chart to be used as a filter. It makes the filtering interactive and informative at the same time. You can select multiple chart elements to filter at a time...
by Nate Moore | Dec 7, 2015 | Business Intelligence, Excel 2013
I have 6 Power View filtering tips for you in Excel Video 487. The first tips are easy ways to minimize and close the filters area. You won’t necessarily make your visualization area bigger, but it does make it easier for your users to focus on the data they need to...
