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...
by Nate Moore | Aug 31, 2015 | Business Intelligence, Excel 2013
My objective in Excel Video 473 is configuring Excel 2013 BI tools so we can get started. The first hurdle is to get the right version of Excel. You either need the Pro Plus version of Office 365, the Professional version of Office 2013, or the standalone version of...
by Nate Moore | Aug 28, 2015 | Business Intelligence
If you’ve been following my recent Excel Videos, I’m starting to demonstrate some of the new Excel Business Intelligence tools. Here are two recent Office blogs that give you a feel for the direction Microsoft is taking with Excel 2016 and their new...
by Nate Moore | Aug 24, 2015 | Business Intelligence
Welcome to a new series of Excel Videos introducing Excel 2013 BI tools. Today I’ll demonstrate two of the new Excel 2013 Business Intelligence tools, Power View and Power Map. We’ll cover how to build these visualizations and maps in future Excel Videos. Today I just...
