Product

Open Source vs. Periscope Data for Python and R Analyses

Wondering if you should use open source tools (such as Jupyter Notebook, R Studio) or analytics solutions (such Periscope Data) for your analysis? We examined the workflow from setup through permission to provide you with an objective comparison.

<div><div class="w-embed"><style>/* Inertia Scroll for iOS */@media only screen and (max-width: 991px){.row-table-wrap{overflow-y: scroll;-webkit-overflow-scrolling: touch;}}</style></div><div class="object-full-width"><div class="section no-border"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a821f7332f0d300017e685a_pd-icon-setting.svg" width="80" alt="setup icon"></div><h2>Setup</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="rich-text-block w-richtext"><p><strong>On local machine (individual laptops)</strong>:</p><ul><li>Requires download and installation</li><li>Data size you can work with depends on your&nbsp;RAM</li><li>Risk of inconsistent analysis across multiple laptops</li></ul><p><strong>On company server</strong>:</p><ul><li>Requires IT to provision the server, ensure the right software, maintain virtual environments, etc.</li></ul></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p><strong>Handled by Periscope</strong></p><ul><li>On a Periscope server</li><li>Software pre-installed</li><li>Unlimited RAM of the Periscope server</li></ul></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a034f9c8bafc9000141c07e_pd-logomark.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Periscope Wins</strong> — Periscope allows users to hit the ground running immediately</div></div></div></div><div class="section no-border greyer"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a7b99f5737da00001ab2daa_pd-icon-python.svg" width="48" alt="python icon" class="margin-right"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a7b9a374d05920001621f15_pd-icon-r.svg" width="48" alt="R icon"></div><h2>Getting Data For Analysis</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><ul><li>Manually query through a SQL tool, download a CSV and upload into a Python or R tool, OR</li><li>Set up a database connection in a Python or R tool, and query from there</li><li>Data cannot be easily combined across databases — limited to what can be stored locally.</li></ul></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><ul><li>Easily combine terabytes of data from across organization with native cross-database joins</li><li>Access to data when you need it and&nbsp;work with it where it lives.</li></ul></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><div><strong>Tie</strong>&nbsp;— depends on what you need to get done</div></div></div></div><div class="section no-border"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a822725bd255a0001fa41c4_pd-icon-library.svg" width="80" alt="libraires icon"></div><h2>Libraries And Packages</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><ul><li><strong>On local environment:</strong>&nbsp;can install any software and libraries to help develop</li><li><strong>On a server:</strong>&nbsp;may or may not require software and libraries to be defined at setup</li></ul></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p>Most common libraries and packages are pre-installed in Periscope Data (e.g. Pandas, Sklearn, Matplotlib, etc.)</p><ul><li>Cannot install more on your own, but can submit requests to <a href="mailto:[email protected]">[email protected]</a>&nbsp;&nbsp;</li></ul></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a8226ba72707c000122a54b_icon-open-source.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Open Source Wins</strong>&nbsp;— Open Source tools give you more choices upfront</div></div></div></div><div class="section no-border greyer"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a82275d71acd50001b169b1_pd-icon-chart%20and%20dashboard.svg" width="80" alt="visualization icon"></div><h2>Visualization</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><p>Visualize using any libraries and packages. However, customizing charts in matplotlib can be tedious.</p></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p><strong>2 options:</strong></p><ul><li>Use pre-installed libraries and packages, OR&nbsp;</li><li>Use Periscope’s native &amp; interactive charting options (which does not require codes to customize)&nbsp;&nbsp;</li></ul></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a034f9c8bafc9000141c07e_pd-logomark.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Periscope Wins</strong>&nbsp;— Periscope makes visualization extremely&nbsp;easy</div></div></div></div><div class="section no-border"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a82283cbd255a0001fa424c_pd-icon-analyze_1.svg" width="80" alt="analyze icon"></div><h2>Analysis Time</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><ul><li>Analysis can run for any length of time</li></ul></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p>4 minute timeout</p></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a8226ba72707c000122a54b_icon-open-source.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Open Source Wins</strong>&nbsp;— Open Source tools are more flexible</div></div></div></div><div class="section no-border greyer"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a8228b025c8bc00017cd9df_pd-icon-version%20control.svg" width="80" alt="version control icon"></div><h2>Version Control</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><p>Set up a Github repository and do version control</p></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p>Your analysis is automatically version controlled, ensuring you can recover older versions any time</p></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><div><strong>Tie</strong>&nbsp;— Open Source gives you more flexibility and full Github control while Periscope gives user easy version control</div></div></div></div><div class="section no-border"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a8228ccbd255a0001fa427a_pd-icon-share.svg" width="80" alt="sharing icon"></div><h2>Sharing</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><p>Manually download or screenshot images, then paste into emails and documents for sharing. OR</p><p>Uploading an entire Jupyter Notebook onto a server:</p><ul><li>Requires server resources and setup</li><li>Requires sharing of the Jupyter Notebook link for people to see analysis</li></ul></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p>Many Periscope sharing features available natively: URL, email, Slack integration, printed PDF, TV mode for presentation, etc.</p></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a034f9c8bafc9000141c07e_pd-logomark.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Periscope Wins</strong>&nbsp;— Users can easily share the way they want&nbsp;to</div></div></div></div><div class="section no-border greyer"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a822931bd255a0001fa429b_pd-icon-dependency%20map.svg" width="80" alt="visualization icon"></div><h2>Permission</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><p>Permissions must be managed through whatever tool is used for sharing</p></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p>Periscope’s permissions available to limit query and edit access and view access</p></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a034f9c8bafc9000141c07e_pd-logomark.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Periscope Wins</strong>&nbsp;— Users have one place to manage all permissions</div></div></div></div><div class="section no-border"><div class="row"><div class="column center-content"><div><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a82297832f0d300017e731c_pd-icon-finance.svg" width="80" alt="pricing icon"></div><h2>Pricing</h2><div class="spacer1"></div></div></div><div class="row"><div class="column no-padding"><div class="row"><div class="column"><h5 class="object-full-width border-bottom border-teal">Open Source Tools</h5><div class="w-richtext"><p>Upfront cost is free</p></div></div><div class="column"><h5 class="object-full-width border-bottom border-purple text-purple">Periscope Data</h5><div class="w-richtext"><p><a href="http://periscopedata.com/contact">Contact us for a quote</a></p></div></div></div></div></div><div class="row row-table"><div class="column infographic-result"><img src="https://uploads-ssl.webflow.com/589e47d231ee752554896ef9/5a8226ba72707c000122a54b_icon-open-source.svg" width="48" alt="Periscope Logomark" class="margin-right"><div><strong>Open Source Wins</strong></div></div></div></div><div class="section no-border"><div class="row"><div class="column"><div class="w-richtext"><h2>Conclusion</h2><p>Open source options for Python and R analyses can be very powerful with abilities to customize every bit of your experience and the upfront cost is low. However, there are costs associated with setup time, having a fragmented analytics workflow, and risk of inconsistent analysis across teams.</p><p>With Periscope Data, you can hit the ground running immediately, spending your time on analyzing data, then easily visualizing and sharing your insights. Periscope Data takes away the hard work and leaves you with only the part of the job you love — looking for insights in the&nbsp;data.</p></div><div class="spacer1"></div></div></div></div></div></div>

Tags: 

Want to discuss this article? Join the Periscope Data Community!

Periscope Data
The world’s fastest visualization platform for data analysts.