Microsoft SQL Server 2019 – Introduction to Data Analysis Course



This data analysis course, Microsoft SQL Server 2019: Introduction to Data Analysis, will give you a thorough overview of the job responsibilities and functions that data analysts need to be familiar with, including methods and techniques for building models, displaying visualizations, and analyzing data through Power BI. In addition, you’ll get to learn how to access various types of data sources, both relational and non-relational, in order to process them.

  • 13  Training Hours
  • 77 Videos
  • 17  Topics
  • 75 Practice Questions
SKU: 601956326628 Category:

Enhance your abilities. Improve your business intelligence. Study data analytics.

Get ready to supercharge your data analysis skills with our dynamic and empowering course! In this exciting program, you will uncover the incredible responsibilities and functions of a data analyst, equipping you with the knowledge and tools to excel in this rapidly evolving field.

Throughout the course, you will dive deep into the world of data analysis, discovering a wide array of methods and best practices aligned with both business and technical requirements. With a special emphasis on cutting-edge tools like Power BI, Microsoft Analysis Services, and other powerful data analysis tools, you’ll gain the expertise to model, visualize, and analyze data like a true data pro.

We understand that data comes in all shapes and sizes, which is why our course goes beyond traditional relational databases and explores non-relational data sources as well. You’ll learn how to access and process data from various sources, harnessing their potential to uncover invaluable insights.

Security is a top priority in the data-driven era, and we’ve got you covered. Our course will guide you through implementing robust security standards and policies across the entire Power BI spectrum, including datasets and groups. You’ll gain the confidence to handle sensitive data with utmost care and protect your organization’s information assets effectively.

But that’s not all! We go the extra mile by delving into the world of report management and deployment. You’ll master the art of crafting visually stunning reports and dashboards that captivate and engage your audience. Plus, with our comprehensive guide, you’ll discover the best ways to share and distribute your reports and dashboards, ensuring your insights reach the right people at the right time.

As an added bonus, we’ll introduce you to the captivating realm of Power Apps. With this powerful component of the Power Platform, you’ll be able to build and utilize apps that seamlessly connect to your business data. Picture this: using the Power Apps visual, you can pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. Imagine the power of deriving business insights and taking immediate action, all within your Power BI reports and dashboards. It’s a game-changer!

And there’s even more good news! Our course offers a comprehensive exam at the end, where you can showcase your newfound skills and earn a valuable certification. Stand out in the job market and demonstrate your ability to leverage data effectively for informed decision-making. Your certification will be a testament to your dedication and expertise in the field of data analysis.

Don’t miss out on this extraordinary opportunity to transform your data analysis capabilities and propel your career to new heights. Enroll today and unlock a world of possibilities!

Course Outline:

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

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?

The “Microsoft SQL Server 2019 – Introduction to Data Analysis” course provides a comprehensive overview of the essential job duties and functions that data analysts need to be familiar with. Throughout the course, you will learn various techniques for creating data models, generating visualizations, and evaluating information using Power BI. Additionally, you will gain insights into accessing and processing data from different types of data sources, including both relational and non-relational databases. The course also covers the implementation of security standards and policies across the Power BI spectrum, encompassing datasets and groups.

How is the course content delivered?

The course content is delivered through an online platform and consists of 13 hours of training material. It includes 77 video lessons covering 17 different topics, along with 75 practice questions to reinforce your understanding. The content is designed to be consumed on demand, allowing you to learn at your own pace and convenience.

Can I start learning right away?

Yes, you can start learning immediately after signing up for the course. The course offers instant access to the learning materials, enabling you to begin your educational journey right away without any delay.

What’s the outcome of completing this course?

Upon completing the “Microsoft SQL Server 2019 – Introduction to Data Analysis” course, you will become proficient in using Power BI and other data analysis tools. The course not only provides theoretical knowledge but also offers practical experience through hands-on projects. As an added benefit, this course prepares you for the Microsoft Certified: Data Analyst certification. By passing two exams, namely DA-100 and DA-101, you can obtain this certification, which enhances your professional profile in the field of data analysis.

Your Training Instructor

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.