by Nate Moore | Nov 30, 2015 | Business Intelligence, Excel 2013
Power View filtering can add power and flexibility to your visualizations. There are a couple of ways to do power view filtering, so we’ll start with the basics in Excel Video 486. If you’ve filtered Tables or Pivot Tables in Excel, the filtering menus I’ll describe...
by Nate Moore | Nov 23, 2015 | Business Intelligence, Excel 2013
Sorting Power View visualizations is where we’ll start our review of Power View basics in Excel Video 485. Watch how easy it is to sort a table and a matrix by simply clicking on the column heading. Also note that a table can only be sorted by one column at a time,...
by Nate Moore | Nov 16, 2015 | Business Intelligence, Excel 2013
We’ll continue our discussion about getting started with Excel Power View in Excel Video 484. Watch for things that are easy to do in Power View but hard to do in a traditional Excel spreadsheet, and vice versa. We’ll chart our data a couple of different ways with...
by Nate Moore | Nov 9, 2015 | Business Intelligence, Excel 2013
Now that we have PowerPivot, Power View, Power Query and Power Map installed, set up and configured, we’re getting started with Power View in Excel Video 483. If you haven’t watched Excel Videos 472 to 482, this video will make a lot more sense once you have Excel...
by Nate Moore | Nov 3, 2015 | Business Intelligence, Excel 2013
Excel Video 482 explains the rationale for building a date table in the Excel Data Model. Remember that tools like PowerPivot and Power View don’t allow you to group date fields like you can group in a traditional Pivot Table. Our objective today is building a date...
by Nate Moore | Oct 26, 2015 | Business Intelligence, Excel 2013
Excel Video 481 has two parts. First I’ll show why and how the Hide from Client Tools option is used when hiding columns in the Excel Data Model.. Excel Video 480 showed how sorting columns work and why they’re important. Sorting columns are important, but once...
