|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analyst-powerbipowerpivotpowerquerypivotchartdax/
课程评论：没有评论
课程名称：数据分析师：PowerBI、PowerPivot、PowerQuery、PivotChart、DAX 课程概述：作为数据分析师，您正踏上使用数据的旅程。如今，组织每天生成和可用的数据量巨大，包括传统数据库中的事务性数据、来自使用服务的遥测数据以及来自社交媒体等不同领域的信号。例如，现代零售企业收集和存储海量数据，跟踪浏览和购买的商品，访问过的页面，购买产品的过道，消费习惯等等。在数据和信息成为企业最具战略意义的资产的情况下，企业面临的主要挑战是理解并利用这些数据，从而积极推动业务的变革。然而，许多企业仍在努力有效地使用数据，这直接影响到他们的行动能力。 解锁数据的关键在于讲述数据背后的故事。在竞争激烈且快速变化的商业环境中，制作能够讲述这些故事的报告是帮助企业领导者根据数据采取行动的关键。决策者依赖准确的数据故事来推动更好的商业决策。企业通过快速做出准确的决策可以提升竞争力，获得优势。没有故事，难以理解数据所传达的含义。 然而，单凭数据并不足够。您需要能够对数据采取行动，以实现业务变革。这些行动可以包括在资源的重新分配、识别失败的营销活动并在适当时机改变方向等情况。此时，讲述数据故事变得尤为重要。企业今日面临的挑战是理解并利用数据，以影响业务和最终盈利。您需要能够审视数据，从而做出可信的商业决策，并清楚理解所涉及的指标所表达的含义。 数据分析旨在帮助企业克服这些挑战，最终通过讲述故事的方式发现洞见，揭示数据中的隐藏价值。您将学习如何运用和应用分析技能，进一步超越单一报告，通过数据讲述故事，推动数据文化的发展。 Power BI 是一套商业分析解决方案，可以帮助您可视化数据并与组织内的其他人分享见解，或将其嵌入到应用程序或网站中。通过连接数百个数据源，利用实时仪表板和报告让您的数据焕发生机。您将学习如何快速从数据中提取见解，掌握 Power BI 服务、Power BI Desktop 和 Power BI Mobile 等强大工具。 Microsoft Excel 中的 Power Query 和 Power Pivot 功能结合后，可以发挥强大的作用。Power Query 可以帮助您发现、连接和导入数据，而 Power Pivot 则可以快速建模这些数据。您将学习如何运用 DAX 公式语言来实现查找功能。 课程内容将包括逐步指导您如何使用 Power Query 选择数据、准备查询、清洗数据以及为 Power Pivot 准备数据；展示 Power Pivot 的工作流程，包括如何创建数据模型、导入额外数据、构建数据之间的关系、创建计算和度量。您将通过实际案例学习 Power Query 和 Power Pivot 的实际操作。 学习目标包括： - 准备查询 - 使用 Power Query 清洗数据 - 增强查询 - 在 Power Pivot 中创建数据模型 - 构建关系 - 创建数据透视表与数据透视图 - 创建查找 - 使用 DAX 连接数据 - 创建数据模型 - 分析数据与数据透视表和数据透视图 - 将 Power Query 与 PowerPivot 结合使用 - 连接到多个数据源并创建和发布Power BI报告 - 刷新数据源、更新查询 - 使用条件语句、快速和动态度量 - 转换连接数据集中的数据 这个课程将帮助您掌握数据分析必备的实用技能，从而在数据驱动的决策过程中增强竞争力。
As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media.For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products from, your spending habits, and much more.With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business. Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.The key to unlocking this data is being able to tell a story with it. In today's highly competitive and fast-paced business world, crafting reports that tell that story is what helps business leaders take action on the data. Business decision makers depend on an accurate story to drive better business decisions. The faster a business can make precise decisions, the more competitive they will be and the better advantage they will have. Without the story, it is difficult to understand what the data is trying to tell you.However, having data alone is not enough. You need to be able to act on the data to effect change within the business. That action could involve reallocating resources within the business to accommodate a need, or it could be identifying a failing campaign and knowing when to change course. These situations are where telling a story with your data is important.The underlying challenge that businesses face today is understanding and using their data in such a way that impacts their business and ultimately their bottom line. You need to be able to look at the data and facilitate trusted business decisions. Then, you need the ability to look at metrics and clearly understand the meaning behind those metrics.Data analysis exists to help overcome these challenges and pain points, ultimately assisting businesses in finding insights and uncovering hidden value in troves of data through storytelling. As you read on, you will learn how to use and apply analytical skills to go beyond a single report and help impact and influence your organization by telling stories with data and driving that data culture.Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools-which includes the Power BI service, Power BI Desktop, and Power BI Mobile-can help you more effectively create and share impactful visualizations with others in your organization.The Power Query and Power Pivot features in Microsoft Excel can make a powerful combination. Power Query enables you to discover, connect to, and import data, and Power Pivot lets you quickly model that data. You will learn how to use the DAX formula language to provide lookup abilities.I will walk you through step-by-step how to use Power Query to select data, prepare a query, cleanse data, and prepare data for Power Pivot. Also i will walks you through the Power Pivot workflow, showing how to create a data model, import additional data if needed, build relationships between data, and create calculations and measures. You will learn hands on real-world scenarios for working together with Power Query and Power Pivot.Learning objectivesPreparing queriesCleansing data with Power QueryEnhancing queriesCreating a data model in Power PivotBuilding relationshipsCreating Pivot Tables and Pivot ChartsCreating LookupsUsing DAX to link dataCreating data modelCreating relationship between data sourcesAnalyzing data with PivotTables and PivotChartsUsing Power Query with PowerPivotConnecting to a variety of data sources with Power BICreate and publish reports to Power BI ServiceRefreshing Data Source Updating QueriesUsing Conditional statementsUsing quick and dynamic measuresTransforming data on connected datasets
