My Sql, Excel Pivots & Charts, Tableau (4 In 1)

Learn to query databases using MySQL plus become a Tableau, Excel pivots & charts expert.

What you'll learn

MY SQL Workbench

MY SQL Queries

MY SQL functions

Write complex SQL Join queries across tables

Excel Charts & Pivots

Create reports from pivots

Install Tableau Desktop 2022

Tableau Interface & Charts

Tableau Filters

Tableau Visualization Activities

Work with Parameters

Create Treemaps

Create Data Hierarchies

Adding Filters and Quick Filters

Create Dual Axis Charts

Create Area Charts

Create Scatterplots

Create Piecharts

Create Barcharts

Dashboard Creation in Tableau

Adding Actions to Dashboards (filters )

Requirements

No MySQL, Tableau experience needed! Complete beginners to MySQL are welcome.

Software Installed : MS Excel 2007 to 2021

Software Installed : Tableau 2022

Software Installed : My SQL community 8.0.30 (My SQL Server +Benchmark)

All you need is a working computer for this course like Laptop or PC , Mac

Stable Internet connection

Description

Welcome to the MySQL, Tableau , Excel Pivots & Charts course! This comprehensive course is designed to provide you with a solid foundation in MySQL and Tableau, focusing on SQL queries, basic Tableau functionality, filters, and charts. Whether you're a beginner or have some experience with these tools, this course will help you develop the skills necessary to manipulate and visualize data effectively.In the MySQL section of the course, you will learn the fundamentals of SQL queries. SQL (Structured Query Language) is a powerful tool used for managing and analyzing data stored in relational databases. You will explore the basics of creating databases, designing tables, and manipulating data using SQL queries. By the end of this section, you will have a strong understanding of SQL and the ability to retrieve, filter, and aggregate data efficiently.Moving on to Tableau, you will be introduced to the basics of this popular data visualization tool. You will learn how to connect Tableau to data source, navigate the Tableau interface, and create simple visualizations. With a focus on filters, you will discover how to apply filters to your data to drill down and explore specific subsets of information. You will also learn how to create basic charts, such as bar charts, line charts, and pie charts, to effectively communicate your data. Throughout this course, you will have the skills and confidence to work proficiently with MySQL, Tableau, Excel Pivots, and Charts, and leverage their combined power to uncover valuable insights, make informed decisions, and present data in a compelling and impactful way.By the end of this course, you will have a strong foundation in SQL queries, a basic understanding of Tableau's features, and the ability to apply filters and create charts in Tableau. These skills will empower you to work with databases, perform data analysis, and visualize data in a more meaningful and impactful way.Whether you're a student, a business professional, or someone interested in expanding their data analysis skills, this course will equip you with the knowledge and confidence to tackle data-related tasks using MySQL and Tableau. Join us now to unlock the potential of these powerful tools and take your data analysis and visualization skills to the next level.Section 1:Bundle1 : MYSQL PART (A)Lecture 1:A1Lecture 2:A2Section 2:MY SQL PART (B)Lecture 3:B1Lecture 4:B2Lecture 5:B3Lecture 6:B4Lecture 7:B5Section 3:MY SQL PART (D)Lecture 8:D1Lecture 9:D2Lecture 10:D3Lecture 11:D4Lecture 12:D5Lecture 13:D6Lecture 14:D7Lecture 15:D8Section 4:MY SQL PART (E)Lecture 16:E1Section 5:MY SQL PART (F) ActivitiesQuiz 1:MY SQL QUIZ 1Quiz 2:MY SQL QUIZ 2Lecture 17:L1Lecture 18:L2Lecture 19:L3Lecture 19:L4Lecture 19:L5Lecture 19:L6Lecture 19:L7Lecture 19:L8Lecture 19:L9Lecture 19:L10Section 6:Bundle2 : Excel Pivots PART (A)Lecture 20:A1Section 7:Bundle2 : Excel Pivot PART (B)Lecture 21:B1Lecture 22:B2Lecture 23:B3Section 8:Bundle3 : Excel Charts PART (A)Lecture 24:A1Lecture 25:A2Section 9:Bundle3 : Excel Charts PART (B)Lecture 26:A3Lecture 27:A4Lecture 28:A5Lecture 29:A6Lecture 30:A7Section 10:Bundle4 : Tableau PART (A)Lecture 31:S1Lecture 32:S2Lecture 33:S3Lecture 34:S4Lecture 35:S5Lecture 36:S6Lecture 37:S7Lecture 38:S8Lecture 39:S9Lecture 40:S10Lecture 41:S11Lecture 42:S12Lecture 43:S13Lecture 44:S14Lecture 45:S15Lecture 46:S16Lecture 47:S17Lecture 48:S18Lecture 49:S19Lecture 50:S20Section 11:Tableau PART (B)Lecture 51:S21Lecture 52:S22Lecture 53:S23Lecture 54:S24Lecture 55:S25Lecture 56:S26Lecture 57:S26Section 12:Tableau PART (C)Lecture 58:S27Lecture 59:S28Lecture 60:S29Lecture 61:S30Lecture 62:S31Lecture 63:S32Lecture 64:S33Lecture 65:S34Lecture 66:S35Lecture 67:S36Section 13:Tableau PART (C)Lecture 68:S37Lecture 69:S38Lecture 70:S39Lecture 71:S40Lecture 72:S41Lecture 73:S42Lecture 74:S43Lecture 75:S44Lecture 76:S45Lecture 77:S46Lecture 78:S47Lecture 79:S48Lecture 80:S49Lecture 81:S50Lecture 82:S51Lecture 83:S52Section 14:Tableau PART (D)Lecture 84:D1Lecture 85:D2Lecture 86:D3Lecture 87:D4Lecture 88:D5Lecture 89:D6Lecture 90:D7Lecture 91:D8Lecture 92:D9Lecture 93:D10Lecture 94:`D11Lecture 95:D12Lecture 96:D13Lecture 97:D14Lecture 98:D15Lecture 99:D16Lecture 100:D17Lecture 101:D18Lecture 102:D19Section 15:Tableau PART (E)Lecture 103:E1Lecture 104:E2Lecture 105:E3Lecture 106:E4Lecture 107:E5Lecture 108:E6Lecture 109:E7Lecture 110:E8Lecture 111:E9Lecture 112:E10Lecture 113:E11Lecture 114:E12Lecture 115:E13Lecture 116:E15Lecture 117:E16Lecture 118:E17Section 16:Tableau ActivitiesLecture 119:Download Data SetContentLecture 120:1Lecture 121:2Lecture 122:3Lecture 123:4Lecture 124:5Lecture 125:6Lecture 126:7Lecture 127:8Lecture 128:9Lecture 129:10Lecture 130:11Lecture 131:12Lecture 132:13Lecture 133:14Lecture 134:15Lecture 135:16Lecture 136:17Lecture 137:18Lecture 138:19Lecture 139:20Lecture 140:21Lecture 141:22Lecture 142:23

Overview

Section 1: Bundle1 : MYSQL PART (A)

Lecture 1 MYSQL DB File

Lecture 2 Welcome

Lecture 3 A1

Lecture 4 A2

Section 2: MY SQL PART (B)

Lecture 5 B1

Lecture 6 B2

Lecture 7 B3

Lecture 8 B4

Lecture 9 B5

Section 3: MY SQL PART (D)

Lecture 10 D1

Lecture 11 D2

Lecture 12 D3

Lecture 13 D4

Lecture 14 D5

Lecture 15 D6

Lecture 16 D7

Lecture 17 D8

Section 4: MY SQL PART (E)

Lecture 18 E1

Section 5: MY SQL PART (F) Activities

Lecture 19 L1

Lecture 20 L2

Lecture 21 L3

Section 6: Bundle2 : Excel Pivots PART (A)

Lecture 22 A1

Section 7: Excel Pivot PART (B)

Lecture 23 B1

Lecture 24 B2

Lecture 25 B3

Section 8: Bundle3 : Excel Charts PART (A)

Lecture 26 A1

Lecture 27 A2

Section 9: Excel Charts PART (B)

Lecture 28 A3

Lecture 29 A4

Lecture 30 A5

Lecture 31 A6

Lecture 32 A7

Section 10: Bundle4 : Tableau PART (A)

Lecture 33 S1

Lecture 34 S2

Lecture 35 S3

Lecture 36 S4

Lecture 37 S5

Lecture 38 S6

Lecture 39 S7

Lecture 40 S8

Lecture 41 S9

Lecture 42 S10

Lecture 43 S11

Lecture 44 S12

Lecture 45 S13

Lecture 46 S14

Lecture 47 S15

Lecture 48 S16

Lecture 49 S17

Lecture 50 S18

Lecture 51 S19

Lecture 52 S20

Section 11: Tableau PART (B)

Lecture 53 S21

Lecture 54 S22

Lecture 55 S23

Lecture 56 S24

Lecture 57 S25

Lecture 58 S26

Lecture 59 S26

Section 12: Tableau PART (C)

Lecture 60 S27

Lecture 61 S28

Lecture 62 S29

Lecture 63 S30

Lecture 64 S31

Lecture 65 S32

Lecture 66 S33

Lecture 67 S34

Lecture 68 S35

Lecture 69 S36

Section 13: Tableau PART (C)

Lecture 70 S37

Lecture 71 S38

Lecture 72 S39

Lecture 73 S40

Lecture 74 S41

Lecture 75 S42

Lecture 76 S43

Lecture 77 S44

Lecture 78 S45

Lecture 79 S46

Lecture 80 S47

Lecture 81 S48

Lecture 82 S49

Lecture 83 S50

Lecture 84 S51

Lecture 85 S52

Section 14: Tableau PART (D)

Lecture 86 D1

Lecture 87 D2

Lecture 88 D3

Lecture 89 D4

Lecture 90 D5

Lecture 91 D6

Lecture 92 D7

Lecture 93 D8

Lecture 94 D9

Lecture 95 D10

Lecture 96 D11

Lecture 97 D12

Lecture 98 D13

Lecture 99 D14

Lecture 100 D15

Lecture 101 D16

Lecture 102 D17

Lecture 103 D18

Lecture 104 D19

Section 15: Tableau PART (E)

Lecture 105 E1

Lecture 106 E2

Lecture 107 E3

Lecture 108 E4

Lecture 109 E5

Lecture 110 E6

Lecture 111 E7

Lecture 112 E8

Lecture 113 E9

Lecture 114 E10

Lecture 115 E11

Lecture 116 E12

Lecture 117 E13

Lecture 118 E15

Lecture 119 E16

Lecture 120 E17

Section 16: Tableau Activities

Lecture 121 Download Data Set

Lecture 122 1

Lecture 123 2

Lecture 124 3

Lecture 125 4

Lecture 126 5

Lecture 127 6

Lecture 128 7

Lecture 129 8

Lecture 130 9

Lecture 131 10

Lecture 132 11

Lecture 133 12

Lecture 134 13

Lecture 135 14

Lecture 136 15

Lecture 137 16

Lecture 138 17

Lecture 139 18

Lecture 140 19

Lecture 141 20

Lecture 142 21

Lecture 143 22

Lecture 144 23

Absolute beginners & Intermediates are also welcome,Working professionals, business analytics & managers,Anyone interested in learning SQL to help with their current job or to find a new role,Anyone looking to answer complex business problems and generate reports using data