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

The main purpose of the course is to give students a good understanding of data analysis with Power BI.

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

Developing SQL Databases & Analyzing Data with Power BI

The course includes SQL Development, creating visualizations, the Power BI Service, and the Power BI Mobile App.

Purpose Of the Course

The course will develop highly skilled Data Analytics, Business Analytical Developer, Power Bi Developer, Report Developer, and BI Analyst to fill the skill-gap in the job market

Entrance requirement Description

Acceptance into The Bright Technology Training is competitive and all students seeking admission must meet all applicable requirements. In order to be considered for admission, all applicants must:

  1. Complete and submit an admissions application along with the required non-refundable $25 fee;
  2. Provide proof of U.S. citizenship or Permanent Residence status.
  3. Provide proof of a U. S. high school diploma, GED, or the recognized equivalent.
  4. Interview with the admissions officer.
  5. Possess basic keyboard skills (A minimum of 35 WPM is required).
  6. Provide proof of at least one year of professional work experience in an office environment.
  7. Pass the Bright Technology Training computer-based Computer Literacy Test (CLT); and,
  8. Complete and sign an Enrollment Agreement.

20761 Querying Data with Transact SQL 40 Hours

Learning Objectives

 After finishing this course, students have the confidence to use Transact-SQL commands to interact with relational databases. Students will be able to:

  • Gain the skill required to build and implement databases across an enterprise
  • Learn about database file creation, data types, and tables
  • Discover how to plan, create, and optimize indexes
  • See the proper methods used for ensuring data integrity and data availability
  • Learn about implementing views, stored procedures, and functions
  • Execute managed code in SQL Server
  • Understand how to manage transactions and locks

COURSE OUTLINE

  • 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

  • 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

Set An
Appointment

Submit Online
Application