Subscribe to DSC Newsletter

All Blog Posts Tagged 'sql' (8)

ETL vs ELT: Considering the Advancement of Data Warehouses

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 is hard and outdated

ETL arose to solve a problem of…

Continue

Added by Luba Belokon on April 6, 2018 at 7:30am — No Comments

Data Collection Tools for Events Analytics

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

Event Analytics: How to Define User Sessions with SQL

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.  

What is a session and why should I care?



The session is usually defined as a group…

Continue

Added by Luba Belokon on March 27, 2018 at 1:00am — No Comments

Event Analytics: How to Define User Sessions with SQL

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

Using SQL to Estimate Customer Lifetime Value (LTV) without Machine Learning

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

What's the best database for an analyst?

Which database is best? The question, obviously, depends on what you want to use it for.

Best Database Search

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

3 Essential SQL Queries in 1.5 Minutes

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…

Continue

Added by Matt Ritter on October 25, 2015 at 12:57pm — No Comments

How to Ask an Analyst a Question

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

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

1999

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service