Group Project
Maven Toys Sales Analysis
Background
Although Maven Toys has grown in sales, its profit is stagnant and more likely to decline.
Results
Through forecasting analysis, Maven Toys can define the sales projection and lifecycle of a product in order to improve promotion or redesign the product.
Tools
- Spreadsheet
- SQL (BigQuery)
- Python (Google Colab)
- Tableau
CrediU(Fintech): Developing Support Dashboard for Business Performance (KPI) Management
Background
Expert is trying to redevelop the Business Performance Management process at CrediU(Fintech) Company.
Data Analyst is expected to support this initiative by developing a Business Performance Management Dashboard.
Results
There are three dashboards (Strategic, Analytical, Operation) that has different user and needs.
- Strategic : Monitor overall business Performance
- Analytical : Analyze the condition of the Application Process to gain insight
- Operation : Gain information regarding the collection target each week.
Tools
- Spreadsheet
- SQL (BigQuery)
- Tableau
CrediU(Fintech) Marketing Strategy: Revising Marketing Ratio Through Customer Segmentation Analysis
Background
Due to the inaccurate proportion in the marketing strategy ratio, CrediU has been attracting applicants with high-risk profiles.
Results
Through applicant segmentation analysis, CrediU can define a better marketing strategy in order to attract more applicants with low-risk profiles.
Tools
- Spreadsheet
- SQL (BigQuery)
- Python (Google Colab)
- Tableau
CrediU(Fintech) Application Process: Analyzing & Evaluating Application Funnel For Better Application Funnel Strategy
Background
Due to the simple system (first come, first served), CrediU application process performance is affected by the growth of high-risk profile users.
Results
Through application system analysis, CrediU can develop new application system processes that can reduce the number of users with high risk profiles.
Tools
- Spreadsheet
- SQL (BigQuery)
- Python (Google Colab)
- Tableau
CrediU(Fintech) Payment Performance Strategy: Analyzing & Evaluating Payment Performance
Background
Massive growth of bad applicants with high risk status affects CrediU payment performance.
Results
There are strategies that CrediU can implant: improving payment performance strategies by focusing on collection for certain clusters and prevention strategies for minimizing the impact of bad debtors in the future.
Tools
- Spreadsheet
- SQL (BigQuery)
- Python (Google Colab)
- Tableau