End to End E-Commerce Data Analysis Project | Power BI + SQL + Machine Learning + Python
Dataset & Other Resources:
github.com/AlHafidzLuhurDarma/TechSquare_E-Commerce_Analysis
#powerbi #dataanalytics #powerbitutorial #machinelearning #kmeans #sqlserver #sqlservermanagementstudio #python
In this complete E-Commerce Analysis project using SQL Server, Power BI & Python, we will cover a wide range of topics which includes
1. ETL process in SQL Server
2. Data Cleaning in SQL Server
3. Power BI Transformations
4. Power BI Visualization & Enhancing Visuals
5. Build Machine Learning Model - K-Means in Google Colab
6. Presenting Our Reports in Github
Below are the Timestamps:
0:00 Agenda
1:44 - Create Database
7:03 - Answering Stakeholders Questions
1:04:25 - Finding NULL & Duplicates Values
1:10:02 - Load Data into Power BI
1:33:06 - Dashboard Design
2:19:30 - Prepare Machine Learning Data
2:28:39 - Customer Cluster using K-Means
3:00:21 - Reports
SSMS Installation Link:
learn.microsoft.com/en-us/ssms/install
Google Colab Link:
https://colab.research.google.com/
Connect with me:
Linkedin : linkedin.com/in/al-hafidz-luhur-darma-putra-227b30300/
Gmail : [email protected]
Portfolio Website : https://sites.google.com/view/hafidzl
power bi dashboard,power bi,power bi dashboard tutorial,power bi tutorial,power bi dashboard design,power bi tutorial for beginners,power bi for beginners,microsoft power bi,learn power bi,sales dashboard in power bi,power bi training,power bi desktop,how to create dashboard in power bi,power bi reports,power bi project,power bi dashboards,power bi report,power bi kpi dashboard,dashboard in power bi,how to power bi,power bi dashboard examples