|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analyst-power-bi-ssrs-ssis-ssas-sql-server/
课程评论：没有评论
课程名称：数据分析师：Power BI SSRS SSIS SSAS SQL Server 课程概述：本课程介绍了Power BI及其相关工具，如SQL Server Reporting Services（SSRS）、SQL Server Integration Services（SSIS）和SQL Server Analysis Services（SSAS），为学员提供了全面的数据分析和可视化技能。Power BI是一个软件服务、应用程序和连接器的集合，旨在将不同来源的数据转化为连贯的、具有视觉冲击力和互动性的见解。无论数据来自Excel电子表格还是云端与本地的混合数据仓库，Power BI都能帮助用户轻松连接数据源，发现重要信息并与他人分享。 Power BI的核心组成部分包括： - Power BI Desktop：适用于Windows的桌面应用程序。 - Power BI服务：在线的SaaS（软件即服务）平台。 - Power BI移动应用：针对Windows、iOS和Android设备的应用程序。 此外，课程讲解了SQL Server Reporting Services，它是一款报表软件，可以生成格式化的报表，并在服务器上托管以供用户根据参数随时执行。SQL Server Integration Services是用于构建企业级数据集成和转换解决方案的平台，支持从多种来源提取和转化数据，并将其加载到一个或多个目的地中。 SQL Server Analysis Services是一个多维OLAP服务器和分析引擎，能够处理大量数据，支持多个维度的分析。这些服务为商业智能（BI）、数据分析和报告应用提供了企业级的语义数据模型能力。 最后，SQL Server作为关系数据库管理系统，设计用于高效管理数据库，存储和检索其他应用程序请求的数据。通过使用SQL Server，开发者可以更轻松、更快速且更可靠地构建数据库应用程序。 本课程适合希望提升数据分析和可视化能力的专业人士，无论是数据初学者还是有一定基础的学员均可参与学习。
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.Power BI consists of several elements that all work together, starting with these three basics:A Windows desktop application called Power BI Desktop.An online SaaS (Software as a Service) service called the Power BI service.Power BI mobile apps for Windows, iOS, and Android devices.SQL Server Reporting Services (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services suite.SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.Integration Services includes a rich set of built-in tasks and transformations, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages.You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.SQL Server Analysis services (SSAS) is a multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data. It is part of Microsoft SQL Server and helps perform analysis using various dimensions. It has 2 variants Multidimensional and Tabular. The SSAS full form is SQL Server Analysis Services.Analysis Services is an analytical data engine (VertiPaq) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms.SQL Server is a software application designed to manage databases, it stores and retrieves data as requested by other applications. When software developers are writing new business applications that store information in a database they will very often use SQL Server's functionality to look after the databases rather than reinventing the wheel writing their own code to do the same thing. This makes writing database applications easier and quicker (and therefore cheaper) as well as making them more reliable, scalable and secure.SQL Server is known as a "Relational Database" Management System. Data is stored in tables in a similar way to rows and columns in a spreadsheet. If you imagine a database containing accounting information you may have a table for each invoice with values, VAT, Totals, invoice number etc. Each invoice relates to a customer but instead of recording the customer's details (name, address, discounts etc.) with each invoice you just record it once in a separate table called Customers. The Customers table and Invoices table are linked or "related".The "Management System" part of SQL Server makes sure the databases are stored efficiently and the data can be searched or retrieved as quickly as possible. It also makes sure multiple people connecting to the same data are managed properly so you don't get problems if two people change the same information at the same time.
