by Nate Moore | Oct 19, 2015 | Business Intelligence, Excel 2013
Sorting in the Excel Data Model can be different than what you’re used to in Excel, so Excel Video 480 walks through a solution. Dates like January and February or weekdays like Monday and Tuesday sort the way you expect in Excel. In some of the BI tools like Power...
by Nate Moore | Oct 12, 2015 | Business Intelligence, Excel 2013
We’ll work on formatting in the Excel Data Model in Excel Video 479 today. If you’re a long time Pivot Table user, you’re familiar with changing number formats using the Value Field Settings menu. Today we’ll change the formatting for numbers and dates in the Excel...
by Nate Moore | Oct 5, 2015 | Business Intelligence, Excel 2013
In Excel Video 478 we’ll start using PowerPivot and the Excel Data Model together. I’ll show you two ways to build a Pivot Table with the Excel Data Model we’ve created so far. We’ll cover more about PowerPivot and Pivot Tables in future Excel Videos. The goal for...
by Nate Moore | Sep 28, 2015 | Business Intelligence, Excel 2013
Creating and managing relationships in the Excel Data Model, as we’ll do in Excel Video 477, adds tremendous power and flexibility to our analysis. In a typical Pivot Table, you can only pivot data from one table. If you wanted to combine data from multiple tables,...
by Nate Moore | Sep 21, 2015 | Business Intelligence, Excel 2013
Now that Excel Video 475 helped us load data, Excel Video 476 is about refreshing data loaded into the Excel Data Model. Watch out for the yellow warning bar. I see that very frequently in practices I work with. By default, Microsoft blocks external content to protect...
by Nate Moore | Sep 14, 2015 | Business Intelligence, Excel 2013
Loading data into the Excel Data Model is the first step to taking advantage of the power of this new tool, and that’s the subject of Excel Video 475. Excel has a new tool called Power Query that can load data into the Excel Data Model and transform the data to meet...
