Data Analytics Certificate
$3700
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.
Upcoming Dates | Class Times | Class Format | Price |
M,T,F June 19th – August 4th, 2023 | 7:30 am – 10:00 am | Instructor-Led
Virtual Live Class |
$3,700 |
Email: info@brighttechnologylc.com or call 678435-9016 to get the registration form.
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:
- Complete and submit an admissions application along with the required non-refundable $25 fee;
- Provide proof of U.S. citizenship or Permanent Residence status.
- Provide proof of a U. S. high school diploma, GED, or the recognized equivalent
- Interview with the admissions officer,
- Possess basic keyboard skills (A minimum of 35 WPM is required),
- Provide proof of College Degree in any disciplines for students seeking admission into Data Analytic Program
- Provide proof of at least one year of professional work experience in an office environment.
- Pass the Bright Technology Training computer-based Computer Literacy Test (CLT); and,
- 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