|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dynamic-dashboards-and-data-analysis-with-google-data-studio/
课程评论：没有评论
**课程名称：** 使用 Looker Studio 动态创建仪表板和进行数据分析 **课程概述：** 本课程将带您学习如何使用 Google Looker Studio（原 Google Data Studio）构建强大的数据可视化仪表板，从而解锁数据洞察，帮助您为客户或雇主驱动业务成果。课程内容兼顾数据分析的基础知识与实践操作，从聚合、数据透视表、计算字段、数据混合等关键概念入手，深入到实际项目： * **项目一：** 使用 Google Analytics 创建用户行为漏斗 * **项目二：** 利用用户级别数据创建设备细分可视化 * **全新挑战：** 10 分钟仪表板构建比拼，并获得讲师及同学的反馈 **课程学习目标：** * 熟练掌握和理解课程中介绍的所有图表类型，如子弹图、饼图、记分卡、散点图等。 * 连接和混合来自 Google Analytics 和 Google Sheets 的数据源。 * 创建包含条件表达式（CASE、REGEXP_MATCH、IN）的自定义维度。 * 基于 Google Analytics 的“页面标题”维度构建用户行为漏斗。 * 创建设备细分可视化，并通过散点图探索用户级别数据（电子商务）。 * 基于特定的 SQL 查询创建 Google BigQuery 表，并在 Looker Studio 中进行可视化。 * 利用滚动日期和交互式过滤器创建时间序列图表。 * 配置仪表图以跟踪绩效与特定目标或 KPI。 * 通过高级日期选择过滤器自动化报表。 * 理解 Looker Studio 中的访问权限级别（“所有者”与“查看者”）。 * 应用条件格式规则来标记数据异常。 * 在 Looker Studio 中提取报表主题和配色方案（从图像）。 * 在 CASE 语句中使用 IF 语句和运算符。 **学员评价：** * “课程节奏很棒，我可以使用提供的数据文件和 Google Analytics 演示账户跟上所有练习。” - Tricia * “这门课程太棒了。讲师在内容讲解上清晰且重点突出。Lachezar 从一个完全的初学者层面，将我带到了能够实际构建仪表板并理解数据科学工作原理的水平。视频内容相对于我获得的价值而言，篇幅之短令我惊讶。如果您深入研究并自己重现课程中的每一个步骤（和仪表板），这会轻松花费您 10-15 小时的工作量。这是一门没有冗余、内容更新、讲师支持良好的课程，我强烈推荐大家学习。” - Roi * “这门课程完成得非常好，清晰且富有洞察力。我将从今天开始使用 Data Studio。” - Silvia **讲师介绍：** Lachezar Arabadzhiev 是一位数字营销专家，在绩效分析和数据可视化方面拥有 4 年以上经验。他曾是微软的数字营销专员，之后转向衡量与分析领域，并有机会与加拿大航空、RBC、Kimberly-Clark、Mazda 和 HSBC 等知名品牌合作。Lachezar 自 2017 年初开始使用 Data Studio 和 BigQuery，构建了各种各样的可视化图表和自动化流程，从整合 GMP 数据源（Google Analytics 360、Campaign Manager 和 Display & Video 360）的绩效仪表板，到包含用户级别电子商务数据的受众细分视图。Lachezar 是 GMP 专家认证，也是 2018 年加拿大 Google 数据与分析峰会的官方演讲者。 **课程附加福利：** 本课程包含每个环节的自定义 Google Sheets 数据集、一本 Data Studio 解决方案手册，以及完成课程后赠送的免费仪表板模板。课程提供 30 天不满意退款保证。
Welcome to Dynamic Dashboards and Data Analysis with Google Looker Studio! In this course, you will learn how to build powerful data visualizations and unlock insights that can help you drive business results for your clients or employers. This course aims to strike a balance between the foundations of data analysis and hands-on practical examples. The course starts with an introductory view of key concepts such as aggregation, pivot tables, calculated fields, data blending and then dives into real-world projects, including:Project 1: Create a User Journey Funnel with Google AnalyticsProject 2: Create a device breakdown visualization with user-level dataNEW* Dashboard Building Challenge: Create a dashboard in 10 minutes and get feedback from the instructor and/or your fellow students! (Assignment)By the end of the course, you will be able to:Use and understand all chart types throughout the course (Bullets, Pie Charts, Scorecards, Scatter plot and etc.)Connect and blend data sources from Google Analytics and Google SheetsCreate custom dimensions with conditional expressions (CASE + REGEXP_MATCH + IN)Build a user journey funnel with Google Analytics data based on a "Page Title" dimensionCreate a device breakdown visualization and explore user-level data with scatter plot (eCommerece)Create a Google BigQuery table based on a specific SQL query and visualize it in Looker Studio, formerly Google Data StudioCreate time series with rolling dates and interaction filtersConfigure Gauge charts to track performance against a specific goal or KPIAutomate reports with advanced date selection filtersUnderstand the access levels in Looker Studio - "Owner" vs "Viewer"Apply conditional formatting rules to signal data anomalies Extract a report theme and colour scheme from an image in Looker Studio, formerly Google Data StudioApply IF statements within a CASE and use operatorsWhat are the students who took the course saying?"The pace of the course was great and I was able to follow along with all the exercises using the provided data files and Google Analytics demo account" - Tricia"The course is fantastic. The instructor was clear and on-point when it came to the content. Lachezar took me from a complete beginner to someone who can actually build dashboards and understand how DS works.I was blown away by how relatively short the video content was compared to the value I received - if you go beyond what's instructed and dive deep to recreate every single step (and dashboard) presented in this course yourself, it'll take you easily 10-15 hours of work to do.This is a no fluff course, updated, with great support from the instructor - I urge you to go for it." - Roi"This course has been very very done, clear and insightful. I will start to use Data studio from today on." - SilviaWho is the instructor? Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC.Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data.Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.BonusThe course includes custom Google Sheets data sets for each section, a Data Studio Solutions Manual and a FREE Dashboard Template upon completion of the course. And don't worry, if the course does not work out for you, you can always get your money back in 30 days.
