Category archive for ‘MS Access’ 
-
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 [...] -
MS Access vs Excel vs Datamartist
When data analysis requirements really get tough, the tough get going- and start to seriously use databases.
Let's face it, if you're considering Microsoft Access chances are what you need to get done is beyond what Excel does well, so you're looking for options. Its also likely that your IT department is unable or un-willing [...] -
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 [...]
