Attendees will hear the multi-year story of my tool evolution and use at an education non-profit. We start from a world of only having Excel and spending days manually formatting reports, and end in a world of Excel plus databases, Tableau and Python. There will be numerous demonstrations of past (and current) applications of tools. With every tool, attendees will hear the motivations behind adoption, the challenges in implementation, and the long term impact.
Attendees will walk away having learned:
-Strengths and Limitations of Excel
-Exposure to new tools (VBA, SQL, Tableau, Python), with a reasoned understanding of their respective strengths and weaknesses.
-Approaches for identifying process bottlenecks in data workflow
-Understanding of data challenges being separated as being collection, storage, access, visualization, and analysis
-Key questions to ask (and get answered) before investing in a new tool
-Strategies on successful launch and implementation of new tools