Blog

Beekeeper Data Shutting Down on August 31st 2017

by Matthew Rathbone, June 19, 2017

It is with great sadness that I announce the shut down of all Beekeeper Data services on August 31st 2017.
Read more »

Introducing Scheduled Jobs. Run SQL On A Schedule, Sync To Email Or Google Sheets

by Matthew Rathbone, February 28, 2017

Run a SQL query every day, week, or Month, get results emailed to you or synced to Google Sheets automatically
Read more »

Announcing Business Intelligence and Analytics for Heroku

by Matthew Rathbone, February 07, 2017

Our new Heroku add-on provides powerful analytics capabilities for any Heroku application. Write SQL, get results.
Read more »

Visualizing Heroku App Data with Google Sheets

by Matthew Rathbone, February 03, 2017

I'll show you how to build pivot tables and charts in Google Sheets in order to visualize your Heroku Postgres data and track basic analytics data.
Read more »

Release 7.0.0

by Lucas Gray, December 06, 2016

Release 7.0.0 introduces many style and UI updates, and new business user/developer views to streamline your work process.
Read more »

Moving data from Heroku Postgres to Google Sheets

by Matthew Rathbone, December 06, 2016

Learn how to quickly get data from your Heroku app into Google Sheets so you can start monitoring your software.
Read more »

How to Set Up a Read-Only PostgreSQL Slave Server for Data Analytics

by Matthew Rathbone, November 09, 2016

It is good practice to isolate your production database from data analytics users. We'll teach you how to make a read-only replica so your analytics users can go nuts.
Read more »

How to Create a Read-Only Database User in Postgres for Analytics and Reporting

by Matthew Rathbone, October 07, 2016

Need to provide access to your Postgres database for analytics and reporting? This post will be very helpful.
Read more »

Release 6.0.0

by Beekeeper Staff, August 15, 2016

Release notes for August 2016
Read more »

Cats vs. Dogs: A Belated International Cat Day Debate

by Leigh Gray, August 09, 2016

We took an internal poll to determine cats vs. dogs and why as our way of celebrating International Cat Day.
Read more »

Nav Highlighting with Ember and Bootstrap

by Zach Foster, August 01, 2016

How to highlight links using a complex Bootstrap navbar in a real Ember.js application - we'll walk through code, gotchas, and implementation details.
Read more »

Writing Legible SQL with Common Table Expressions

by Lucas Gray, July 26, 2016

Writing legible SQL is important for maintainability. We'll walk through a real life example of how to write clear and concise SQL with Common Table Expressions (CTEs).
Read more »

6 Reasons You Shouldn't Use Cron to Schedule Your MapReduce and Spark Jobs

by Matthew Rathbone, July 19, 2016

Got batch jobs you need to run nightly? Cron seems like a simple solution, but it's more trouble than it's worth.
Read more »

Release 5.0.0

by Beekeeper Staff, July 15, 2016

Release notes for July 2016
Read more »

Joy & Agony: Fan Loyalty & Perception of Euro 2016

by Beekeeper Staff, July 11, 2016

Game-by-game sentiment analysis of /r/soccer fan comments during Euro 2016. Was your team a good sport?
Read more »

Importing Relational Data into Hadoop with Sqoop and Sqoop2

by Matthew Rathbone, June 29, 2016

Got data in MySQL, Redshift, Postgres, or similar and want it in Hadoop? I'll go through how transfer the data using the open source Sqoop tool.
Read more »

Release 4.0.0

by Beekeeper Staff, June 15, 2016

Release notes for June 2016
Read more »

Release 3.0.0

by Beekeeper Staff, May 15, 2016

Release notes for May 2016
Read more »

Release 2.0.0

by Beekeeper Staff, April 15, 2016

Release notes for April 2016
Read more »

Redshift vs. MySQL: How to Determine the Right Data Analytics Solution

by Beekeeper Staff, February 16, 2016

In this post, I'm going to look at some of the advantages of MySQL and Amazon's Redshift, and give you ideas on which might be best for your organization.
Read more »

5 Signs You Should Move Your Excel Spreadsheet Data to a Database

by Beekeeper Staff, February 16, 2016

If your organization's data assets are rapidly increasing, it may be a sign that it's time to consider a relational database.
Read more »

A Business User's Guide to Databases - What Is a Database and Why Should I Care?

by Beekeeper Staff, February 09, 2016

Databases are collections of information that are organized in such a way that users can quickly access both specific data elements and groups of related data.
Read more »

5 Free Query Tools for SQL

by Beekeeper Staff, February 01, 2016

These five query tools give you the ability to experiment with your data without a financial commitment.
Read more »

Top 10 Resources for Learning SQL as a Business User

by Beekeeper Staff, January 29, 2016

These ten resources - many of which are low-cost or free - are helpful in becoming familiar with SQL to maximize data use for business improvement.
Read more »

Excel vs. Access - What Are the Differences?

by Beekeeper Staff, January 28, 2016

Excel and Access are key products for analysts to consider when trying to decide between a spreadsheet or a simple database.
Read more »

A Business User's Guide to SQL - What Is It and Why Should I Care?

by Beekeeper Staff, January 12, 2016

Structured query language (SQL) is the standard language for communicating with relational database management systems. For data analysts who need to retrieve, update, and analyze records stored in a database, SQL is the most common tool.
Read more »

5 Free Visualization Tools To Help Understand Your Big Data

by Beekeeper Staff, January 05, 2016

Visualization tools help you get a clearer picture of the data you're working with, and make better decisions with the results. Here are five free visualization tools for big data.
Read more »

Apache Spark Java Tutorial with Code Examples

by Beekeeper Data, December 28, 2015

To follow my post implementing a pipeline in regular Spark, I do the same thing with Java. The walkthrough includes open source code and unit tests.
Read more »

Bar Charts vs. Line Charts: How to Make Your Data Sing

by Beekeeper Staff, December 21, 2015

Data visualizations don't need to be complex to communicate your message. Bar and line charts are two effective options for illustrating business changes at data-driven organizations.
Read more »

Apache Spark Scala Tutorial with Examples

by Beekeeper Data, December 14, 2015

I implement a realistic pipeline in Spark as part of my series on Hadoop frameworks. The walkthrough includes open source code and a unit test.
Read more »

What is a Pivot Table and Why Should I Use One?

by Matthew Rathbone, December 07, 2015

The pivot table is a powerful tool you can utilize to help organize and sort through information. When thousands–or even millions–of data points become overwhelming, pivot tables help us put them back in order.
Read more »

8 Ways To Improve Customer Experience For Your Digital Business

by Beekeeper Staff, November 30, 2015

You run a website, SaaS product, or other digital business. Retaining customers is vital, and these simple tips will allow you to increase the quality of your customer experience, and thrive.
Read more »

6 Often Overlooked Metrics That All SaaS Companies Need to Track

by Matthew Rathbone, November 23, 2015

There are some fundamental metrics that highlight the health of a SaaS business. We provide calculations and examples, so if you're a SaaS business you should be tracking them!
Read more »

Announcing the Availability of Beekeeper Data's Reporting Platform

by Matthew Rathbone, November 10, 2015

Our reporting product is now available. Beekeeper makes reporting as easy as sending a newsletter.
Read more »

What it Takes to Become a Data Driven Organization: 3 Leaps of Faith

by Julia Scavicchio, October 01, 2015

Discover the 3 leaps every organization must take to become data driven
Read more »

5 Factors to Consider in the “Build or Buy” Decision for Reporting Software

by Jillian D'Arcy, September 15, 2015

Learn the top five factors companies should consider when deciding to build or buy a reporting software
Read more »

3 Tips for Crafting an Effective Customer Reporting Strategy

by Jillian D'Arcy, August 27, 2015

Learn how to craft an effective strategy for sending data to customers
Read more »

Hadoop Hive UDAF Tutorial - Extending Hive with Aggregation Functions

by Matthew Rathbone, August 17, 2015

How to implement a UDAF function in Hive to build table-spanning functions like sum() and count()
Read more »

How to Reduce SaaS Churn Rate Through Effective Reporting

by Jillian D'Arcy, August 04, 2015

Through effective reporting strategies SaaS companies can reduce customer churn rate. We explain how and go through a couple of examples
Read more »

Hadoop Hive UDTF Tutorial - Extending Apache Hive with Table Functions

by Matthew Rathbone, July 26, 2015

How to implement a UDTF in Apache Hive to allow multiple column and row outputs from a custom function like explode()
Read more »

Integrate Google Sheets into Your Scala Application in 4 Steps

by Lucas Gray, May 18, 2015

Getting started integrating Google Sheets into your Scala application can seem daunting. From picking the right dependencies for your use case, to enabling OAuth 2.0, to dealing with the crufty Java APIs, there are plenty of rabbit holes and gotchas. Fortunately, we've handled them so you don't have to!
Read more »

Five Resources for Learning Scala

by Mike Marr, May 01, 2015

Some of Scala's appeal is the ease of transition from Java and other object-oriented languages. Although Scala is object-oriented and runs on the JVM, transition into a mature Scala project is far from easy. Here are five ways to make it easier
Read more »