|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-desktop-for-business-intelligence-urdu/
课程评论：没有评论
**Coursera 课程总结：Microsoft Power BI Desktop (乌尔都语/印地语)** 本课程面向数据专业人士和有志成为分析师的学生，旨在帮助您精通领先的商业智能平台 Power BI Desktop。课程将通过实操项目和真实的商业场景，带您掌握将原始数据转化为专业报告和仪表板的完整流程。 **课程项目：AdventureWorks Cycles 商业智能分析师** 您将扮演一家虚构制造公司 AdventureWorks Cycles 的商业智能分析师，负责： * 创建自动化数据处理流程。 * 分析区域绩效和产品级别趋势。 * 识别高价值客户。 * 构建用于跟踪关键绩效指标 (KPI) 的报告和仪表板。 **课程内容阶段：** **第一阶段：连接与整理数据 (Connecting & Shaping Data)** * **核心工具：** Power Query * **关键技能：** * 数据连接器和存储/导入模式。 * 查询编辑工具，包括表格转换、文本/数值/日期/时间处理、滚动日历、索引/条件列、分组/聚合、透视/逆透视、合并/追加查询。 * 连接数据库和从网页提取数据。 * 质量保证 (QA) 和数据剖析工具。 **第二阶段：创建关系型数据模型 (Creating a Relational Data Model)** * **核心概念：** 数据建模最佳实践 * **关键技能：** * 基数 (cardinality)、规范化 (normalization)、筛选器流程 (filter flow) 和星型架构 (star schemas)。 * 构建关系型数据模型，包括事实表 (fact tables) 和维度表 (dimension tables)。 * 主键/外键 (primary/foreign keys) 的应用。 * 星型和雪花型架构 (star & snowflake schemas)。 * 管理活动和非活动关系，以及理解关系基数和筛选器上下文/流程。 **第三阶段：使用 DAX 添加计算字段 (Adding Calculated Fields with DAX)** * **核心工具：** 数据分析表达式 (DAX) * **关键技能：** * 创建计算列 (calculated columns) 和度量值 (measures)。 * 理解行上下文 (row context) 和筛选器上下文 (filter context)。 * 运用筛选函数 (filter functions)、迭代器 (iterators) 和时间智能模式 (time intelligence patterns)。 * 掌握 DAX 语法、运算符、数学/统计函数、条件/逻辑函数、SWITCH 函数、文本函数、日期/时间函数、RELATED 函数。 * 深入理解 CALCULATE, FILTER & ALL 函数以及 X 迭代器函数。 **第四阶段：使用报表可视化数据 (Visualizing Data with Reports)** * **核心概念：** 数据可视化最佳实践和仪表板设计 * **关键技能：** * 构建和格式化基本图表（卡片、KPI、折线图、表格、矩阵）。 * 添加交互性，包括书签 (bookmarks)、切片器面板 (slicer panels)、参数 (parameters)、工具提示 (tooltips)、报表导航。 * 实现条件格式化、Top N 筛选、地图可视化、钻取 (drill up/down) 功能。 * 使用数字和字段参数。 **课程优势：** * **即时访问：** 购买后即可获得终身访问权限。 * **内容丰富：** 包含 10 小时以上的高质量视频。 * **实操资源：** 提供可下载的课程项目文件。 * **职业导向：** 帮助您培养符合行业标准 Power BI 技能。 本课程由 Jaffar Tayyar 主讲，是您学习 Power BI Desktop、成为数据分析专家的一站式解决方案。
Welcome to the Power BI Desktop Course in (Urdu اردو / Hindi हिंदी) language. If you're a data professional or an aspiring analyst aiming to master the leading business intelligence platform, you're in the perfect spot.Throughout this course, you'll engage in hands-on projects and unique real-world assignments to sharpen your skills.The Course Project:Imagine yourself as a Business Intelligence Analyst for AdventureWorks Cycles, a fictitious manufacturing company. Your mission is to transform raw data into professional-grade reports and dashboards. These will track KPIs, analyze regional performance, delve into product-level trends, and pinpoint high-value customers.Don't fret! We'll be your mentors every step of the way. Expect crystal-clear explanations and valuable pro tips, ensuring your journey from novice to expert - is guaranteed.This course is designed to follow the critical stages of the business intelligence workflow and simulate real-world tasks that data professionals encounter on the job:STAGE 1: Connecting & Shaping DataIn this stage, we'll focus on building automated workflows to extract, transform, and load our project data using Power Query and explore common data connectors, storage modes, profiling tools, table transformations, and more:Data connectorsStorage & import modesQuery editing toolsTable transformationsConnecting to a databaseExtracting data from the webQA and profiling toolsText, numerical, date & time toolsRolling calendarsIndex & conditional columnsGrouping & aggregatingPivoting & unpivotingMerging & appending queriesSTAGE 2: Creating a Relational Data ModelIn stage 2, we'll review data modeling best practices, introduce topics like cardinality, normalization, filter flow, and star schemas, and begin to build our AdventureWorks data model from the ground up:Database normalizationFact & dimension tablesPrimary & foreign keysStar & snowflake schemasActive & inactive relationshipsRelationship cardinalityFilter context & flowSTAGE 3: Adding Calculated Fields with DAXIn stage 3, we'll introduce data analysis expressions (DAX). We'll create calculated columns and measures, explore topics like row and filter context, and practice applying powerful tools like filter functions, iterators, and time intelligence patterns:DAX vs. MCalculated columns & measuresImplicit, explicit & quick measuresMeasure calculation stepsDAX syntax & operatorsMath & stats functionsConditional & logical functionsThe SWITCH functionText functionsDate & time functionsThe RELATED functionCALCULATE, FILTER & ALLIterator (X) functionsTime intelligence patternsSTAGE 4: Visualizing Data with ReportsStage 4 is about bringing our data to LIFE with reports and dashboards. We'll review data viz best practices, build and format basic charts, and add interactivity with bookmarks, slicer panels, parameters, tooltips, report navigation, and more:Data viz best practicesDashboard design frameworkCards & KPIsLine charts, trend lines & forecastsOn-object formattingTable & matrix visualsConditional formattingTop N filteringMap visualsDrill up, drill downReport slicers & interactionsBookmarks & page navigationNumeric & field parametersReady to get started? Join today and get immediate, lifetime access to:10 hours of high-quality videoDownloadable course project filesIf you're looking for the ONE course to help you build job-ready Power BI skills, you've come to the right place.Happy learning!-Jaffar Tayyar
