Udemy

Microsoft Business Intelligence Tools: SSIS,SSRS,SSAS,BI

立即報名
  • 2,183 名學生
  • 更新於 12/2022
4.0
(50 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
7 小時 8 分鐘
教學語言
英語
授課導師
Bluelime Learning Solutions
評分
4.0
(50 個評分)
6次瀏覽

課程簡介

Microsoft  Business Intelligence Tools: SSIS,SSRS,SSAS,BI

Make Data-Driven Decisions using Microsoft Business Intelligence Tools: SQL Server | SSIS | SSRS | SSAS | Power BI

Business intelligence (BI) combines business analytics, data mining, data visualisation, data tools and infrastructure, and best practices to help organisations to make more data-driven decisions. In practice, you know you’ve got modern business intelligence when you have a comprehensive view of your organisation’s data and use that data to drive change, eliminate inefficiencies and quickly adapt to market or supply changes. Business intelligence comprises the strategies and technologies used by enterprises for the data analysis and management of business information.


Microsoft BI tools provide a solution for handling the volume of important business intelligence information continuously generated by modern companies. With the right tools, you can process huge amounts of data in mere seconds, and it is this part of the process that counts. Any business can collect information, but it takes skill and careful management using business intelligence tools to make it valuable. This is the essence of “business intelligence”: the ability to take vast quantities of market data and extract trends and patterns.



The Microsoft BI Suite is the software giant’s suite of tools designed for easy data processing. That’s putting it a bit simply, but these programs do have a simple objective. The system aims to help businesses turn all of that messy, complex information into extractable insights. It is one of the most popular BI solutions on the market right now.


The full range of tools enables businesses to direct data through IT systems, identify and isolate data, and create expansive reports on the current status of different departments. They include (SQL Server Integration Services), SSAS (SQL Server Analytical Services) and SSRS (SQL Server Reporting Services) and Power BI


With these tools, any mass of data can be turned into a digestible report, dashboard, graph, spreadsheet or another format. You just need to input your parameters and let the system know what you need. The Microsoft business intelligence platform works by moving data from multifarious, unmanageable sources to a centralized architecture where it can be reconfigured.


課程章節

  • 8 個章節
  • 93 堂課
  • 第 1 章 SQL Server Setup
  • 第 2 章 Visual Studio Setup
  • 第 3 章 Implementing ETL with SSIS
  • 第 4 章 SQL Server Reporting Services - SSRS
  • 第 5 章 SQL Server Analysis Services - SSAS
  • 第 6 章 Power BI Setup
  • 第 7 章 Overview of Power BI
  • 第 8 章 Data Analysis & Visualization with Power BI

課程內容

  • Connect to multiple data sources, Clean, Transform and import data, Create data relationships, Implementing ETL with SSIS, Create and execute SSIS Package, Configure SSRS Report Server, Create and publish reports with SSRS, Create tabular model with SSAS, Create key performance indicators -KPI's, Create Perspectives, Create hierarchies, Analyze in Excel, Deploy and Analyze Model, Create data visualizations and dashboards, Publish reports to the Power BI Service


評價

  • A
    Ashish Yadav
    1.0

    I was expecting macOS compatibility.

  • P
    Patrick Brady
    4.5

    Very clear and thorough. Only improvement would be to include common pitfalls.

  • C
    Casper Veldhuijzen
    3.0

    Some if not most of the applications used in the examples are outdated. It requires some messing around with some of the configurations making some steps really unclear.

  • A
    Akani Bvuma
    3.5

    Clear voice and instructions

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意