|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/my-sql-excel-pivots-charts-tableau-4-in-1/
课程评论：没有评论
课程名称：商业智能分析师课程 课程概述：欢迎参加商业智能分析师课程！本课程旨在为您提供MySQL和Tableau的坚实基础，重点讲解SQL查询、Excel与Tableau的功能、筛选器和图表。无论您是初学者还是已有一定经验，本课程都将帮助您有效地处理和可视化数据。在MySQL部分，您将学习SQL查询的基本知识。SQL（结构化查询语言）是用于管理和分析关系数据库中存储的数据的强大工具。您将探索创建数据库、设计表格以及使用SQL查询操作数据的基本技巧。完成这部分学习后，您将具备强大的SQL理解能力，能够高效地检索、过滤和聚合数据。 接下来，将学习Tableau，这是一款流行的数据可视化工具。您将学习如何将Tableau连接到数据源，导航Tableau界面，并创建简单的可视化图表。通过聚焦于筛选器，您将了解如何对数据应用筛选，以深入挖掘特定信息子集。此外，您还将学习如何创建基本图表，如条形图、折线图和饼图，以有效传达数据。整个课程中，您将获得熟练使用MySQL、Tableau、Excel透视表和图表的技能和信心，从而利用这些工具的综合力量发现有价值的洞察，做出明智的决策，并以引人注目的方式呈现数据。 课程结束时，您将对SQL查询有扎实的基础，对Tableau的功能有基本的理解，并能在Tableau中应用筛选器和创建图表。这些技能将使您能够与数据库合作、进行数据分析以及以更有意义和更具影响力的方式可视化数据。无论您是学生、商业专业人士，还是希望扩展数据分析技能的人，这门课程将为您提供知识和信心，以使用MySQL和Tableau解决与数据相关的任务。立即加入我们，解锁这些强大工具的潜力，让您的数据分析和可视化技能晋升为商业智能分析师！
Welcome to the Business Intelligence Analyst course! This comprehensive course is designed to provide you with a solid foundation in MySQL and Tableau, focusing on SQL queries, Excel & 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 become a BI analystSection 1:Bundle1: MYSQL PART (A)Lecture 1:A1Lecture 2:A2Section 2:MY SQL PART (B)Lecture 3:B1Lecture 4:B2Lecture 5:B3Section 3:MY SQL PART (C)Lecture 8:C1Lecture 9:C2Section 4:MY SQL PART (D)Lecture 8:D1Lecture 9:D2Lecture 10:D3Lecture 11:D4Lecture 12:D5Lecture 13:D6Lecture 14:D7Lecture 15:D8Section 5:MY SQL PART (E)Lecture 16:E1Section 6: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
