|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bidata-analyst-power-bisqlazureexcelalteryx/
课程评论：没有评论
课程名称：Power BI/数据分析师 - Power BI/SQL/Azure/Excel/Alteryx 课程概述：Power BI是一种商业分析解决方案，让您能够可视化数据并在组织内部共享洞察，或将其嵌入到您的应用程序或网站中。通过连接数百种数据源，您可以用实时仪表板和报告将数据生动呈现。该课程旨在帮助学习者快速从数据中获取洞察，使用Power BI这一强大的商业分析工具集，包括Power BI服务、Power BI Desktop和Power BI Mobile，您将有效地创建和分享影响力视觉化内容。 课程内容涵盖了初心者所需的基本知识，包括如何连接和转换基于网络的数据源，如何在Power BI服务上发布和分享报告与视觉内容。学习内容包括：导入数据、创建视觉化、将这些视觉化整理成报告、将视觉化固定到仪表板以便共享。此外，您还将学习如何使用DAX语言（数据分析表达式）对数据模型进行计算。 具体主题包括： - 连接SQL Server和PostgreSQL数据库 - 连接Microsoft Access数据库文件 - 创建数据视觉化报告 - 修改现有报告 - 创建和管理数据仪表板 - 创建Power BI数据集、仪表板、报告和工作簿 - 连接基于网络的数据源 - 使用Excel数据集 - 使用查询编辑器 - 表格连接和创建表 - 使用DAX逻辑进行公式计算 - 使用快速度量和动态度量 - 使用条件语句 - 对连接数据集执行各种转换 本课程适合希望掌握Power BI工具、提升数据分析能力的初学者。
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 dataset
