.

All Blog Posts Tagged 'sql' (12)

Single or Multiple Lines: What's Better For Python Code Readability?

In another article, we discussed how to simplify your Python code for optimal readability. That piece covered why writing simpler code will help with the reader’s comprehension of your syntax and force you to think about problems in a way that is easier to explain to those who may not be as technically savvy. This article will…

Continue

Added by Zoe Zbar on December 22, 2020 at 12:04pm — No Comments

How and Why You Should Be Explicit When Python Coding

In a previous article, you learned how to format your Python code for optimal readability. That piece went into detail about spacing, number of characters on a line, and more. In this article, you will learn how to keep your Python code explicit to ensure others fully understand your work and eliminate any possible confusion. This good practice will…

Continue

Added by Zoe Zbar on December 22, 2020 at 12:00pm — No Comments

Best Naming Conventions When Writing Python Code

Naming Conventions 

During a recent workshop, bootcamp instructor Alex Baransky shared some of the best practices in writing Python code for better readability. Through this series of articles, we will summarize and give you a few examples of those best practices to help you write more elegant Python code, benefiting those who may read and use your…

Continue

Added by Zoe Zbar on December 22, 2020 at 11:57am — No Comments

Automating SQL Queries to Push Information to Business

Most of us working in business intelligence and data science spend a lot of time creating data models, reports and beautiful dashboards. Even though the models are great and reports look fancy, the true value is in your customers actively using it. How often do you find that nobody is actually running the report?

This hurts, but it also makes sense. People get so much information during a day, they really need to be selective. So any important information should pop out of your report…

Continue

Added by Nanne Sluis on June 10, 2020 at 10:00am — No Comments

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

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

1999

© 2021   TechTarget, Inc.   Powered by

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