Shop our Labor Day sale and take 40% off all regularly priced courses and bundles sitewide.  Just add to cart to see your discounts.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Microsoft SQL Server 2019 – Data Analysis

This data analysis course, Microsoft SQL Server 2019 – Introduction to Data Analysis will provide a comprehensive overview of the job duties and functions that data analysts need to be familiar with, such as techniques and approaches for creating models, displaying visualizations, and evaluating information through Power BI. Besides that, you’ll also get to learn how to access various types of data sources – both relational and non-relational – in order to process them properly.

Included In This Course

Included In This Course

Total Hours
13  Training Hours
Microsoft SQL Server 2019 – Data Analysis
77 On-demand Videos
Closed Caption

Closed Captions

Course Topics
17  Topics
Prep Questions
75 Prep Questions
Microsoft SQL Server 2019 – Data Analysis

Certificate of Completion

Course Description

Empower your skills. Elevate your business intelligence. Learn data analytics

This data analysis course will discuss the responsibilities and functions of a data analyst. In this data analysis course, you will learn the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI, Microsoft Analysis Services and other data analysis tools. Our data analysis course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

This data analysis course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. Power BI is a member of the Power Platform. Power Apps is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your app users to derive business insights and take actions from right within their Power BI reports and dashboards.

Frequently Asked Questions About Microsoft SQL Server 2019 – Introduction to Data Analysis Course

What will I learn in the Microsoft SQL Server 2019 – Introduction to Data Analysis course?

This course provides a comprehensive overview of the job duties and functions that data analysts need to be familiar with. You’ll learn techniques for creating models, displaying visualizations, and evaluating information using Power BI. You’ll also get to learn how to access and process data from various types of data sources, both relational and non-relational. Besides, the course covers how to implement security standards and policies across the Power BI spectrum, including datasets and groups​.

How is the course content delivered?

The course comprises 13 hours of online training, 77 videos, 17 topics, and 75 practice questions. You’ll learn through on-demand content, meaning you can go at your own pace.

Can I start learning right away?

Absolutely! The course offers instant access, meaning you can get started with your learning journey immediately after signing up.

What’s the outcome of completing this course?

On completing the course, you should become familiar with Power BI and other data analysis tools. Plus, you’ll gain hands-on experience by working on projects. As a bonus, this course also preps you for the Microsoft Certified: Data Analyst certification, which can be obtained by passing two exams: DA-100 and DA-101. This certification can bolster your professional profile in the data analysis field.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft SQL Server 2019 - Introduction to Data Analysis Course Content

Module 1 - Query Tools

  •    1.1 Course Introduction

  •    1.2 Intro to Management Studio

  •    1.3 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Introducing T-SQL

  •    2.2 Understanding Sets

  •    2.3 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Writing Simple SELECT Statements

  •    3.2 Eliminate Duplicates with DISTINCT

  •    3.3 Using Column and Table Aliases

  •    3.4 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Understanding Joins

  •    4.2 Querying with Inner Joins

  •    4.3 Querying with Outer Joins

  •    4.4 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Sorting Data

  •    5.2 Filtering Data with Predicates

  •    5.3 Filtering with the TOP and OFFSET-FETCH

  •    5.4 Working with Unknown Values

Module 6 - Introduction to Business Intelligence and Data Modeling

  •    6.1 Introduction to Business Intelligence

  •    6.2 The Microsoft Business Intelligence Platform

  •    6.3 Exploring a Data Warehouse

  •    6.4 Exploring a Data Model

Module 7 - Prepare Data

  •    7.1 Introduction to Power BI

  •    7.2 Get data from various data sources

  •    7.3 Preview source data

Module 8 - Clean, Transform, and Load Data

  •    8.1 Data Transformation Intro

  •    8.2 Transformation Example 1

  •    8.3 Transformation Example 2

  •    8.4 Transformation Example 3

  •    8.5 Transformation Example 4

  •    8.6 Transformation Example 5

  •    8.7 Transformation Example 6

Module 9 - Design a Data Model

  •    9.1 Introduction to Data Modeling

  •    9.2 Model Relationships

  •    9.3 Table Configuration

  •    9.4 Model interface

  •    9.5 Quick Measures

  •    9.6 Many-to-many relationships

  •    9.7 Row-level security

Module 10 - Create Model Calculations using DAX

  •    10.1 DAX context

  •    10.2 Calculated Tables

  •    10.3 Calculated Columns

  •    10.4 Managing Date Tables

  •    10.5 Measures

  •    10.6 Filter Manipulation

  •    10.7 Time Intelligence

Module 11 - Create Reports

  •    11.1 Basic Report Creation

  •    11.2 Example Page 1

  •    11.3 Example Page 2

  •    11.4 Example Page 3

  •    11.5 Report Publishing

  •    11.6 Enhancing Reports

  •    11.7 Drill-Through Pages

  •    11.8 Conditional Formatting

  •    11.9 Buttons and Bookmarks

Module 12 - Create Dashboards

  •    12.1 Dashboard Basics

  •    12.2 Real Time Dashboards

  •    12.3 Enhanced Dashboards

Module 13 - Create Paginated Reports

  •    13.1 Introduction to Power BI Report Builder

  •    13.2 Report Layouts

  •    13.3 Report Data

  •    13.4 Report Tables

Module 14 - Perform Advanced Analytics

  •    14.1 Introduction to Advanced Analytics

  •    14.2 Scatter Chart

  •    14.3 Forecast

  •    14.4 Decomposition Tree

  •    14.5 Key Influencers

Module 15 - Create and Manage Workspaces

  •    15.1 Introduction to Workspaces

  •    15.2 Working with Workspaces and the Portal

Module 16 - Create Power App Visuals

  •    16.1 Introduction to Power Apps Visual

  •    16.2 Creating the App

  •    16.3 Basic Power Apps Concepts

  •    16.4 Refreshing the Report

Module 17 - Analysis Services and Power BI

  •    17.1 Introduction to Analysis Services

  •    17.2 Connecting with Multidimensional Models

  •    17.3 Premium Workspaces and Analysis Services

  •    17.4 Course Wrap Up

Add a review
Microsoft SQL Server 2019 - Data Analysis Microsoft SQL Server 2019 - Data Analysis
* Rating is required
Your review
* Review is required
* Name is required
Based on 49 reviews
5 star
4 star
3 star
2 star
1 star
1-5 of 49 reviews
  1. I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.

  2. The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  3. The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!

  4. This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.

Your Training Instructor

James Ring-Howell

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.

Microsoft SQL Server 2019 - Data Analysis



Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft SQL Server 2019 – Data Analysis

Microsoft SQL - Data Analysis
Microsoft SQL Server 2019 – Data Analysis
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses


Take the Microsoft 70-480: Programming in HTML5, JavaScript and CSS3 course and become a skilled web developer. Enroll now!

In this Microsoft 70-480 course you will learn how to implement and manipulate document structures and objects, implement program flow, access and secure data, and use CSS3 in applications. This course will teach you HTML5, CSS3, Javascript and jQuery.


Get certified in Microsoft 70-463: Implementing a Data Warehouse with SQL Server with ITU Online. Get expert-led training and start your career today!

In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.


Get certified as a Microsoft MCSA: SQL Server Solutions Associate with our comprehensive training program. Implement SQL Server solutions with ease.

Showcase your indispensable abilities and ingenious insights in creating and managing the upcoming generation of mission-critical environments with our Microsoft MCSA: SQL Server Solutions Associate online course.