Power BI Case Study
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Course Introduction
Course Introduction
In this lesson, we'll introduce the Software as a Service (SaaS) company Interslice. We'll outline how the company works and discuss the areas we will be analyzing as part of this course.
Introducing the Data
Introducing the Data
The data for the course is contained in an Excel file containing three tables of data. We'll explain the dataset in detail and import it into Power BI Desktop in this lesson.
Exploring the Dataset
Exploring the Dataset
In this lesson, we'll create several charts that give us some insights into the dataset. Specifically, we'll analyze the customer distribution of the company by several different variables
Initial MRR Analysis
Initial MRR Analysis
In this lesson, we'll start analyzing Monthly Recurring Revenue (MRR), the key revenue measure for a SaaS company. We'll analyze MRR development by location, and by the different plans offered.
Breaking Down Changes in MRR
Breaking Down Changes in MRR
There are several different components of MRR for Interslice. In this lesson, we'll create a report allowing users to analyze each of these components individually
Evaluating Growth Trends
Evaluating Growth Trends
The success of a SaaS company can be considered in terms of customer numbers or revenue. We'll create charts tracking changes in both of these metrics in this lesson.
Tracking MRR Changes
Tracking MRR Changes
It's often useful to create a report that viewers, such as managers or clients, can easily interact with to generate insights of interest to them. We'll create a waterfall chart for this purpose in this lesson.
Comparing Customer Sign-Up Trends
Comparing Customer Sign-Up Trends
In the next few lessons, we'll analyze the customers of Interslice. In this lesson, we'll analyze past sign-up trends to see when new customers are most likely to sign-up.
Analyzing Customer Tenure
Analyzing Customer Tenure
For a subscription business, maximizing tenure, or the length of time a customer subscribes for before leaving is critical. In this lesson, we'll analyze the tenure length of customers of Interslice.
Cohort Analysis
Cohort Analysis
Cohort analysis breaks customers up into groups that share a common characteristic and compares these groups to each other. In this lesson, we'll analyze cohorts of customers who signed up in particular months, and compare churn rates for these cohorts.
Calculating Average Revenue per User
Calculating Average Revenue per User
Average Revenue per User (ARPU) measures how much a customer pays per license. Variations in ARPU can reflect discounts that are offered to larger customers on more expensive plans, which we'll analyze in this lesson.
Comparing Customer Distribution by Plan
Comparing Customer Distribution by Plan
Interslice wants larger customers to use its more expensive plans. In this lesson, we'll see if this is the case, by creating bins to analyze the number of users in a company.
