Tableau Data Analyst Certification Preparation

via Udemy

Go to Course: https://www.udemy.com/course/tableau-data-analyst-certification-preparation/

Overview

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

Skills

Reviews