Teaching analytics with modern Excel
As an analyst you will frequently receive data in FNAME LNAME format. This is poor data design -- it does not allow you to sort the data A-Z by last name. In this video I will show you how to convert …
Continue Reading about Convert from FNAME LNAME to LNAME, FNAME in Excel →
Excel gets a bad rap for poor documentation of work. In this video I will show three ways to document and trace work in a spreadsheet. This will help you and your coworkers make better sense of …
Continue Reading about Documenting your Excel Workbook — 3 Ways →
"This is good," a fellow doctoral student told me at our meeting the other day. "You are asking people for help. I should have done that." One suggestion this older student gave to me was not to be …
One thing I've grappled with frequently on this blog is whether I am an "Excel blogger."It is probably increasingly clear that I do not primarily write about Excel. This is especially true …
Continue Reading about Excelstentialism and Systems Blogging →
One of my favorite parts of learning is making connections between seemingly unrelated things.Here's one. Half of all enterprise resource planning (ERP) systems fail. Why? Often they do not account …
Continue Reading about What Your IT Manager Can Learn from the US Constitution →
I am becoming skeptical about the promises of Big Data.Surprised? So am I.The Big Data worldview tends to see information as a natural resource, like oil. It emerges from some chemical or physical …
Continue Reading about Does Big Data Overlook Human Behavior? →
