Excel as a Database: How to Create a Data Model in Excel 2013
jul 28,
2015
Many blogs, including some originating from our friends in the rainy Pacific Northwest, have referred to the “new” data models in Excel 2013. I’m not sure “new” is quite the right word. “Useful”, absolutely. “Interesting”, most definitely. But what we are really seeing here is not so much new as it is another step in […]
ADO,
Commodities Trade Workbook,
Economic Data,
Excel Data Models,
Excel Power Pivot,
Excel SQL,
Excel VBA,
Linked Tables,
Pivot Tables,
SQL,
VBA
How to Use SQL and the Excel Data Model to Repair Data
jul 16,
2015
In the previous instalment on querying economic data with SQL we saw a problem not uncommon in the world of worksheets-as-database. Errors and inconsistencies that seem trivial when looking at the data themselves become annoying impediments to creating the pivot table we want. In many cases, the traditional tools of the SQL database are well […]
ADO,
Commodities Trade Workbook,
Economic Data,
Excel Data Models,
Excel Power Pivot,
Excel SQL,
Excel VBA,
Linked Tables,
Pivot Tables,
SQL,
VBA
Excel as a Database: How to Query Economic Data With SQL
jun 12,
2015
As we noted in the previous post on how to use Power Pivot Linked Tables, a wealth of economic information is available for download from banks and government agencies, as well as the United Nations. Unfortunately, the structure of that data differs from source to source, and rarely does it meet our requirements as is. In […]
Excel As a Database: How to Use Power Pivot Linked Tables
jun 11,
2015
It seems almost trivial to say that Excel is a spreadsheet application. Yet, many organizations use Excel workbooks as a repository for data, in other words, as a database system. I myself have seen United States military operations executed from worksheets, pretty much because the people involved weren’t quite sure how to use Access. For […]