ETL stands for Extract, Transform, Load. It has been a traditional way to manage analytics pipelines for decades. With the advent of modern cloud-based data warehouses, such as BigQuery or Redshift, the traditional concept of ETL is changing towards ELT – when you’re running transformations right in the data warehouse. Let’s see why it’s happening, what it means to have ETL vs ELT, and what we can expect in the future.
ETL arose to solve a problem of…Continue
Added by Luba Belokon on April 6, 2018 at 7:30am — No Comments
One of the first things we do after launching a website nowadays is connect to Google Analytics. A little bit down the road we’ll connect more “out-of-box” analytics tools to calculate funnels, retention, A/B tests, and more.
These tools are great and work fine until a company gets bigger and analytics requirements get more sophisticated. It’s time to set up a data infrastructure, which means selecting a data collection tool, ETL tool, data warehouse, and BI tool on top of…Continue
Added by Luba Belokon on March 30, 2018 at 3:30am — No Comments
Many of “out-of-the-box” analytics solutions come with automatically defined user sessions. It’s good to start with, but as your company grows, you’ll want to have your own session definitions based on your event data. Analyzing user sessions with SQL gives you flexibility and full control over how metrics are defined for your unique business.
The session is usually defined as a group…
Added by Luba Belokon on March 27, 2018 at 1:00am — No Comments
Quite recently we’ve built event analytics for our team and thought to share this experience with you in this post .
Many of “out-of-the-box” analytics solutions come with automatically defined user sessions. It’s good to start with, but as your company grows, you’ll want to have your own session definitions based on your event data. Analyzing user…Continue
Added by Luba Belokon on February 8, 2018 at 7:30am — No Comments
The Statsbot team estimated LTV 592 times for different clients and business models.
Customer lifetime value, or LTV, is the amount of money that a customer will spend with your business in their “lifetime,” or at least, in the portion of it that they spend in a relationship with you. It’s an important indicator of how much you can spend on acquiring new customers. For example, your customer acquisition cost (CAC) is $150, and LTV is…Continue
Added by Luba Belokon on February 1, 2018 at 8:30am — No Comments
Which database is best? The question, obviously, depends on what you want to use it for.
I, like most analysts, want to use a database to warehouse, process, and manipulate data—and there’s no shortage of thoughtful commentary outlining the types of databases I should prefer. But these evaluations, which typically discuss databases in terms of …Continue
Added by Benn Stancil on December 9, 2015 at 9:00am — No Comments
How often are you stuck waiting for someone else to pull data for you? There's nothing worse than missing a deadline because someone else didn't do a 30 second query. Never again - here are the basic queries that will get you numbers instantly for pivoting, graphing, and other applications of your analysis skills, as applied to an imaginary table of sales data:
Get It All…
Added by Matt Ritter on October 25, 2015 at 12:57pm — No Comments
Asking questions is easy. It’s so easy that, as askers, we often don’t think about the quality of our questions. Poorly framed questions waste everyone’s time—yours included—because they require the answerer to make assumptions. When it comes to asking analysts to explore a problem you’re trying to solve, better questions will drive better analysis and, ultimately, more actionable answers.
Here’s an example:
Marketer: “How many people converted from paid ad…Continue
Added by Derek Steer on March 19, 2015 at 11:49am — No Comments