Tag Archives: Excel

Excel tip: How to clean duplicate rows

Data is often imperfect. As consultants we know that perfect data is a myth. No matter the organization or website, data is gunky, irregular, and often broken. Was at Starbucks this morning doing my travel and expenses. Went to the American Express website and downloaded the last 6 months of corporate charges, or about $34K in planes,… Read More »

Data analysis in 20 minutes

Consultants are in the business of taking messy, unorganized data and turning it into information, and hopefully, some insights. Here is a simple example of excel clean up, and the steps to copy, paste, filter, sort, and cleanse data. For most consultants, the data cleansing would 7-10 minutes (takes some trial and error) and the graphics would be… Read More »

No more excel graphs, Tableau is the future

Tableau. Yes, this is french for Table.  It is also the most user-friendly, powerful, and amazing desktop visualization tool for consultants. Tableau is a company based out of Seattle Washington, founded in 2003 to commercialize work out of Stanford. Fast-forward 10 years, and it is a publicly traded company of 1,500+ employees, $232 million in revenue… Read More »