|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-master-class-data-modelling-and-dax-formulas/
课程评论:没有评论
课程名称:Power BI大师班 - 数据模型与DAX公式 课程概述: 优秀的报告源于优秀的数据模型。本课程将带你学习创建关系、创建度量值、使用DAX以及构建一款确保报告质量的数据模型所需的所有技能。本课程旨在帮助你快速入门,为你成为Power BI专家奠定重要基础。 课程内容与成果: - 创建计算列:基本计算、日期字段与日期表的使用 - 创建度量值:聚合度量 =Calculate 公式、All 和 AllExcept 公式、时间智能、客户细分等 - 创建表之间的关系及其计算 - 创建虚拟表及表之间的计算 - 创建并使用层次结构和数据分组 - 直接查询、星型模式和快速度量案例研究 关于讲师: 我是一名Udemy的讲师伙伴,拥有超过20年的培训和管理咨询经验。专注于培训商业用户学习强大的方法和技术,将数据转化为有用的信息和智能,同时学习强大的数据分析方法。 学生反馈: 这门课程非常棒,揭示了我以前从未想到的功能。我迫不及待想在实际场景中应用这些技巧。来自Spotfire的我,在公司决定使用Power BI后,本课程帮助我适应了Power BI的使用。虽然我之前对Power BI已经颇为熟悉,但这门课程让我看到了更多工具的潜力。我非常欣赏讲师直接、清晰且易于理解的教学风格,强烈推荐给所有已经使用Power BI并准备迈出下一步的人。 数据分析课程路线图: 随着技术行业的不断发展,人工智能、机器学习和大数据领域的投资显著增长,这意味着对数据分析师的需求也在不断增加。具备正确的技能并采取积极的态度,数据分析师可以达到前所未有的高度!我目前在Udemy上提供14门涵盖各种工具和技能的课程,以帮助你自信地探索动态数据分析领域,获取有价值的数据解读技能,并驱动智能、数据驱动的决策。
Great reports are built on great data models. In this course, learn how to create relationships, create measures, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch! This course will get you up to speed and working in a very short time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert. COURSE CONTENT AND OUTCOMECreating Calculated Columns - Basic calculations, using date fields and date tablesCreating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Time Intelligence, Customer Segmentation and many moreCreating Relationships between tables and using relationship calculationsCreating Virtual Tables and Calculations between TablesCreating and using hierarchies and data groupsCase Studies on DirectQuery, Star Schemas and Quick MeasuresABOUT THE TRAINERI am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.WHAT STUDENTS ARE SAYINGThis course is great, it revealed to me functions that I never thought existed. I cannot wait to apply these in real time scenarios. Thanks Ian you are doing a great job.Coming from Spotfire (after company decided PowerbI is cheaper) with its slightly different approach, this course helped to gain some traction with PowerBII felt quite comfortable using Power BI, but this course opened my eyes to many more possibilities the tool offers. I really appreciate the straightforward, no-nonsense and easy to follow teaching style from the instructor. Highly recommended to all who have been using Power BI and are ready for the next step.DATA ANALYSIS COURSES ROADMAPThe tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.Microsoft ExcelIntroduction to Analyzing Data with Excel Pivot TablesComplete Introduction to Excel Power PivotComplete Introduction to Excel Power QueryExcel Interactive Dashboards and Data AnalysisComplete Introduction to Business Data AnalysisTables and Formulas with ExcelMicrosoft Power BIComplete Introduction to Microsoft Power BIComplete Introduction to Power BI Query EditorPower BI Master Class-Data Models and DAX FormulasPower BI Master Class - Dashboards and Power BI ServiceGoogleComplete Introduction to Google Sheets Pivot TablesComplete Introduction to Looker Studio (formerly Google Data Studio)Amazon QuickSightComplete Introduction to Amazon QuickSightChatGPTIntroduction to Analyzing Data with ChatGPT