Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading
Awkward Data
Posts Tagged → normalize
Normalize Data using Excel Get & Transform
In my last post I used formulas to solve a messy data disaster. In this post/video I’ll show you how to use Excel’s amazing Get & Transform feature (aka Power Query) to re-arrange the data. Continue reading
Data Disaster: non normalized data
Imagine a weekly task of sending out a simple report. To do this you rely on data from someone else. When the layout of the data changes chaos reigns! What can we do? Continue reading
Video 00167 Sliding Formula Ranges
Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your analysis. This post contains three examples in which normalizing your data might not be necessary when doing a quick analysis. Continue reading
Video 00122 Normalizing Exported Data
Many of us enjoy puzzles. Sudoku, Crosswords, Chess, etc. I solve a lot of data puzzles using Microsoft Excel. A few months ago, a YouTube viewer had this question for me. Continue reading