|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/saas-data-analytics-with-excel/
课程评论：没有评论
课程名称：Excel数据分析：面向SaaS和软件公司 课程概述：欢迎参加面向SaaS和软件公司的Excel数据分析课程。本课程的目标是学习如何使用Excel分析数据，提取洞察，识别趋势，并在演示中传达您的发现，重点关注与SaaS相关的分析以及实践操作。如果您在科技、软件或SaaS公司工作，并且在工作中进行数据分析，那么您来对地方了。我们将专注于您在工作中遇到的实际问题和分析。 本课程的重点是软件公司特定的分析。您将学习如何利用数据分析预订、年重复收入（ARR）、平均售价（ASP）、客户保留率、客户分析、销售生产力、预测建模等。我们将逐步引导您完成从头到尾的分析过程。在此过程中，我们还将向您展示一些Excel的快捷键和技巧，以使您的工作更轻松。每个部分结束时都会有练习题，您可以针对类似但略有不同的问题进行练习，以测试您的技能。 在整个课程中，我们将使用一个主数据集，从而模拟处理和产生各种分析的现实体验。完成本课程后，您将能够操控原始数据，分析财务和运营数据，创建透视表，构建汇总表，添加分析趋势的指标，创建有效的图表，格式化演示文稿图表，构建包含见解的幻灯片，并为SaaS公司进行简单的预测。 本课程为提升您的学习体验提供了以下内容： - 高质量的视频 - 教程/演示 - 包含模板和解决方案的数据文件 - Excel快捷键和技巧 准备好后，让我们开始吧。我期待与您一起学习。欢迎加入！ 课程内容概览： - 课程欢迎 - 课程工作簿和支持文件 - Excel设置和技巧 - 预订分析 - 年重复收入分析 - 客户分析 - 平均售价（ASP）分析 - 销售生产力分析 - 预测概述 - 预测方法概述和演示 涵盖的主题包括预订分析、ARR和客户分析等，重点关注通过Excel工具完成的实际数据分析任务。
Welcome to Data Analytics with Excel for SaaS & Software Companies. The goal of this course is to learn how to use Excel to analyze data, draw insights, identify trends, and communicate your findings in a presentation, with an emphasis on SaaS-related analyses and a hands-on approach. If you are working at a technology, software or SaaS company, and you do data analysis as part of your job, you have come to the right place.We are going to focus on the practical problems and analyses that you will encounter on your job.This course focuses on analyses specific for software companies. We will learn how to use data to analyze bookings, Annual Recurring Revenue or ARR, Average Selling Price (or ASP), retention rate, customer analysis, sales productivity, forecast modeling, and more.We will walk you through the analysis step-by-step from start to finish. Along the way, we will show you keyboard shortcuts and Excel tricks that will make your job easier.At the end of each section, there are practice exercises for you to work on similar but slightly different problems so you can test your skills.For all the analyses in the entire course, we will use one master dataset, so it simulates a real-life experience on how to handle and produce various analysis from a rich data set.By the end of this course, you will be able to:manipulate raw data, analyze financial and operational data, create pivot tables, build summary tables, add metrics to analyze trends, create effective graphs, format charts for presentations, build slides with insights, and perform simple forecasting for SaaS Companies.This course is packed with the following to enhance your learning:High quality videosTutorials/DemosData files with template and solutions ExercisesExcel keyboard shortcuts and tipsWhenever you are ready, let's jump right in. I'm looking forward to spending some time with you. Welcome!*************************Course Content OverviewCourse WelcomeCourse Workbook and Supporting FilesExcel Setup & TipsBookings AnalysisBookings - Section IntroBookings - Examine Raw DataBookings - Create Pivot TablesBookings - Build Summary TablesBookings - Build Bookings ChartsBookings - Build Presentation SlidesExercise: Bookings AnalysisARR AnalysisARR - Intro to Annual Recurring Revenue ConceptsARR - Stage ARR DataARR - Build Customer ListARR - Build ARR By Customer SummaryARR - Calculate New/Expand/Downsell/ChurnARR - Build ARR Summary TableARR - Add Trended MetricsARR - Build ARR ChartsARR - Build Presentation SlidesExercise: ARR AnalysisARR - Net Retention Rate Concepts IntroARR - Net Retention Rate AnalysisARR - Term Length AnalysisCustomer AnalysisCustomer AnalysisCustomer Trend MetricsCustomer Trends - ChartsAverage Selling Price (ASP) - IntroAverage Selling Price (ASP) - CalculationAverage Selling Price (ASP) - ChartsSales Productivity AnalysisSales Productivity - Analysis Sales Productivity - ChartsForecast OverviewForecasting Methodology OverviewForecasting DemoExercise: Forecast
