Tag archive for ‘Access’
Microsoft Access allows users to create complex queries and analyze large data sets. However, it can be complicated to use compared to Excel. In this post, I’ll talk about ms access queries and the equivalent way to perform the same data transformation in the Datamartist tool– visually and simply. Microsoft Access has a clear role […]
-
MS Access query example and comparision to Datamartist
Microsoft Access allows users to create complex queries and analyze large data sets. However, it can be complicated to use compared to Excel. In this post, I’ll talk about ms access queries and the equivalent way to perform the same data transformation in the Datamartist tool– visually and simply. Microsoft Access has a clear role […]
-
Spreadmarts and Data Shadow Systems- The Debate
When business users are not getting what they want out of the enterprise business intelligence system they very rarely just give up. Successful business people didn’t get where they are by giving up when someone doesn’t deliver something, they take things into their own hands and get it done. Knowing this, it’s not surprising that […]
-
Data mart Data Modelling 101
Last time we talked about how much data can comfortably be put into and Excel spreadsheet and I’ve found that more than a few hundred thousand rows can get awkward. Plus, certain types of operations are more difficult to automate in excel (often requiring programming skills with macros or visual basic for applications (VBA)). So- this means […]
