|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-dax-practice-test-and-solutions/
课程评论：没有评论
**课程名称:** Power BI DAX 练习测试及解决方案 **课程概述:** 本课程是一项实践测试，旨在帮助学习者巩固和提升在 Power BI 中使用 DAX (Data Analysis Expressions) 语言的能力。DAX 是 Power BI 的核心脚本语言，用于创建自定义表、计算列和度量值，通过公式和表达式来计算和输出值。 **先决条件:** 在学习本课程之前，学习者应具备以下知识和技能： * 如何连接到数据源。 * 数据建模和关系建模。 * 熟悉 DAX 函数和表达式。 **测试内容:** 本练习测试将重点考察以下 DAX 函数类别： * 聚合函数 * 迭代器函数 * 筛选函数 * 条件函数 * 逻辑函数 * 日期和时间函数 * 统计函数 * 时间智能函数 **数据源:** 测试将使用 Adventure Works 数据库。该数据库包含一个虚构的国际制造公司 Adventure Works Cycles 的信息。 **学习者需要加载的表格:** * Calendar Table (日历表) * Customers Table (客户表) * Products Table (产品表) * Territories Table (地区表) * Sales Table (销售表) **数据建模要求:** 学习者需要根据以下关系正确地连接各个表： * 将 Products 表与 Sales 表通过 `ProductKey` 列连接。 * 将 Customers 表与 Sales 表通过 `CustomerKey` 列连接。 * 将 Territories 表与 Sales 表通过 `SalesTerritoryKey` 列连接。 * 将 Calendar 表与 Sales 表通过 `Date` 列和 `OrderDate` 列连接。 **学习者须知:** * 数据库的链接将在测试页面提供。 * 数据库中的列易于理解。 * 某些问题可能有多种解决方案，只要结果正确即可。 * 鼓励学习者在遇到困难时，可以先跳过问题，稍后再回来解决，并可以参考提供的解决方案进行对比。
Legend says if you can't write DAX then you don't know Power BI.Microsoft Power BI uses the scripting language Data Analysis Expressions DAX to build custom tables, calculated columns, and measurements. It is a set of operators, constants, and functions that can be included in a formula or expression to compute and output one or more values.In this Practice Test, you will be using the Adventure Works Database.The AdventureWorks Database is the source of information for Adventure Works Cycles, a made-up international manufacturing firm. Before taking this test, ensure you know:How to connect to a Data SourceModel a Data RelationshipFamiliar with DAX Functions and ExpressionsThe Practice Test is going to cover:Aggregation FunctionsIterator FunctionsFilter FunctionsConditional FunctionsLogical FunctionsDate and Time FunctionsStatistical FunctionsTime Intelligence FunctionsInstructionsThe link to the database will be given on the test page. If you encounter any problem downloading the database from the link, please feel free to drop me a message.You are going to load five tables, from the database:Calendar Table Customers TableProducts TableTerritories TableSales TableEnsure your Data Modelling is right by defining the right relationships.Join the Calendar, Customers, Products and Territories Lookup Tables to the Sales Data Table. Join Products Table to Sales Table using the ProductKey Column in both Tables.Join Customers Table to Sales Table using the CustomerKey Column in both Tables.Join Territories Table using the TerritoryKey Column to Sales Table using the SalesTerritoryKeyJoin the Calendar Table using the Date column to the Sales Table using the OrderDate columnPlease take your time to study the database, the columns in the database are self-explanatory. Some questions might have different ways of solving, provided your answer is correct don't worry. You can still compare with my solution.If you can't solve a question skip it and come back to it later.
