Udemy Course Analyze

📚 Table of Contents

• 💼 Business Case

• 📑Example Datasets

• 🚩 The Requirement

• A. Data Exploration and Cleansing

• B. Analysis

• 📃 What can you practice with this case study?

---

💼 Business Case

• This is the Final Test Exam of 'Data for Everyone' course of MINDX TECHNOLOGY SCHOOL.

• The requirement of Test is cleaning, analyzing, doing visualization with the raw file data (udemy.csv).

  • I would use the SQL to clear and filter the clean data for analyzing test.
  • Power BI would be the visualization tool for me to visualize and analyze the clean data.
  • Finally, I would give the comments about these data through graphs of Power BI.

---

📑Example Datasets

Table : udemy_course

course_id	course_title	url	is_paid	price	num_subscribers	num_reviews	num_lectures	level	content_duration	published_timestamp	subject
1070968	Ultimate Investment Banking Course.	https://www.udemy.com/ultimate-investment-banking-course/	TRUE	200	2147	23	51	All Levels	1.5	1/19/2017 3:58	Business Finance
1113822	Complete GST Course & Certification - Grow Your CA Practice	https://www.udemy.com/goods-and-services-tax/	TRUE	75	2792	923	274	All Levels	39	3/9/2017 23:34	Business Finance
1006314	Financial Modeling for Business Analysts and Consultants	https://www.udemy.com/financial-modeling-for-business-analysts-and-consultants/	TRUE	45	2174	74	51	Intermediate Level	2.5	12/20/2016 2:26	Business Finance
1210588	Beginner to Pro - Financial Analysis in Excel 2017	https://www.udemy.com/complete-excel-finance-course-from-beginner-to-pro/	TRUE	95	2451	11	36	All Levels	3	5/31/2017 3:07	Business Finance
1011058	How To Maximize Your Profits Trading Options	https://www.udemy.com/how-to-maximize-your-profits-trading-options/	TRUE	200	1276	45	26	Intermediate Level	2	12/13/2016 21:57	Business Finance
192870	Trading Penny Stocks: A Guide for All Levels In 2017	https://www.udemy.com/trading-penny-stocks-a-guide-for-all-levels/	TRUE	150	9221	138	25	All Levels	3	5/2/2014 22:13	Business Finance

---

🚩 The Final Test Requirements

1. Introduce about your choosen dataset
2. Introduce the technical tools and steps to explore, discover unclear data before analyzing.
3. Show steps how to use power bi to import, modelling, analyze and visualize the final clean data (if candidates use power bi to explore and discover data, show it in this part too)
4. Present the information that the candidate discovered from the dataset
5. If possible, give some follow-up recommendations.

A. Data Exploration and Cleansing

B. Analysis

---

What can you practice with this case study?

• SQL
  • Filter
  • JOINS
  • CTE's
  • Window Function
  • Import CSV File
• POWER BI
  • Visualize
  • Analyze
  • Import CSV File and Transform data