|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-pivot-power-query-in-excel-and-powerbi/
课程评论：没有评论
课程名称：Excel中的Power Pivot、Power Query及Power BI捆绑课程 课程概述： 本课程由Microsoft专家Simon Sez IT推出，包括实践练习文件。结合了两门优质的数据分析课程，旨在帮助学员掌握Microsoft Power BI、Power Pivot、Power Query和DAX。适用于在Excel中面临数据分析挑战并希望提升数据处理能力的学员。 在这一高级Excel课程中，将深入探讨三个关键功能：Power Pivot、Power Query和DAX。这一系列Excel功能可以帮助您操控、分析和评估来自Excel或其他数据库的数百万条数据。课程内容包括： - 使用Power Query整合、合并和清理数据 - 创建数据表之间的关系并建立数据模型 - 使用DAX对数据模型进行计算 - 使用数据透视表和数据透视图展示分析结果 学习内容涵盖： - Power Query的入门 - 连接Excel到多个工作簿 - 从网络及其他来源获取数据 - 使用Power Query合并和追加查询 - Power Pivot窗口的功能 - 在数据模型中设置和管理关系 - 使用DAX创建计算列 - 生成数据透视图和数据透视表并利用切片器调整展示数据 Power BI部分： Power BI是微软提供的一种强大的自助式商业智能(BI)解决方案，非常适合技术经验有限的用户。课程内容包括： - Power BI的基本概念及其应用 - 将CSV和Excel文件导入Power BI Desktop - 使用合并查询从其他查询获取数据 - 在数据模型中创建不同表之间的关系 - 学习DAX的基本用法，包括COUTROWS、CALCULATE和SAMEPERIODLASTYEAR函数 - 使用卡片视觉化创建汇总信息 - 利用其他视觉化工具（如簇状柱形图、地图和趋势图）表示数据 - 使用切片器过滤报告并快速一致地格式化报告 课程包括： - 7小时以上的视频教程 - 89个独立的视频讲座 - 实践文件以巩固学习内容 - 完成证书 学员反馈： 学生们对课程的反馈非常积极，认为内容详尽且易于理解。很多人期待继续深化Power BI的学习，并认为这门课程为其职业生涯带来了实用的应用价值。 通过本课程，您将从高级Excel技能提升到Power BI应用，特别适合Excel数据分析师。
**This course includes practice exercise files**Learn Microsoft Power BI and Power Pivot, Power Query and DAX in Excel in this two-course bundle from Microsoft experts Simon Sez IT.We've combined two of our best data analysis courses to create this huge-value bundle. If you have reached your limit in Excel and you need to analyze and make sense of huge amounts of data, then you need Power Pivot, Power Query and Power BI. These tools can help you take your existing data-crunching capabilities to new heights!Power Pivot, Power Query and DAXIn this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.We first look at how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.***Exercise and demo files included***In the Power Pivot, Power Query & DAX course you will learn:How to get started with Power QueryHow to connect Excel to multiple workbooksHow to get data from the web and other sourcesHow to merge and append queries using Power QueryHow the Power Pivot window worksHow to set up and manage relationships in a data modelHow to create a PivotTable to display your data from the Power Pivot data modelHow to add calculated columns using DAXHow to use functions such as CALCULATE, DIVIDE, DATESYTD in DAXAll about creating Pivot Charts and PivotTables and using your data modelHow to use slicers to adjust the data you displayPower BIPower BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.In the Power BI course you will learn:What is Power BI and why you should be using it.To import CSV and Excel files into Power BI Desktop.How to use Merge Queries to fetch data from other queries.How to create relationships between the different tables of the data model.All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.All about using the card visual to create summary information.How to use other visuals such as clustered column charts, maps, and trend graphs.How to use Slicers to filter your reports.How to use themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.***Exercise files included***This course includes:7+ hours of video tutorials89 individual video lecturesExercise files to practice what you learnedCertificate of completionHere's what our students are saying…"Very detailed course, really enjoyed the Power BI section. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advance techniques."- Martin"Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand. Recommended. I will be looking for other courses by them."- Andrew"Extremely clear instructions and has framed the subject matter as usable in the real world as opposed to just an academic sample. I was exposed to Power Pivot in one of my classes in college but it was presented in a way that made it difficult to apply to my work. Glad I found this course!"- Jeff"The best course where you can get the knowledge from Advance Excel to Power Bi. Highly recommended for Excel data analyst."- Sabari
