Category archive for ‘Spreadsheet Tips’ 
-
Purchasing Data Mart – cutting costs with analysis (Part 1)
In these difficult economic times, cutting costs isn't just optimization, it's survival. You can't reduce what you can't quantify so it's critical to analyze the accounts payable (AP), or purchasing data to identify the areas where cost savings are possible. This is one of the most useful financial data marts because spending is often something [...]
-
Duplicate Data and removing duplicate records
Duplicate records, doubles, redundant data, duplicate rows; it doesn't matter what you call them, they are one of the biggest problems in any data analyst's life. There are lots of different types of data quality problems, but in this post I'll focus on Duplicates. I'll share some hints on how to find duplicate records and remove duplicate records, [...]
-
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 [...]
-
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 [...]
