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

Tag archive for ‘Excel’

  • Spreadsheet errors- Fear, uncertainty and doubt

    I love the acronym FUD which stands for "Fear, uncertainty and doubt". What I don't love is the underhanded use of FUD to manipulate peoples behavior. Spreading FUD is not about creating something new, but destroying- destroying someones confidence in something, clouding the real issue, stopping a new or creative direction from being taken. FUD [...]

    1/11/10 • (0)

  • Vlookup, Excel and social media.

    Somebody is always doing a study on how much lost productivity is costing companies when people do something other than work at work. It used to be that the business intelligence companies were always going on about how much time people "wasted" using excel- now a days it's the huge cost of employees using social [...]

    11/17/09 • (0)

  • The Microsoft Version Skip- XP Mode

    Microsoft has announced that they will include a license of XP, running on a "seamless" virtual environment that can be run inside Windows 7. It's being dubbed "XP Mode". They have decided not to include a "Vista mode", citing lack of demand. This is a very smart move on the part of Microsoft. Aside from [...]

    4/27/09 • (0)

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

    3/31/09 • (2)

  • Excel auto formating is getting into your genes

    We often give Excel our data, and trust it to do the right thing. There was a link posted on meta-filter today that sparked some lively discussion amongst the crowd. The Excel auto formating "feature" loves to scramble common genetic nomenclature. It turns out that in the genetics field, common codes get converted to incorrect [...]

    3/04/09 • (0)

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

    2/17/09 • (0)

  • Importing Data into Excel

    I've seen lots of Business Intelligence (BI) solutions, (data marts, data warehouses and the accompanying reports and dashboards) using all sorts of different tools. But I'll tell you- NO tool has yet been as successful as Microsoft Excel for providing a do it yourself data analysis platform to import data into. Now, I'm not suggesting [...]

    9/01/08 • (Comments Off)

  • The wonderous resistance to CHANGE

    Its not easy to get good figures on just how many people have switched to Excel 2007, but from what I've been able to find its sounding like not more than 20%- this figure a near random guess based on complex methods such as random Google searches.  (There are of course power user, or early [...]

    6/05/08 • (0)

  • Setting the stage: managing data issues

    Anyone who has done any data analysis with more than a few lines of data knows that some of the biggest time wasters are data quality issues. What is bad data?  Well, some of it is easy to see, some is downright impossible to find. Lets look at an easy example; a row of data where the country [...]

    5/01/08 • (0)