1.8 Sample analytics | E commerce Here are some sample problem statements that a data analyst may have to solve in the e-commerce or any sales data base based company. 1. Write a query to find the names and ages of all customers who have placed an order in the past month. Customers table: Customer … Read more
1.7 Sample Project | Ed Tech Title: Analyzing Student Engagement in an Online Course Overview: In this project, we used data analytics to understand student engagement in an online course. We collected data on student activity in the course, including the time spent on course materials, the number of discussions participated in, and the number … Read more
1.6 Sample Project | Food delivery startup Title: Analyzing Delivery Times at a Food Delivery Startup Overview: In this project, we used data analytics to understand delivery times at a food delivery startup. We collected data on delivery times for each order, including the order time, delivery time, and distance traveled. We used SQL and … Read more
1.5 Introduction to Data analytics : Data analytics is the process of collecting, organizing, and analyzing large sets of data in order to gain insights and make better business decisions. It involves using a variety of tools and techniques to extract valuable information from data, and can be applied to a wide range of industries … Read more
1.4 Introduction to Data analytics : Sample project Title: Analyzing the Impact of Social Media Marketing on Sales Overview: In this project, we used data analytics to understand the relationship between social media marketing efforts and sales at an online retailer. We collected data on social media engagement, ad spend, and sales over a six-month … Read more
1.2 Fintech Analytics Suppose we have a fintech startup that provides a mobile app for managing personal finances. We want to use data analytics to understand how our users are using the app and identify opportunities for growth. To do this, we can use SQL queries to analyze data from our users’ transactions and app … Read more
1.1 E-commerce Analytics ;Business Metrics : MAU In the world of digital products and services, it’s common to track the number of monthly active users (MAUs) as a key metric of success. In this blog, we’ll look at how you can use SQL queries to calculate MAUs for your product or service. MAU is an … Read more
Finding the customer who made the most orders 1.0 E-Commerce analytics 101 In this blog, we’ll walk through a basic data analytics problem and see how we can use an SQL query to solve it. Suppose we have a table that contains data on customer orders at an online store. The table includes the following … Read more
1.0 Basics of Retention analysis What is Retention Analysis? User retention is a key metric used across various businesses to measure the ratio of users who come back in specific time interval to use a product or service. For example, if a company like Netflix acquires some X number of subscribers in a month, then … Read more