|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-hands-on-etl-course-2022-real-world-business-case/
课程评论：没有评论
课程名称：2023年Power BI实操ETL课程——真实商业案例 课程概述：本课程旨在教授学员根据行业标准和最佳实践设计和开发出色的Power BI报告。您将学习Power BI Desktop的所有独特功能，帮助您理解并增强自信心，包括数据集成、数据转换、数据建模、数据探索、数据可视化和讲故事的技巧。 课程内容：我们将采用实操方法，首先理解商业案例，然后根据需求，进行逐步的实际操作，首先清理我们的数据，进行数据整合，接着开始可视化工作。在这门全面的实操课程中，您将体验作为数据分析师的角色，为首席市场官和首席财务官开发Power BI报告，帮助他们从数据中发现商业洞察，跟踪主要销售和财务关键绩效指标(KPI)。 您将分析销售和市场份额分析数据，重点关注哪些产品类别和制造商生成了最多的收入，同时进行与其他顶级制造商的竞争分析。我们将从多个数据源整合数据，然后执行大量转换以准备和清理数据，使其能够进行报告。一旦数据加载完成，我们将开始构建数据模型，并逐步进行可视化工作。 在课程中，您将进行大量的数据分析和探索，并通过提出重要问题来促进学习。同时，我们将研究销售分析中常见问题的答案，使用DAX计算，创建自己的度量值和计算列。我们的最终目标是设计一个专业的销售分析报告，使最终用户能够轻松获取见解并采取相应行动。 此外，我们还将使用多种基于AI的Power BI可视化工具，对数据进行深入分析。
Learn to design and develop amazing Power BI report as per industrial standards and best practices. In this course, you'll learn all the unique features of Power BI Desktop to help you understand and gain confidence in - Data IntegrationData TransformationData ModellingData ExplorationData VisualizationStorytellingCourse content We'll be taking a practical approach by first understanding the business case, then as per our requirement will be working step-by-step practical approach to first clean our data, mashup and then start our work on visualizations.In this extensive hands-on course, you will be under the shoes of a Data analyst who is developing a Power BI report for Chief Marketing Officer and Chief Financial Officer to help them uncover the business insights from their data and track major Sales and Financial KPIs.You will be working and analyzing a Sales and market share analysis data where your focus would be to find out which product categories and manufacturers are generating the most revenue. Along with that, you will be doing a competitive analysis against other top manufacturers. We'll start by integrating the data from multiple data sources and then performing lot of transformations to prepare and clean our data and make it ready for reporting.Once loaded, we'll start working on making a data model and working our way towards the visualizations.We'll be doing a lot of data analysis and exploration by asking important questions throughout the course.We'll also be working our way to answer some of the common questions while doing Sales analysis through DAX calculations and creating our own measures and calculated columns.Our final goal will be to design a professional sales analysis report that can easily be used by the end users to gather the insights and help them take actions out of it.Furthermore, we'll be using multiple AI-based Power BI visuals to do some advanced analysis on our data.
