Sokkary | Code3arabi

Lesson 4: Cleaning and Transforming Data Using Power Query In this lesson, you'll learn how to clean and prepare your data using the Power Query Editor in Power BI Desktop. 🧹 What is Power Query? Power Query is a data transformation tool built into Power BI. It allows users to shape, clean, and enrich their data without writing code. Uses a GUI-based editor. Supports over 300 transformations. Runs on the M language under the hood. ⚙️ Opening the Power Query Editor After connecting to a data source, click Transform Data . The Power Query Editor window will open with a preview of your data. You can now apply transformations step by step. 🔧 Common Data Transformations Remove Columns/Rows: Delete unnecessary data. Filter Rows: Keep only relevant records. Change Data Types: Set fields as Date, Text, Number, etc. Split Column: Break a single column into multiple parts. Merge Columns: Combine multiple columns into one. Replace Values: Clean up ty...

Lesson 3: Connecting to Data Sources in Power BI In this lesson, you will learn how to connect Power BI Desktop to different data sources such as Excel, CSV, databases, and web APIs. 🔗 Common Data Sources Power BI supports a wide range of data sources. The most commonly used include: Excel – Connect to .xlsx or .xls files. CSV/Text – Flat files like .csv and .txt. SQL Server – Connect to relational databases. Web – Fetch data from REST APIs or online tables. SharePoint – Import from lists or files stored on SharePoint sites. 📥 How to Connect to a Data Source Follow these steps to connect: Open Power BI Desktop. Click on Home > Get Data . Choose the data source (e.g., Excel, SQL Server). Navigate to the file or server and click Connect . Select the tables/sheets you want to load. Click Load to import data, or Transform to clean it first. ⚡ Import vs. DirectQuery When connecting to databases, you will be ...

Lesson 2: Installing and Exploring Power BI Desktop In this lesson, you will learn how to download, install, and get familiar with the Power BI Desktop interface. ⬇️ Downloading Power BI Desktop You can download Power BI Desktop from the official Microsoft website or the Microsoft Store: https://powerbi.microsoft.com/desktop Or search for "Power BI Desktop" in the Microsoft Store Once downloaded, follow the installation wizard to complete the setup. 🖥️ Launching Power BI Desktop After installation, open Power BI Desktop. You will see a welcome screen with options to: Get Data Open a recent report Learn tutorials and documentation Click on “ Get Data ” to start connecting to your first data source. 🧭 Exploring the Interface The main interface of Power BI Desktop is divided into several key areas: Ribbon: Contains tabs like Home, View, Modeling, etc. Fields Pane: Shows tables and fields from the connected d...

Lesson 1: What is Power BI? In this lesson, you will learn what Power BI is and the key components that make up the Power BI ecosystem. 📦 Power BI Components Power BI is a suite of tools developed by Microsoft for business intelligence and data visualization. It includes three main components: Power BI Desktop – A free Windows application to create reports and dashboards. Power BI Service – A cloud-based service to publish, share, and collaborate on reports. Power BI Mobile – Mobile apps for Android and iOS to view dashboards and stay updated on the go. 🖥️ Power BI Desktop Power BI Desktop is a free application that runs on Windows. It allows users to: Import and clean data from multiple sources (Excel, CSV, SQL, etc.). Create interactive reports using charts, tables, and visuals. Use Power Query for data transformation. It is the main tool for report development before publishing to the cloud. ☁️ Power BI Service Powe...