|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-master-class-power-pivot-data-model-and-dax-formulas/
课程评论：没有评论
课程名称：完整的Excel Power Pivot入门 课程概述： 在这门课程中，您将学习如何利用Excel的强大功能Power Pivot，轻松导入数百万行数据，创建来自不同数据源的汇总，并构建复杂的数据模型。这将使您能够快速分析数据并分享见解。这是一个适合渴望快速掌握Excel Power Pivot的人的课程。 您可以期待学习的内容包括： - 课程简介和大纲 - Power Pivot与数据模型 - Power Pivot与数据透视表 - 创建计算列：基本计算、使用日期字段和日期表 - 创建度量值：聚合度量、=Calculate公式、All和AllExcept公式以及时间智能 - 案例研究 - 在表格之间创建关系及使用关系计算 - 在数据模型中使用KPI可视化 - 创建和使用层级 关于讲师： 讲师拥有20年以上的培训和管理咨询经验，是Udemy的合作讲师，专注于培训商业用户使用强大的方法和技巧，将数据转化为有用的信息和洞察，同时教授微软Excel、微软Power BI、Looker Studio、亚马逊QuickSight及ChatGPT等工具的数据分析方法。 学生评价： 学生们对这门课程给予了高度评价，认为课程易于理解，节奏恰到好处，是非常好的Power Pivot入门。课程内容详实且容易掌握，非常适合专业人士，强烈推荐。 数据分析课程路线图： 随着技术行业不断发展，人工智能、机器学习和大数据领域的投资也显著增加，这意味着对数据分析师的需求不断上升。掌握正确的技能和主动的工作方式，数据分析师可以获得前所未有的成功！讲师目前在Udemy上提供14门涵盖多种工具和技能的数据分析课程，帮助学员自信地探索数据分析的动态领域，获得有价值的数据解读技能，推动数据驱动的决策。
With Excel's impressive Power Pivot, you can import millions of rows of data, create mashups from different data sources and build sophisticated data models with ease. This allows you to analyze your data and share insights with just a few clicks of your mouse. If you are eager to learn about Excel's Power Pivot quickly and easily, this is the course for you. WHAT YOU CAN EXPECT:Introduction and Course ContentPower Pivot and the Data ModelPower Pivot and Pivot TablesCreating Calculated Columns - Basic calculations, using date fields and date tablesCreating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula and Time IntelligenceCase StudiesCreating Relationships between tables and using relationship calculationsUsing KPIs visualizations in the data modelCreating and using hierarchiesABOUT 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 SAYING:I have been searching for a Power Pivot course for a while now and this one fits my expectations; easy to understand and at the right pace. Amazing course, above expectations!Great introduction the power pivot. Now I have a good understanding of the foundation of the material.Incredibly detailed and yet easy to grasp course for professionals! Highly recommendedDATA 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
