Since 2014, Jeff Gallant has been on a data odyssey, from managing Affordable Learning Georgia's humble data origins in annual cost savings estimates to wrangling a system of gigantic, unwieldy spreadsheets which only could communicate with each other through application-breaking formulas and a dice roll that Excel would not crash. It's about time that he fixed this mess - and you can fix it, too! Join Jeff in an exploration of dimensions, tall data, folders imitating databases, and ultimately a new level in data connections and visualizations.
Attendees of this session will be able to:- Explain the difference between dimension tables and fact tables
- Convert a wide spreadsheet into a system of dimensions and tall data
- Connect fact tables together using a folder system
- Connect disparate data with each other through data modeling