|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-interview-questions-and-answers-c/
课程评论：没有评论
这份Coursera课程“Power BI面试题与解答”旨在帮助学习者准备Power BI相关的面试。课程内容涵盖了Power BI的关键概念和常用功能，并以问答的形式深入讲解。 **课程核心内容包括：** * **基础概念解析：** 详细解释了计算列（Calculated Columns）和计算度量（Calculated Measures）的区别、创建位置及应用场景。 * **Power Query 详解：** 介绍了M语言（M codes）、参数（Parameters）、数据网关（Data Gateway）的作用，以及查询折叠（Query Folding）和拆分函数（Split function）等关键概念。 * **过滤器与函数：** 阐述了不同级别的过滤器（视觉对象级、页面级、报表级），并深入讲解了 `ALL` 和 `ALL EXCEPT` 函数、分组（Grouping）、“What if” 参数、`Distinct` 与 `Values` 的区别。 * **DAX 核心函数：** 涵盖了DAX（Data Analysis Expressions）的基本概念、常用函数，以及 `SUM` vs `SUMX`、`LookupValue`、`Datesbetween` vs `DatesinPeriod`、`COUNTA`/`COUNTX`/`COUNTAX` 等函数的辨析。 * **数据模型与查询：** 比较了导入查询（Import Query）与实时查询（Direct Query）的区别，解释了追加查询（Append Query）与合并查询（Merge Query）以及不同类型的表连接（Joins）。 * **高级DAX与实用技巧：** 介绍了`USERELATIONSHIP` vs `TREATAS`、书签（Bookmark）、变量（Variables）、`RANKX` 函数、`CALCULATE` 関数、`RELATED` vs `RELATEDTABLE`、`DATEADD` & `PARALLELPERIOD` 函数等高级主题。 **课程更新与展望：** 课程已于2023年1月更新，新增了关于DAX变量（VAR）以及Power BI数据透视（Pivot）和反透视（Unpivot）的视频。未来计划添加更多关于高级DAX的问题，如时间智能（Time Intelligence）、仪表板（Dashboards）和行级别安全性（Row Level Security）等内容。 总而言之，本课程提供了一个全面的Power BI面试准备指南，通过深入浅出的问答形式，帮助学习者掌握Power BI的核心技能和面试技巧。
UPDATE (Jan 2023): We're pleased to let you know that we have just published a new video on variables (DAX VAR) and power bi pivot and unpivot. This new year 2023 we are planning to add more videos in this course especially around advance DAX questions like Time Intelligence Questions, Dashboards and Row Level Security and many more.So stay updated and please subscribe to this course.Covers Calculated Columns, Measures, Power Query, Data Gateway & Parameters:-Question 01:- What are Calculated columns ?Question 02:- Where can calculated columns be created in Power BI?Question 03:- What are calculated measures in Power BI?Question 04:- Where can calculated measures be created in Power BI?Question 05:- Difference between Calculated Column and Measure in Power BI?Question 06:- What are M codes in power bi & Where Can You Write Power Query M Code?Question 07:- What are Parameters in Power BI?Question 08:- What is Power BI data gateway?Question 09:- Do we need data gateway for schedule refresh in Power BI?Question 10:- What is Query Folding in Power BI?Question 11:- What is the use of Split function in Power BI?Question 12:- Difference between visual level, page level and report level filters in Power BI?Questions on ALL & ALL EXCEPT functions, Grouping , what if parameter, Distinct:-Question 13:- Difference between ALL and ALL EXCEPT functions?Question 14:- What is "What if" parameter in Power BI?Question 15:- How to keep or remove specific rows in Power BI?Question 16: What is grouping in power bi and how to use it?Question 17:- Difference between Distinct and Values in Power BI?Important questions on DAX, DAX Function, Power Query, Power BI Reports:-Question 18:-What is DAX and most common DAX functions used?Question 19:- What is Power Query?Question 20:- What are different types of Filters in Power BI Reports?Differentiating between sum vs sumx and Direct Query vs Import Query:-Question 21:- Difference between sum and sumx in power bi?Question 22:- Import Query vs Direct Query in power bi?Append Query vs Merge Query and different types of Power BI Joins:-Question 23 - Append Query VS Merge Query in Power BI ?Question 24 - Types of Join and Types of Join kind in Power BI ?LookupValue DAX function, Differentiate Datesbeteween VS DatesinPeriod in Power BI.Question 25 - What is LookupValue DAX function in Power BI ?Question 26- Understand Datesbetween vs DatesinPeriod ?Crack Power BI Interview Questions on COUNTA, COUNTX, COUNTAX, Filter Top N.Question 27 - COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTINCTCOUNT, COUNTROWS ?Question 28 - How to filter Top N in Power BI ?Difference between USERELATIONSHIP and TREATAS, Bookmark in Power BI.Question 29:- Power BI USERELATIONSHIP VS TREATAS ?Question 30:- What is Bookmark in Power BI?Variables in Power BI and how Power Pivot and Unpivot differs from each other.Question 31 - Variables in Power BI ?Question 32 - Power Pivot VS Power Unpivot ?Essential questions around Table Joins, Crossjoin and DAX RANX Function.Question 33 - How to use the DAX RANKX function in Power BI?Question 34 - Table Joins - Crossjoin, Union, Except & Intersect?Explain how to use Calculate DAX Function ?Question 35:- How to use Calculate DAX Function in Power BI ?RELATED VS RELATEDTABLE, DATEADD & PARALLELPERIOD Functions in DAX.Question 36:- What is the difference between Related and RelatedTable ?Question 37:- What is the use of DateAdd and ParallelismPeriod Functions?
