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

Focused View

Start-Tech Academy

18:10:28

153 View

1. Introduction

1. Introduction.mp4

04:24

2. Installation and getting started

1. Installing PostgreSQL and pgAdmin in your PC.mp4

10:44

2. This is a milestone!.mp4

03:31

3. If pgAdmin is not opening .html

4. Course Resources.html

3. Case Study Demo

1. Case Study Part 1 - Business problems.mp4

04:21

2. Case Study Part 2 - How SQL is Used.mp4

06:17

4. Fundamental SQL statements

1. CREATE.mp4

11:40

2. INSERT.mp4

09:07

3. Import data from File.mp4

04:59

4. SELECT statement.mp4

03:40

5. SELECT DISTINCT.mp4

06:05

6. WHERE.mp4

04:02

7. Logical Operators.mp4

06:03

8. UPDATE.mp4

05:24

9. DELETE.mp4

04:11

10. ALTER - Part 1.mp4

06:49

11. ALTER - Part 2.mp4

10:31

5. Restore and Back-up

1. Restore and Back-up.mp4

07:37

2. Debugging restoration issues.mp4

08:26

3. Creating DB using CSV files.mp4

05:40

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.mp4

04:18

2. BETWEEN.mp4

05:40

3. LIKE.mp4

08:52

7. Selection commands Ordering

1. Side lecture Commenting in SQL.mp4

01:21

2. ORDER BY.mp4

07:42

3. LIMIT.mp4

03:38

8. Alias

1. AS.mp4

03:33

9. Aggregate Commands

1. COUNT.mp4

05:07

2. SUM.mp4

03:24

3. AVERAGE.mp4

02:53

4. MIN & MAX.mp4

04:18

10. Group By Commands

1. GROUP BY.mp4

11:42

2. HAVING.mp4

05:04

11. Conditional Statement

1. CASE WHEN.mp4

05:17

12. JOINS

1. Introduction to Joins.mp4

02:54

2. Concepts of Joining and Combining Data.mp4

11:58

3. Preparing the data.mp4

02:00

4. Inner Join.mp4

08:04

5. Left Join.mp4

07:30

6. Right Join.mp4

06:27

7. Cross Join.mp4

04:21

8. Intersect and Intersect ALL.mp4

07:06

9. Except.mp4

02:53

10. Union.mp4

03:09

13. Subqueries

1. Subquery in WHERE clause.mp4

04:55

2. Subquery in FROM clause.mp4

05:23

3. Subquery in SELECT clause.mp4

04:02

14. Views and Indexes

1. VIEWS.mp4

07:14

2. INDEX.mp4

06:25

15. String Functions

1. LENGTH.mp4

03:22

2. UPPER LOWER.mp4

02:10

3. REPLACE.mp4

04:13

4. TRIM, LTRIM, RTRIM.mp4

06:56

5. CONCATENATION.mp4

02:56

6. SUBSTRING.mp4

06:01

7. LIST AGGREGATION.mp4

04:54

16. Mathematical Functions

1. CEIL & FLOOR.mp4

03:20

2. RANDOM.mp4

05:04

3. SETSEED.mp4

04:11

4. ROUND.mp4

02:27

5. POWER.mp4

02:18

17. Date-Time Functions

1. CURRENT DATE & TIME.mp4

04:25

2. AGE.mp4

03:50

3. EXTRACT.mp4

08:16

18. PATTERN (STRING) MATCHING

1. PATTERN MATCHING BASICS.mp4

07:33

2. ADVANCE PATTERN MATCHING - Part 1.mp4

08:29

3. ADVANCE PATTERN MATCHING - Part 2.mp4

06:49

19. Windows Functions

1. Introduction to Window functions.mp4

09:57

2. Introduction to Row number.mp4

06:04

3. Implementing Row number in SQL.mp4

19:19

4. RANK and DENSERANK.mp4

07:19

5. NTILE function.mp4

07:20

6. AVERAGE function.mp4

08:22

7. COUNT.mp4

03:55

8. SUM TOTAL.mp4

11:14

9. RUNNING TOTAL.mp4

06:58

10. LAG and LEAD.mp4

08:17

20. COALESCE function

1. COALESCE function.mp4

05:57

21. Data Type conversion functions

1. Converting Numbers Date to String.mp4

10:46

2. Converting String to Numbers Date.mp4

05:49

22. User Access Control Functions

1. User Access Control - Grant and Revoke.mp4

07:50

2. User Access Control - Drop, Alter.mp4

05:22

23. Nail that Interview!

1. Tablespace.mp4

05:37

2. PRIMARY KEY & FOREIGN KEY.mp4

05:02

3. ACID compliance.mp4

05:32

4. Truncate.mp4

03:54

24. Database Basics

1. What is SQL.mp4

01:49

2. Tables and DBMS.mp4

03:10

3. Types of SQL commands.mp4

04:30

4. PostgreSQL.mp4

02:29

25. TABLEAU

1. Why Tableau.mp4

04:41

2. Tableau Products.mp4

09:21

26. Installation and getting started

1. Installing Tableau desktop and Public.mp4

05:02

2. About the data.mp4

09:59

3. Connecting to data.mp4

12:26

4. Live vs Extract.mp4

04:24

27. Combining data to create Data model

1. Combining data from multiple tables.mp4

04:27

2. Relationships in Tableau.mp4

13:56

3. Joins in Tableau.mp4

06:43

4. Types of Joins in Tableau.mp4

06:12

5. Union in Tableau.mp4

07:55

6. Physical Logical layer and Data models.mp4

06:30

7. The visualization screen - Sheet.mp4

09:13

28. Data categorization in Tableau

1. Types of Data - Dimensions and Measures.mp4

06:49

2. Types of Data - Discreet and Continuous.mp4

06:09

3. Changing Data type in Tableau.mp4

09:25

29. Most used charts

1. Bar charts.mp4

14:09

2. Line charts.mp4

08:53

3. Scatterplots.mp4

06:11

30. Customizing charts using Marks shelf

1. Marks cards.mp4

13:38

2. Dropping Dimensions and Measures on marks card.mp4

09:49

3. Dropping Dimensions on Line chart.mp4

04:10

4. Adding marks in scatterplot.mp4

04:44

31. Other important charts

1. Text tables, heat map and highlight tables.mp4

08:33

2. Pie charts.mp4

07:34

3. Area charts.mp4

09:06

4. Creating custom hierarchy.mp4

04:04

5. Tree map.mp4

05:00

6. Dual combination charts.mp4

08:16

7. Creating Bins.mp4

06:11

8. Histogram.mp4

04:36

32. Grouping and Filtering data

1. Grouping Data.mp4

09:18

2. Filtering data.mp4

09:31

3. Dimension filters.mp4

10:55

4. Measure filters.mp4

04:04

5. Date-Time filters.mp4

08:02

6. Filter options.mp4

08:51

7. Types of filters and order of operation.mp4

11:00

8. Customizing visual filters.mp4

09:09

9. Sorting options.mp4

14:35

33. Map chart in Tableau

1. How to make a map chart.mp4

07:04

2. Considerations before making a Map chart.mp4

04:46

3. Marks card for customizing maps.mp4

07:26

4. Customizing maps using map menu.mp4

09:33

5. Layers in a Map.mp4

07:56

6. Visual toolbar on a map.mp4

04:35

7. Custom background images.mp4

11:04

8. Territories in maps.mp4

06:12

9. Data blending for missing geocoding.mp4

11:09

34. Calculations and Analytics

1. Calculated fields in Tableau.mp4

15:07

2. Functions in Tableau.mp4

02:53

3. Table calculations theory.mp4

07:06

4. Table calculations in Tableau.mp4

09:38

5. Understanding LOD expressions.mp4

27:11

6. LOD expressions examples.mp4

15:49

7. Analytics pane.mp4

20:01

35. Sets and Parameters

1. Understanding sets in Tableau.mp4

05:34

2. Creating Sets in Tableau.mp4

10:51

3. Parameters.mp4

14:45

36. Dashboard and Story

1. Dashboard part -1.mp4

17:04

2. Dashboard part - 2.mp4

10:45

3. Story.mp4

05:09

37. Appendix

1. Connecting to SQL data source.mp4

05:26

2. Connecting to cloud storage services.mp4

03:53

3. The final milestone!.mp4

01:33

38. Congratulations and about your certificate

1. Bonus Lecture.html

Description

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

What You'll Learn?

Master SQL syntax and write complex queries to extract business insights.
Develop the skills to visualize complex data using Tableau.
Use Tableau to create interactive dashboards and reports to communicate insights effectively.
Explore and analyze large datasets to identify trends and patterns.
Discover how to clean, transform, and prepare data for analysis using SQL.
Master advanced SQL concepts like subqueries, joins, and views.
Learn how to create calculated fields and use Tableau's data blending capabilities

Who is this for?

Business analysts who want to improve their skills in data analysis and visualization using SQL and Tableau to advance their career.

Entrepreneurs who want to use data-driven insights to grow their business and make better strategic decisions.

Students who are pursuing a degree in business, finance, or data science and want to gain practical skills in business intelligence.

Professionals in fields such as finance, healthcare, or logistics who want to use data analysis and visualization to improve their organization's performance.

More details

Description
If you're looking to take your career to the next level by mastering data analytics, you're in the right place! Do you ever wonder how top companies like Amazon, Netflix, and Google make informed decisions? The answer is Business Intelligence, and this course will teach you the fundamentals of it using SQL and Tableau.
Business Intelligence Mastery with SQL and Tableau [2-in-1] is a comprehensive course that covers the essentials of Business Intelligence, equipping you with the skills to leverage data to drive business decisions.
In this course, you will:
Develop a deep understanding of SQL and its practical applications in extracting insights from complex data sets
Master Tableau to create interactive dashboards and visualize complex data with ease
Explore real-world case studies and practice exercises to apply your skills in practice
Gain a competitive edge in the job market by acquiring highly sought-after Business Intelligence skills
Get access to lucrative career opportunities in various domains such as finance, marketing, and operations
Business Intelligence is a key element of success in today's data-driven world. By learning SQL and Tableau, you'll gain a competitive edge in the job market and be able to work with data to inform business decisions.
Throughout the course, you'll be challenged with quizzes, exercises, and projects to cement your learning and apply your skills in practice. Our experienced instructors have designed this course to ensure that you have a solid understanding of Business Intelligence and are well-equipped to take on any data analytics challenge.
Why learn from us? Our instructors are experts in the field of Business Intelligence and have extensive experience working with SQL and Tableau. By enrolling in this course, you'll receive personalized support and guidance throughout your learning journey.
Business Intelligence Mastery with SQL and Tableau [2-in-1] is the perfect course for anyone looking to take their career to the next level.
Enroll today and start unlocking the power of data!
Who this course is for:
Business analysts who want to improve their skills in data analysis and visualization using SQL and Tableau to advance their career.
Entrepreneurs who want to use data-driven insights to grow their business and make better strategic decisions.
Students who are pursuing a degree in business, finance, or data science and want to gain practical skills in business intelligence.
Professionals in fields such as finance, healthcare, or logistics who want to use data analysis and visualization to improve their organization's performance.

User Reviews

Rating

average 0

Total votes0

Focused display

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. Founded by Abhishek Bansal and Pukhraj Parikh. Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.