|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-microsoft-excel-power-pivot-dax-meaures/
课程评论：没有评论
**课程名称：** Microsoft Excel Power Pivot：Power Pivot、DAX 和数据透视表 **课程概述：** 本课程旨在帮助学习者在短时间内显著提升 Excel、数据透视表和 Power Pivot 的技能与知识，从而在职场中脱颖而出，获得管理层和潜在雇主的关注。通过学习，您将大大提高使用 Excel 的效率，节省宝贵的工作时间，并消除工作压力。掌握 Power Pivot 技能将使您更有信心地处理数据，从而获得晋升和更高的薪资。 **核心内容：** * **Power Pivot 简介：** * Power Pivot 是 Excel 的一个插件，将商业智能功能植入 Excel。 * 能够连接多个数据源，处理超过一百万行数据，实现比传统数据透视表更强大的数据分析。 * 无限制地处理大数据。 * 可以整合来自 SQL Server、Oracle、XML、Excel、Microsoft Access 等多种数据源，并在同一数据透视表中进行分析。 * **Power Pivot 的可用性：** * Power Pivot 已集成到所有 Windows 版本的 Excel 中，包括 Excel 2010、2013、2016 及之后的 Office 365 版本。 * **先决条件：** * 至少需要了解什么是数据透视表，如何插入数据透视表并创建基本计算。 * 课程使用 Excel 2010，但会讲解与 Excel 2013、2016 和 2019 版本之间的差异。 * **课程主要内容：** * **导入/加载数据：** 从工作簿、工作表、单独的工作簿导入数据。 * **表格关系：** 创建表格之间的关系，包括通过图表视图创建关系。 * **数据透视表和切片器：** 创建数据透视表，以及使用切片器进行数据筛选。 * **DAX 公式入门：** * DAX 公式基础。 * 度量值（Measures）与计算列（Calculated Columns）的区别与应用。 * 常用 DAX 函数介绍，如 DISTINCTCOUNT()、SUM()、CALCULATE()。 * 结合 DAX 创建“唯一订单日期”度量值、“总销售额”度量值，计算“每日期平均销售额”，显示“最大销售值”等。 * **度量值和计算列：** * 使用 CALCULATE() 显示最大销售值。 * 使用计算列提取订单中的年份。 * 利用 CALCULATE() 实现按年份分组。 * 链接日历表，使月份排序正确。 * 向日历表中添加层级结构。 * 结合计算列和度量值进行净利润分析。 **课程价值：** 如果您渴望提升 Excel 技能，节省大量时间（每天、每周、每年），实现职业发展（晋升、加薪），并在同事中脱颖而出，那么本课程将是您的理想选择。立即加入，开启您的个人和职业进步之旅！
You're Just Seconds Away From Leveraging Excel, Pivot Tables & Power Pivot That Will Make It Possible For YOU To:Increase your Excel, Pivot Table & Power Pivot SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!Use Excel Pivot Pivot with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!--------------------***** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! ****--------------------Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.In a nutshell, Power Pivot allows you to use multiple data sources for analysis. So it is a Pivot Table on steroids, meaning it can handle more data and create more powerful calculations using Measures & DAX Formulas.Power Pivot gives you the power to work with large sets of data that are OVER 1 millions rows!!!You can import, consolidate and create relationships from your data and perform enhanced analysis. The beautiful thing with Power Pivot is it allows you to work on Big Data with NO limitations.Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access and analyzing these all into one awesome Pivot Table!This course will introduce you to the key concepts of getting started with Power Pivot and it's various features for enhanced calculations, so you will be confident & comfortable in using Power Pivot on your data.----------POWER PIVOT IS NOW AVAILABLE IN ALL EXCEL VERSIONS!In July 2018, Microsoft announced that Excel Power Pivot will now be available in all Windows editions of Excel, which is awesome news and a step in the right direction.Previously in the 2016 version of Office 365, you needed to have purchased the Office Pro Plus or Office 365 E3 to have access to Power Pivot within Excel.So now you can get Power Pivot in Excel 2010, Excel 2013 and all Office 2016 products, such as:Office 365 Home, Office 365 Personal, Office 365 Business Essentials, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E1----------PREREQUISITES FOR THIS POWER PIVOT COURSE:You need at least an understanding of what Pivot Tables are and how to insert a Pivot Table and create a few calculations.----------EXCEL VERSION THAT I AM USING:I am using Excel 2010 in this course but the layout is very similar to Excel 2013, 2016 & 2019. Any variations in versions between Excel 2010 and the other versions, I explain in each tutorial.----------In this course we will go through the following Power Pivot features:IMPORT/LOAD DATAImport From WorkbookImport From WorksheetImport From Separate WorkbooksTABLE RELATIONSHIPSCreate RelationshipsCreate Relationships via the Diagram ViewPIVOT TABLES & SLICERSCreate a Pivot TableInsert a SlicerINTRO TO DAX FORMULASIntro to DAX FormulasIntro to DAX Formulas: Measures vs Calculated Columns - Part 1Intro to DAX Formulas: Measures vs Calculated Columns - Part 2List of various DAX FormulasMEASURES & CALCULATED COLUMNSDISTINCTCOUNT() - Create a "Unique Order Dates" MeasureSUM() - Create a "Total Sales" MeasureCombine 2 Measures to get "Average Sales Per Date"CALCULATE() - Show Largest Sales ValuesCalculated Column - Extract Years from Order DateCALCULATE() - Group YearsLink a Calendar TableSort Month Dates Into The Correct OrderAdd a Hierarchy to the CalendarCombine a Calculated Column with a Measure - Net Profit Analysis----------Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...…saving HOURS each day, DAYS each week and WEEKS each year…...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…...All whilst impressing your boss and STANDING OUT from your colleagues and peers......THEN THIS COURSE IS FOR YOU!Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills! To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...
