Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Data Analytics with Excel: For SaaS & Software Companies

Analyze Data, Create Charts and Build Effective Presentation Slides: A Step-by-Step Guide
0.0
0.0/5
(0 reviews)
1 students
Created by

9.9

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.3

Content

Platform: Udemy
Video: 2h 53m
Language: English
Next start: On Demand

Top Data Analysis courses:

Detailed Analysis

CourseMarks Score®

9.9 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 6/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.3 / 10
Video Score: 8.0 / 10
The course includes 2h 53m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

2 articles.
3 resources.
0 exercise.
0 test.

Table of contents

Description

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 videos
•Tutorials/Demos
•Data files with template and solutions
•Exercises
•Excel keyboard shortcuts and tips
Whenever you are ready, let’s jump right in. I’m looking forward to spending some time with you. Welcome!
*************************
Course Content
Overview
•Course Welcome
•Course Workbook and Supporting Files
•Excel Setup & Tips
Bookings Analysis
•Bookings – Section Intro
•Bookings – Examine Raw Data
•Bookings – Create Pivot Tables
•Bookings – Build Summary Tables
•Bookings – Build Bookings Charts
•Bookings – Build Presentation Slides
•Exercise: Bookings Analysis
ARR Analysis
•ARR – Intro to Annual Recurring Revenue Concepts
•ARR – Stage ARR Data
•ARR – Build Customer List
•ARR – Build ARR By Customer Summary
•ARR – Calculate New/Expand/Downsell/Churn
•ARR – Build ARR Summary Table
•ARR – Add Trended Metrics
•ARR – Build ARR Charts
•ARR – Build Presentation Slides
•Exercise: ARR Analysis
•ARR – Net Retention Rate Concepts Intro
•ARR – Net Retention Rate Analysis
•ARR – Term Length Analysis
Customer Analysis
•Customer Analysis
•Customer Trend Metrics
•Customer Trends – Charts
•Average Selling Price (ASP) – Intro
•Average Selling Price (ASP) – Calculation
•Average Selling Price (ASP) – Charts
Sales Productivity Analysis
•Sales Productivity – Analysis
•Sales Productivity – Charts
Forecast Overview
•Forecasting Methodology Overview
•Forecasting Demo
•Exercise: Forecast

You will learn

✓ Excel for data analysis
✓ Manipulate raw data
✓ Analyze financial and operational data
✓ Advanced IF formulae (multiple IFs, SUMIFs, COUNTIFs)
✓ Create pivot tables
✓ Build summary tables
✓ Analyze metrics trends
✓ Create effective graphs
✓ Format charts for quality presentations
✓ Simple forecasting
✓ SaaS / Software Company Analysis
✓ Bookings, ARR, Customer Analysis

Requirements

• Basic knowledge of Excel
• Basic knowledge of Google Slides
• Basic knowledge of SaaS / enterprise software metrics

This course is for

• Data analysts that need to perform sales, operation and financial analysis
• Beginner Excel users looking to learn complex analysis
• Managers at SaaS / Software companies that need to present data to executives

How much does the Data Analytics with Excel: For SaaS & Software Companies course cost? Is it worth it?

The course costs $14.99. And currently there is a 82% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.

Does the Data Analytics with Excel: For SaaS & Software Companies course have a money back guarantee or refund policy?

YES, Data Analytics with Excel: For SaaS & Software Companies has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Data Analytics with Excel: For SaaS & Software Companies course, but there is a $70 discount from the original price ($84.99). So the current price is just $14.99.

Who is the instructor? Is Jimmy Chim a SCAM or a TRUSTED instructor?

Jimmy Chim has created 4 courses that got 645 reviews which are generally positive. Jimmy Chim has taught 3,284 students and received a 4.6 average review out of 645 reviews. Depending on the information available, Jimmy Chim is a TRUSTED instructor.
SaaS, Cloud & Software | Finance, Strategy & Data Analytics
Built on 10+ years of finance, consulting and strategy experience working in Silicon Valley, my courses are focused on:
· SaaS / Software Business Strategy & Operations Management
· Data Analytics
· Microsoft Excel / Google Sheet
· Microsoft PowerPoint / Google Slides
· Cloud Financial Management
My approach is to make complex topics simple to understand, and teach through real life examples so you can apply the skills on your job.

9.9

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.3

Content

Platform: Udemy
Video: 2h 53m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Data Analytics with Excel: For SaaS & Software Companies rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/data-analytics-with-excel-for-saas-software-companies/" target="_blank" title="Data Analytics with Excel: For SaaS & Software Companies on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/99.svg" width="200px" alt="Data Analytics with Excel: For SaaS & Software Companies rating"/></a>