Data Analytics MasterClass(PostgreSQL, BI, Python)
PostgreSQL for Beginners, PowerBI MasterClass, QlikView/Qlik Sense Dashboard Design MasterClass, Python for Beginners
Business Intelligence,Data Analytics,Database Administration,Business Analytics & Intelligence,Development
Lectures -134
Resources -14
Duration -8.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Today, we are all surrounded with full of data.
Data can be in the form of structured data(eg: Tables, and worksheets), or unstructured data (free text fields or comments from social media).
An example of Data Usage is in AI model.
Data are the core of an AI model, which utilizes data input for the model to train, test, and learn from the data.
The usage of Machine Learning has allowed computers to perform predictions and provides suggestions to humans based on the data input that has been fed into the machine.
An example of Machine Learning is the Web Search Engine, which tries to understand what is the content we are searching for based on the data input that has been entered into the Search Engine.
This course offers everyone an abundance of information about analytical tools that may help you in developing your career moving forward.
Content in this course is as below:
Database
1. PostgreSQL For Beginners
Learning Outcomes:
~How to install and configure PostgreSQL.
~How to create and modify tables in PostgreSQL.
~How to perform basic SQL commands in PostgreSQL.
BI (Business Intelligence)
2. PowerBI MasterClass
Learning Outcomes:
~How to transform our columns to extract values or change column formatting
~How to add new columns, eg: Custom columns, conditional columns, index columns, etc.
~DAX expressions
3. QlikView Dashboard Design MasterClass
Learning Outcomes:
How to build a simple dashboard:
~ HR Dashboard
~Opening a Fast Food Restaurant
~Sales Dashboard
4. Qlik Sense for Beginners
Imagine if we are recently appointed to be a director of an organization, are we able to:
1. React based on the latest or historical information around us?
2. Reduce or automate the manual work done in decades?
3. Draw insights from a stack of printed reports?
If you do not have the answer, join this class to know more about Qlik Sense which can help solve your problems.
Advanced Analytics
5. Python for Beginners
Learning Outcomes:
1. Python Function and Class Objects.
2. Data Types - String and Numeric.
3. Python Data Structure - List and Data Dictionary.
Goals
What will you learn in this course:
At the End of the Course, you will learn:
- What is PostgreSQL
- How to build Dashboard Visualizations
- What is Data & Analytics
- What is Qlik Sense
- What is PowerBI
- What is QlikView
- What is Python
Prerequisites
What are the prerequisites for this course?
Suitable for all levels
Curriculum
Check out the detailed breakdown of what’s inside the course
PostgreSQL for Beginners
18 Lectures
- PostgreSQL for Beginners: Introduction 00:10 00:10
- Introduction 03:00 03:00
- What is PostgreSQL? 03:43 03:43
- Thanks for Enrolling! 00:43 00:43
- PostgreSQL Installation 06:32 06:32
- PostgreSQL for Beginners: Create, Modify & Delete Table 00:10 00:10
- Creating Tables 05:29 05:29
- Alter Tables 13:29 13:29
- Copying CSV Records into Table 04:42 04:42
- PostgreSQL for Beginners : SQL Commands 00:10 00:10
- Select Statement 03:21 03:21
- Where Statements - Text, Numeric & Date columns 04:18 04:18
- Where Statements - Dynamic, And/Or filters 06:16 06:16
- Where Statement - Wildcards 04:25 04:25
- Order By Statement 02:21 02:21
- Sum 05:21 05:21
- Select Distinct 02:16 02:16
- PostgreSQL for Beginners : Conclusion 02:08 02:08
PowerBI MasterClass
48 Lectures
QlikView Dashboard Design MasterClass
28 Lectures
Qlik Sense for Beginners
18 Lectures
Python for Beginners
22 Lectures
Instructor Details
Arthur Fong
BI DeveloperI have been in BI Industry for 4 years. In my past experience, I have being with a Qlik partner organization which helped me in gaining experience on developing some of the Qlik products, namely QlikView, Qlik Sense, and NPrinting. And I would like to share my knowledge as a developer with everyone here. Hopefully you will find my class informative for your learning.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now