This episode covers the journey of Jeff Davies from finance to founding an energy data startup. Jeff shares how his 30-year career in spreadsheets led him to create Intersection, a platform for energy insights. Frustrated by the manual effort to create charts, Jeff partnered with developers to build an API aggregation tool in Google Sheets. This evolved into Wrapify, which automates data visualization and reporting. The product helps users create charts in Sheets and seamlessly flow them into Slides.
-Jeffrey’s background in banking, finance, and energy trading. Discussions on the Enron scandal and early days of credit default swaps.
-The idea behind Wrapify – automating data visualization and reporting workflows using Google -Sheets and Datawrapper. Allows users to turn spreadsheet data into interactive charts, then drag and drop charts into presentations or documents.
-Benefits of Wrapify for investment analysts, consultants, sales teams, reporting, etc. Saves huge amounts of time compared to manually updating charts.
-Using Google Apps Script to pull data from APIs directly into Sheets on a schedule. Aggregating data sources into one centralized platform.
-Overview of how Wrapify came together very quickly over the past few months. Leveraging existing tools like Datawrapper in creative ways.
-The future of AI and how it could play a role in energy data analytics. Risks and benefits of increased automation.
-Jeffrey’s thoughts on macro trends in the energy industry – consolidation, growth projections, OPEC influence.
-Finding unique datasets to analyze, avoiding biases, and importance of top-down macro view.
-Cryptocurrency discussion – risks, benefits, and unknowns around recession impact.