Business Intelligence using Microsoft Power BI (in Arabic)

Unlock the Power of Business Intelligence with Microsoft Power BI Desktop

This comprehensive Arabic course provides a practical, step-by-step guide to mastering Business Intelligence (BI) and data analysis using Microsoft Power BI Desktop. Learn to connect, transform, analyze, and visualize data with ease, regardless of your experience level.

Course Description:

Looking for a hands-on approach to learning Microsoft Power BI Desktop? You've come to the right place! Power BI is now the leading self-service BI platform globally – an essential tool for data professionals and beginners alike. This course empowers you to connect to hundreds of data sources, build integrated and formatted data models using intuitive tools, and ultimately design stunning, interactive dashboards – all for free.

Course Project:

You'll step into the role of a lead Business Intelligence Analyst at Adventure Works Cycles, a global manufacturing company. Your mission is to design and deliver a high-quality, professional BI solution using Power BI and provided CSV data files. I'll guide you through each stage, sharing clear explanations and practical tips along the way. The project is structured around four key objectives:

• POWER BI OBJECTIVE #1: Connect & Transform Raw Data

  • Introduction to the Power BI Query Editor
  • Types of Power BI Data Connectors
  • Basic Table Transformations
  • Text, Number & Date Tools
  • Index & Conditional Columns
  • Grouping & Aggregating Data
  • Pivoting & Unpivoting
  • Modifying, Merging & Appending Queries
  • Connecting to Folders
  • Defining Hierarchies & Categories
  • Query Editing & Power BI Best Practices

• POWER BI OBJECTIVE #2: Build a Relational Data Model

  • Introduction to Database Normalization
  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables
  • Creating Power BI Table Relationships
  • "Star" vs. "Snowflake" Schemas
  • Active vs. Inactive Relationships
  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Filtering & Cross-Filtering
  • Hiding Fields from the Power BI Report
  • Data Modeling & Power BI Best Practices

• POWER BI OBJECTIVE #3: Add Calculated Fields with DAX

  • Introduction to Data Analysis Expressions (DAX)
  • Calculated Columns vs. Measures
  • Row Context vs. Filter Context in Power BI
  • DAX Syntax & Operators
  • Common Power BI Functions
  • Basic Date & Time Formulas
  • Logical & Conditional Statements
  • Text, Math & Stats Functions
  • Joining Data with RELATED, CALCULATE, ALL & FILTER Functions
  • DAX Iterators (SUMX, AVERAGEX)
  • Time Intelligence Formulas
  • DAX & Power BI Best Practices

• POWER BI OBJECTIVE #4: Design Interactive Power BI Reports

  • Introduction to the Power BI Report View
  • Adding Basic Charts to Power BI Reports
  • Formatting & Filtering Options
  • Matrix Visuals
  • Slicers & Timelines
  • Cards & KPIs
  • Power BI Map Visuals (Basic, Fill, ArcGIS)
  • Treemaps, Lines, Areas & Gauges
  • Editing Report Interactions
  • Linking to Report Bookmarks
  • Using "What-If" Parameters
  • Power BI Data Viz Best Practices

This course will equip you with the skills to become a proficient Power BI user and unlock valuable insights from your data. Start your journey to becoming a data expert today!