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...
by Nate Moore | Sep 7, 2015 | Business Intelligence, Excel 2013
I’m introducing the Excel Data Model in Excel Video 474. I’ll discuss a couple of cons (you can’t edit data, formulas will take some getting used to, and you may need 64 bit Excel) as well as several pros (the Excel Data Model holds way more than 1 million rows, is...
