|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/bi-developer-learn-power-bi-ssis-ssrs-ssasdwt-sql/
课程评论：没有评论
课程名称：BI开发者：学会（Power BI SSIS SSRS SSASDWT-SQL） 概述：本课程旨在教授Power BI，这是一种商业分析解决方案，可以帮助您可视化数据并在组织中分享见解，或将其嵌入到您的应用或网站中。通过连接数百个数据源，将数据生动呈现，利用实时仪表板和报告快速获取数据洞察。本课程适合初学者，涵盖如何使用Power BI工具集，包括Power BI服务、Power BI桌面和Power BI移动应用等。您将学习连接和转换基于网络的数据源，发布和分享报告与可视化内容，以及如何导入数据、创建可视化并将其整理成报告。同时，课程还将教授如何将可视化固定到仪表板上以便分享，以及如何使用DAX语言（数据分析表达式）对数据模型进行计算。 课程内容包括： 1. 连接SQL Server和PostgreSQL数据库 2. 连接Microsoft Access数据库文件 3. 创建数据可视化报告 4. 修改现有报告 5. 创建和管理数据仪表板 6. 创建Power BI数据集、仪表板、报告和工作簿 7. 连接网络数据源 8. 连接Excel数据集 9. 使用查询编辑器 10. 表格连接与创建 11. DAX逻辑公式的使用 12. 快速度量和动态度量的应用 13. 使用条件语句 14. 对连接数据集进行各种转化 15. 实现数据仓库解决方案 16. 调试和故障排除SSIS包 17. 使用数据质量服务进行数据清洗 18. 通过自定义脚本和组件扩展SSIS 19. 创建ETL（提取、转换、加载）过程 20. 部署SSIS包 21. 使用SQL Server集成服务创建SSIS包 22. 下载并安装SQL Server数据工具 23. 使用SQL Server分析服务进行数据分析 24. 使用SQL Server报告服务生成报告 25. 下载并安装SQL Server 26. 学习一些关键的T-SQL操作 作为BI开发者，需具备多种技能，以便执行设计、实施和维护结构化查询语言（SQL）数据库的任务。根据具体职位，BI开发者可能担任数据库或网络开发人员。BI开发者应具备较强的分析、沟通和问题解决能力，并对SQL服务器、SQL Server分析服务（SSAS）、SQL Server集成服务（SSIS）以及服务器报告服务（SSRS）有充分的了解。
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 datasetHow to implement a data warehouse solutionDebug and Troubleshoot SSIS packages.Cleansing data by using Data Quality Services.Extend SSIS with custom scripts and components.How to create ETL (Extract,Transform, Load) processHow to deploy SSIS PackageHow to create SSIS package using SQL Server Integration ServicesHow to download and install SQL Server Data ToolsHow to perform data analysis with SQL Server Analysis Server - SSASHow to create reports using SQL Server Reporting ServicesHow to download and install SQL ServerLearning some key operations using T-SQLBI developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases. They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers.As a BI developer, you should have strong analytical, communication, and problem-solving skills. A knowledge of SQL servers, SQL Server Analysis Services -SSAS, SQL Server integration services (SSIS) and server reporting services (SSRS) is also important.
