Business Intelligence Mastery with SQL and Tableau [2-in-1]

سرفصل های دوره

Unlock the Power of Data: Become a Business Intelligence Expert with SQL and Tableau | Business Intelligence Essentials

1. Introduction

1. Introduction

2. Installation and getting started

1. Installing PostgreSQL and pgAdmin in your PC

2. This is a milestone!

3. If pgAdmin is not opening .html

4. Course Resources.html

3. Case Study Demo

1. Case Study Part 1 - Business problems

2. Case Study Part 2 - How SQL is Used

4. Fundamental SQL statements

1. CREATE

2. INSERT

3. Import data from File

4. SELECT statement

5. SELECT DISTINCT

6. WHERE

7. Logical Operators

8. UPDATE

9. DELETE

10. ALTER - Part 1

11. ALTER - Part 2

5. Restore and Back-up

1. Restore and Back-up

2. Debugging restoration issues

3. Creating DB using CSV files

4.1 Customer.csv

4.2 Product.csv

4.3 Sales.csv

4. Debugging summary and Code for CSV files.html

6. Selection commands Filtering

1. IN

2. BETWEEN

3. LIKE

7. Selection commands Ordering

1. Side lecture Commenting in SQL

2. ORDER BY

3. LIMIT

8. Alias

1. AS

9. Aggregate Commands

1. COUNT

2. SUM

3. AVERAGE

4. MIN & MAX

10. Group By Commands

1. GROUP BY

2. HAVING

11. Conditional Statement

1. CASE WHEN

12. JOINS

1. Introduction to Joins

2. Concepts of Joining and Combining Data

3. Preparing the data

4. Inner Join

5. Left Join

6. Right Join

7. Cross Join

8. Intersect and Intersect ALL

9. Except

10. Union

13. Subqueries

1. Subquery in WHERE clause

2. Subquery in FROM clause

3. Subquery in SELECT clause

14. Views and Indexes

1. VIEWS

2. INDEX

15. String Functions

1. LENGTH

2. UPPER LOWER

3. REPLACE

4. TRIM, LTRIM, RTRIM

5. CONCATENATION

6. SUBSTRING

7. LIST AGGREGATION

16. Mathematical Functions

1. CEIL & FLOOR

2. RANDOM

3. SETSEED

4. ROUND

5. POWER

17. Date-Time Functions

1. CURRENT DATE & TIME

2. AGE

3. EXTRACT

18. PATTERN (STRING) MATCHING

1. PATTERN MATCHING BASICS

2. ADVANCE PATTERN MATCHING - Part 1

3. ADVANCE PATTERN MATCHING - Part 2

19. Windows Functions

1. Introduction to Window functions

2. Introduction to Row number

3. Implementing Row number in SQL

4. RANK and DENSERANK

5. NTILE function

6. AVERAGE function

7. COUNT

8. SUM TOTAL

9. RUNNING TOTAL

10. LAG and LEAD

20. COALESCE function

1. COALESCE function

21. Data Type conversion functions

1. Converting Numbers Date to String

2. Converting String to Numbers Date

22. User Access Control Functions

1. User Access Control - Grant and Revoke

2. User Access Control - Drop, Alter

23. Nail that Interview!

1. Tablespace

2. PRIMARY KEY & FOREIGN KEY

3. ACID compliance

4. Truncate

24. Database Basics

1. What is SQL

2. Tables and DBMS

3. Types of SQL commands

4. PostgreSQL

25. TABLEAU

1. Why Tableau

2. Tableau Products

26. Installation and getting started

1. Installing Tableau desktop and Public

2. About the data

3. Connecting to data

4. Live vs Extract

27. Combining data to create Data model

1. Combining data from multiple tables

2. Relationships in Tableau

3. Joins in Tableau

4. Types of Joins in Tableau

5. Union in Tableau

6. Physical Logical layer and Data models

7. The visualization screen - Sheet

28. Data categorization in Tableau

1. Types of Data - Dimensions and Measures

2. Types of Data - Discreet and Continuous

3. Changing Data type in Tableau

29. Most used charts

1. Bar charts

2. Line charts

3. Scatterplots

30. Customizing charts using Marks shelf

1. Marks cards

2. Dropping Dimensions and Measures on marks card

3. Dropping Dimensions on Line chart

4. Adding marks in scatterplot

31. Other important charts

1. Text tables, heat map and highlight tables

2. Pie charts

3. Area charts

4. Creating custom hierarchy

5. Tree map

6. Dual combination charts

7. Creating Bins

8. Histogram

32. Grouping and Filtering data

1. Grouping Data

2. Filtering data

3. Dimension filters

4. Measure filters

5. Date-Time filters

6. Filter options

7. Types of filters and order of operation

8. Customizing visual filters

9. Sorting options

33. Map chart in Tableau

1. How to make a map chart

2. Considerations before making a Map chart

3. Marks card for customizing maps

4. Customizing maps using map menu

5. Layers in a Map

6. Visual toolbar on a map

7. Custom background images

8. Territories in maps

9. Data blending for missing geocoding

34. Calculations and Analytics

1. Calculated fields in Tableau

2. Functions in Tableau

3. Table calculations theory

4. Table calculations in Tableau

5. Understanding LOD expressions

6. LOD expressions examples

7. Analytics pane

35. Sets and Parameters

1. Understanding sets in Tableau

2. Creating Sets in Tableau

3. Parameters

36. Dashboard and Story

1. Dashboard part -1

2. Dashboard part - 2

3. Story

37. Appendix

1. Connecting to SQL data source

2. Connecting to cloud storage services

3. The final milestone!

38. Congratulations and about your certificate

1. Bonus Lecture.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training