Datamartist gives you data profiling and data transformation in one easy to use visual tool.

Category archive for ‘Business Intelligence Architecture’ rss

  • Data Warehouse vs Data Mart

    Very often, the question is asked- what's the difference between a data mart and a data warehouse- which of them do I need? Data warehouse or Data Mart? Data Warehouse: Holds multiple subject areas Holds very detailed information Works to integrate all data sources Does not necessarily use a dimensional model but feeds dimensional models. [...]

    12/02/08 • (0)

  • Business Intelligence Workspaces and in memory self serve analysis

    In the classical Business Intelligence architecture, users sit at their computers, requesting reports and analysis, and huge central servers churn through the numbers.  The dual-core machine on the desk with 2Gb of RAM is asked to do almost nothing. As machines get faster and faster, new tools that use memory are going to create functionality and speed that just hasn't been [...]

    10/08/08 • (0)

  • 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 [...]

    9/23/08 • (0)

  • Data, Data Everywhere- but not a report to read

    It is truly astounding how much data storage there is in the world. The IDC claims in one of their reports almost 300 exabytes of storage capacity exists, I don't know if they included my USB key in there or not- but that's still a lot. Now of course, the majority of that is photos and video [...]

    4/22/08 • (0)

  • Moores Law and PC based data analysis

    The funny thing about Moore's law is how it keeps sneaking up on you. Even though we've all been seeing drastic reductions in cost and increases in power in computers for years, I still find I get amazed by it. When Moore first speculated that the number of transistors per chip would double about every 12 [...]

    4/11/08 • (0)

  • Welcome to Datamartist

     Welcome to Datamartist, a blog for people who need to analyze large amounts of data quickly and are finding that their need for new analysis is outstripping the IT department's ability to deliver.  You probably fall right into this population if you answer "YES" to any of the following; Even though your company has one or more [...]

    2/17/08 • (0)