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
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
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
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 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