|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/tableau-course-for-beginner-9-hours/
课程评论：没有评论
**Tableau 精通课程：数据可视化新篇章** 本课程专为初学者以及希望从 Excel 转向 Tableau 的职场人士设计。Tableau 是当前数据分析和商业智能领域中备受推崇的数据可视化工具，在 Gartner 的分析与商业智能魔力象限中被评为领导者。 **Tableau 的优势：** * **强大的数据可视化能力**：快速创建交互式可视化图表。 * **易于实施**：快速上手，效率提升。 * **处理大数据能力**：轻松应对海量数据。 * **支持多种脚本语言**：扩展性强。 * **移动端支持与响应式仪表板**：多平台适用。 * **公司战略**：了解 Tableau 的行业地位。 * **报告调度与通知**：自动化工作流程。 **告别 Excel 的痛点：** 您是否曾因 Excel 工作簿数据量过大导致运行缓慢甚至崩溃？是否曾误操作已保存的文件？是否厌倦了每天手动发送大量 Excel 文件？制作包含多个图表和复杂函数的仪表板是否耗费数小时？Excel 在存储和更新大量数据方面效率低下，操作繁琐。 **请注意：** Excel 依然是一款出色的应用程序，在数据可视化和分析方面也具备强大功能，只是在处理超大数据集和复杂交互式仪表板方面存在局限性。 **课程内容概览：** 本课程将带您掌握 Tableau Desktop 的核心功能，助您在数据可视化领域脱颖而出，为职业生涯注入新动力。 **第一部分：入门与基础（Booster）** 涵盖 Tableau 的介绍、下载、安装、连接数据库、数据提取、工作界面的熟悉、数据类型、字段理解（维度与度量）、可视化数据、创建层级、分组、数据粒度、图表转换、颜色标签、地图绘制、过滤器（包括动态、日期、相关过滤器）以及集合、离散与连续值、筛选技巧和保留/排除等概念。 **第二部分：过滤器精讲** 深入讲解各类过滤器，包括数据源过滤器、快速过滤器、维度相关过滤器、度量过滤器，以及上下文过滤器（多部分详解）和日期过滤器。 **第三部分：图表类型与应用** 涵盖创建各种图表的详细步骤，如气泡图、饼图、树状图、词云图、地理地图（含气泡图、尺寸颜色应用）、条形图（含颜色、尺寸、双轴、堆叠）、参考线设置，以及散点图、漏斗图、瀑布图、折线图（含双轴、尺寸、运动效果）等。还将学习参数的使用及其与动态参考线的结合。 **第四部分：数据联合与连接（Union & Joins）** 讲解 inner join, left join, right join, full join 等连接类型在 Tableau 中的应用，以及 Union 和类似 VLOOKUP 的Relation 操作。 **第五部分：函数基础** 介绍基本的聚合函数（SUM, MIN, MAX, AVERAGE, COUNT）、数值函数（FLOOR, CEILING）、文本函数（UPPER, LOWER, RIGHT, LEFT）等。 **第六部分：函数和计算（第一部分）** 学习排名函数（RANK, RANK_DENSE, RANK_UNIQUE）、字符串函数（MID, LEN, FIND, TRIM, REPLACE）、计数函数（COUNT vs COUNTD）以及多种 Tableau 内置的计算函数（如日期函数now(), today(), DateName(), DatePart()等）。 **第七部分：函数和计算（第二部分）** 深入讲解数值函数（round(), absolute()）、文本函数（Concatenate(), Replace()）以及表计算（Table Across, Table Down, Table Across Then Down）。 **第八部分：函数和计算（第三部分）** 重点讲解条件逻辑函数 IF, CASE, NULL 的应用，以及 AND, OR 逻辑在 Tableau 中的实现。 通过本课程的学习，您将能够熟练运用 Tableau 这一强大的工具，提升数据分析和可视化能力，为您的职业发展打开新的大门。
WHO'S THIS FOR?This course is designed specifically for freshers and also for those who want to switch career from Excel to Tableau.Tableau is a leading data visualization tool used for data analysis and business intelligence. Gartner's Magic Quadrant classified Tableau as a leader for analytics and business intelligence.Advantages of TableauData visualization.Quickly Create Interactive visualizations.Ease of Implementation.Tableau can handle large amounts of data.Use of other scripting languages in Tableau.Mobile Support and Responsive Dashboard.Tableau Company Strategy.Scheduling or notification of reports.PROBLEMS YOU'VE EXPERIENCED WITH EXCEL IN THE PASTExcel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.Mistakenly working on the wrong file you saved.It's so annoying to email multiple Excel files to the same people everyday.It takes hours to create a dashboard with multiple charts and formula functions.Some time Excel files are used to store the large amount data which is a very wrong decision because to update the data everyday on that file is a headache because it takes so much time to get open and then to get save.Note: Excel is also an Excellent Application. Yes Excel has some draw backs but it doesn't means its useless. Excel is also the Excellent tool to visualize and analyze the data.Learn how to use a TABLEAU Desktop (Data Visualization) most demanded tool in the industry today. Give your career a boost. With our online sessions, you will be amazed what you can achieved.Section 1: Booster1 Introduction 2 Download 3 Install 4 Tableau Extension5 Connect with Database 6 Tableau Live & Extract 7 View Tables 8 Data Types9 Tableau Work Sheet Interface 10 Data Types Symbol 11 Adding new Sheet 12 Product Category & Sales13 Dimensions & Measures 14 Visualize data in workspace15 Make Hierarchy 16 Grouping17 Auto Generated Fields 5 18 Auto Generated Fields in Tableau19 Records Per Dimension data or Item 20 Granularity 21 Granularity and Drill Down 22 Table into chart form 23 Color label 24 Color label for two different dimension 25 Map 26 Normal 27 Dynamic Filter 28 Date Filter 1 29 Date Filter 2 (Part1) 30 Date Filter 2 (Part2) 31 Date Filter 2 (Part 3)32 Date Filter 3 33 Relevant Filter Explained34 Relevant Filter in Tableau 35 Set36 Discrete vs Continuous37 Filtering 38 Keep only and ExcludeSection 2: Filters1 Filters 2 Type of Filters 3 Data Source Filters 4 Quick Filters 5 Dimension and Dependent Filters 6 Measure Filters 7 Context Filters Part1 8 Context Filters Part2 9 Context Filter Proper Details Part3 10 Date FilterSession 3: Charts1 Introduction to charts 2 Create a Chart 3 Swap the Dimension & Measures 4 Bubble Chart5 Pie Chart 6 Tree Map 7 Stacked Tree Map 8 Word Map Chart8 Word Map Chart9 Geographical Map10 Geographical Bubble Map Measure11 Geographical Bubble Map with size and color Measure12 Geographical Bubble Map (Unknown error)13 Geographical Map with color Dimension14 Geographical Map with Date as Year Filter15 Month Year Filter16 Month Year Filter Apply17 Bar chart18 Bar chart color Measure19 Bar chart size Measure20 Bar chart size and color Measure21 Bar chart with dual axis22 Bar Stacked chart part 1 23 Bar Stacked chart part 2 24 Reference line scope Entire table 25 Reference line scope per cell 26 Reference line scope per pan 27 Tree Map Stacked in Bar Chart 28 Bar Chart with Date as Month Year Filter. 29 Bubble Chart color label 30 Bubble Chart color label as second dimension 31 Bubble Chart with motion 32 Line Chart 33 Line chart dual axis 34 Line Chart size Measure 35 Line chart dual Measure Date as Month Year Filter 36 Funnel Chart 1 37 Funnel Chart 2 Intro38 Funnel Chart 2 Created 39 Scattered chart 40 Water Fall Chart 41 Parameter part 1 42 Parameter part 2 43 Parameter with Dynamic Reference line 44 Scatter plot and Many more Part145 Scatter plot and Many more Part2 46 Scatter plot and Many more Part3 Section 4: Union & Joins1 Intro Joins2 Inner Join3 Left Join4 Right Join5 Full Join6 Inner Join In Tableau7 Left Join in Tableau8 Right Join In Tableau9 Full Join In Tableau10 Union11 Union in Tableau12 Relation Like VlookupSection 5 : Function Base1 Function Intro2 Sum ()3 Min () & Max ()4 Average ()5 Floor ()6 Ceiling ()7 Count ()8 Upper ()9 Lower ()10 Right () & Left ()Section 6: Functions & Calculations Part11 Function Intro2 RANK() 3 RANK_DENSE()4 Rank Part 25 Rank_unique Part16 Rank_unique Part27 Rank_unique Part38 COUNT() vs CountD()9 Mid() 10 Len() 11 Find () 12 Mid() part 2 13 Trim() 14 Replace()15 Quick Table Calculations 16 Running Total 17 Difference 18 Percent Difference 19 Percent of Total 20 Moving Average Part 1 21 Moving Average Part 1 continuous 22 Date Functions () 24 Now() Today() 25 DateName and DatePart () 26 Date Diff () 27 Dateadd () 28 Datetrunc() 29 MakeDate() Section 7: Functions & Calculations Part 21 round zero or round function 2 round 1 2 3 4 3 absolute() 4 Concatenate() 5 Replace() 6 Table Across 7 Table Down 8 Table Across Then Down Section 8: Functions & Calculations Part 21 IF () 2 IF () in Tableau 3 IF () OR 4 IF () OR in Tableau 5 IF () AND 6 Nested IF () 7 Case () 8 Null() using if 9 Null() using if including OR AND 10 AND OR Part1 11 AND OR Part2
