Practice Problems & Solutions
Have a go at these practice problems in Causal, which cover a range of different concepts - e.g. cohorts, scenarios, seasonality, views etc. All of it can be learnt by navigating our docs
🧙♂
- a company has 100 users on Jan 1 2022 and wants to model out the business for the next 2 years on a monthly basis
- 80% are on the pro plan and the rest on the business plan
- they expect a 10% MoM growth rate for the business plan and a 15% growth rate for the pro plan
- every December, there’s an additional 10% growth due to Xmas
- create a stacked bar chart to display the user growth over time
- add a scenario “No seasonality” in which you remove the Xmas growth
- compare the total user numbers of the two scenarios in a line chart
- create a Freeform visual that displays the difference between the two outcomes
- First learn about cohort modeling in Causal
- a company gets 100 new users each month
- create a 3 year monthly Causal model
- after the first month 30% cancel, in the next month 10% cancel, next month another 10%, after that every month 1% cancel
- create a cohort model showing the size of each cohort over time
- each user pays $10/month — calculate the total revenue over time
- create a scenario called “trial period” in which new users don’t pay for the first month
- compare the two scenarios on a chart
- compare them on a table
- create the following categories:
- country: UK, US, Singapore, Germany, Switzerland
- region: US, Europe, Asia
- team: Engineering, Sales
- map countries to regions
- create an “Initial Employees” variable explicitly broken down by country and team and add some dummy numbers
- create a growth rate variable split by region (20% in Asia and 10% outside of Asia)
- create a "Running headcount" variable that takes the Initial Employees in month 1 of the model, then grows by the growth rate for future months
- create a table and show the employees by country and team
- create a variable that groups the employees by region and team, and a table that shows this
- create a “salary per employee” variable: 100 for sales, 100 for eng
- compute the total salary over time
- apply a 10% bonus in US and a 5% bonus outside of US
- clone model 3
- create a google sheet and load the first 4 months of employee counts from a google sheet
- create a version called “Month 4”
- add another month to the google sheet, refresh the datasource
- create a table that compares the forecast from the version with the new data (show the table by region and team)
- clone model 4
- invite someone to your team
- create a view that only shows the US numbers and share it with your team (read only)
- create a private link to the model and open it in an incognito tab to see what the dashboard view looks like
- make sure the bonus variable is in the input section so it’s editable in the dashboard
Last modified 11mo ago