|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/business-intelligence-using-microsoft-power-bi-in-arabic/
课程评论：没有评论
**[Arabic] Business Intelligence using Microsoft Power BI (Coursera Course Summary)** This course is a comprehensive, practical guide to mastering Microsoft Power BI Desktop, presented in Arabic. Power BI is recognized as the world's leading self-service business intelligence platform, essential for both data professionals and beginners. **Course Overview:** The course empowers you to connect to hundreds of data sources, build integrated and refined data models using user-friendly tools, and design stunning interactive dashboards from scratch, all for free. **Course Project:** You will act as a lead Business Intelligence Analyst for Adventure Works Cycles, a global manufacturing company. Your mission is to design and deliver a high-quality, professional BI solution solely using Power BI and provided CSV data files. The instructor will guide you through each stage with clear explanations and expert tips, dividing the project into four key objectives: **1. Connect & Transform Raw Data:** * Introduction to the Power BI Query Editor. * Understanding and using various Power BI Data Connectors. * Performing basic table transformations, including text, number, and date manipulations. * Utilizing index and conditional columns. * Grouping and aggregating data. * Pivoting and unpivoting data. * Modifying, merging, and appending queries. * Connecting to data from folders. * Defining hierarchies and categories. * Adhering to Query Editing and Power BI best practices. **2. Build a Relational Data Model:** * Introduction to database normalization. * Distinguishing between "Fact" and "Dimension" tables. * Creating and managing Power BI table relationships. * Understanding "Star" versus "Snowflake" schemas. * Working with active and inactive relationships. * Defining relationship cardinality. * Connecting multiple data tables. * Implementing filtering and cross-filtering. * Hiding fields from Power BI Report View. * Following Data Modeling and Power BI best practices. **3. Add Calculated Fields with DAX:** * Introduction to Data Analysis Expressions (DAX). * Understanding the difference between Calculated Columns and Measures. * Grasping Row Context versus Filter Context in Power BI. * Learning DAX syntax and operators. * Utilizing common Power BI functions, including basic date & time formulas, logical/conditional statements, text, math, and stats functions. * Joining data with `RELATED`. * Employing `CALCULATE`, `ALL`, and `FILTER` functions. * Using DAX Iterators like `SUMX` and `AVERAGEX`. * Implementing Time Intelligence Formulas. * Following DAX and Power BI best practices. **4. Design Interactive Power BI Reports:** * Introduction to the Power BI Report View. * Adding basic charts to Power BI reports. * Exploring formatting and filtering options. * Creating and using Matrix visuals. * Implementing Slicers and Timelines. * Designing Cards and KPIs. * Utilizing various Power BI Map visuals (Basic, Fill, ArcGIS). * Creating Treemaps, Lines, Areas, and Gauges. * Editing report interactions. * Adding Drillthrough Filters. * Linking to report bookmarks. * Using "What-If" Parameters. * Following Power BI Data Visualization best practices.
تعتبر هذه الدورة من أقوى الدورات باللغة العربية المتخصصة فى تعلم ذكاء الأعمال وتحليل البيانات باستخد ام الأداة الرائعة الخاصة بشركة مايكروسوفت بطريقة سلسة وواضحة ومترابطة. __________وصف الدورة التدريبية:إذا كنت تبحث عن دليل عملي شامل لتعلمMicrosoft Power BI Desktopفقد وصلت إلى المكان الصحيح.أصبح الباور بى أى أقوى منصة ذكاء أعمال ذاتية الخدمة في العالم حاليا، وأداة ضرورية للغاية لمحترفي البيانات والمبتدئين على حد سواء. باستخدام الباور بى أى، يمكنك الاتصال بمئات من مصادر البيانات المختلفة، وإنشاء نماذج بيانات متكاملة ومطبعة باستخدام أدوات بسيطة وممتعة، وأخيرا تصميم لوحات معلومات تفاعلية مذهلة من البداية - كل ذلك مجانًا.__________مشروع الدورة:في هذه الدورة ، ستلعب دور محلل ذكاء الأعمال الرائد في Adventure Works Cycles ، وهي شركة تصنيع عالمية. مهمتكهي تصميم وتقديم حل ذكاء الأعمال الشامل بجودة واحترافية عاليتين فقط باستخدام Power BI وبعض الملفات بامتداد csv والتى بها البيانات.سأوجهك خلال كل مرحلة، مع مشاركة التفسيرات الواضحة والنصائح الاحترافية المفيدة في كل خطوة. وسنقسم مشروعنا إلى أربعة أهداف رئيسية:POWER BI OBJECTIVE #1: Connect & Transform the Raw DataIntro to the Power BI Query EditorTypes of Power BI Data ConnectorsBasic Table TransformationsText, Number & Date ToolsIndex & Conditional ColumnsGrouping & Aggregating DataPivoting & UnpivotingModifying, Merging & Appending QueriesConnecting to FoldersDefining Hierarchies & CategoriesQuery Editing & Power BI Best Practices__________POWER BI OBJECTIVE #2: Build a Relational Data ModelIntro to Database NormalizationData ("Fact") Tables vs. Lookup ("Dimension") TablesCreating Power BI Table Relationships"Star" vs. "Snowflake" SchemasActive vs. Inactive RelationshipsRelationship CardinalityConnecting Multiple Data TablesFiltering & Cross-FilteringHiding Fields from the Power BI Report ViewData Modeling & Power BI best Practices__________POWER BI OBJECTIVE #3: Add Calculated Fields with DAXIntro to Data Analysis Expressions (DAX)Calculated Columns vs. MeasuresRow Context vs. Filter Context in Power BIDAX Syntax & OperatorsCommon Power BI FunctionsBasic Date & Time FormulasLogical & Conditional StatementsText, Math & Stats FunctionsJoining Data with RELATEDCALCULATE, ALL & FILTER FunctionsDAX Iterators (SUMX, AVERAGEX)Time Intelligence FormulasDAX & Power BI Best Practices__________POWER BI OBJECTIVE #4: Design Interactive Power BI ReportsIntro to the Power BI Report ViewAdding Basic Charts to Power BI ReportsFormatting & Filtering OptionsMatrix VisualsSlicers & TimelinesCards & KPIsPower BI Map Visuals (Basic, Fill, ArcGIS)Treemaps, Lines, Areas & GaugesEditing Report interactionsAdding Drillthrough FiltersLinking to Report BookmarksUsing "What-If" ParametersPower BI Data Viz Best Practices
