#3 - Power BI : Import MySQL + Nettoyage Données (2 Méthodes) | Tuto ETL Débutant

🎯 Import 148K transactions into Power BI and clean your data in 22 minutes — 2 universal methods (direct MySQL connection + CSV). Welcome to PART 3 of the "Power BI Project from A to Z" series! In this video, I'll show you two methods for importing your data into Power BI Desktop: a direct MySQL connection (Windows x64) and a CSV import (Mac, Windows ARM, Linux). Then we'll clean everything up using the Power Query Editor. Both methods achieve the same result. Choose the one that best suits your system. ⏱️ TIMESTAMPS: 00:00 - Introductory video 00:04 - Introduction: 2 methods explained 01:34 - Exporting CSV from MySQL Workbench 03:34 - Importing CSV into Power BI Desktop 05:19 - Exploring Power Query Editor 06:44 - Data cleaning: Data types, headers, test codes 11:39 - Handling NULL values ​​(currency) 13:34 - Currency conversion: USD → INR 17:04 - Creating calculated columns (profit_amount, profit_margin_pct) 20:29 - Final loading into Power BI 21:24 - Recap & Announcement Part 4 📋 METHOD 1 - DIRECT MYSQL CONNECTION: ✅ Prerequisites: Windows 10/11 (x64), MySQL installed and running 🔧 Steps : 1. Install the MySQL ODBC driver: https://dev.mysql.com/downloads/conne... 2. Restart your computer 3. Power BI → Get Data → MySQL Database 4. Server: localhost | Base: Sales 5. Select tables: Customers, Date, Markets, Products, Transactions 6. Transform the data → Join the video at timestamp 05:19 📋 METHOD 2 - CSV IMPORT (UNIVERSAL): ✅ Compatible: Mac, Windows ARM, Linux, ALL systems 🔧 Steps: 1. Export MySQL tables to CSV (timesample 01:34) 2. Power BI → Get Data → Text/CSV 3. Import the 5 CSV files 4. Transform the data ✅ WHAT YOU WILL LEARN: • Import MySQL data into Power BI (2 methods) • Master the Power Query Editor • Detect and correct data types • Remove unnecessary data/test codes • Manage NULL values ​​and multiple currencies • Create calculated business columns • Optimize ETL performance 📁 FREE RESOURCES: 🔗 Project SQL/CSV files: https://github.com/bouba02/Analyse-de... 🔗 Script & PDF Guide "2 MySQL Import Methods": https://github.com/bouba02/Analyse-de... 🔗 Complete repository: https://github.com/bouba02/Analyse-de... 🎯 PREREQUISITES: • Power BI Desktop installed (Free) • MySQL Database Ready (Part 1) • Windows/Mac/Linux (Both methods cover EVERYTHING) 📺 COMPLETE SERIES: ✅ Part 1: MySQL Installation + Database Import ✅ Part 2: SQL Exploratory Analysis ✅ Part 3: Power BI - Import & ETL (THIS VIDEO) → Part 4: Star Schema & Relationships → Part 5: Complete 3-Page Dashboard → Part 6: Power BI Service Publishing 💼 TRANSFORMATIONS PERFORMED: • Data type correction (text → number, date) • Test code removal (-1, 0) • NULL handling (empty currency → INR) • USD → INR normalization (rate 75) • Calculated columns: profit_amount, profit_margin_pct • 148,000 rows cleaned and ready 🎓 PROFESSIONAL SKILLS: ✔ Multi-source import (MySQL, CSV) ✔ ETL with Power Query ✔ Real data cleaning ✔ Multi-currency management ✔ Business-specific calculated columns ✔ Performance optimization 👨‍💼 ABOUT: BOUBACAR NIKIEMA Data Analyst | Master's in Big Data & Cloud Computing Power BI Dashboards • SQL • Excel • Python 🔗 STAY CONNECTED: 💼 LinkedIn:   / boubacar-nikiema   🐙 GitHub: https://github.com/bouba02 📧 Email: [email protected] 📢 SUPPORT THE CHANNEL: 👍 LIKE this video 💬 COMMENT: Which method did you use? CSV or MySQL? 🔔 SUBSCRIBE for Part 4 📤 SHARE with your data colleagues 🎯 NEXT VIDEO: Part 4 - Star Schema + Relationships → We'll connect our 5 tables using the Star Schema model for high-performance dashboards. #powerbi #powerquery #etl #datacleaning #mysql #csvfiles #datatransformation #powerbitutorial #dataanalytics #businessintelligence #learnpowerbi #datapreparation #powerbidesktop #microsoftpowerbi