HOT

Data Analytics MasterClass(PostgreSQL, BI, Python)

IT & Software

Enroll Now

Data Analytics MasterClass(PostgreSQL, BI, Python), available at $19.99, with 134 lectures, and has 5 subscribers.

You will learn about Dashboard Visualizations Data Analytics Qlik Sense PowerBI QlikView PostgreSQL Python This course is ideal for individuals who are BI Analyst or Business Analyst or Fresh Graduate in IT or Data Analytics Beginner or Business Intelligence Beginner or Python Beginners who is curious about Data Science It is particularly useful for BI Analyst or Business Analyst or Fresh Graduate in IT or Data Analytics Beginner or Business Intelligence Beginner or Python Beginners who is curious about Data Science.

Enroll now: Data Analytics MasterClass(PostgreSQL, BI, Python)

Summary

Title: Data Analytics MasterClass(PostgreSQL, BI, Python)

Price: $19.99

Number of Lectures: 134

Number of Published Lectures: 134

Number of Curriculum Items: 134

Number of Published Curriculum Objects: 134

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

  • Dashboard Visualizations
  • Data Analytics
  • Qlik Sense
  • PowerBI
  • QlikView
  • PostgreSQL
  • Python

Who Should Attend

  • BI Analyst
  • Business Analyst
  • Fresh Graduate in IT
  • Data Analytics Beginner
  • Business Intelligence Beginner
  • Python Beginners who is curious about Data Science

Target Audiences

  • BI Analyst
  • Business Analyst
  • Fresh Graduate in IT
  • Data Analytics Beginner
  • Business Intelligence Beginner
  • Python Beginners who is curious about Data Science

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.

Course Curriculum

Chapter 1: PostgreSQL for Beginners

Lecture 1: PostgreSQL for Beginners: Introduction

Lecture 2: Introduction

Lecture 3: What is PostgreSQL?

Lecture 4: Thanks for Enrolling!

Lecture 5: PostgreSQL Installation

Lecture 6: PostgreSQL for Beginners: Create, Modify & Delete Table

Lecture 7: Creating Tables

Lecture 8: Alter Tables

Lecture 9: Copying CSV Records into Table

Lecture 10: PostgreSQL for Beginners : SQL Commands

Lecture 11: Select Statement

Lecture 12: Where Statements – Text, Numeric & Date columns

Lecture 13: Where Statements – Dynamic, And/Or filters

Lecture 14: Where Statement – Wildcards

Lecture 15: Order By Statement

Lecture 16: Sum

Lecture 17: Select Distinct

Lecture 18: PostgreSQL for Beginners : Conclusion

Chapter 2: PowerBI MasterClass

Lecture 1: PowerBI MasterClass : Introduction

Lecture 2: Introduction

Lecture 3: Table of Content

Lecture 4: Introduction to BI

Lecture 5: Installing PowerBI Desktop

Lecture 6: Loading Data into PowerBI

Lecture 7: Creating Our First Dashboard_Demo (Slicer, Card, Donut)

Lecture 8: Creating Our First Dashboard(Table and Bar)

Lecture 9: Challenge

Lecture 10: Solution

Lecture 11: Creating Measure

Lecture 12: Creating Measure Logic in Excel

Lecture 13: Data Types

Lecture 14: Creating Measures in PowerBI

Lecture 15: Sorting

Lecture 16: Sorting : Demo

Lecture 17: Calendar

Lecture 18: DAX

Lecture 19: Chart Interaction

Lecture 20: Creating Buttons

Lecture 21: Creating Bookmarks

Lecture 22: PowerBI MasterClass : PowerQuery Introduction

Lecture 23: Introduction to PowerQuery

Lecture 24: Connecting Data from Web

Lecture 25: Changing Data Type

Lecture 26: Splitting Columns

Lecture 27: Formatting

Lecture 28: Extract

Lecture 29: Statistical Information from PowerQuery

Lecture 30: Alternative to transform Column

Lecture 31: Custom Column

Lecture 32: Conditional Column

Lecture 33: Index & Duplicated Columns

Lecture 34: Add Column: Format & Extract

Lecture 35: Challenge 2

Lecture 36: Solution 2

Lecture 37: PowerBI Report: Visual, Measure, and DAX

Lecture 38: Master Calendar

Lecture 39: Table Matrix

Lecture 40: Variable

Lecture 41: MTD Logic

Lecture 42: MTD Logic: Advanced Filtering

Lecture 43: Challenge 3

Lecture 44: Solution 3

Lecture 45: Prior Month & Prior Year

Lecture 46: Buttons

Lecture 47: Color Codes

Lecture 48: PowerBI MasterClass : Conclusion

Chapter 3: QlikView Dashboard Design MasterClass

Lecture 1: QlikView MasterClass : HR Dashboard

Lecture 2: Introduction

Lecture 3: Data Study

Lecture 4: Extracting Dataset

Lecture 5: Forecast Logic

Lecture 6: Dashboard Title

Lecture 7: KPI Objects

Lecture 8: Forecast Demo

Lecture 9: Net Pay KPI

Lecture 10: Forecast vs Actual (%)

Lecture 11: Donut & Block Chart

Lecture 12: Bar Chart by Quarter by Region

Lecture 13: Class Groupings

Lecture 14: Conclusion

Lecture 15: QlikView MasterClass : Opening A Food Restaurant

Lecture 16: Introduction

Lecture 17: Data Walkthrough

Lecture 18: Lines, Page Separator

Lecture 19: KPI Boxes

Lecture 20: Main Course & Dish

Lecture 21: Scatter Plot – Calories vs Price

Lecture 22: Dine In Reason & Conclusion

Lecture 23: QlikView MasterClass : Sales Dashboard

Lecture 24: Logo and Title

Lecture 25: KPI Box

Lecture 26: Block Chart

Lecture 27: Sales vs Target Line Chart

Lecture 28: Sales Composition By Product Category

Chapter 4: Qlik Sense for Beginners

Lecture 1: Qlik Sense for Beginners : Introduction

Lecture 2: Introduction

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 0 votes
  • 4 stars: 0 votes
  • 5 stars: 0 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Google Shopping Ads Digital Marketing Course

Complete Copywriting System : write to sell with ease

Product Positioning Masterclass: Unlock Market Traction