Demo : Workplace Skills Mastery Program
Course Instructor:
Trainer 1
FREE
To enroll in this course, please contact the Admin
/CourseBundles(67379)/4658562-COURSE.png)
Course Overview
Schedule of Classes
Course Curriculum
5 Subjects
Demo Induction
1 Learning Materials
Welcome to the Induction Session
Induction Video
Video
00:23:55
Excel
6 Learning Materials
Introduction to Excel
Introduction to Excel - Part 1
Video
00:18:33
Introduction to Excel - Part 2
Video
00:08:01
UI Overview
Lesson - Excel UI Overview
Video
00:08:42
Formatting techniques: alignment, borders, conditional fills, number formatting.
Formatting techniques: alignment, borders, conditional fills, number formatting.
Video
00:14:52
Navigation: Freeze Panes, Split View, Hide/Unhide rows/columns/sheets/Group rows
Navigation- Freeze Panes, Split View, Hide/Unhide rows/columns/sheets/Group rows
Video
00:11:33
What is a Pivot Table? Why people use it?
What is a Pivot Table? Why people use it?
Video
00:14:20
SQL
6 Learning Materials
Introduction to SQL
Introduction to SQL - Part 1
Video
00:20:58
Introduction to SQL - Part 2
Video
00:07:00
What is Relational Database Management System (RDBMS)?
What is RDBMS?
Video
00:08:17
What is a Server? Data Flow & ETL Concepts (Source → Staging → Transformation → Loading)
Data Flow, Server & ETL Concepts
Video
00:26:31
Installation (Installing SQL Server, Creating DB connection, SSMS intro)
SSMS Installation & Overview
Video
00:20:13
Load CSV
Video
00:04:13
CREATE / DROP database/ table
Power BI
10 Learning Materials
Lesson : Introduction to Power BI
Introduction to Power BI
Video
00:28:31
Lesson : Download & Installation
Download & Installation of Power BI
Video
00:09:40
Lesson : How to use Power Bi desktop Application
How to Use Power BI Desktop App
Video
00:09:04
Lesson : Data and their types (Categorical, Numerical, Date)
Data and thier types
Video
00:15:47
Lesson : Creating Charts in Power Bi
Creating Charts in Power BI
Video
00:10:09
Lesson : Stack column chart
Stack Column Chart
Video
00:23:57
Lesson : Stack bar chart
Stack Bar Chart
Video
00:04:50
Lesson : Clustered column chart
Clustered Column Chart
Video
00:07:42
Lesson : Saving a file in local system
Saving a File in Local System
Video
00:06:08
Lesson : Trend Analysis chart (Line area, stack area chart)
Trend Analysis (Line Area, stack Area)
Video
00:14:07
Tableau
Course Instructor
Trainer 1
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy