|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-desktop-and-dax-plus-dashboard-creation/
课程评论：没有评论
**课程名称：** Microsoft Power BI Desktop and DAX plus Dashboard creation **课程概述：** 本课程是一门以实践为主的Microsoft Power BI Desktop教程，旨在帮助您掌握商业智能平台的应用，特别是利用Power BI Desktop和DAX（Data Analysis Expressions）进行数据分析和仪表板创建。课程将引导您应对真实世界的数据分析项目，为数据专业人士和有志于成为数据分析师的学习者建立信心。 **项目场景：** 您是一名新晋的数据分析师，加入一家销售分销公司。您的首要任务是利用Power BI分析公司的历史销售数据，并创建响应式仪表板，以追踪关键绩效指标（KPI），如收入、退货、退款和利润。您还需要识别高利润的产品、客户和地区等。本课程将一步步地指导您完成整个过程，提供清晰的解释和实用的资源。 **课程内容：** * **第一阶段：数据连接与转换** * 学习如何导入和清理数据。 * 探索从CSV文件导入数据的方法，以及使用“文件夹”选项整合年度、周度、季度或月度数据的高级技巧，实现自动化更新。 * **第二阶段：数据建模与关系建立** * 学习如何有效地连接数据表和查找表。 * **第三阶段：使用DAX创建计算字段** * 深入学习DAX语言，了解如何创建计算列和度量值。 * 掌握何时使用计算列以及应予避免的情况。 * **第四阶段：可视化与仪表板创建** * 学习如何创建专业、引人注目的报告和仪表板。 * 探索创建自定义工具提示、书签和Power BI What-If参数等高级功能，让数据“活”起来。
Welcome to Power BI Desktop course. This is completely built with lots of Practical that will make you work with any real-Life datasetsAre you a data professional or aspiring analyst looking to learn the top business intelligence platform on the market,taking this course will build your confidence in data and analytics in general.Through out the course we will guide you through on how to approach real-life projects.This is the scenario:You just got hired as a DATA analyst into a sales and distribution company. Your first task is to use POWER BI to getinsight from the company's historical data.Request from your Employer:Your employer needs you to help them TRACK KPI's like: Revenue, Returns, Refunds & Profit etc. Create a dashboard that helps them find trend and other useful insights.They want to identify high profitable Product, Customer and Location etcYou don't need to worry about how to go through this project, we'll be here to walk you through every single step with intuitive, crystal clear explanations and helpful resources you need to get better.Step 1: Connecting to data and transformationIn this first stage we are going to look at how to get data, get it clean and transformed and load it into Power BI desktop.We will explore how to append data from csv and further use the advanced way to combine data from csv which is using the folder option to consolidate your yearly, weekly, quarterly or monthly data for easy update.Step 2: Data modelling or Creating a RelationshipIn this stage we will look at how to best connect your data table and the lookup tables together.Step 3: Adding Calculated Fields with DAXIn this stage things will start to get more interesting. This is the stage you are going to get introduced to Data AnalysisExpressions (DAX) at this stage we will learn how to create calculated columns and measures, explore when to use calculated column and when to avoid it.Step 4: Visualization (Dashboard)This final stage is where we bring our data to LIFE with report and dashboard. We will learn the best way to create an outstanding dashboard, create custom tooltips, explore bookmarks and Power BI What-If Parameters.
