Apply Now

Data Analytics Certificate

About this course

Too busy at work to miss 3 days out of the office to take this class? This course will run for 70 hours.

Instructor-Led Virtual Live Class

Students are expected to take two courses during this data Analytics training. The course are:

  • Developing SQL Databases, Business Intelligence.
  • Analyzing Data with Power BI

Developing SQL Databases, Business Intelligence

COURSE OUTLINE

1. INTRODUCTION TO MICROSOFT SQL SERVER 2016
  • Learn the Basics of SQL Server Architecture
  • Get Exposed to the Different SQL Server Editions and Versions
  • Become Familiar with SQL Server Management Studio
  • Lab: Working with SQL Server 2016 Tools
  • Learn the Components of T-SQL
  • Understand Sets and Predicate Logic
  • Master the Logical Order of Operations in SELECT statements
  • Lab: Introduction to Transact-SQL Querying
  • Write Simple SELECT Statements and CASE Expressions
  • Eliminate Duplicates With DISTINCT
  • Practice Using Column and Table Aliases
  • Lab: Writing Basic SELECT Statements
  • Understand Joins
  • Query with Inner Joins, Outer Joins, Cross Joins and Self Joins
  • Lab: Querying Multiple Tables
  • Learn How to Sort Data
  • Filter Data with Predicates
  • Work With Unknown Values
  • Lab: Sorting and Filtering Data
  • Learn About SQL Server 2016 Data Types
  • Work With Character Data and Date and Time Data
  • Lab: Working with SQL Server 2016 Data Types
  • Insert Data
  • Modify and Delete Data
  • Lab: Using DML to Modify Data
  • Write Queries with Built-In Functions
  • Practice Conversion Functions and Logical Functions
  • Practice Using Functions to Work with NULL
  • Lab: Using Built-In Functions
  • Use Aggregate Functions and the GROUP BY Clause
  • Filter Groups with HAVING
  • Lab: Grouping and Aggregating Data
  • Write Self-Contained and Correlated Subqueries
  • Execute the EXISTS Predicate with Subqueries
  • Lab: Using Subqueries
  • Navigate Views and Inline Table-Valued Functions
  • Manipulate Derived Tables and Common Table Expressions
  • Lab: Using Table Expressions
  • Complete Queries with the UNION Operator
  • Use EXCEPT, INTERSECT and APPLY
  • Lab: Using Set Operators
  • Create Windows with OVER
  • Explore Window Functions
  • Lab: Using Windows Ranking, Offset, and Aggregate Functions
  • Write Queries with PIVOT and UNPIVOT
  • Work with Grouping Sets
  • Lab: Pivoting and Grouping Sets
  • Query Data with Stored Procedures
  • Pass Parameters to Stored procedures
  • Create Simple Stored Procedures
  • Navigate Dynamic SQL
  • Lab: Executing Stored Procedures

Analyzing Data with Power BI – 30 hour

Business Intelligence

  • Design/Create and deploy your report using SQL SERVER REPORT SERVICE
  • Import Data to SQL Server Using SQL SERVER INTEGRATION SERVICE
  • Create and deploy Tabular Project in SQL SERVER ANALYTIC SERVICE

 

Learning Objectives
After completing this course, students will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.

COURSE OUTLINE

1. INTRODUCTION TO SELF-SERVICE BI SOLUTIONS
  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI
  • Lab : Exploring an Enterprise BI solution
  • Power BI
  • The Power BI service
  • Lab : Creating a Power BI dashboard
  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service
  • Lab : Importing data into Power BI
  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Lab : Shaping and combining data
  • Relationships
  • DAX queries
  • Calculations and measures
  • Lab : Modelling Data
  • Creating Power BI reports
  • Managing a Power BI solution
  • Lab : Creating a Power BI report
  • Cloud data
  • Connecting to analysis services
  • Lab : Direct Connectivity
  • The developer API
  • Custom visuals
  • Lab : Using the developer API
  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded