|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-beginner-to-intermediate-training/
课程评论：没有评论
课程名称：微软 Power BI 精通：从初学者到中级 课程概述： 本课程包包含可下载的课程讲师文件，方便学员跟随学习。我们将微软 Power BI 初学者和中级课程结合在这个超值套餐中。如果您在 Excel 的使用上遇到瓶颈，需要分析和理解大量数据，Power BI 将帮助您将现有的数据处理能力提升到一个新的高度！Power BI 是微软提供的一个强大的自助式商业智能(BI)解决方案，非常适合技术经验有限的用户。 课程内容： 初学者课程： - 了解 Power BI 及其使用价值 - 将 CSV 和 Excel 文件导入 Power BI Desktop - 使用合并查询提取其他查询的数据 - 创建数据模型的表之间的关系 - 深入学习 DAX，包括 COUTROWS、CALCULATE 和 SAMEPERIODLASTYEAR 函数 - 使用卡片视觉创建摘要信息 - 利用其他视觉效果，如分组柱形图、地图和趋势图 - 使用切片器来过滤报告 - 使用主题快速一致性格式化报告 - 编辑视觉化之间的交互，并在视觉化、页面和报告层面进行过滤 中级课程： - 在 Power Query 中导入和转换数据 - 导入 Excel、文本和 CSV 文件，并合并文件 - 启用/禁用加载和报告刷新 - 解决数据导入错误 - 数据建模、关系类型及解决关系问题 - 措施与计算列 - 使用 DAX 创建日期表 - 创建附加和条件列 - 使用 ROUNDUP 和 SUMX 函数 - 快速创建措施和关键措施表 - 使用 DAX - CALCULATE 函数 - 格式化视觉化并应用条件格式 - 使用列、线条和地图图表，仪表和卡片视觉 - 使用切片器和过滤器并应用设计元素 - 在 Power BI 服务中创建共享工作区 - 构建报告和仪表板 - 将视觉化固定到仪表板 - 设置定时刷新 课程包包括： - 10+ 小时的视频教程 - 110+ 个独立视频讲座 - 课程和练习文件，帮助您跟随学习 - 完成证书 学生反馈： - “精彩课程，适合初学者理解POWER的功能。” - Andrew - “详细的课程，Simon 解释每个步骤都很好。” - Martin - “非常推荐，课程信息量大且易于跟随。” - Thomas - “一切都很清晰易懂，完美的课程！” - Jovita
**This course bundle includes downloadable course instructor files to follow along.**We've combined our Microsoft Power BI Beginner and Intermediate courses in this great value bundle. If you have reached your Excel limit and need to analyze and make sense of huge amounts of data, then Power BI can help take your existing data-crunching capabilities to new heights!Power 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.The Power BI beginner course starts 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.This intermediate training course is designed to be a continuation of the introductory Power BI course. We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success. The latter part of the course is an intensive exercise to give you practice creating reports and dashboards.What's included?Power BI for Beginner: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.Power BI Intermediate:Importing and transforming data in Power QueryImporting Excel, text, and CSV files and combining filesEnabling/disabling load and report refreshResolving data import errorsData modeling, relationship types, and troubleshooting relationship issuesMeasures vs. calculated columnsCreating a date table with DAXCreating additional and conditional columnsUsing the ROUNDUP and SUMX functionsCreating quick measures and key measures tablesThe DAX - CALCULATE functionTables vs. matrix tablesFormatting visualizations and applying conditional formattingUsing column, line, and map chartsGauge and card visualizationsUsing slicers and filters and applying design elementsCreating a shared workspace in Power BI serviceBuilding reports and dashboardsPinning visualizations to the dashboardSetting up scheduled refreshesThis course bundle includes:10+ hours of video tutorials110+ individual video lecturesCourse and exercise files to help you follow alongCertificate of completionHere's what our students are saying...5 Stars "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." -Andrew5 Stars "Very detailed course, really enjoyed the Power BI course. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques." -Martin5 Stars "I would highly recommend. The course was informative and easy to follow." - Thomas5 Stars "I like everything! Everything is clear and understandable. Perfect courses!" -Jovita
