Data Exploration Using the SQLite Interface

In this segment, Favio will perform some basic data exploration and analysis directly using the SQLite browser.

In the next video, Favio will run some basic queries for data exploration. Let’s watch the video.

So, in the video, Favio explored the different tables and performed a basic analysis on the customer information. In the next video, he will be exploring the customer accounts table. Let us go ahead and watch the video.

So, in the video, you saw Favio perform some basic queries on the customers’ accounts data. One interesting observation was that most customers had a month-to-month contract.

Moving on, in the next video, Favio will try to understand the churn and see how it relates to other variables. Let us go ahead and watch the video.

So, we were able to gather some interesting insights in the previous video: 

• Customers who left the company (churned) were paying “less” compared with customers who were with it.
• Customers who left the company are paying more as monthly payments compared with customers who are still with it.
• Customers with a 1- or 2-year contract in general don’t leave the company.

So, now that we have gathered some basic insights using SQL, we will now move to Python where we can run some more complex queries to fetch more interesting insights.