وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 13310
    حجم: 7200 مگابایت
    مدت زمان: 1091 دقیقه
    تاریخ انتشار: ۲۰ خرداد ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید