|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/business-reports-with-ssrs/
课程评论：没有评论
课程名称：使用 SQL Server Reporting Services (SSRS) 创建商业报告 课程概述：本课程旨在教您如何设计和部署个人或工作用的商业报告。您将学习 SQL Server Reporting Services 的基础知识，包括从安装到创建第一个报告的全过程。课程还将介绍一些基本的 SQL Server 安装和 SQL Management Studio，以提供完整的新手指南。 您将学习： - 安装 SQL Server 2019 - 安装 SQL Server Management Studio - 下载并设置 Adventure Works 数据库 - 下载和安装 SQL Server Reporting Services (SSRS) - SSRS 门户的介绍 - 下载和安装 Report Builder - 创建数据源和共享数据源 - 创建第一个数据集 - 创建第一个 SSRS 报告 - 报告设计，包括页眉和页脚 - 报告表格视图的创建与格式化 - 表达式和参数的介绍 - 使用下拉参数 - 创建链接或依赖的级联下拉参数 - 在 SSRS 报告中添加图像 - 在 SSRS 中进行分组、序号和总计 - 向报告中添加图表 - 将报告发布到 SSRS 服务器 - 为自动投递设置订阅（文件夹和电子邮件接收者） 适合人群：如果您是希望成为数据分析师或数据库/后端开发人员的初学者，本课程非常适合您。对于需要将商业报告纳入解决方案的开发人员，课程将帮助您在几分钟内开始构建第一份报告。此外，适合需要定期发送报告的同事、以及在数据工作中需要快速产生分析和洞察的团队成员。 材料与资源：您只需一台个人电脑和良好的互联网连接，以下载本课程所需的软件。
Class OverviewLearn how to design and deploy business reports for personal use or for work. In this course, you will get started with the basics of SQL Server Reporting Services - everything from installation to creating your first report. I also include some basic SQL Server installation and SQL Management Studio to provide a complete beginner's guide to SSRS.What You Will Learninstalling SQL Server 2019Installing SQL Server Management StudioDownload And Setup Adventure Works DatabaseDownload And Install SQL Server Reporting Services (SSRS)Introduction To The SSRS PortalDownload And Install Report BuilderCreating A Datasource & Shared DatasourceCreating Your First DatasetCreating Your First SSRS ReportDesigning The Report - Header & FooterCreating And Formatting A Report Table ViewIntroduction To ExpressionsIntroduction To ParametersWorking With Dropdown ParametersCreating Linked Or Dependent/Cascading Dropdown ParametersAdding Images To Your SSRS ReportGrouping, Serials & Totals In SSRSAdding Graphs/Charts To Your ReportPublishing Your Report To The SSRS ServerSubscribing To A Report For Automatic Delivery - To A File FolderSubscribing To A Report For Automatic Delivery - To E-Mail RecipientsWho Should Take This ClassIn this day and age, automation of routine tasks is key. It is possible to create a business report, deploy it and automatically schedule it to be delivered to your intended recipients with a one-time setup. If you are a beginner who is interested in becoming a data analyst or database/backend developer then this course if for you.If you are already a developer who needs to now include business reporting as part of your solution, then this class will get you started and building your first report in a matter of minutes.Who This Course Is ForThis is course is great for you if you want to get started with Data Analytics as some of the concepts taught here will be useful in more advanced data analytics courses.If you work with colleagues that require reports sent to them on a regular schedule (e.g. 9am each morning) You can automate this task and have your reports delivered without a need to think about it. This course is also for you if you work with data and are expected to quickly produce analysis and insight into different datasets as part of a larger team or on a project.Materials/ResourcesAll you need to get started is your personal computer and good internet connectivity to download the required software for this course.
