|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-dax-for-power-bi/
课程评论：没有评论
课程名称：Microsoft Power BI Desktop：高级 DAX 数据分析 课程概述：对于希望将 Power BI 技能提升到更高水平的用户来说，掌握数据分析表达式（DAX）是必不可少的。在这门以项目为基础的实践课程中，您将测试自己的 DAX 技能，并将所学应用于一些最具挑战性的现实数据分析和商业智能案例。您将扮演 Maven Roasters 的商业智能分析师，这是一家位于纽约市的小批量咖啡连锁店。您的目标是使用 Power BI 和 DAX 通过分析产品库存、回头客、门店绩效等关键问题，提供数据驱动的洞察。 课程将快速回顾先决条件主题（如评估上下文、筛选流程、基本度量等），然后深入探讨 DAX 公式和存储引擎的工作原理，包括查询评估、列式结构以及 VertiPaq 压缩和编码。接下来，我们将覆盖 DAX 高级用户的实用技巧和分析最佳实践，包括变量、注释、查询格式和错误处理，并深入研究标量函数、迭代器、先进时间智能、计算表连接、关系函数等众多主题。最后，我们将介绍 DAX Studio 和 Power BI 性能分析器工具的性能调优和 DAX 查询优化技巧。 如果您希望构建专家级的数据分析技能，使用 DAX 和 Power BI，这门课程将非常适合您！ 课程内容包括： - 前置技能回顾：复习核心 DAX 概念，如评估上下文、筛选流程等。 - 课程项目介绍：引入 Maven Roasters 课程项目，并构建我们将在 Power BI Desktop 中分析的数据模型。 - DAX 引擎：了解 DAX 公式和存储引擎及其工作原理。 - DAX 提示与最佳实践：审查格式化 DAX 查询、处理错误等的实用技巧。 - 标量函数：探索常用的 DAX 标量函数。 - 高级 CALCULATE：回顾 CALCULATE 修饰符及其与表的交互。 - 表和筛选函数：创建计算表、回顾 DAX 筛选函数等。 - 计算表连接：在 Power BI 中创建物理和虚拟表之间的计算连接。 - 关系函数：探索扩展表和常见关系函数。 - 迭代器 ("X") 函数：深入了解迭代器的各种特性。 - 高级时间智能：构建 DAX 日期表，管理财务日历等。 - 性能调优：介绍 DAX Studio 和 Power BI 性能分析器的使用。 课程提供： - 150 多页的 Power BI 和 DAX 电子书 - 可下载的数据集和 Power BI 项目文件 - 家庭作业和测验 - 一对一专家支持 - 课程问答论坛 - 30 天退款保证 欢迎加入课程，立即获得终身访问权！
For users looking to take their Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a MUST. In this hands-on, project-based course, you'll put your DAX skills to the test and apply what you learn to some of the toughest real-world data analysis and business intelligence use cases.You'll be playing the role of Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your goal? Use Power BI and DAX to answer key questions and deliver data-driven insights for the business, by analyzing product inventory, repeat customers, store-level performance, and everything in between.We'll start by quickly reviewing prerequisite topics (evaluation context, filter flow, basic measures, etc.), then dive behind the scenes to explore how the DAX formula and storage engines actually work, including query evaluation, columnar structures, and VertiPaq compression and encoding.From there we'll cover helpful tips and analytics best practices for DAX power users, including variables, comments, query formatting and error handling, then dive deep into scalar functions, iterators, advanced time intelligence, calculated table joins, relationship functions, and much, much more. Last but not least, we'll share a sneak peek into performance tuning and DAX query optimization using DAX Studio and Power BI's Performance Analyzer tool.If you're looking to build expert-level data analysis skills using DAX and Power BI, this is the course for you!__________FULL COURSE OUTLINE:Prerequisite Skills ReviewReview the core DAX concepts you should already know, including evaluation context, filter flow, measures, etc.Course Project IntroIntroduce the Maven Roasters course project, and build the data model that we'll analyze in Power BI DesktopThe DAX EnginesUnderstand the DAX formula and storage engines, data types, VertiPaq encoding & compression methods, etc.DAX Tips & Best PracticesReview helpful tips for formatting DAX queries, adding comments, handling errors, and using DAX variablesScalar FunctionsExplore common DAX scalar functions, including rounding, information, conversion, and logical functionsAdvanced CALCULATEReview CALCULATE modifiers, context transition, interactions with tables, etc.Table & Filter FunctionsCreate calculated tables, review common DAX filter functions, generate new data, etc.Calculated Table JoinsCreate calculated joins between physical and virtual tables in Power BI (UNION, EXCEPT, INTERSECT, etc.)Relationship FunctionsExplore expanded tables, physical & virtual relationships, common relationship functions, etc.Iterator ("X") FunctionsExplore iterator cardinality, nested iterators, context transition, RANKX, DAX calculation granularity, etc.Advanced Time IntelligenceBuild date tables with DAX, compare custom time periods, manage fiscal calendars, etc.SNEAK PEEK: Performance TuningIntroduce DAX Studio, the Power BI performance analyzer, and common DAX optimization techniques__________Join today and get immediate, lifetime access to the following:150+ page Power BI & DAX ebookDownloadable datasets and Power BI project filesHomework assignments & quizzes1-on-1 expert supportCourse Q & A forum30-day money-back guaranteeSee you in there!-Aaron (Power BI & DAX Instructor, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!Hear why our Power BI courses are the TOP-RATED on Udemy:"I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning - I wanted to keep charging on to the next lesson!"-Ann S."Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI and DAX and enjoyed the course from start to finish."-Nikola H."Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!"-Jorge M."Where can I leave a 6 star rating?"-Carlos B.
