Udemy

Complete Business Intelligence with SSIS, SSAS and SSRS

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
2 小時 52 分鐘
教學語言
英語
授課導師
Ikram Haq
評分
4.2
(371 個評分)
4次瀏覽

課程簡介

Complete Business Intelligence with SSIS, SSAS and SSRS

Master Microsoft BI by solving Real-Life Problems. Learn ETL, Integration, Analytics, Reporting and Visualization!

*** This course includes LIFETIME access, More content is being developed,quality of lectures are a 100% satisfaction guarantee ***

Reviews from some of our students

"I had little knowledge about Business Intelligence. But after attending this course and practising the examples. I can now do BI solutions on my own."

-Edwin Molapo


"Great course. I am in College currently getting my BA in Data Analytics and this course has help solidify my learning and also helped me with projects we had in our classes. I would highly recommend for and Business Intelligence seekers "

-Jared Rentz


"Easy to follow and very understandable"

-Dilli Sharma



As data volumes are exploding, more data has been created in the past two years than in the entire previous history of the human race. With an estimate of 4.1 zettabyets of data available today, the numbers just keeps increasing every second. Organizations today estimate that only a fraction of recorded data can be analyzed, and IT professionals who can work with data by Data Integration, Data Analyzation, Data Visualization etc. in short a 'Data Geek' are becoming increasingly popular.

In Simpler terms, there is enormous amount of data and not enough professionals to manage it.This course aims to close that gap with SQL Server Management Studio and SQL Server Data Tools for Business Intelligence (BI).

We will Learn from the basics of creating a Microsoft Business Intelligence (MS BI)ecosystem, Sql server Integrating services(SSIS), Sql Server Analysis Services (SSAS), Sql Server Reporting Services (SSRS) and putting all of them together to learn the Complete Microsoft Business Intelligence (MS BI)

Learn and Master Microsoft Business Intelligence(MS BI) in this Comprehensive course.

SSIS(Sql Server Integrating Services)

Extracting Data from Source.
Transforming the Data in a staging area
Loading the data onto a destination
Managing different types of sources and destinations
Implementing aggregates and transformations
Managing data flow and control flow tasks
SSAS(Sql Server Analysis Services)

Configuring analysis services
Creating a cube
Managing data in the data source view
Designing and deploying Cube dimensions and meassures
SSRS(Sql Server Reporting Services)

Creating reports and visualizations
With 6 years of experience in the BI, Data analytics and Big Data, be sure to get rich content to help you succeed. Although it is still in the beginning phase but more in depth and quality lectures are being added regularly.


課程章節

  • 5 個章節
  • 38 堂課
  • 第 1 章 Setting up your Microsoft BI environment
  • 第 2 章 SSIS Control Flow Tasks
  • 第 3 章 SSIS Data Flow Tasks
  • 第 4 章 SSAS : Designing Cubes for Analysis
  • 第 5 章 SSRS: Understanding report creation, management and deployment

課程內容

  • Perform file system tasks, Perform FTP tasks, Create dynamic properties with variables, Perform ETL jobs (Extraction, Transformation and Loading), Perform Aggregates, Sorting and Conditional Splitting of data, Create analytic cube in SSAS, Design the Cube Dimensions and Measures

評價

  • J
    Jürgen Bugmann
    4.0

    It was great; however, the second half of the SSRS section is missing, including the use case example and the final output.

  • A
    Aaliya
    3.5

    The course provided a very good overview however it teaches using very old versions of the SQL server and the visual studio. Also downloading material created some issues.

  • K
    Kanu M Varu
    1.0

    SSRS part missing in session 38 many time discuss "see in next lecture" lack of support in Q&A session(Last response I see before 9 months)

  • B
    Baljinder Singh Ghuman
    4.5

    Very nice explanations and easy to understand. very good proffessor. I didnt have enough understanding about ETL but with course I have better understanding. still a lot to learn though. I was bit upset because i have some problem in the middle I texted proffessor and he never replied back and someone also had same problem 6 months ago and published problem but proffessor never replied, so this was very frustrating and I finally found solution on my own. These courses are amazing until you can tweak by yourself, dont expect feedback or help from proffessors because udemy dont take responsibility of that. i tried talking to them. Regards.

立即關注瀏覽更多

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

我已閱讀及同意