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

Data Analysis & Reporting – ( MS SQL, ETL,SSIS, SSRS, SSAS ), available at $39.99, has an average rating of 3, with 100 lectures, based on 4 reviews, and has 28 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner SQL Developers or Beginner Data Analyst or Beginner Data Scientist or Beginner Data Engineers It is particularly useful for Beginner SQL Developers or Beginner Data Analyst or Beginner Data Scientist or Beginner Data Engineers.

Enroll now: Data Analysis & Reporting – ( MS SQL, ETL,SSIS, SSRS, SSAS )

Summary

Title: Data Analysis & Reporting – ( MS SQL, ETL,SSIS, SSRS, SSAS )

Price: $39.99

Average Rating: 3

Number of Lectures: 100

Number of Published Lectures: 100

Number of Curriculum Items: 100

Number of Published Curriculum Objects: 100

Original Price: $79.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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 .

Course Curriculum

Chapter 1: Microsoft SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: What is SQL

Lecture 4: SQL Server Editions

Lecture 5: Download SQL Server

Lecture 6: Install SQL Server

Lecture 7: Install SSMS

Lecture 8: Connect SSMS to SQL Server

Lecture 9: Install Sample Database

Lecture 10: Install sample DW Database

Lecture 11: Overview of Data Analysis & Reporting – ( MS SQL, ETL,SSIS, SSRS, SSAS )

Chapter 2: Installing SQL Server Data Tools (SSDT)

Lecture 1: What is Visual Studio

Lecture 2: Install Visual Studio

Lecture 3: Install SQL Server Data Tools

Lecture 4: Install SSDT Business Intelligence Templates

Chapter 3: Data Analysis with Microsoft SQL

Lecture 1: Filtering data with equality filters

Lecture 2: Filtering data with comparisons filters

Lecture 3: Filtering data with logical filters

Lecture 4: Filtering data with String comparisons

Lecture 5: Filtering data with NULL comparisons

Lecture 6: Sorting data

Lecture 7: Sorting data in ascending order

Lecture 8: Sorting data in descending order

Lecture 9: Sorting data by multiple columns

Lecture 10: Using Analytic funtions

Lecture 11: Syntax for analytic functions

Lecture 12: Analysing data with LEAD Function

Lecture 13: Analysing data with LAG Function

Lecture 14: Analysing data with LAST_VALUE Function

Lecture 15: Analysing data with FIRST_VALUE Function

Lecture 16: Analysing data with PERCENT_RANK Function

Lecture 17: Analysing data with PERCENTILE_DISC Function

Lecture 18: Analysing data with PERCENTILE_CONT Function

Lecture 19: Analysing data with Rank Functions

Lecture 20: Analysing data with NTILE Function

Lecture 21: Analysing data with DENSE RANK FunctionS

Lecture 22: Analysing data with ROW_NUMBER Function

Lecture 23: Analysing data with multiple RANK Functions

Lecture 24: Analysing data with table joins

Lecture 25: Analysing data with INNER Join

Lecture 26: Analysing data with Full OUTER Join

Lecture 27: Analysing data with LEFT OUTER Join

Lecture 28: Analysing data with RIGHT OUTER JOIN

Lecture 29: Analysing data with Aggregate functions

Lecture 30: Analysing data with AVG Aggregate function

Lecture 31: Analysing data with COUNT Aggregate function

Lecture 32: Analysing data with SUM Aggregate function

Lecture 33: Analysing data with MIN Aggregate function

Lecture 34: Analysing data with MAX Aggregate function

Lecture 35: Analysing data with multiple Aggregate function

Lecture 36: Grouping data

Lecture 37: Analysing data with VAR Aggregate function

Lecture 38: Analysing data with VARP Aggregating Functions

Chapter 4: Extract ,Transform & Load Data with ETL & SSIS

Lecture 1: What is SSIS

Lecture 2: What is ETL

Lecture 3: Create a new SSIS Project

Lecture 4: SSIS Designer

Lecture 5: Add and configure Flat file connection manager

Lecture 6: Remapping column data types

Lecture 7: Add & configure OLE DB Connection manager

Lecture 8: Add a data flow task to package

Lecture 9: Add & configure flat file source

Lecture 10: Add & configure lookup transformations

Lecture 11: Add & configure lookup for datekey transformation

Lecture 12: Add & configure OLE DB destination

Lecture 13: Run & test SSIS Package

Chapter 5: Creating reports with SQL Server Reporting Services (SSRS)

Lecture 1: What is SSRS

Lecture 2: Create a new SSRS Project

Lecture 3: Create a report definition file

Lecture 4: Configure a data source for the report

Lecture 5: Define a dataset for the report

Lecture 6: Format the report

Lecture 7: Grouping data in report

Lecture 8: Adding totals to report

Lecture 9: Previewing report

Lecture 10: Exporting report

Chapter 6: Data Analysis with SQL Server Analysis Services ( SSAS)

Lecture 1: What is SSAS

Lecture 2: Installing SSAS

Lecture 3: Connecting to SSAS

Lecture 4: Create a tabular model project

Lecture 5: Explore tabular model authoring

Lecture 6: Create a connection to data source

Lecture 7: Transform and import data

Lecture 8: Mark as a data table

Lecture 9: Create table relationships

Lecture 10: Create calculated columns: part 1

Lecture 11: Create calculated columns: part 2

Lecture 12: Creating measures : part 1

Lecture 13: Creating measures : part 2

Lecture 14: Creating measures : part 3

Lecture 15: Create key performance indicators

Lecture 16: Create perspectives

Lecture 17: Create hierarchies : part 1

Lecture 18: Create hierarchies : part 2

Instructors

Tech Academy
Real Skills For The Real World

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 0 votes
5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu