Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Other Office Productivity Big Data

Tableau高级分析: LOD表达式与TC表计算

——原理详解与25个案例解读
Bestseller
Rating: 5.0 out of 55.0 (67 ratings)
244 students
Created by 喜乐君 Wu
Last updated 10/2020
Simplified Chinese
30-Day Money-Back Guarantee

What you'll learn

  • 理解LOD-详细级别
  • Tableau的多种详细级别及其表达式
  • Fixed /include/exclude LOD的语法与用法
  • 15大详细级别表达式的解读
  • 表计算的逻辑和10大案例解读

Requirements

  • 熟悉Tableau Desktop的基本使用
  • 使用过Tableau的基本计算

Description

Tableau的高级分析以LOD为代表。依赖于最受欢迎的中文LOD博客全新升级而成,从“非IT”的视角出发,建立了广义LOD的概念和体系,帮助Tableau业务分析师理解并使用高级分析表达式。

全新思路:广义LOD和狭义LOD的区分;三类六种LOD表达式划分;可视化分析的四个步骤;从LOD的角度理解大数据分析。增加表计算逻辑与10大表计算过程。

Who this course is for:

  • Tableau中高级用户
  • 大数据业务分析用户
  • 期望参加Tableau认证考试的用户

Course content

6 sections • 40 lectures • 9h 44m total length

  • Preview23:36
  • 精简版-行级别计算与聚合计算的差异
    14:23

  • Preview12:02
  • Preview22:01
  • 狭义LOD表达式——Fixed LOD的三种情形 V2.0
    14:51
  • LOD表达式——独立视图聚合级别Include/exclude
    21:35
  • LOD表达式——终极总结
    17:26
  • 使用LOD的五个建议
    15:16
  • 使用Fixed LOD做会员RFM_L分析
    25:31

  • 15大LOD-1 忠诚度分析之客户购买频次
    15:35
  • 15大LOD-2 忠诚度分析之矩阵分析
    08:54
  • 15大LOD-3 Daily Profit KPI 每天的盈利标签
    10:33
  • 15大LOD-4 Percent of Total 全球占比
    07:11
  • 15大LOD-5随日期的新客户增长+表计算
    13:01
  • 15大LOD-6 标杆分析 增加参数动作
    17:51
  • 15大详细级别表达式-7 Average of Maximum-最大值的平均值与表计算
    20:44
  • 15大详细级别表达式-8 Profit Vs. Target--标靶图
    15:17
  • 15大详细级别表达式-9 Value on Last Day of a Period
    16:13
  • 15大详细级别表达式-10 Return Purchase by Cohort_复购分析
    11:27
  • 15大详细级别表达式-11区间差异 LOD和表计算方法
    13:07
  • 15大详细级别表达式-12 作为筛选器的LOD
    26:05
  • 15大详细级别表达式-13 Frequency访问频次的分布
    17:56
  • 15大详细级别表达式-14 比例刷 LOD和集动作方法
    14:52
  • 15大详细级别表达式-15 Purchase Frequency_购买频次和表计算
    17:45

  • TC表计算的差异性和独特性(通俗版) V2.1
    11:04
  • 理解表计算的逻辑(高级版)
    12:11
  • 表计算的逻辑:维度如何参与计算过程
    14:47
  • 表计算的逻辑2+:相对与绝对方向、范围 V1.1
    13:18
  • TC表计算函数:分类与介绍
    22:30

  • Preview16:16
  • TC2-Common Baseline- Toy Story 公共基准(index索引)
    08:26
  • TC3 -Percent of total sales over time (Multi-pass aggregation)-多遍聚合
    06:03
  • TC4-Bump-Chart凹凸图(rank排序)
    12:03
  • TC 5 running 汇总 -两种方法
    12:00
  • TC6-Weighted-Average加权平均
    06:27
  • TC7-Grouping-by-Calc 按计算分组
    03:43
  • TC9-Moving-Average 移动平均
    05:04
  • TC10-Difference-from-average 与平均值的差异
    05:23
  • 高难TC8 Number of Incidents Over a Moving Range 窗口计算
    26:57

  • 购物篮连带分析
    15:33

Instructor

喜乐君 Wu
Tableau传道士
喜乐君 Wu
  • 4.8 Instructor Rating
  • 87 Reviews
  • 286 Students
  • 2 Courses

Tableau Partner, Tableau Desktop and Server QA Certification

《数据可视化分析:Tableau原理与实践》作者(喜乐君)

山东大学法学学士、教育学硕士,Tableau 重要合作伙伴;多年业务经验,从熟练使用Excel,如今到Tableau,期望帮助更多人,特别是业务用户,从数据统计走向大数据分析。

做Tableau的深度解读和传道者,而非搬运工。

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.