Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analysis & Reporting - ( MS SQL, ETL,SSIS, SSRS, SSAS )
Rating: 3.8 out of 5(6 ratings)
32 students

Data Analysis & Reporting - ( MS SQL, ETL,SSIS, SSRS, SSAS )

Real World Data Analytic & Reporting Skills
Created byTech Academy
Last updated 3/2026
English

What you'll learn

  • Analyze & filter data with SQL
  • Analyze & sort data with SQL
  • Analyze data with SQL aggregate functionS
  • Analyze data using SQL Joins
  • Analyze with SQL analytic functions
  • Analyze data with SQL ranking functions
  • Extract, Transform ,Load Data with SSIS
  • Create & execute SSIS package
  • Create reports with SSRS
  • Create & analyze data models with SSAS

Course content

7 sections101 lectures8h 46m total length
  • Introduction0:20
  • What is SQL Server2:57
  • What is SQL3:38
  • SQL Server Editions4:45
  • Download SQL Server4:31
  • Install SQL Server9:43
  • Install SSMS5:48
  • Connect SSMS to SQL Server7:46
  • Install Sample Database6:28
  • Install sample DW Database5:49
  • Overview of Data Analysis & Reporting - ( MS SQL, ETL,SSIS, SSRS, SSAS )2:11

Requirements

  • Basic knowledge of database concepts

Description

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Data reporting is the process of collecting and submitting data which gives rise to accurate analyses of the facts on the ground; inaccurate data reporting can lead to vastly uninformed decision-making based on erroneous evidence .

SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading.

SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.

Microsoft SQL Server Analysis Services is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files .

Who this course is for:

  • Beginner SQL Developers
  • Beginner Data Analyst
  • Beginner Data Scientist
  • Beginner Data Engineers