|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/exploring-ssrs-creating-great-reports/
课程评论:没有评论
课程名称:学习SSRS SQL报告与商业智能基础 课程概述: 本课程是针对Microsoft SQL Server Reporting Services (SSRS)的快速而深入的学习项目,旨在帮助学员迅速建立自己的优秀报告。课程内容从基本知识开始,逐步涵盖到高级主题,包括:表格、矩阵、提示、参数、图表、穿透报告、子报告、仪表和标准偏差等。尽管课程进展较快以保持学员的兴趣,但并不会忽略重要概念或细节。通过三小时的视频教学,课程将展示完成实际工作所需的全部内容。 本课程使用的数据库围绕一个虚构的消费电子商店展开,数据库设计简单明了,不含多余的复杂内容。您将惊讶于能够创建的各种类型报告。课程为实践导向,包含所有构建数据库所需的SQL代码,学员不必是SQL专家,视频会逐行讲解课程中使用的所有查询和存储过程。每节课的适当部分将附有SQL代码,您可以在家中跟随学习。 课程分为两个主要部分: 1. 数据库设置 - 解释数据库的架构、数据、存储过程及其他一般后端内容。 2. SSRS - 课程的主要部分,涵盖制作优秀报告所需的重要操作,这不仅涉及功能性报告的制作,也包括实用性报告的实现。虽然具备一些SQL知识会有所帮助,但并不是必须的,因为所有SQL代码都会在讲解中详细说明。 如果您希望提升自己的SSRS技能,提供超出最终用户期望的报告,那么本课程非常适合您。
This is a fast-paced and in-depth course for Microsoft SQL Server Reporting Services (SSRS) designed to get you building your own great reports in no time. This course will take you from the bare minimum basics all the way through advanced topics including: Tables Matrices Prompts Parameters Charts Drill Throughs Sub Reports Gauges Standard Deviation This course moves quickly to keep you interested but that doesn't mean skipping over important concepts or skimming details. With three hours of videos this course shows you everything you need to get the job done in the real world. The database we will be using focuses on a fictional consumer electronics store. This database is simple and easy to understand without a lot of extra fluff. But you'll be surprised at how many different types of reports you will be able to create. This course is hands-on. It includes all the SQL code you need to build your own copy of the database used in the lectures. It's OK if you aren't a SQL pro, the videos go line-by-line through all the queries and stored procedures used in the course. With SQL code attached in the appropriate lectures, you'll be able to follow along at home. The course is broken out into 2 main sections: Database Setup - Explains the schema of the database, the data, the Stored Procedures, and other general back-end items. SSRS - The main focus of the course, this section covers how to do all the important things to make great reports. This includes not only making functional reports, but also useful reports. A small amount of SQL knowledge would be beneficial, but not strictly required for the course, as all SQL code is explained in the lectures. You should take this course if you are looking to improve your SSRS skill set and deliver reports that exceed your end-user's expectations.