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

Upcoming Dates	Class Times	Class Format	Price
M,T,F January 9thst -February 28th, 2023	7:30 am – 10:00 am	Instructor-Led Virtual Live Class	$3,700

Email: info@brighttechnologylc.com or call to register 678435-9016

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 and Analyzing Data with Power BI

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

 

Purpose Of this 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 College Degree in any disciplines for students seeking admission into Data Analytic Program
7. Provide proof of at least one year of professional work experience in an office environment.
8. Pass the Bright Technology Training computer-based Computer Literacy Test (CLT); and,
9. Complete and sign an Enrollment Agreement.

 

Course Outline

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

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

2 – INTRODUCTION TO T-SQL QUERYING

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

3 – WRITING SELECT QUERIES

Write Simple SELECT Statements and CASE Expressions

Eliminate Duplicates With DISTINCT

Practice Using Column and Table Aliases

Lab: Writing Basic SELECT Statements

4 – QUERYING MULTIPLE TABLES

Understand Joins

Query with Inner Joins, Outer Joins, Cross Joins and Self Joins

Lab: Querying Multiple Tables

5 – SORTING AND FILTERING DATA

Learn How to Sort Data

Filter Data with Predicates

Work With Unknown Values

Lab: Sorting and Filtering Data

6 – WORKING WITH SQL SERVER 2016 DATA TYPES

Learn About SQL Server 2016 Data Types

Work With Character Data and Date and Time Data

Lab: Working with SQL Server 2016 Data Types

7 – USING DML TO MODIFY DATA

Insert Data

Modify and Delete Data

Lab: Using DML to Modify Data

8 – USING BUILT-IN FUNCTIONS

Write Queries with Built-In Functions

Practice Conversion Functions and Logical Functions

Practice Using Functions to Work with NULL

Lab: Using Built-In Functions

9 – GROUPING AND AGGREGATING DATA

Use Aggregate Functions and the GROUP BY Clause

Filter Groups with HAVING

Lab: Grouping and Aggregating Data

10 – USING SUBQUERIES

Write Self-Contained and Correlated Subqueries

Execute the EXISTS Predicate with Subqueries

Lab: Using Subqueries

11 – USING TABLE EXPRESSIONS

Navigate Views and Inline Table-Valued Functions

Manipulate Derived Tables and Common Table Expressions

Lab: Using Table Expressions

12 – USING SET OPERATORS

Complete Queries with the UNION Operator

Use EXCEPT, INTERSECT and APPLY

Lab: Using Set Operators

13 – USING WINDOWS RANKING, OFFSET, AND AGGREGATE FUNCTIONS

Create Windows with OVER

Explore Window Functions

Lab: Using Windows Ranking, Offset, and Aggregate Functions

14 – PIVOTING AND GROUPING SETS

Write Queries with PIVOT and UNPIVOT

Work with Grouping Sets

Lab: Pivoting and Grouping Sets

15 – EXECUTING STORED PROCEDURES

Query Data with Stored Procedures

Pass Parameters to Stored procedures

Create Simple Stored Procedures

Navigate Dynamic SQL

Lab: Executing Stored Procedures

 

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

 

Analyzing Data with Power BI – 30 hour

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

 

2 – INTRODUCING POWER BI

Power BI

The Power BI service

Lab : Creating a Power BI dashboard

 

3 – POWER BI

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

 

4 – SHAPING AND COMBINING DATA

Power BI desktop queries

Shaping data

Combining data

Lab : Shaping and combining data

 

5 – MODELLING DATA

Relationships

DAX queries

Calculations and measures

Lab : Modelling Data

 

6 – INTERACTIVE DATA VISUALIZATIONS

Creating Power BI reports

Managing a Power BI solution

Lab : Creating a Power BI report

 

7 – DIRECT CONNECTIVITY

Cloud data

Connecting to analysis services

Lab : Direct Connectivity

 

8 – DEVELOPER API

The developer API

Custom visuals

Lab : Using the developer API

 

9 – POWER BI MOBILE APP

The Power BI mobile app

Using the Power BI mobile app

Power BI embedded