|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/bi-data-engineer-analyst-power-bi-sql-data-excel-dax/
课程评论：没有评论
课程名称：BI数据工程师分析师：Power BI, SQL, 数据Excel, DAX 课程概述：Power BI是一种商业分析解决方案，可以让您可视化数据，并在组织中分享见解，或将其嵌入到您的应用或网站中。通过连接数百个数据源，您可以以实时仪表板和报告的方式使数据生动起来。本课程将教您如何快速从数据中提取见解，利用Power BI这一强大的商业分析工具集，包括Power BI服务、Power BI桌面版和Power BI移动版，有效创建和分享富有影响力的可视化效果。 本初学者课程将指导您熟悉这个强大的工具集。我们将涵盖连接和转换基于网络的数据源等主题。您将学习如何在Power BI服务中发布和分享报告和可视化内容，以及如何导入数据、创建可视化效果并将其安排到报告中。您还将学习如何将可视化效果固定到仪表板上以便分享。此外，您将学习如何使用DAX语言（数据分析表达式）对数据模型进行计算。 课程主题包括： - 连接到SQL Server和PostgreSQL数据库 - 连接到Microsoft Access数据库文件 - 创建数据可视化报告 - 修改现有报告 - 创建和管理数据仪表板 - 创建Power BI数据集、仪表板、报告和工作簿 - 连接到基于Web的数据源 - 连接到Excel数据集 - 使用查询编辑器 - 连接和创建表 - 使用DAX逻辑进行公式计算 - 使用快速度量和动态度量 - 使用条件语句 - 对连接的数据集执行各种转换 此外，我们还将使用Excel和SQL进行一些数据分析。
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.In this beginners course you will learn how to get started with this powerful toolset. We will cover topics like connecting to and transforming web based data sources. You will learn how to publish and share your reports and visuals on the Power BI service.You will learn how to import data, create visualizations, and arrange those visualizations into reports. You will learn how to how to pin visualizations to dashboards for sharing. You will also learn how to use DAX language( Data Analysis Expressions) to perform calculations on data models.Topics include:Connecting to SQL Server and PostgreSQL DatabasesConnecting to Microsoft Access Database FileCreating reports with data visualizationsModifying existing reportsCreating and managing data dashboardsCreating Power BI datasets, dashboards, reports, and workbooksConnecting to web based data sourceConnecting to Excel datasetUsing Query EditorJoining tables and creating tablesFormulating via DAX logicUsing quick measures and dynamic measuresUsing conditional statementsPerforming various transformation on connected datasetWe will also be performing some data analysis using Excel and SQL.
