|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-and-power-query-for-excel-users/
课程评论：没有评论
课程名称：适用于Excel用户的Power BI与Power Query 课程概述：该课程由一位在企业商业智能（BI）领域拥有18年经验的专业分析师主讲，课程旨在教导新分析师们如何高效利用Power BI和Power Query。每个项目将包括Excel、Power Query和Power BI三个版本，通过这种方式可以强化学习，展示这三个平台如何巧妙连接以及各自的角色。 课程内容不冗长，将重点放在真实项目上。课程中不会逐一列出所有Excel函数，也不会详解每个Power BI菜单项，而是直接进入实践，通过逐步引导来完成分析过程。 学习流程包括： 1. 定义业务问题 2. 审核和分类原始数据及其来源系统 3. 加载、转换、清洗和组织数据，以形成数据模型 4. 构建可视化图表和报告 每个项目都将进行Excel版、Power Query版和Power BI版的制作，完成若干项目后，学员将能识别到过程中的规律，这样的学习将更为有效。 本课程的目标是帮助学员识别这些模式，使其能够像分析师一样思考和工作。跟随课程完成真实世界的项目，提升你的数据分析能力。
I'm a professional analyst with 18 years' experience in BI in a corporate setting. This is exactly how I teach my new analysts.For each project, there is an Excel version, a Power Query version, and a Power BI version. This reinforces learning, and you will see how Microsoft has ingeniously linked the platforms, and the role each one plays.Some Courses Advertise Hundreds of Hours of Content...I keep it straight to the point. I will not be listing all the Excel functions, I will not be explaining every Power BI menu ribbon item...instead, we will jump straight into real projects, and I will guide you step-by-step through the analytics process.We will approach each project the same way:Define the business problem;Review and classify raw data and source systems;Load, transform, cleanse, and organize data into a data model;Build the visualizations and reportsWe will do an Excel version, a Power Query version, and a Power BI version.Once you do a handful of projects, you will notice patterns to the process.This is where things begin to "click". And that's more powerful than any course that simply walks you through what each function does and then has one Case Study at the end.My goal is to help you see those patterns today and think and work like an analyst.Follow along as we complete Real World projects.
