Microsoft SQL Server 2019 – Data Analysis » Optima : Elevating Digital Learning

Master Data Analysis with Microsoft SQL Server 2019

Elevate your data analysis skills through our course, “Microsoft SQL Server 2019 – Introduction to Data Analysis.” This comprehensive program offers a holistic understanding of essential data analyst responsibilities, encompassing model creation, visualization techniques, and information assessment using Power BI. Moreover, delve into the art of accessing diverse data sources – both relational and non-relational – and mastering effective processing techniques. Strengthen your data prowess today!

Enhance Your Skill Set. Elevate Business Intelligence. Embark on Data Analytics.

Uncover the world of data analysis through this comprehensive course. Dive into the roles and functions that define a data analyst’s realm. Learn a diverse array of methods and best practices aligning with both business and technical requisites. Develop expertise in modeling, visualization, and data analysis using tools like Power BI and Microsoft Analysis Services.

This course is your gateway to mastering data analytics. Navigate through the intricacies of accessing and processing data from an array of sources, be it relational or non-relational. Safeguard your insights with robust security measures across the Power BI spectrum, including datasets and groups. Gain the prowess to effectively manage and deploy reports and dashboards for seamless sharing and content distribution.

Unveil the realm of paginated reports within the Power BI service, seamlessly integrating them into your workspace. Power BI, a member of the Power Platform, offers a holistic solution. Discover how Power Apps, another vital component, empowers everyone to build and utilize apps that seamlessly connect with business data.

Experience the Power Apps visual, enabling contextual data transmission to canvas apps. Witness real-time updates within your report as changes occur. Empower app users to glean business insights and enact actions directly from their Power BI reports and dashboards. This course transcends boundaries, equipping you with the skills needed for contemporary data analysis challenges.

Curriculum

17 Sections
17 Lessons
3 Weeks

Expand all sectionsCollapse all sections

Module 1 - Query Tools
1
- 1.1
  1.1 Course Introduction
Module 2 - Introduction to T-SQL Querying
1
- 2.1
  2.1 Introducing T-SQL
Module 3 - Basic SELECT Queries
1
- 3.1
  3.1 Writing Simple SELECT Statements
Module 4 - Querying Multiple Tables
1
- 4.1
  4.1 Understanding Joins
Module 5 - Sorting and Filtering Data
1
- 5.1
  5.1 Sorting Data
Module 6 - Introduction to Business Intelligence and Data Modeling
1
- 6.1
  6.1 Introduction to Business Intelligence
Module 7 - Prepare Data
1
- 7.1
  7.1 Introduction to Power BI
Module 8 - Clean, Transform, and Load Data
1
- 8.1
  8.1 Data Transformation Intro
Module 9 - Design a Data Model
1
- 9.1
  9.1 Introduction to Data Modeling
Module 10 - Create Model Calculations using DAX
1
- 10.1
  10.1 DAX context
Module 11 - Create Reports
1
- 11.1
  11.1 Basic Report Creation
Module 12 - Create Dashboards
1
- 12.1
  12.1 Dashboard Basics
Module 13 - Create Paginated Reports
1
- 13.1
  13.1 Introduction to Power BI Report Builder
Module 14 - Perform Advanced Analytics
1
- 14.1
  14.1 Introduction to Advanced Analytics
Module 15 - Create and Manage Workspaces
1
- 15.1
  15.1 Introduction to Workspaces
Module 16 - Create Power App Visuals
1
- 16.1
  16.1 Introduction to Power Apps Visual
Module 17 - Analysis Services and Power BI
1
- 17.1
  17.1 Introduction to Analysis Services

optimaAdmin

Agile Project Expert

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.

Academies

Categories