This project aims to understand the concepts of business intelligence insights, by analysing various successful conversions. You will be doing Data cleaning and EDA through python and identifying the KBRs and KPIs for this specific business problem.
About the Company
Leadup Universe is Asia’s leading career acceleration organization. They collaborate with top-tier institutes, international academicians and Global CXOs to create learning experiences that are experiential, immersive, and interactive. This gives professionals an in-depth understanding of the real-world scenario and the tools to find solutions to real-life business challenges.
Learning Outcomes
- Understand the KBRs and KPIs of an ed-tech business
- Cleaning data and feature selection.
- Learn EDA through Python, to find all the relevant metrics that would help us to track our KPIs.
- Dynamic Charts creation and Dashboarding through Tableau using various metrics to provide a clear analysis of the company’s performance.
Detailed Description
Aim: To understand the concepts of business intelligence insights, by analysing various successful conversions.
Data cleaning and EDA through python and identifying the KBRs and KPIs for this specific business problem.
Business Problem:
An ed tech company manages to sell a lot of online courses across different countries and thousands of users.
These courses are from different sectors starting from Business category, there are courses from Finance, Entrepreneurship, Communication, Management, Sales, Strategy, Operations, Project Management, Business Law, Data & Analytics, Home Business, Human Resources and Industry each having multiple courses under its domain.
Our goal is to provide a complete analysis about their sales distribution, consumer demands, revenue generated etc, with proper data visuals and DTC dashboard at the end in Tableau.
Learning Outcomes:
- Understand the KBRs and KPIs of an ed-tech business
- Cleaning data and feature selection.
- Learn EDA through Python, to find all the relevant metrics that would help us to track our KPIs.
- Dynamic Charts creation and Dashboarding through Tableau using various metrics to provide a clear analysis of the company’s performance.
Initial Skill Requirement:
- Proficiency in Python libraries: pandas, numpy, matplotlib and seaborn.
- Along with that Tableau dynamic charts creation and Dashboarding skills.
Road map:
Phase 1
- Initially we need to have a good understanding of the project requirement and domain knowledge about how web traffic data is processed, and the terms used for tracking its several metrices.
- Step 1: Explanation of all the metrices and dimensions recorded in this dataset.
- Step 2: What are business insights and how are they best detected.
- Step 3: Understanding the data with the help of excel and then loading it into python for further analysis
- Creation of KBRs and KPIs and maintaining proper notes for it.
- Step 4: Required Installations – Python, MS Excel, Tableau
Phase 2
After planning and studying our business requirement, it’s time to perform further data cleaning and EDA in Python using various Python libraries.
- Step 1: Loading the excel file data into a python pandas data frame, understanding the types of files and their connecting function in Python
- Step 2: Studying the data with python data frame features, checking for the exact numbers of null values in all the columns.
- Step 3: Clean the data using drop and other functions that helps in proper feature selection.
- Step 4: Plotting various features in a graph to see the correlation of metrics to our goals (KPIs).
- Step 5: Finalizing all our findings and converting the updated data frame into excel sheet to be further used in Tableau
Phase 3
In this phase our focus would be to visualize the data through Tableau as, dashboards are the end product that needs to be delivered to the clients as the most part of our analytics services. All the insights related to this ed-tech business needs to be presented in the best way possible.
- Step 1: Connect the data in Tableau.
- Step 2: Create the required charts, according to the features and metrics selected during EDA.
- Step 3: Add dynamic features to the charts to make it more insightful and user friendly with the help of parameters and calculated fields.
- Step 4: Design a Dashboard that perfectly presents all the business insights with the dynamic chats created above in step 3.