|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysts-toolbox-excel-python-power-bi/
课程评论：没有评论
课程名称：数据分析师工具箱：Excel、Python、Power BI和数据透视表 课程概述： 在商业领域，理解、利用和使用数据的能力不再是少数高薪分析师的专属技能，而是许多角色的必备能力。虽然这听上去令人生畏，但如今有一系列工具使数据分析对每个人都更加可及。本课程为一个高价值的四门课程组合，详细讲解了三种工具：Excel、Python和Power BI。单独看，Excel、Python和Power BI都是非常有用且强大的工具，学习这三种工具将使您对复杂数据分析的方法有更深的理解。本课程主要面向中级Excel用户，旨在帮助他们掌握Python和Power BI。所有课程都包含实践练习，让您能将所学知识付诸实践。 课程内容： 1. Python入门 - Python中的基本数据类型：字符串、整数、浮点数和布尔值 - Python内置函数的使用 - 变量和函数的工作原理 - 如何调试Python中的错误 - Python关键字的介绍 - 使用IF-Else语句 - 存储复杂数据（包括列表和字典） - Python模块的使用及安装 - 本地安装Python - 编写您的第一个Python脚本 - 完成第一个Python项目 2. 高级数据透视表 - 数据透视表快速回顾 - 如何从多个工作表中组合数据 - 分组、取消分组和处理错误 - 如何格式化数据透视表 - 值字段设置的使用 - 数据透视表中的高级排序和过滤 - 使用切片器和时间线 - 创建计算字段 - 使用GETPIVOTDATA - 创建数据透视图及添加微型图和切片器 - 从数据透视表使用3D地图 - 更新数据透视表和数据透视图中的数据 - 数据透视表中的条件格式设置 - 创建美观的仪表板 3. Power Pivot、Power Query和DAX - 开始使用Power Query - 如何将Excel连接到多个工作簿 - 从网页及其他来源获取数据 - 使用Power Query合并和附加查询 - Power Pivot窗口的工作原理 - 在数据模型中设置和管理关系 - 使用Power Pivot数据模型创建数据透视表 - 使用DAX添加计算列 - DAX函数的使用：如CALCULATE、DIVIDE、DATESYTD - 创建数据透视图和数据透视表以及使用数据模型 - 使用切片器调整显示数据 4. Power BI - 什么是Power BI及其使用价值 - 如何将CSV和Excel文件导入Power BI Desktop - 使用合并查询从其他查询获取数据 - 创建数据模型中不同表之间的关系 - DAX的使用：包括COUTROWS、CALCULATE和SAMEPERIODLASTYEAR函数 - 使用卡片视觉效果创建摘要信息 - 使用其他视觉效果，如聚集柱状图、地图和趋势图 - 使用切片器过滤报告 - 使用主题快速一致地格式化报告 - 编辑视觉化间的交互，并在视觉、页面和报告级别过滤 课程特色： - 超过21小时的视频教程 - 200多节独立视频讲座 - 实践练习文件 - 完成证书 学生反馈： “讲师讲解得非常清晰，资料也很有帮助。”——奥斯卡 “这门课程与我的工作非常相关，讲师解释详细而不急于求成。”——图拉尼 “我在IT方面有一定知识，但之前从未考虑专注于数据分析。这次课程非常振奋人心，我迫不及待想学更多。”——肯维斯 “谢谢你们这样的精彩授课，对我来说是一次很好的学习体验。”——安库什
In business, being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid analysts. It's becoming an essential part of many roles.If that sounds daunting, don't worry. There is a growing set of tools designed to make data analysis accessible to everyone, in this huge-value, four-course Data Analysts Toolbox bundle we look in detail at three of those tools: Excel, Python, and Power BI. In isolation Excel, Python, and Power BI are useful and powerful. Learn all three and you are well on your way to gaining a much deeper understanding of how to perform complex data analysis.This Data Analysts Toolbox bundle is aimed at intermediate Excel users who are new to Python and Power BI. All courses include practice exercises so you can put into practice exactly what you learn.Here's what each course covers:Introduction to PythonThe basic data types in Python - Strings, Integers, Floats, and BooleanAll about Pythons built-in functionsHow Variables and Functions work in PythonHow to debug errors in PythonAll about Python KeywordsHow to use IF-Else Statements in PythonAll about storing complex data, including Lists and DictionariesAll about Python Modules and how to install themHow to install Python locallyHow to write your first script in PythonTo complete your first Python projectAdvanced PivotTablesHow to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing looking dashboardsPower Pivot, Power Query and DAXHow 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 BIWhat 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 and demo files and project files included***This mega-value bundle includes:21+ hours of video tutorials200+ individual video lecturesExercise files to practice what you learnedCertificate of completionHere's what our students are saying…"The instructors have explained everything amazing and the resources are super helpful."- Oscar"This course is very relevant in my line of work. The facilitators are detailed in their explanation & don't rush through the information."- Thulani"My name is Kenvis and I have a knowledge in IT but never thought of specializing in Data Analytics before. This was so exciting and I am now anxious to learn more."- Kenvis"Thank you for such a wonderful teaching. This is a great learning experience for me."- Ankush
