|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/tableau-data-analyst-certification-preparation/
课程评论：没有评论
课程名称：Tableau 数据分析师认证准备 概述： 本课程旨在为希望通过 Tableau 进行数据分析并获取认证的学习者提供全面的准备。课程内容涵盖了四个主要领域： 领域一：连接与转换数据 包括识别数据源、连接至各种数据源（如文件、关系数据库和 Tableau Server/Cloud 上已发布的数据源）、准备数据以进行分析（如数据质量评估、清洗和组织数据字段），以及在 Tableau Prep 中进行数据转换。 领域二：探索与分析数据 学习如何创建计算字段、表计算、过滤器和参数以增强数据交互性，并掌握数据结构、地图数据的地理可视化以及利用分析面板汇总、建模和自定义数据，包括创建细节级别（LOD）计算。 领域三：创建内容 学生将学习如何从零开始创建各种图表（如条形图、折线图、饼图等），设计仪表板和故事，并向仪表板添加交互性元素。此外，还将涵盖工作簿和仪表板的格式化以及自定义设计。 领域四：在 Tableau Server 和 Tableau Cloud 上发布与管理内容 涉及到如何发布工作簿与数据源、调度数据更新以及管理已发布的工作簿，包括创建警报、订阅和自定义视图等。 本课程为学习者提供了系统化的知识和实用技能，使其能够熟练使用 Tableau 进行数据分析和报告，从而为获取数据分析师认证做好充分的准备。
Domain 1: Connect to and Transform Data1.1 Connect to data sources1.1.1. Identify data source1.1.2. Determine live connection vs. extract1.1.3. Connect to extracts1.1.4. Connect to files1.1.5. Connect to relational databases1.1.6. Connect to published data sources from a Tableau Server or Tableau Cloud site1.1.7. Replace the connected data source with another data source for an existing chart or sheet1.2. Prepare data for analysis1.2.1. Assess data quality (completeness, consistency, accuracy)1.2.2. Perform cleaning operations1.2.3. Organize data fields into folders1.2.4. Use multiple data sources (establish relationships, create joins, union tables)1.2.5. Prepare data by using Data Interpreter, pivot, and split1.2.6. Create extract and data source filters1.3. Perform data transformation in Tableau Prep1.3.1. Choose which data transformation to perform based on a business scenario1.3.2. Combine data by using unions1.3.3. Combine data by using joins1.3.4. Shape data by using aggregations1.3.5. Perform filtering1.3.6. Shape data by using pivots1.3.7. Determine which output type to use1.4. Customize fields1.4.1. Change default field properties (types, sorting, etc.)1.4.2. Rename columns1.4.3. Choose when to convert between discrete and continuous1.4.4. Choose when to convert between dimension and measure1.4.5. Create aliasesDomain 2: Explore and Analyze Data2.1. Create calculated fields2.1.1. Write date calculations2.1.2. Write string functions2.1.3. Write logical and Boolean expressions2.1.4. Write number functions2.1.5. Write type conversion functions2.1.6. Write aggregate functions2.1.7. Write basic spatial calculations2.3. Create table calculations2.3.1. Moving average and window average2.3.2. Percent of total2.3.3. Running total2.3.4. Difference and percent of difference2.3.5. Percentile2.3.6. Index2.3.7. Ranking2.3.8. Apply quick table calculations2.3.9. Customize table calculations2.4. Create and use filters2.4.1. Apply filters to dimensions and measures2.4.2. Configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional2.4.3. Add filters to context2.4.4. Apply filters to multiple sheets and data sources2.5. Create parameters to enable interactivity2.5.1. In calculations2.5.2. With filters2.5.3. With reference lines2.5.4. Set parameters to dynamically refresh2.6. Structure the data2.6.1. Sets2.6.2. Bins2.6.3. Hierarchies2.6.4. Groups2.7. Map data geographically2.7.1. Create symbol maps2.7.2. Create density maps2.7.3. Create choropleth maps (filled maps)2.7.4. Create mark layers2.8. Summarize, model, and customize data by using the Analytics pane2.8.1. Totals and subtotals2.8.2. Reference lines2.8.3. Reference bands2.8.4. Average lines2.8.5. Trend lines2.8.6. Distribution bands2.8.7. Forecast by using default settings2.8.8. Customize a data forecasting model2.9. Create Level of Detail (LOD) calculations2.9.1. Write FIXED LOD calculations2.9.2. Write INCLUDE LOD calculations2.9.3. Write EXCLUDE LOD calculations2.9.4. Write nested LOD calculationsDomain 3: Create Content3.1. Create charts3.1.1. Create basic charts from scratch (bar, line, pie, highlight table, scatter plot, histogram, tree map, bubbles, data tables, Gantt, box plots, area, dual axis, combo)3.1.2. Sort data (including custom sort)3.2. Create dashboards and stories3.2.1. Combine sheets into a dashboard by using containers and layout options3.2.2. Add objects (containers, images, text)3.2.3. Create stories using story points3.3. Add interactivity to dashboards3.3.1. Use filter in a dashboard3.3.2. Add filter, URL, and highlight actions3.3.3. Create interactivity using dynamic zone visibility3.3.4. Add navigation buttons3.3.5. Create interactivity using set and parameter actions3.3.6 Create show/hide buttons for dashboard objects3.4. Format workbooks, worksheets, and dashboards3.4.1. Apply color, font, shapes, styling3.4.2. Add custom shapes and color palettes3.4.3. Add annotations3.4.4. Customize tooltips3.4.5. Apply padding3.4.6. Format gridlines, row-level and column-level bands, and shading3.4.7. Create a responsive design for specific device layoutsDomain 4: Publish and Manage Content on Tableau Server and Tableau Cloud4.1. Publish Content4.1.1. Publish a workbook4.1.2. Publish a data source from Desktop or Prep4.1.3. Export content4.1.4. Publish a flow4.2. Schedule data updates4.2.1. Schedule data extract refreshes4.3. Manage published workbooks4.3.1. Create alerts4.3.2. Create subscriptions4.3.3. Create and save custom views4.3.4. Understand user roles and permissions4.3.5. Customize and distribute a published workbook
