|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-dax-transition-from-sql/
课程评论：没有评论
课程名称：从SQL过渡到Power BI DAX 课程概述：在我超过10年的数据分析与商业智能领域经验中，我发现许多人在从SQL转向Power BI DAX时感到不适应。任何想要以实践方式学习Power BI DAX的人都可以参加本课程。特别适合具备SSRS报告服务经验的人，如果他们想了解DAX中SQL的相应功能，本课程将帮助您以简单的逐步方式理解Power BI DAX。该课程完全基于DAX Studio和SQL。我们首先编写SQL查询，然后尝试在DAX Studio中实现相同结果。我定期更新课程内容，确保与微软的最新更新保持一致。这是Udemy上独特的课程，将SQL和DAX Power BI结合在一起。 课程内容包括以下主题： - 如何从Excel导入数据到SQL？ - 数据验证 - 使用Select和Evaluate获取数据 - DAX和SQL中的Selectcolumns函数 - 如何在DAX和SQL中对结果排序 - 如何在DAX和SQL中创建计算列 - DAX和SQL中的唯一记录 - 使用Summarize函数获取唯一记录 - DAX和SQL中的Power BI Coalesce函数 - 使用Summarize和Selectcolumns函数创建自定义列 - 在DAX和SQL中过滤记录集 - 使用Filter和Selectcolumn进行多个逻辑条件 - 使用Countrows与Summarize进行分组 - 使用Addcolumns进行聚合 - Addcolumn与Selectcolumn - Addcolumns与Summarize函数 - 使用Calculatetable过滤记录集 - Calculatetable与Filter函数的区别 - 何时使用calculatetable与Filter函数 - DAX和SQL中的Natural inner join和Inner join - DAX中的Natural inner join与无物理关系 - DAX中Natural Inner join的替代方案 - DAX和SQL中的Having子句 - DAX和SQL中的左外连接 - DAX和SQL中的交叉连接 - DAX和SQL中的Summarizecolumns - 带度量的Summarizecolumns - DAX和SQL中的IN运算符 - DAX和SQL中的字符串搜索 - 从左或右在DAX和SQL中搜索字符串 - DAX和SQL中的TopN结果 - DAX和SQL中的生成与TopN 关于我：我是您的讲师Muhammad Asif，微软认证的数据管理与分析解决方案专家。我在微软BI系统方面拥有超过10年的经验，曾在世界领先的金融公司工作。您将学习到行业中实际使用的内容。
During my more than 10 years of experience in the area of Data Analysis & Business Intelligence, I see people feel not comfortable when they move from SQL track to Power BI DAX. Anyone can take this course who want to learn Power BI DAX in a practical way. People who have experience with SSRS reporting services and if they want to learn what will be the equivalent of SQL in DAX, this course will help you understand Power BI DAX in a very easy step by step approach.This course is purely based on DAX studio and SQL. First, we write SQL query and then we try to achieve the same results in DAX studio. I updated all of the courses available on Udemy regularly with the latest updates from Microsoft.This is one of the unique courses available on Udemy that takes SQL and DAX Power BI together.This course includes the following topics.- How to import data into SQL from Excel?-Data Validation-Use of Select & Evaluate to fetch the Data-Selectcolumns function in DAX and SQL-How to sort results in DAX and SQL-How to create calculated column in DAX and SQL-Distinct records in DAX and SQL-How to fetch unique records using Summarize function-Power BI Coalesce function in DAX and SQL-Custom column using Summarize and Selectcolumns function-Filtering record set in DAX and SQL-Multiple logical conditions with Filter and Selectcolumn-Countrows with Summarize for grouping-Use of Addcolumns to achieve aggregation-Addcolumn with Selectcolumn-Addcolumns with Summarize function-Calculatetable to filter recordset-Calculatetable vs Filter function-When to use calculatetable and filter function-Naturalinnerjoin and Inner join in DAX and SQL-Naturalinnerjoin and no physical relationship-Alternatives of Natural Inner join in DAX-Having clause in DAX and SQL-Left outer join in dax and sql-Cross join in dax and SQL-Summarizecolumns in DAX and SQL-Summarizecolumns with measure-IN operator in DAX and SQL-Search string in DAX and SQL-Search string from left or right in DAX and SQL-TopN results in DAX and SQL-Generate with TopN in DAX and SQLAbout meI am your instructor Muhammad Asif Microsoft certified solutions expert in data management & Analytics. I have more than 10 years of experience in Microsoft BI stack with world-leading financial Firm. You will learn what exactly is used in the industry.
