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