Date: Mon, 20 Jan 2020 11:00:00 -0500
<div class="wp-block-jetpack-markdown"><h3>Summary</h3> <p>In order for an organization to be data driven they need easy access to their data and a simple way of sharing it. Arik Fraimovich built Redash as a way to address that need by connecting to any data source and building attractive dashboards on top of them. In this episode he shares the origin story of the project, his experiences running a business based on open source, and the challenges of working with data effectively.</p> <h3>Announcements</h3> <ul> <li>Hello and welcome to Podcast.__init__, the podcast about Python and the people who make it great.</li> <li>When you’re ready to launch your next app or want to try a project you hear about on the show, you’ll need somewhere to deploy it, so take a look at our friends over at Linode. With 200 Gbit/s private networking, scalable shared block storage, node balancers, and a 40 Gbit/s public network, all controlled by a brand new API you’ve got everything you need to scale up. And for your tasks that need fast computation, such as training machine learning models, they just launched dedicated CPU instances. Go to <a href="https://www.pythonpodcast.com/linode?utm_source=rss&utm_medium=rss">pythonpodcast.com/linode</a> to get a $20 credit and launch a new server in under a minute. And don’t forget to thank them for their continued support of this show!</li> <li>You listen to this show to learn and stay up to date with the ways that Python is being used, including the latest in machine learning and data analysis. For even more opportunities to meet, listen, and learn from your peers you don’t want to miss out on this year’s conference season. We have partnered with organizations such as O’Reilly Media, Corinium Global Intelligence, ODSC, and Data Council. Upcoming events include the Software Architecture Conference in NYC, Strata Data in San Jose, and PyCon US in Pittsburgh. Go to <a href="https://www.pythonpodcast.com/conferences?utm_source=rss&utm_medium=rss">pythonpodcast.com/conferences</a> to learn more about these and other events, and take advantage of our partner discounts to save money when you register today.</li> <li>Your host as usual is Tobias Macey and today I’m interviewing Arik Fraimovich about Redash, an open source business intelligence platform that helps you make sense of your data.</li> </ul> <h3>Interview</h3> <ul> <li> <p>Introductions</p> </li> <li> <p>How did you get introduced to Python?</p> </li> <li> <p>Can you start by describing what Redash is and its origin story?</p> <ul> <li> <p>What are the primary ways that it is used?</p> </li> <li> <p>The business intelligence market is quite mature and has many commercial and open source projects to choose from. What are the aspects of Redash that have allowed you to be successful?</p> </li> <li> <p>What would you consider to be your closest competitors?</p> </li> </ul> </li> <li> <p>What was your background with data before starting on Redash?</p> <ul> <li>What are some of the most notable lessons that you have learned about business intelligence since starting the project?</li> <li>How has the landscape for business intelligence and data analysis changed since you began the project?</li> </ul> </li> <li> <p>Beyond just accessing data, Redash focuses on enabling visualization of the results. What types of visualizations do you support and how do you support users in choosing the most effective ways to represent the information?</p> </li> <li> <p>What are some of the common challenges that your users and customers encounter when communicating with data?</p> </li> <li> <p>One of the critical aspects of enabling data access in an organization is the ability to collaborate on asking and answering questions. How do you approach that challenge in Redash?</p> </li> <li> <p>How is Redash implemented and how has the overall design and architecture evolved since you first started working on it?</p> <ul> <li>How do you manage the complexity of supporting so many different data sources?</li> <li>If you were to start over today, what would you do differently?</li> </ul> </li> <li> <p>Beyond the code of Redash, you also have a business around providing it as a hosted service. What are some of the most interesting, challenging, or unexpected lessons that you have learned in the process of building and growing that service?</p> </li> <li> <p>How do you approach the direction and governance of the open source project and balance that against the wants and needs of the community?</p> </li> <li> <p>What are some of the most interesting, innovative, or unexpected ways that you have seen Redash used?</p> </li> <li> <p>When is Redash the wrong platform to use?</p> </li> <li> <p>What do you have planned for the future of the Redash business and project?</p> </li> </ul> <h3>Keep In Touch</h3> <ul> <li><a href="https://github.com/arikfr?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">arikfr</a> on GitHub</li> <li><a href="http://arikfr.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Website</a></li> <li><a href="https://twitter.com/arikfr?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">@arikfr</a> on Twitter</li> </ul> <h3>Picks</h3> <ul> <li>Tobias <ul> <li><a href="https://www.dataengineeringpodcast.com?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Engineering Podcast</a></li> </ul> </li> <li>Arik <ul> <li><a href="http://docs.peewee-orm.com/en/latest/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Peewee ORM</a></li> <li><a href="https://aws.amazon.com/ecs/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Amazon ECS</a></li> </ul> </li> </ul> <h3>Closing Announcements</h3> <ul> <li>Thank you for listening! Don’t forget to check out our other show, the <a href="https://feeds.fireside.fm/pythonpodcast/rss">Data Engineering Podcast</a> for the latest on modern data management.</li> <li>Visit the <a href="https://www.pythonpodcast.com?utm_source=rss&utm_medium=rss">site</a> to subscribe to the show, sign up for the mailing list, and read the show notes.</li> <li>If you’ve learned something or tried out a project from the show then tell us about it! Email <a href="mailto:hosts@podcastinit.com">hosts@podcastinit.com</a>) with your story.</li> <li>To help other people find the show please leave a review on <a href="https://itunes.apple.com/us/podcast/podcast.-init/id981834425?mt=2&uo=6&at=&ct=&utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">iTunes</a> and tell your friends and co-workers</li> <li>Join the community in the new Zulip chat workspace at <a href="https://www.pythonpodcast.com/chat?utm_source=rss&utm_medium=rss">pythonpodcast.com/chat</a></li> </ul> <h3>Links</h3> <ul> <li><a href="https://redash.io/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Redash</a></li> <li><a href="https://cloud.google.com/appengine/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Google App Engine</a></li> <li><a href="https://github.com/EverythingMe?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">EverythingMe</a></li> <li><a href="https://aws.amazon.com/redshift/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">RedShift</a></li> <li><a href="https://www.metabase.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Metabase</a> <ul> <li><a href="https://www.dataengineeringpodcast.com/metabase-with-sameer-al-sakran-episode-29/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Engineering Podcast Interview</a></li> </ul> </li> <li><a href="https://superset.apache.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Apache Superset</a></li> <li><a href="https://www.elastic.co/products/elasticsearch/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Elasticsearch</a> <ul> <li><a href="https://www.dataengineeringpodcast.com/elastic-stack-with-philipp-krenn-episode-23/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Engineering Podcast Interview</a></li> </ul> </li> <li><a href="https://www.tableau.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Tableau</a></li> <li><a href="https://looker.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Looker</a> <ul> <li><a href="https://www.dataengineeringpodcast.com/looker-with-daniel-mintz-episode-55/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Engineering Podcast Interview</a></li> </ul> </li> <li><a href="https://powerbi.microsoft.com/en-us/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">PowerBI</a></li> <li><a href="https://en.wikipedia.org/wiki/Data_warehouse?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Warehouse</a></li> <li><a href="https://en.wikipedia.org/wiki/Data_lake?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Lake</a></li> <li><a href="https://aws.amazon.com/athena/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Athena</a></li> <li><a href="https://spark.apache.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Spark</a> <ul> <li><a href="https://www.dataengineeringpodcast.com/putting-apache-spark-into-action-with-jean-georges-perrin-episode-60/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Engineering Podcast Interview</a></li> </ul> </li> <li><a href="https://redash.io/help/user-guide/visualizations/funnel-howto?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Redash Funnel Visualization</a></li> <li><a href="https://www.stephen-few.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Stephen Few</a></li> <li><a href="https://palletsprojects.com/p/flask/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Flask</a></li> <li><a href="https://www.sqlalchemy.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">SQLAlchemy</a></li> <li><a href="https://redis.io/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Redis</a></li> <li><a href="https://www.postgresql.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">PostgreSQL</a> <ul> <li><a href="https://www.dataengineeringpodcast.com/postgresql-with-jonathan-katz-episode-42/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Data Engineering Podcast Interview</a></li> </ul> </li> <li><a href="http://www.celeryproject.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Celery</a></li> <li><a href="https://python-rq.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">RQ</a></li> <li><a href="https://en.wikipedia.org/wiki/Tornado?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Tornado</a></li> <li><a href="https://docs.djangoproject.com/en/dev/topics/db/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Django ORM</a></li> <li><a href="https://angularjs.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">AngularJS</a></li> <li><a href="https://reactjs.org/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">ReactJS</a></li> <li><a href="https://nodejs.org/en/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">NodeJS</a></li> <li><a href="https://redash.io/help/user-guide/querying/query-results-data-source?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Redash Query Results Data Source</a></li> <li><a href="https://www.ibm.com/analytics/db2?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">IBM DB2</a></li> <li><a href="https://retool.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Retool</a></li> <li><a href="https://www.forestadmin.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Forest Admin</a></li> <li><a href="https://grafana.com/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">Grafana</a></li> </ul> <p>The intro and outro music is from Requiem for a Fish <a href="http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">The Freak Fandango Orchestra</a> / <a href="http://creativecommons.org/licenses/by-sa/3.0/?utm_source=rss&utm_medium=rss" rel="noopener" target="_blank">CC BY-SA</a></p> </div> <img alt="" height="0" src="https://analytics.boundlessnotions.com/piwik.php?idsite=1&rec=1&url=https%3A%2F%2Fwww.pythonpodcast.com%2Fredash-data-driven-dashboards-episode-246%2F&action_name=Building+A+Business+On+Building+Data+Driven+Businesses+-+Episode+246&urlref=https%3A%2F%2Fwww.pythonpodcast.com%2Ffeed%2F&utm_source=rss&utm_medium=rss" style="border: 0; width: 0; height: 0;" width="0" />