|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-bi-sql-server-reporting-service-ssrs-course/
课程评论：没有评论
课程名称：微软BI - SQL Server报告服务（SSRS）课程 课程概述：本课程涵盖了从基础到高级的SSRS知识，专注于在微软SQL Server报告服务（SSRS）中创建报告。学员无需具备任何编程或商业智能基础，但一些SQL知识会有帮助。我们将下载包含SSRS的免费SQL Server版本，并逐步创建各种报告，提升技能。在报告设计方面，我们将选择报告组件（如矩阵、表格、图表等数据可视化组件）、识别数据源和参数、设计分组结构、以及创建钻取报告和钻取透视报告。在报告布局实现方面，我们将学习如何格式化（包括颜色、日期和数字格式）、配置页面、以及在报告中实施页眉和页脚，使用矩阵、表格、图表、图像、指示器、地图和分组。此外，我们将创建不同数据区域的多种报告，定义自定义字段和全局集合，设定表达式，并实现数据可视化组件。在报告交互性实现方面，我们将创建钻取报告和钻取透视报告，添加交互式排序，分析参数（包括多值参数），使用参数创建动态报告，实施显示/隐藏属性，添加链接（跳转到报告和URL），并添加固定页眉和文档视图图。 课程结束时，学员应该能够自信地在SSRS中创建自己的报告。
Course Covers SSRS which is applicable for students from Basics to Advanced Levels.This course is all about creating reports in Microsoft SQL Server Reporting Services (SSRS). No prior Programming or BI knowledge is needed, but some knowledge of SQL would be helpful.We will download a version of SQL Server which includes SSRS - for free. We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:Select report components (matrix, table, chart and other data visualisation component),Identify the data source and parameters,Design a grouping structure,Create drilldown reports and drillthrough reports.As part of implementing a report layout, we will:Find out how to format, including formatting colours, dates and numbers;Configure the page;Implement headers and footers;Implement matrices, tables, chart, images, indicators, maps and groupings in reports;Create a range of reports using different data regions;Define custom fields;Implement global collections;Define expressions; andImplement data visualisation components.As part of implementing interactivity in a report, we will:Create drilldown reports;Create drillthrough reports;Add interactive sorting;Investigate parameters, including multi-value parameters;Create dynamic reports in SSRS using parameters;Implement show/hide property;Add actions (jump to report and URL);Add Fixed headers and a document map.By the end of this course, you should be confident in creating your own reports in SSRS.
