case study challenge solution

DEV Community

Posted on Oct 12, 2022

8 Week SQL Challenge: Case Study #2 Pizza Runner

Introduction

Danny was scrolling through his Instagram feed when something really caught his eye — “80s Retro Styling 🎸 and Pizza 🍕 Is The Future!”

Danny was sold on the idea, but he knew that pizza alone was not going to help him get seed funding to expand his new Pizza Empire — so he had one more genius idea to combine with it — he was going to Uberize it — and so Pizza Runner was launched!

Danny started by recruiting “runners” to deliver fresh pizza from Pizza Runner Headquarters (otherwise known as Danny’s house) and also maxed out his credit card to pay freelance developers to build a mobile app to accept orders from customers.

Table Relationship

• customer_orders — Customers’ pizza orders with 1 row each for individual pizza with topping exclusions and extras, and order time.
• runner_orders — Orders assigned to runners documenting the pickup time, distance and duration from Pizza Runner HQ to customer, and cancellation remark. runners — Runner IDs and registration date
• pizza_names — Pizza IDs and name
• pizza_recipes — Pizza IDs and topping names
• pizza_toppings — Topping IDs and name

Case Study Questions

This case study has LOTS of questions — they are broken up by area of focus including:

A. Pizza Metrics

B. runner and customer experience, c. ingredient optimisation, d. pricing and ratings.

• E. Bonus DML Challenges (DML = Data Manipulation Language)

Data Cleaning and Transformation

Before I start with the solutions, I investigate the data and found that there are some cleaning and transformation to do, specifically on the

• null values and data types in the customer_orders table
• null values and data types in the runner_orders table
• Alter data type in pizza_names table

Firstly, to clean up exclusions and extras in the customer_orders — we create TEMP TABLE #customer_orders and use CASE WHEN.

Then, we clean the runner_orders table with CASE WHEN and TRIM and create TEMP TABLE #runner_orders .

In summary,

• pickup_time — Remove nulls and replace with ‘ ‘
• distance — Remove ‘km’ and nulls
• duration — Remove ‘minutes’ and nulls
• cancellation — Remove NULL and null and replace with ‘ ‘

Then, we alter the date according to its correct data type.

• pickup_time to DATETIME type
• distance to FLOAT type
• duration to INT type

Now that the data has been cleaned and transformed, let’s move on solving the questions! 😉

How many pizzas were ordered?

• Total pizzas ordered are 14.
• How many unique customer orders were made?

• There are 10 unique customer orders made.
• How many successful orders were delivered by each runner?

• Runner 1 has 4 successful delivered orders.
• Runner 2 has 3 successful delivered orders.
• Runner 3 has 1 successful delivered order.
• How many of each type of pizza was delivered?

• There are 9 delivered Meatlovers pizzas.
• There are 3 delivered Vegetarian pizzas.
• How many Vegetarian and Meatlovers were ordered by each customer?

• Customer 101 ordered 2 Meatlovers pizzas and 1 Vegetarian pizza.
• Customer 102 ordered 2 Meatlovers pizzas and 2 Vegetarian pizzas.
• Customer 103 ordered 3 Meatlovers pizzas and 1 Vegetarian pizza.
• Customer 104 ordered 1 Meatlovers pizza.
• Customer 105 ordered 1 Vegetarian pizza.
• What was the maximum number of pizzas delivered in a single order?

• Maximum number of pizza delivered in a single order is 3 pizzas.
• For each customer, how many delivered pizzas had at least 1 change and how many had no changes?

• Customer 101 and 102 likes his/her pizzas per the original recipe.
• Customer 103, 104 and 105 have their own preference for pizza topping and requested at least 1 change (extra or exclusion topping) on their pizza.
• How many pizzas were delivered that had both exclusions and extras?

• Only 1 pizza delivered that had both extra and exclusion topping. That’s one fussy customer!
• What was the total volume of pizzas ordered for each hour of the day?

• Highest volume of pizza ordered is at 13 (1:00 pm), 18 (6:00 pm) and 21 (9:00 pm).
• Lowest volume of pizza ordered is at 11 (11:00 am), 19 (7:00 pm) and 23 (11:00 pm).
• What was the volume of orders for each day of the week?

• There are 5 pizzas ordered on Friday and Monday.
• There are 3 pizzas ordered on Saturday.
• There is 1 pizza ordered on Sunday.

How many runners signed up for each 1 week period? (i.e. week starts 2021-01-01)

• On Week 1 of Jan 2021, 2 new runners signed up.
• On Week 2 and 3 of Jan 2021, 1 new runner signed up.
• What was the average time in minutes it took for each runner to arrive at the Pizza Runner HQ to pickup the order?

• The average time taken in minutes by runners to arrive at Pizza Runner HQ to pick up the order is 15 minutes.
• Is there any relationship between the number of pizzas and how long the order takes to prepare?

• On average, a single pizza order takes 12 minutes to prepare.
• An order with 3 pizzas takes 30 minutes at an average of 10 minutes per pizza.
• It takes 16 minutes to prepare an order with 2 pizzas which is 8 minutes per pizza — making 2 pizzas in a single order the ultimate efficiency rate.
• What was the average distance travelled for each customer?

(Assuming that distance is calculated from Pizza Runner HQ to customer’s place)

• Customer 104 stays the nearest to Pizza Runner HQ at average distance of 10km, whereas Customer 105 stays the furthest at 25km.
• What was the difference between the longest and shortest delivery times for all orders?

Firstly, let’s see all the durations for the orders.

Then, we find the difference by deducting the shortest (MIN) from the longest (MAX) delivery times.

• The difference between longest (40 minutes) and shortest (10 minutes) delivery time for all orders is 30 minutes.
• What was the average speed for each runner for each delivery and do you notice any trend for these values?

(Average speed = Distance in km / Duration in hour)

• Runner 1’s average speed runs from 37.5km/h to 60km/h.
• Runner 2’s average speed runs from 35.1km/h to 93.6km/h. Danny should investigate Runner 2 as the average speed has a 300% fluctuation rate!
• Runner 3’s average speed is 40km/h
• What is the successful delivery percentage for each runner?

• Runner 1 has 100% successful delivery.
• Runner 2 has 75% successful delivery.

Runner 3 has 50% successful delivery (It’s not right to attribute successful delivery to runners as order cancellations are out of the runner’s control.)

I will continue with Part A, B and C soon!

What are the standard ingredients for each pizza?

What was the most commonly added extra?

What was the most common exclusion?

Generate an order item for each record in the customers_orders table in the format of one of the following:

Meat Lovers

Meat Lovers - Exclude Beef

Meat Lovers - Extra Bacon

Meat Lovers - Exclude Cheese, Bacon - Extra Mushroom, Peppers

• Generate an alphabetically ordered comma separated ingredient list for each pizza order from the customer_orders table and add a 2x in front of any relevant ingredients

For example: "Meat Lovers: 2xBacon, Beef, ... , Salami"

• What is the total quantity of each ingredient used in all delivered pizzas sorted by most frequent first?

If a Meat Lovers pizza costs $12 and Vegetarian costs $10 and there were no charges for changes — how much money has Pizza Runner made so far if there are no delivery fees? What if there was an additional $1 charge for any pizza extras?

• Add cheese is $1 extra

The Pizza Runner team now wants to add an additional ratings system that allows customers to rate their runner, how would you design an additional table for this new dataset — generate a schema for this new table and insert your own data for ratings for each successful customer order between 1 to 5.

Using your newly generated table — can you join all of the information together to form a table which has the following information for successful deliveries?

• customer_id
• runner_id - rating - order_time
• pickup_time
• Time between order and pickup
• Delivery duration
• Average speed
• Total number of pizzas
• If a Meat Lovers pizza was $12 and Vegetarian $10 fixed prices with no cost for extras and each runner is paid $0.30 per kilometre travelled — how much money does Pizza Runner have left over after these deliveries?

E. Bonus Questions If Danny wants to expand his range of pizzas — how would this impact the existing data design? Write an INSERT statement to demonstrate what would happen if a new Supreme pizza with all the toppings was added to the Pizza Runner menu?

Top comments (2)

Templates let you quickly answer FAQs or store snippets for re-use.

• Location Uj
• Work SQL developer at Independent
• Joined May 5, 2019

I've not read the whole article (too long!) But your first two code blocks could have been achieved using ISNULL(), REPLACE() and CAST() and avoided the CASE statements and ALTER column types. Cleaner code and less steps.

• Joined Jan 15, 2022

Hi Aaron thanks for your suggestion, i'm just started MySql .

Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink .

Hide child comments as well

For further actions, you may consider blocking this person and/or reporting abuse

Day 3: Diving into Spring Security

Waldy - Aug 11

Mastering React Router Hooks: A Comprehensive Guide

Vishal Yadav - Aug 23

Migrating Guide: RDS for MySQL to Aurora

Atsushi Suzuki - Aug 10

GenAI for dummies

Neha Sharma - Aug 22

We're a place where coders share, stay up-to-date and grow their careers.

Business growth

Marketing tips

16 case study examples (+ 3 templates to make your own)

I like to think of case studies as a business's version of a resume. It highlights what the business can do, lends credibility to its offer, and contains only the positive bullet points that paint it in the best light possible.

Imagine if the guy running your favorite taco truck followed you home so that he could "really dig into how that burrito changed your life." I see the value in the practice. People naturally prefer a tried-and-true burrito just as they prefer tried-and-true products or services.

To help you showcase your success and flesh out your burrito questionnaire, I've put together some case study examples and key takeaways.

What is a case study?

A case study is an in-depth analysis of how your business, product, or service has helped past clients. It can be a document, a webpage, or a slide deck that showcases measurable, real-life results.

For example, if you're a SaaS company, you can analyze your customers' results after a few months of using your product to measure its effectiveness. You can then turn this analysis into a case study that further proves to potential customers what your product can do and how it can help them overcome their challenges.

It changes the narrative from "I promise that we can do X and Y for you" to "Here's what we've done for businesses like yours, and we can do it for you, too."

16 case study examples 

While most case studies follow the same structure, quite a few try to break the mold and create something unique. Some businesses lean heavily on design and presentation, while others pursue a detailed, stat-oriented approach. Some businesses try to mix both.

There's no set formula to follow, but I've found that the best case studies utilize impactful design to engage readers and leverage statistics and case details to drive the point home. A case study typically highlights the companies, the challenges, the solution, and the results. The examples below will help inspire you to do it, too.

1. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Volcanica Coffee and AdRoll

People love a good farm-to-table coffee story, and boy am I one of them. But I've shared this case study with you for more reasons than my love of coffee. I enjoyed this study because it was written as though it was a letter.

In this case study, the founder of Volcanica Coffee talks about the journey from founding the company to personally struggling with learning and applying digital marketing to finding and enlisting AdRoll's services.

It felt more authentic, less about AdRoll showcasing their worth and more like a testimonial from a grateful and appreciative client. After the story, the case study wraps up with successes, milestones, and achievements. Note that quite a few percentages are prominently displayed at the top, providing supporting evidence that backs up an inspiring story.

Takeaway: Highlight your goals and measurable results to draw the reader in and provide concise, easily digestible information.

2. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Taylor Guitars and Airtable

This Airtable case study on Taylor Guitars comes as close as one can to an optimal structure. It features a video that represents the artistic nature of the client, highlighting key achievements and dissecting each element of Airtable's influence.

It also supplements each section with a testimonial or quote from the client, using their insights as a catalyst for the case study's narrative. For example, the case study quotes the social media manager and project manager's insights regarding team-wide communication and access before explaining in greater detail.

Takeaway: Highlight pain points your business solves for its client, and explore that influence in greater detail.

3. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} EndeavourX and Figma

My favorite part of Figma's case study is highlighting why EndeavourX chose its solution. You'll notice an entire section on what Figma does for teams and then specifically for EndeavourX.

It also places a heavy emphasis on numbers and stats. The study, as brief as it is, still manages to pack in a lot of compelling statistics about what's possible with Figma.

Takeaway: Showcase the "how" and "why" of your product's differentiators and how they benefit your customers.

4. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} ActiveCampaign and Zapier

Zapier's case study leans heavily on design, using graphics to present statistics and goals in a manner that not only remains consistent with the branding but also actively pushes it forward, drawing users' eyes to the information most important to them. 

The graphics, emphasis on branding elements, and cause/effect style tell the story without requiring long, drawn-out copy that risks boring readers. Instead, the cause and effect are concisely portrayed alongside the client company's information for a brief and easily scannable case study.

Takeaway: Lean on design to call attention to the most important elements of your case study, and make sure it stays consistent with your branding.

5. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Ironclad and OpenAI

In true OpenAI fashion, this case study is a block of text. There's a distinct lack of imagery, but the study features a narrated video walking readers through the product.

The lack of imagery and color may not be the most inviting, but utilizing video format is commendable. It helps thoroughly communicate how OpenAI supported Ironclad in a way that allows the user to sit back, relax, listen, and be impressed. 

Takeaway: Get creative with the media you implement in your case study. Videos can be a very powerful addition when a case study requires more detailed storytelling.

6. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Shopify and GitHub

GitHub's case study on Shopify is a light read. It addresses client pain points and discusses the different aspects its product considers and improves for clients. It touches on workflow issues, internal systems, automation, and security. It does a great job of representing what one company can do with GitHub.

To drive the point home, the case study features colorful quote callouts from the Shopify team, sharing their insights and perspectives on the partnership, the key issues, and how they were addressed.

Takeaway: Leverage quotes to boost the authoritativeness and trustworthiness of your case study. 

7 . .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Audible and Contentful

Contentful's case study on Audible features almost every element a case study should. It includes not one but two videos and clearly outlines the challenge, solution, and outcome before diving deeper into what Contentful did for Audible. The language is simple, and the writing is heavy with quotes and personal insights.

This case study is a uniquely original experience. The fact that the companies in question are perhaps two of the most creative brands out there may be the reason. I expected nothing short of a detailed analysis, a compelling story, and video content. 

Takeaway: Inject some brand voice into the case study, and create assets that tell the story for you.

8 . .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Zoom and Asana

Asana's case study on Zoom is longer than the average piece and features detailed data on Zoom's growth since 2020. Instead of relying on imagery and graphics, it features several quotes and testimonials. 

It's designed to be direct, informative, and promotional. At some point, the case study reads more like a feature list. There were a few sections that felt a tad too promotional for my liking, but to each their own burrito.

Takeaway: Maintain a balance between promotional and informative. You want to showcase the high-level goals your product helped achieve without losing the reader.

9 . .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Hickies and Mailchimp

I've always been a fan of Mailchimp's comic-like branding, and this case study does an excellent job of sticking to their tradition of making information easy to understand, casual, and inviting.

It features a short video that briefly covers Hickies as a company and Mailchimp's efforts to serve its needs for customer relationships and education processes. Overall, this case study is a concise overview of the partnership that manages to convey success data and tell a story at the same time. What sets it apart is that it does so in a uniquely colorful and brand-consistent manner.

Takeaway: Be concise to provide as much value in as little text as possible.

10. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} NVIDIA and Workday

The gaming industry is notoriously difficult to recruit for, as it requires a very specific set of skills and experience. This case study focuses on how Workday was able to help fill that recruitment gap for NVIDIA, one of the biggest names in the gaming world.

Though it doesn't feature videos or graphics, this case study stood out to me in how it structures information like "key products used" to give readers insight into which tools helped achieve these results.

Takeaway: If your company offers multiple products or services, outline exactly which ones were involved in your case study, so readers can assess each tool.

11. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} KFC and Contentful

I'm personally not a big KFC fan, but that's only because I refuse to eat out of a bucket. My aversion to the bucket format aside, Contentful follows its consistent case study format in this one, outlining challenges, solutions, and outcomes before diving into the nitty-gritty details of the project.

Say what you will about KFC, but their primary product (chicken) does present a unique opportunity for wordplay like "Continuing to march to the beat of a digital-first drum(stick)" or "Delivering deep-fried goodness to every channel."

Takeaway: Inject humor into your case study if there's room for it and if it fits your brand. 

12. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Intuit and Twilio

Twilio does an excellent job of delivering achievements at the very beginning of the case study and going into detail in this two-minute read. While there aren't many graphics, the way quotes from the Intuit team are implemented adds a certain flair to the study and breaks up the sections nicely.

It's simple, concise, and manages to fit a lot of information in easily digestible sections.

Takeaway: Make sure each section is long enough to inform but brief enough to avoid boring readers. Break down information for each section, and don't go into so much detail that you lose the reader halfway through.

13. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Spotify and Salesforce

Salesforce created a video that accurately summarizes the key points of the case study. Beyond that, the page itself is very light on content, and sections are as short as one paragraph.

I especially like how information is broken down into "What you need to know," "Why it matters," and "What the difference looks like." I'm not ashamed of being spoon-fed information. When it's structured so well and so simply, it makes for an entertaining read.

14. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Benchling and Airtable

Benchling is an impressive entity in its own right. Biotech R&D and health care nuances go right over my head. But the research and digging I've been doing in the name of these burritos (case studies) revealed that these products are immensely complex. 

And that's precisely why this case study deserves a read—it succeeds at explaining a complex project that readers outside the industry wouldn't know much about.

Takeaway: Simplify complex information, and walk readers through the company's operations and how your business helped streamline them.

15. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Chipotle and Hubble

The concision of this case study is refreshing. It features two sections—the challenge and the solution—all in 316 words. This goes to show that your case study doesn't necessarily need to be a four-figure investment with video shoots and studio time. 

Sometimes, the message is simple and short enough to convey in a handful of paragraphs.

Takeaway: Consider what you should include instead of what you can include. Assess the time, resources, and effort you're able and willing to invest in a case study, and choose which elements you want to include from there.

16. .css-12hxxzz-Link{all:unset;box-sizing:border-box;-webkit-text-decoration:underline;text-decoration:underline;cursor:pointer;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;outline-offset:1px;-webkit-text-fill-color:currentColor;outline:1px solid transparent;}.css-12hxxzz-Link[data-color='ocean']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='ocean']:hover{outline-color:var(--zds-text-link-hover, #2b2358);}.css-12hxxzz-Link[data-color='ocean']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='white']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='white']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='white']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='primary']{color:var(--zds-text-link, #3d4592);}.css-12hxxzz-Link[data-color='primary']:hover{color:var(--zds-text-link, #2b2358);}.css-12hxxzz-Link[data-color='primary']:focus{color:var(--zds-text-link-hover, #3d4592);outline-color:var(--zds-text-link-hover, #3d4592);}.css-12hxxzz-Link[data-color='secondary']{color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-color='secondary']:hover{color:var(--zds-gray-warm-5, #a8a5a0);}.css-12hxxzz-Link[data-color='secondary']:focus{color:var(--zds-gray-warm-1, #fffdf9);outline-color:var(--zds-gray-warm-1, #fffdf9);}.css-12hxxzz-Link[data-weight='inherit']{font-weight:inherit;}.css-12hxxzz-Link[data-weight='normal']{font-weight:400;}.css-12hxxzz-Link[data-weight='bold']{font-weight:700;} Hudl and Zapier

I may be biased, but I'm a big fan of seeing metrics and achievements represented in branded graphics. It can be a jarring experience to navigate a website, then visit a case study page and feel as though you've gone to a completely different website.

The case study is essentially the summary, and the blog article is the detailed analysis that provides context beyond X achievement or Y goal.

Takeaway: Keep your case study concise and informative. Create other resources to provide context under your blog, media or press, and product pages.

3 case study templates

Now that you've had your fill of case studies (if that's possible), I've got just what you need: an infinite number of case studies, which you can create yourself with these case study templates.

Case study template 1

If you've got a quick hit of stats you want to show off, try this template. The opening section gives space for a short summary and three visually appealing stats you can highlight, followed by a headline and body where you can break the case study down more thoroughly. This one's pretty simple, with only sections for solutions and results, but you can easily continue the formatting to add more sections as needed.

Case study template 2

For a case study template with a little more detail, use this one. Opening with a striking cover page for a quick overview, this one goes on to include context, stakeholders, challenges, multiple quote callouts, and quick-hit stats. 

Case study template 3

Whether you want a little structural variation or just like a nice dark green, this template has similar components to the last template but is designed to help tell a story. Move from the client overview through a description of your company before getting to the details of how you fixed said company's problems.

Tips for writing a case study

Examples are all well and good, but you don't learn how to make a burrito just by watching tutorials on YouTube without knowing what any of the ingredients are. You could , but it probably wouldn't be all that good.

Have an objective: Define your objective by identifying the challenge, solution, and results. Assess your work with the client and focus on the most prominent wins. You're speaking to multiple businesses and industries through the case study, so make sure you know what you want to say to them.

Focus on persuasive data: Growth percentages and measurable results are your best friends. Extract your most compelling data and highlight it in your case study.

Use eye-grabbing graphics: Branded design goes a long way in accurately representing your brand and retaining readers as they review the study. Leverage unique and eye-catching graphics to keep readers engaged. 

Simplify data presentation: Some industries are more complex than others, and sometimes, data can be difficult to understand at a glance. Make sure you present your data in the simplest way possible. Make it concise, informative, and easy to understand.

Use automation to drive results for your case study

A case study example is a source of inspiration you can leverage to determine how to best position your brand's work. Find your unique angle, and refine it over time to help your business stand out. Ask anyone: the best burrito in town doesn't just appear at the number one spot. They find their angle (usually the house sauce) and leverage it to stand out.

Case study FAQ

Got your case study template? Great—it's time to gather the team for an awkward semi-vague data collection task. While you do that, here are some case study quick answers for you to skim through while you contemplate what to call your team meeting.

What is an example of a case study?

An example of a case study is when a software company analyzes its results from a client project and creates a webpage, presentation, or document that focuses on high-level results, challenges, and solutions in an attempt to showcase effectiveness and promote the software.

How do you write a case study?

To write a good case study, you should have an objective, identify persuasive and compelling data, leverage graphics, and simplify data. Case studies typically include an analysis of the challenge, solution, and results of the partnership.

What is the format of a case study?

While case studies don't have a set format, they're often portrayed as reports or essays that inform readers about the partnership and its results. 

Related reading:

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

Hachem Ramki

Hachem is a writer and digital marketer from Montreal. After graduating with a degree in English, Hachem spent seven years traveling around the world before moving to Canada. When he's not writing, he enjoys Basketball, Dungeons and Dragons, and playing music for friends and family.

• Content marketing

Related articles

How to measure brand awareness: 9 key metrics to track

How to measure brand awareness: 9 key...

A social media audit template (and how to use it to perform an audit)

A social media audit template (and how to...

How Google AI Overview impacts 20 industries

How to use ChatGPT for copywriting and content ideation

How to use ChatGPT for copywriting and...

Improve your productivity automatically. Use Zapier to get your apps working together.

• Design for Business
• Most Recent
• Presentations
• Infographics
• Data Visualizations
• Forms and Surveys
• Video & Animation
• Case Studies
• Digital Marketing
• Design Inspiration
• Visual Thinking
• Product Updates
• Visme Webinars
• Artificial Intelligence

15 Real-Life Case Study Examples & Best Practices

Written by: Oghale Olori

Case studies are more than just success stories.

They are powerful tools that demonstrate the practical value of your product or service. Case studies help attract attention to your products, build trust with potential customers and ultimately drive sales.

It’s no wonder that 73% of successful content marketers utilize case studies as part of their content strategy. Plus, buyers spend 54% of their time reviewing case studies before they make a buying decision.

To ensure you’re making the most of your case studies, we’ve put together 15 real-life case study examples to inspire you. These examples span a variety of industries and formats. We’ve also included best practices, design tips and templates to inspire you.

Let’s dive in!

Table of Contents

What is a case study, 15 real-life case study examples, sales case study examples, saas case study examples, product case study examples, marketing case study examples, business case study examples, case study faqs.

• A case study is a compelling narrative that showcases how your product or service has positively impacted a real business or individual. 
• Case studies delve into your customer's challenges, how your solution addressed them and the quantifiable results they achieved.
• Your case study should have an attention-grabbing headline, great visuals and a relevant call to action. Other key elements include an introduction, problems and result section.
• Visme provides easy-to-use tools, professionally designed templates and features for creating attractive and engaging case studies.

A case study is a real-life scenario where your company helped a person or business solve their unique challenges. It provides a detailed analysis of the positive outcomes achieved as a result of implementing your solution.

Case studies are an effective way to showcase the value of your product or service to potential customers without overt selling. By sharing how your company transformed a business, you can attract customers seeking similar solutions and results.

Case studies are not only about your company's capabilities; they are primarily about the benefits customers and clients have experienced from using your product.

Every great case study is made up of key elements. They are;

• Attention-grabbing headline: Write a compelling headline that grabs attention and tells your reader what the case study is about. For example, "How a CRM System Helped a B2B Company Increase Revenue by 225%.
• Introduction/Executive Summary: Include a brief overview of your case study, including your customer’s problem, the solution they implemented and the results they achieved.
• Problem/Challenge: Case studies with solutions offer a powerful way to connect with potential customers. In this section, explain how your product or service specifically addressed your customer's challenges.
• Solution: Explain how your product or service specifically addressed your customer's challenges.
• Results/Achievements : Give a detailed account of the positive impact of your product. Quantify the benefits achieved using metrics such as increased sales, improved efficiency, reduced costs or enhanced customer satisfaction.
• Graphics/Visuals: Include professional designs, high-quality photos and videos to make your case study more engaging and visually appealing.
• Quotes/Testimonials: Incorporate written or video quotes from your clients to boost your credibility.
• Relevant CTA: Insert a call to action (CTA) that encourages the reader to take action. For example, visiting your website or contacting you for more information. Your CTA can be a link to a landing page, a contact form or your social media handle and should be related to the product or service you highlighted in your case study.

Now that you understand what a case study is, let’s look at real-life case study examples. Among these, you'll find some simple case study examples that break down complex ideas into easily understandable solutions.

In this section, we’ll explore SaaS, marketing, sales, product and business case study examples with solutions. Take note of how these companies structured their case studies and included the key elements.

We’ve also included professionally designed case study templates to inspire you.

1. Georgia Tech Athletics Increase Season Ticket Sales by 80%

Georgia Tech Athletics, with its 8,000 football season ticket holders, sought for a way to increase efficiency and customer engagement.

Their initial sales process involved making multiple outbound phone calls per day with no real targeting or guidelines. Georgia Tech believed that targeting communications will enable them to reach more people in real time.

Salesloft improved Georgia Tech’s sales process with an inbound structure. This enabled sales reps to connect with their customers on a more targeted level. The use of dynamic fields and filters when importing lists ensured prospects received the right information, while communication with existing fans became faster with automation.

As a result, Georgia Tech Athletics recorded an 80% increase in season ticket sales as relationships with season ticket holders significantly improved. Employee engagement increased as employees became more energized to connect and communicate with fans.

Why Does This Case Study Work?

In this case study example , Salesloft utilized the key elements of a good case study. Their introduction gave an overview of their customers' challenges and the results they enjoyed after using them. After which they categorized the case study into three main sections: challenge, solution and result.

Salesloft utilized a case study video to increase engagement and invoke human connection.

Incorporating videos in your case study has a lot of benefits. Wyzol’s 2023 state of video marketing report showed a direct correlation between videos and an 87% increase in sales.

The beautiful thing is that creating videos for your case study doesn’t have to be daunting.

With an easy-to-use platform like Visme, you can create top-notch testimonial videos that will connect with your audience. Within the Visme editor, you can access over 1 million stock photos , video templates, animated graphics and more. These tools and resources will significantly improve the design and engagement of your case study.

Simplify content creation and brand management for your team

• Collaborate on designs , mockups and wireframes with your non-design colleagues
• Lock down your branding to maintain brand consistency throughout your designs
• Why start from scratch? Save time with 1000s of professional branded templates

Sign up. It’s free.

2. WeightWatchers Completely Revamped their Enterprise Sales Process with HubSpot

WeightWatchers, a 60-year-old wellness company, sought a CRM solution that increased the efficiency of their sales process. With their previous system, Weightwatchers had limited automation. They would copy-paste message templates from word documents or recreate one email for a batch of customers.

This required a huge effort from sales reps, account managers and leadership, as they were unable to track leads or pull customized reports for planning and growth.

WeightWatchers transformed their B2B sales strategy by leveraging HubSpot's robust marketing and sales workflows. They utilized HubSpot’s deal pipeline and automation features to streamline lead qualification. And the customized dashboard gave leadership valuable insights.

As a result, WeightWatchers generated seven figures in annual contract value and boosted recurring revenue. Hubspot’s impact resulted in 100% adoption across all sales, marketing, client success and operations teams.

Hubspot structured its case study into separate sections, demonstrating the specific benefits of their products to various aspects of the customer's business. Additionally, they integrated direct customer quotes in each section to boost credibility, resulting in a more compelling case study.

Getting insight from your customer about their challenges is one thing. But writing about their process and achievements in a concise and relatable way is another. If you find yourself constantly experiencing writer’s block, Visme’s AI writer is perfect for you.

Visme created this AI text generator tool to take your ideas and transform them into a great draft. So whether you need help writing your first draft or editing your final case study, Visme is ready for you.

3. Immi’s Ram Fam Helps to Drive Over $200k in Sales

Immi embarked on a mission to recreate healthier ramen recipes that were nutritious and delicious. After 2 years of tireless trials, Immi finally found the perfect ramen recipe. However, they envisioned a community of passionate ramen enthusiasts to fuel their business growth.

This vision propelled them to partner with Shopify Collabs. Shopify Collabs successfully cultivated and managed Immi’s Ramen community of ambassadors and creators.

As a result of their partnership, Immi’s community grew to more than 400 dedicated members, generating over $200,000 in total affiliate sales.

The power of data-driven headlines cannot be overemphasized. Chili Piper strategically incorporates quantifiable results in their headlines. This instantly sparks curiosity and interest in readers.

While not every customer success story may boast headline-grabbing figures, quantifying achievements in percentages is still effective. For example, you can highlight a 50% revenue increase with the implementation of your product.

Take a look at the beautiful case study template below. Just like in the example above, the figures in the headline instantly grab attention and entice your reader to click through.

Having a case study document is a key factor in boosting engagement. This makes it easy to promote your case study in multiple ways. With Visme, you can easily publish, download and share your case study with your customers in a variety of formats, including PDF, PPTX, JPG and more!

4. How WOW! is Saving Nearly 79% in Time and Cost With Visme

This case study discusses how Visme helped WOW! save time and money by providing user-friendly tools to create interactive and quality training materials for their employees. Find out what your team can do with Visme. Request a Demo

WOW!'s learning and development team creates high-quality training materials for new and existing employees. Previous tools and platforms they used had plain templates, little to no interactivity features, and limited flexibility—that is, until they discovered Visme.

Now, the learning and development team at WOW! use Visme to create engaging infographics, training videos, slide decks and other training materials.

This has directly reduced the company's turnover rate, saving them money spent on recruiting and training new employees. It has also saved them a significant amount of time, which they can now allocate to other important tasks.

Visme's customer testimonials spark an emotional connection with the reader, leaving a profound impact. Upon reading this case study, prospective customers will be blown away by the remarkable efficiency achieved by Visme's clients after switching from PowerPoint.

Visme’s interactivity feature was a game changer for WOW! and one of the primary reasons they chose Visme.

“Previously we were using PowerPoint, which is fine, but the interactivity you can get with Visme is so much more robust that we’ve all steered away from PowerPoint.” - Kendra, L&D team, Wow!

Visme’s interactive feature allowed them to animate their infographics, include clickable links on their PowerPoint designs and even embed polls and quizzes their employees could interact with.

By embedding the slide decks, infographics and other training materials WOW! created with Visme, potential customers get a taste of what they can create with the tool. This is much more effective than describing the features of Visme because it allows potential customers to see the tool in action.

To top it all off, this case study utilized relevant data and figures. For example, one part of the case study said, “In Visme, where Kendra’s team has access to hundreds of templates, a brand kit, and millions of design assets at their disposal, their team can create presentations in 80% less time.”

Who wouldn't want that?

Including relevant figures and graphics in your case study is a sure way to convince your potential customers why you’re a great fit for their brand. The case study template below is a great example of integrating relevant figures and data.

This colorful template begins with a captivating headline. But that is not the best part; this template extensively showcases the results their customer had using relevant figures.

The arrangement of the results makes it fun and attractive. Instead of just putting figures in a plain table, you can find interesting shapes in your Visme editor to take your case study to the next level.

5. Lyte Reduces Customer Churn To Just 3% With Hubspot CRM

While Lyte was redefining the ticketing industry, it had no definite CRM system . Lyte utilized 12–15 different SaaS solutions across various departments, which led to a lack of alignment between teams, duplication of work and overlapping tasks.

Customer data was spread across these platforms, making it difficult to effectively track their customer journey. As a result, their churn rate increased along with customer dissatisfaction.

Through Fuelius , Lyte founded and implemented Hubspot CRM. Lyte's productivity skyrocketed after incorporating Hubspot's all-in-one CRM tool. With improved efficiency, better teamwork and stronger client relationships, sales figures soared.

The case study title page and executive summary act as compelling entry points for both existing and potential customers. This overview provides a clear understanding of the case study and also strategically incorporates key details like the client's industry, location and relevant background information.

Having a good summary of your case study can prompt your readers to engage further. You can achieve this with a simple but effective case study one-pager that highlights your customer’s problems, process and achievements, just like this case study did in the beginning.

Moreover, you can easily distribute your case study one-pager and use it as a lead magnet to draw prospective customers to your company.

Take a look at this case study one-pager template below.

This template includes key aspects of your case study, such as the introduction, key findings, conclusion and more, without overcrowding the page. The use of multiple shades of blue gives it a clean and dynamic layout.

Our favorite part of this template is where the age group is visualized.

With Visme’s data visualization tool , you can present your data in tables, graphs, progress bars, maps and so much more. All you need to do is choose your preferred data visualization widget, input or import your data and click enter!

6. How Workato Converts 75% of Their Qualified Leads

Workato wanted to improve their inbound leads and increase their conversion rate, which ranged from 40-55%.

At first, Workato searched for a simple scheduling tool. They soon discovered that they needed a tool that provided advanced routing capabilities based on zip code and other criteria. Luckily, they found and implemented Chili Piper.

As a result of implementing Chili Piper, Workato achieved a remarkable 75–80% conversion rate and improved show rates. This led to a substantial revenue boost, with a 10-15% increase in revenue attributed to Chili Piper's impact on lead conversion.

This case study example utilizes the power of video testimonials to drive the impact of their product.

Chili Piper incorporates screenshots and clips of their tool in use. This is a great strategy because it helps your viewers become familiar with how your product works, making onboarding new customers much easier.

In this case study example, we see the importance of efficient Workflow Management Systems (WMS). Without a WMS, you manually assign tasks to your team members and engage in multiple emails for regular updates on progress.

However, when crafting and designing your case study, you should prioritize having a good WMS.

Visme has an outstanding Workflow Management System feature that keeps you on top of all your projects and designs. This feature makes it much easier to assign roles, ensure accuracy across documents, and track progress and deadlines.

Visme’s WMS feature allows you to limit access to your entire document by assigning specific slides or pages to individual members of your team. At the end of the day, your team members are not overwhelmed or distracted by the whole document but can focus on their tasks.

7. Rush Order Helps Vogmask Scale-Up During a Pandemic

Vomask's reliance on third-party fulfillment companies became a challenge as demand for their masks grew. Seeking a reliable fulfillment partner, they found Rush Order and entrusted them with their entire inventory.

Vomask's partnership with Rush Order proved to be a lifesaver during the COVID-19 pandemic. Rush Order's agility, efficiency and commitment to customer satisfaction helped Vogmask navigate the unprecedented demand and maintain its reputation for quality and service.

Rush Order’s comprehensive support enabled Vogmask to scale up its order processing by a staggering 900% while maintaining a remarkable customer satisfaction rate of 92%.

Rush Order chose one event where their impact mattered the most to their customer and shared that story.

While pandemics don't happen every day, you can look through your customer’s journey and highlight a specific time or scenario where your product or service saved their business.

The story of Vogmask and Rush Order is compelling, but it simply is not enough. The case study format and design attract readers' attention and make them want to know more. Rush Order uses consistent colors throughout the case study, starting with the logo, bold square blocks, pictures, and even headers.

Take a look at this product case study template below.

Just like our example, this case study template utilizes bold colors and large squares to attract and maintain the reader’s attention. It provides enough room for you to write about your customers' backgrounds/introductions, challenges, goals and results.

The right combination of shapes and colors adds a level of professionalism to this case study template.

8. AMR Hair & Beauty leverages B2B functionality to boost sales by 200%

With limits on website customization, slow page loading and multiple website crashes during peak events, it wasn't long before AMR Hair & Beauty began looking for a new e-commerce solution.

Their existing platform lacked effective search and filtering options, a seamless checkout process and the data analytics capabilities needed for informed decision-making. This led to a significant number of abandoned carts.

Upon switching to Shopify Plus, AMR immediately saw improvements in page loading speed and average session duration. They added better search and filtering options for their wholesale customers and customized their checkout process.

Due to this, AMR witnessed a 200% increase in sales and a 77% rise in B2B average order value. AMR Hair & Beauty is now poised for further expansion and growth.

This case study example showcases the power of a concise and impactful narrative.

To make their case analysis more effective, Shopify focused on the most relevant aspects of the customer's journey. While there may have been other challenges the customer faced, they only included those that directly related to their solutions.

Take a look at this case study template below. It is perfect if you want to create a concise but effective case study. Without including unnecessary details, you can outline the challenges, solutions and results your customers experienced from using your product.

Don’t forget to include a strong CTA within your case study. By incorporating a link, sidebar pop-up or an exit pop-up into your case study, you can prompt your readers and prospective clients to connect with you.

9. How a Marketing Agency Uses Visme to Create Engaging Content With Infographics

SmartBox Dental , a marketing agency specializing in dental practices, sought ways to make dental advice more interesting and easier to read. However, they lacked the design skills to do so effectively.

Visme's wide range of templates and features made it easy for the team to create high-quality content quickly and efficiently. SmartBox Dental enjoyed creating infographics in as little as 10-15 minutes, compared to one hour before Visme was implemented.

By leveraging Visme, SmartBox Dental successfully transformed dental content into a more enjoyable and informative experience for their clients' patients. Therefore enhancing its reputation as a marketing partner that goes the extra mile to deliver value to its clients.

Visme creatively incorporates testimonials In this case study example.

By showcasing infographics and designs created by their clients, they leverage the power of social proof in a visually compelling way. This way, potential customers gain immediate insight into the creative possibilities Visme offers as a design tool.

This example effectively showcases a product's versatility and impact, and we can learn a lot about writing a case study from it. Instead of focusing on one tool or feature per customer, Visme took a more comprehensive approach.

Within each section of their case study, Visme explained how a particular tool or feature played a key role in solving the customer's challenges.

For example, this case study highlighted Visme’s collaboration tool . With Visme’s tool, the SmartBox Dental content team fostered teamwork, accountability and effective supervision.

Visme also achieved a versatile case study by including relevant quotes to showcase each tool or feature. Take a look at some examples;

Visme’s collaboration tool: “We really like the collaboration tool. Being able to see what a co-worker is working on and borrow their ideas or collaborate on a project to make sure we get the best end result really helps us out.”

Visme’s library of stock photos and animated characters: “I really love the images and the look those give to an infographic. I also really like the animated little guys and the animated pictures. That’s added a lot of fun to our designs.”

Visme’s interactivity feature: “You can add URLs and phone number links directly into the infographic so they can just click and call or go to another page on the website and I really like adding those hyperlinks in.”

You can ask your customers to talk about the different products or features that helped them achieve their business success and draw quotes from each one.

10. Jasper Grows Blog Organic Sessions 810% and Blog-Attributed User Signups 400X

Jasper, an AI writing tool, lacked a scalable content strategy to drive organic traffic and user growth. They needed help creating content that converted visitors into users. Especially when a looming domain migration threatened organic traffic.

To address these challenges, Jasper partnered with Omniscient Digital. Their goal was to turn their content into a growth channel and drive organic growth. Omniscient Digital developed a full content strategy for Jasper AI, which included a content audit, competitive analysis, and keyword discovery.

Through their collaboration, Jasper’s organic blog sessions increased by 810%, despite the domain migration. They also witnessed a 400X increase in blog-attributed signups. And more importantly, the content program contributed to over $4 million in annual recurring revenue.

The combination of storytelling and video testimonials within the case study example makes this a real winner. But there’s a twist to it. Omniscient segmented the video testimonials and placed them in different sections of the case study.

Video marketing , especially in case studies, works wonders. Research shows us that 42% of people prefer video testimonials because they show real customers with real success stories. So if you haven't thought of it before, incorporate video testimonials into your case study.

Take a look at this stunning video testimonial template. With its simple design, you can input the picture, name and quote of your customer within your case study in a fun and engaging way.

Try it yourself! Customize this template with your customer’s testimonial and add it to your case study!

11. How Meliá Became One of the Most Influential Hotel Chains on Social Media

Meliá Hotels needed help managing their growing social media customer service needs. Despite having over 500 social accounts, they lacked a unified response protocol and detailed reporting. This largely hindered efficiency and brand consistency.

Meliá partnered with Hootsuite to build an in-house social customer care team. Implementing Hootsuite's tools enabled Meliá to decrease response times from 24 hours to 12.4 hours while also leveraging smart automation.

In addition to that, Meliá resolved over 133,000 conversations, booking 330 inquiries per week through Hootsuite Inbox. They significantly improved brand consistency, response time and customer satisfaction.

The need for a good case study design cannot be over-emphasized.

As soon as anyone lands on this case study example, they are mesmerized by a beautiful case study design. This alone raises the interest of readers and keeps them engaged till the end.

If you’re currently saying to yourself, “ I can write great case studies, but I don’t have the time or skill to turn it into a beautiful document.” Say no more.

Visme’s amazing AI document generator can take your text and transform it into a stunning and professional document in minutes! Not only do you save time, but you also get inspired by the design.

With Visme’s document generator, you can create PDFs, case study presentations , infographics and more!

Take a look at this case study template below. Just like our case study example, it captures readers' attention with its beautiful design. Its dynamic blend of colors and fonts helps to segment each element of the case study beautifully.

12. Tea’s Me Cafe: Tamika Catchings is Brewing Glory

Tamika's journey began when she purchased Tea's Me Cafe in 2017, saving it from closure. She recognized the potential of the cafe as a community hub and hosted regular events centered on social issues and youth empowerment.

One of Tamika’s business goals was to automate her business. She sought to streamline business processes across various aspects of her business. One of the ways she achieves this goal is through Constant Contact.

Constant Contact became an integral part of Tamika's marketing strategy. They provided an automated and centralized platform for managing email newsletters, event registrations, social media scheduling and more.

This allowed Tamika and her team to collaborate efficiently and focus on engaging with their audience. They effectively utilized features like WooCommerce integration, text-to-join and the survey builder to grow their email list, segment their audience and gather valuable feedback.

The case study example utilizes the power of storytelling to form a connection with readers. Constant Contact takes a humble approach in this case study. They spotlight their customers' efforts as the reason for their achievements and growth, establishing trust and credibility.

This case study is also visually appealing, filled with high-quality photos of their customer. While this is a great way to foster originality, it can prove challenging if your customer sends you blurry or low-quality photos.

If you find yourself in that dilemma, you can use Visme’s AI image edit tool to touch up your photos. With Visme’s AI tool, you can remove unwanted backgrounds, erase unwanted objects, unblur low-quality pictures and upscale any photo without losing the quality.

Constant Contact offers its readers various formats to engage with their case study. Including an audio podcast and PDF.

In its PDF version, Constant Contact utilized its brand colors to create a stunning case study design.  With this, they increase brand awareness and, in turn, brand recognition with anyone who comes across their case study.

With Visme’s brand wizard tool , you can seamlessly incorporate your brand assets into any design or document you create. By inputting your URL, Visme’s AI integration will take note of your brand colors, brand fonts and more and create branded templates for you automatically.

You don't need to worry about spending hours customizing templates to fit your brand anymore. You can focus on writing amazing case studies that promote your company.

13. How Breakwater Kitchens Achieved a 7% Growth in Sales With Thryv

Breakwater Kitchens struggled with managing their business operations efficiently. They spent a lot of time on manual tasks, such as scheduling appointments and managing client communication. This made it difficult for them to grow their business and provide the best possible service to their customers.

David, the owner, discovered Thryv. With Thryv, Breakwater Kitchens was able to automate many of their manual tasks. Additionally, Thryv integrated social media management. This enabled Breakwater Kitchens to deliver a consistent brand message, captivate its audience and foster online growth.

As a result, Breakwater Kitchens achieved increased efficiency, reduced missed appointments and a 7% growth in sales.

This case study example uses a concise format and strong verbs, which make it easy for readers to absorb the information.

At the top of the case study, Thryv immediately builds trust by presenting their customer's complete profile, including their name, company details and website. This allows potential customers to verify the case study's legitimacy, making them more likely to believe in Thryv's services.

However, manually copying and pasting customer information across multiple pages of your case study can be time-consuming.

To save time and effort, you can utilize Visme's dynamic field feature . Dynamic fields automatically insert reusable information into your designs.  So you don’t have to type it out multiple times.

14. Zoom’s Creative Team Saves Over 4,000 Hours With Brandfolder

Zoom experienced rapid growth with the advent of remote work and the rise of the COVID-19 pandemic. Such growth called for agility and resilience to scale through.

At the time, Zoom’s assets were disorganized which made retrieving brand information a burden. Zoom’s creative manager spent no less than 10 hours per week finding and retrieving brand assets for internal teams.

Zoom needed a more sustainable approach to organizing and retrieving brand information and came across Brandfolder. Brandfolder simplified and accelerated Zoom’s email localization and webpage development. It also enhanced the creation and storage of Zoom virtual backgrounds.

With Brandfolder, Zoom now saves 4,000+ hours every year. The company also centralized its assets in Brandfolder, which allowed 6,800+ employees and 20-30 vendors to quickly access them.

Brandfolder infused its case study with compelling data and backed it up with verifiable sources. This data-driven approach boosts credibility and increases the impact of their story.

Bradfolder's case study goes the extra mile by providing a downloadable PDF version, making it convenient for readers to access the information on their own time. Their dedication to crafting stunning visuals is evident in every aspect of the project.

From the vibrant colors to the seamless navigation, everything has been meticulously designed to leave a lasting impression on the viewer. And with clickable links that make exploring the content a breeze, the user experience is guaranteed to be nothing short of exceptional.

The thing is, your case study presentation won’t always sit on your website. There are instances where you may need to do a case study presentation for clients, partners or potential investors.

Visme has a rich library of templates you can tap into. But if you’re racing against the clock, Visme’s AI presentation maker is your best ally.

15. How Cents of Style Made $1.7M+ in Affiliate Sales with LeadDyno

Cents of Style had a successful affiliate and influencer marketing strategy. However, their existing affiliate marketing platform was not intuitive, customizable or transparent enough to meet the needs of their influencers.

Cents of Styles needed an easy-to-use affiliate marketing platform that gave them more freedom to customize their program and implement a multi-tier commission program.

After exploring their options, Cents of Style decided on LeadDyno.

LeadDyno provided more flexibility, allowing them to customize commission rates and implement their multi-tier commission structure, switching from monthly to weekly payouts.

Also, integrations with PayPal made payments smoother And features like newsletters and leaderboards added to the platform's success by keeping things transparent and engaging.

As a result, Cents of Style witnessed an impressive $1.7 million in revenue from affiliate sales with a substantial increase in web sales by 80%.

LeadDyno strategically placed a compelling CTA in the middle of their case study layout, maximizing its impact. At this point, readers are already invested in the customer's story and may be considering implementing similar strategies.

A well-placed CTA offers them a direct path to learn more and take action.

LeadDyno also utilized the power of quotes to strengthen their case study. They didn't just embed these quotes seamlessly into the text; instead, they emphasized each one with distinct blocks.

Are you looking for an easier and quicker solution to create a case study and other business documents? Try Visme's AI designer ! This powerful tool allows you to generate complete documents, such as case studies, reports, whitepapers and more, just by providing text prompts. Simply explain your requirements to the tool, and it will produce the document for you, complete with text, images, design assets and more.

Still have more questions about case studies? Let's look at some frequently asked questions.

How to Write a Case Study?

• Choose a compelling story: Not all case studies are created equal. Pick one that is relevant to your target audience and demonstrates the specific benefits of your product or service.
• Outline your case study: Create a case study outline and highlight how you will structure your case study to include the introduction, problem, solution and achievements of your customer.
• Choose a case study template: After you outline your case study, choose a case study template . Visme has stunning templates that can inspire your case study design.
• Craft a compelling headline: Include figures or percentages that draw attention to your case study.
• Work on the first draft: Your case study should be easy to read and understand. Use clear and concise language and avoid jargon.
• Include high-quality visual aids: Visuals can help to make your case study more engaging and easier to read. Consider adding high-quality photos, screenshots or videos.
• Include a relevant CTA: Tell prospective customers how to reach you for questions or sign-ups.

What Are the Stages of a Case Study?

The stages of a case study are;

• Planning & Preparation: Highlight your goals for writing the case study. Plan the case study format, length and audience you wish to target.
• Interview the Client: Reach out to the company you want to showcase and ask relevant questions about their journey and achievements.
• Revision & Editing: Review your case study and ask for feedback. Include relevant quotes and CTAs to your case study.
• Publication & Distribution: Publish and share your case study on your website, social media channels and email list!
• Marketing & Repurposing: Turn your case study into a podcast, PDF, case study presentation and more. Share these materials with your sales and marketing team.

What Are the Advantages and Disadvantages of a Case Study?

Advantages of a case study:

• Case studies showcase a specific solution and outcome for specific customer challenges.
• It attracts potential customers with similar challenges.
• It builds trust and credibility with potential customers.
• It provides an in-depth analysis of your company’s problem-solving process.

Disadvantages of a case study:

• Limited applicability. Case studies are tailored to specific cases and may not apply to other businesses.
• It relies heavily on customer cooperation and willingness to share information.
• It stands a risk of becoming outdated as industries and customer needs evolve.

What Are the Types of Case Studies?

There are 7 main types of case studies. They include;

• Illustrative case study.
• Instrumental case study.
• Intrinsic case study.
• Descriptive case study.
• Explanatory case study.
• Exploratory case study.
• Collective case study.

How Long Should a Case Study Be?

The ideal length of your case study is between 500 - 1500 words or 1-3 pages. Certain factors like your target audience, goal or the amount of detail you want to share may influence the length of your case study. This infographic has powerful tips for designing winning case studies

What Is the Difference Between a Case Study and an Example?

Case studies provide a detailed narrative of how your product or service was used to solve a problem. Examples are general illustrations and are not necessarily real-life scenarios.

Case studies are often used for marketing purposes, attracting potential customers and building trust. Examples, on the other hand, are primarily used to simplify or clarify complex concepts.

Where Can I Find Case Study Examples?

You can easily find many case study examples online and in industry publications. Many companies, including Visme, share case studies on their websites to showcase how their products or services have helped clients achieve success. You can also search online libraries and professional organizations for case studies related to your specific industry or field.

If you need professionally-designed, customizable case study templates to create your own, Visme's template library is one of the best places to look. These templates include all the essential sections of a case study and high-quality content to help you create case studies that position your business as an industry leader.

Get More Out Of Your Case Studies With Visme

Case studies are an essential tool for converting potential customers into paying customers. By following the tips in this article, you can create compelling case studies that will help you build trust, establish credibility and drive sales.

Visme can help you create stunning case studies and other relevant marketing materials. With our easy-to-use platform, interactive features and analytics tools , you can increase your content creation game in no time.

There is no limit to what you can achieve with Visme. Connect with Sales to discover how Visme can boost your business goals.

Easily create beautiful case studies and more with Visme

Trusted by leading brands

Recommended content for you:

Create Stunning Content!

Design visual brand experiences for your business whether you are a seasoned designer or a total novice.

About the Author

Asking the better questions that unlock new answers to the working world's most complex issues.

Trending topics

AI insights

EY Center for board matters

EY podcasts

EY webcasts

Operations leaders

Technology leaders

EY helps clients create long-term value for all stakeholders. Enabled by data and technology, our services and solutions provide trust through assurance and help clients transform, grow and operate.

EY.ai - A unifying platform

Strategy, transaction and transformation consulting

Technology transformation

Tax function operations

Climate change and sustainability services

EY Ecosystems

EY Nexus: business transformation platform

Discover how EY insights and services are helping to reframe the future of your industry.

Case studies

Advanced Manufacturing

How a manufacturer eliminates cost and value leakages with AI-ML

03 Jul 2024 Vinayak vipul

How a young cement company grew 2.5x with organizational and functional transformation

05 Apr 2024 EY India

How a state government transformed into an ecotourism haven

12 Mar 2024 EY India

We bring together extraordinary people, like you, to build a better working world.

Experienced professionals

EY-Parthenon careers

Student and entry level programs

Talent community

At EY, our purpose is building a better working world. The insights and services we provide help to create long-term value for clients, people and society, and to build trust in the capital markets.

July 2024 recorded PE/VC Investments worth US$2.7 billion across 81 deals: EY-IVCA Report

14 Aug 2024 EY India

EY expands its EY ESG Compass platform with new innovative use-cases

06 Aug 2024 EY India

78% of Indian consumers prefer human customer service support when shopping online: EY Report

No results have been found

Recent Searches

How petrochemical industry in India drives growth with investment and innovation

EY highlights how Indian petrochemical companies can navigate rising demands and global competition. Learn more.

Union Budget 2024-25: Accelerating fiscal consolidation for sustained growth

Union Budget 2024-25: Drive fiscal consolidation for lower interest rates, boost private investment, and job growth.

How India Inc. can navigate the road to financial resilience

Explore key findings from the 2024 Cost of Capital Survey, revealing insights into India Inc.'s financial resilience and strategic growth.

Select your location

EY Power BI Innovators - Case study challenge Season-2 

EY Learning Solutions has launched a nationwide Power BI case study challenge aimed at UG and PG students to make them future ready

Welcome to the Second Season of the Power BI Case Challenge!  

About the challenge

The challenge will take place in five phases: 

• Individual registration  
• Selection of case study
• Undergo the sessions (live and eLearning) on Power BI
• Diagnostic assessment  
• Submission  

Eligibility 

Students enrolled in any undergraduate and postgraduate program are eligible to participate, regardless of their year of study.  

Step 1: Registration

Participant, with only individual participation allowed, can register by clicking below:

Registrations are open from 20 August 2024 to 30 September 2024

Step 2: Selection of case study : The participants are required to select a case study (any one) from the following list based on their interest. The participants will have access to the synopsis for each case study to make an informed decision. 

• Maximizing Product Potential: An In-Depth Look at Product Analysis  
• Efficient BPO Workforce Planning: A Roster Management Solution  
• Insurance Claims Overview: Executive Dashboard Insights  
• IT Analytics Dashboard: Monitoring and Managing Support Tickets  

Step 3:   Get familiar with Power BI : This challenge aims to equip participants with the Power BI tool, enabling them to excel in the case challenge. The comprehensive program includes access to eLearning materials and eight hours of live virtual training sessions. By participating in this program, students will gain the confidence to tackle any Power BI task. Please note that the schedule for the eight-hour virtual live sessions will be shared with all registered students 

Step 4: Diagnostic assessment:  To optimize your learning experience and tailor the challenge to your needs, all participants must complete a mandatory quiz. Your score will be considered in the final evaluation of the case solution.

Diagnostic assessment details  

• Duration : one hour 
• Number of questions : 30 
• Format : Multiple-Choice Questions (MCQs), no negative marking 
• Please note:  Failure to participate in the quiz will result in disqualification 

Step 5:   Final submission : Submit responses to the case study questions by 23 rd November, 2024. The submissions should be shared in a Power BI file format (.pbix) which needs to be uploaded on the google drive.

IMPORTANT: Late entries will not be entertained.  

• Registration open: 20 August 2024
• Registration close: 30 September 2024
• Training and learning period: 7 Oct 2024 to 10 Nov 2024
• Diagnostic assessment:  16 Nov 2024
• Final submission: 23 Nov 2024
• Result announcement: 17 Dec 2024
• Two months internship with EY India*
• Gift hamper worth INR 10,000
• Half a year access to any one eLearning certification program at EY Virtual Academy

1st Runner up:

• Gift hamper worth INR 5000

2nd Runner up:

• Gift hamper worth INR 2500

*The winners will secure pro-bono internships with EY. Top 10 best entries will get half a year access to any one eLearning certification program at EY Virtual Academy. 

All registered participants attending the session of eight hours will receive a certificate of participation from EY.

Additionally, all the registered participants will be eligible for 20% scholarship on EY Virtual Academy programs

Registration fee:

The registration fee for the competition is INR 2000 + GST

Evaluation criteria :

The case submissions will be evaluated basis the following:

• Assessment scores 
• Usage of the power BI tool 
• Practical applicability and relevance of solution 
• Depth of research 
• Clarity of thought 
• Content and writing style 

Important details: What to expect and what is expected

• Stay committed to the spirit of fair competition 
• Failure to follow the rules will result in disqualification
• Each participant can submit only one solution to the case study. Requests for resubmission requests will not be accepted
• Deadlines will not be extended
• Absence from the quiz will result in disqualification
• Plagiarism is strictly prohibited 
• Please ensure that you use the same email address for all communication throughout the challenge

For more information reach out to us  ey.learningsolution@in.ey.com

Note: The results announced by EY Learning Solutions shall be determined exclusively at their discretion. Said decision shall not be subject to reassessment, modification, or alteration under any circumstances.  

Direct to your inbox

Stay up to date with our Editor's picks newsletter.

• Connect with us
• Our locations
• Legal and privacy
• Open Facebook profile
• Open X profile
• Open LinkedIn profile
• Open Youtube profile

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.

RUC Mining and Rockwell Automation harness energy-generating potential of underground mine winders

Share This:

• Creating an innovative solution to turn underground mine hoists into energy generators, with energy stored using a regenerative storage solution
• PowerFlex® 755TR variable speed drives were selected due to their flexibility and their suitability for cranes, hoists, and lifting applications
• Low Voltage Motor Control Centres
• ThinManager® software for application management
• FactoryTalk® View Site Edition software for a complete real-time overview of HMI operations
• Network and security services
• Product Support
• A successful regenerative storage solution developed with strong collaboration between Rockwell Automation, RUC Mining, and Energy Power Systems Australia (EPSA)
• Sustainability benefits , including predictions over 24 months of a saving of 1,427 kilolitres of diesel (saving approximately AUD$2 million), a reduction of 3.85 tonnes of CO 2 output, and an approximate 42% reduction in greenhouse gas emissions from power generation
• Future potential to implement the innovative new solution on larger hoists

Underground mining hoists, or winders, are powerful machines used to raise and lower minerals and materials in a mine shaft.

They allow efficient vertical transport of materials, which would otherwise require larger machinery and further costs to extract from the mine.

While travelling upward, a large amount of power is required, but this is not the case on the way down.

It’s the downward trip that sparked an innovative idea by underground mine hoist specialists, RUC Mining: what if energy generated on the way down could be stored, then used to power the upward journey?

The sustainability implications and broader contribution to the electric mine of the future were huge – but there was a technically complex and challenging task to figure out first.

RUC electrical manager, Greg Bell, believed this was more than an idea, and began working on how to make it a reality. He and the RUC team chose strategic partners, Rockwell Automation, and Energy Power Systems Australia (EPSA), to create a fully integrated solution that could be rolled out to hoists across the globe.

In its first application in an Australian mine, RUC installed its RUCShaw 512 single-drum winder, which is powered by 710 kW drives, has a hoist capacity of five metres per second, with 12-tonne line pull, and operates with a design depth of 1,600m.

A Technically Complex Sustainability Solution When hoisting a load up a mine shaft, electric motors consume energy. But when travelling downwards, they have the potential to become generators.

“Most mine hoists use a brake resistor pack with a cooling fan to deal with the heat generated. But these packs create a single point of failure, and are application-specific, so they need recalculation if a variation in brake power is required,” explained Bell.

“Instead, we proposed for the generating power to be supplied back onto the incoming supply bus, to be absorbed by system loads,” he added.

To make this solution a reality, Rockwell Automation provided Active-Front-End (AFE) Powerflex® 755TR regenerative variable speed drives, low voltage motor control centres, GuardLogix® controllers, ThinManager® software for application management, FactoryTalk® View Site Edition software for a complete real-time overview of HMI operations, network and security services, and product and technical support.

The battery selected to store regenerative energy was a Cat PGS 1260 Battery Energy Storage System (BESS), supplied by EPSA, which provided added redundancy through its parallel inverter and battery stack architecture.

“We have one operational project where we have implemented this solution with two hoist drives, and we are looking into incorporating this into future projects. We also see potential for this solution to be rolled out on new and existing mine shafts internationally,” said Bell.

By reducing the amount of diesel power generation, significant environmental gains are achievable with the regenerative energy storage solution in place. RUC has estimated that in their initial installation, over a 24-month period, the regenerative energy storage solution will achieve:

• An estimated reduction in diesel consumption of 1,427 kilolitres (which saves approximately $2 million)
• A reduction of 3.85 tonnes of CO2 output (that’s approximately equal to travelling 12,700km in a petrol car)
• An approximate 42% reduction in greenhouse gas emissions from power generation

Rockwell Automation regional director for South Pacific, Anthony Wong, added, “Sustainability is a key focus for Rockwell, and when RUC came to us with this forward-thinking project, we were enthusiastic to work with them to turn it into a reality, and to help deliver reliability and performance with our hardware and software solutions.”

“While this solution was designed and built in Australia, it will be applicable for mines across the world. It’s a small but significant step towards a more sustainable mining industry and the dream of fully electric mines. We commend RUC for its ingenuity and vision in conceiving this truly innovative solution,” he said.

Not only was there a complex integration of technologies, but the regenerative storage project involved a lot of industry firsts, so there was no existing template to follow.

“I can’t speak highly enough of the Rockwell technical team – they are some of the best engineers I’ve worked with. Another major benefit was the Rockwell vendor manuals and technical information. These are first-class documents, and the latest versions are all available online, which was crucial for training the workforce and working remotely. Revision control was taken out of my hands because we were always accessing the latest version,” he added.

Bell also identified several key benefits of the Rockwell hardware used in this project, including:

• Outstanding drive configurability and parameterisation. RUC was working with approximately 1,500 parameters in a custom, first of its kind solution, so Rockwell’s drives delivered the required flexibility
• Built-in safety with SIL3-capable safe torque off function, which was a performance requirement of the mine operator. (SIL, or Safety Integrity Level, is a rating system that associates safety with the numerical probabilities of hazardous failures (0 being the lowest and 4 being the highest) for continuously operating systems or on-demand systems.)
• Purpose-built drives. The Rockwell Automation PowerFlex 755TR is specifically built for cranes, hoists, and lifting equipment, which means it has all the features this demanding application requires.

“In addition to the hardware, Rockwell’s software also seamlessly integrated with our control and safety system, and with our historian/data logger for diagnostics and advanced troubleshooting. There was a simple integration between drive and air circuit breaker metering equipment via Rockwell’s controller add-on instructions,” said Bell.

While not an initial goal of the regenerative energy storage project, the new solution is delivering “bump-less” performance, as well as an additional level of redundancy within the battery.

“Faults happen when you lose power, and hydraulic braking is aggressive. With the regenerative energy storage solution, we can split the battery with two inverters, so we have an added layer of redundancy. This means if we lose power, the winder does not stop, which delivers smooth, bump-less performance,” said Bell.

“Because power goes straight back to the battery with no heat loss, this type of solution could readily be scaled down to any energy application – even something like elevators. We believe this is the only successful gravity kinetic energy storage system using a hoist in the world, and we are proud to be introducing it here in Australia.

“We have plans to use this technology more widely, because if you think about the electric mine of the future, vertical haulage delivers the most affordable, operable, and achievable solution for transporting material out of the mine. The technology has great export potential, too, so we can showcase Australian innovation on a global scale.

Published March 7, 2024

Receive the latest news, thought leadership and information directly to your inbox.

• Social Media Cookies
• Functional Cookies
• Performance Cookies
• Marketing Cookies
• All Cookies

8 Week SQL Challenge

Start your SQL learning journey today!

Case Study #1 - Danny's Diner

May 1, 2021

Case Study #2 - Pizza Runner

May 4, 2021

Case Study #3 - Foodie-Fi

May 18, 2021

Case Study #4 - Data Bank

June 1, 2021

Case Study #5 - Data Mart

June 20, 2021

Case Study #6 - Clique Bait

June 29, 2021

Case Study #7 - Balanced Tree Clothing Co.

July 2, 2021

Case Study #8 - Fresh Segments

July 9, 2021

Pagsmile secures rapid international growth, enhancing the performance and security of fintech services worldwide with Cloudflare

Pagsmile is an innovative Chinese game publisher and developer of fintech and ecommerce applications. Established in 2013 as a gaming sales platform for the Asian market, the company’s current flagship products, Pagsmile , an online payment service provider, and Smile.one , a full-featured, modern top-up platform for popular games, are steadily gaining international popularity, primarily in Brazil and Latin-American.

Privately funded with headquarters in Beijing, China, and offices in São Paulo, Brazil, Pagsmile is extending its top-quality gaming and financial services platforms to overseas customers. To support a wider customer demographic and promote steady growth in the Middle East, Europe, and Asia alongside its core Latino markets, Pagsmile has an internationalized workforce — 80% of its staff speak more than one language, and 40% are native to its target markets.

Challenge: Accelerating growth in the ecommerce and international financial services sectors

Operating in the ecommerce and international financial services sectors, Pagsmile prioritizes security and performance across its product platforms — a necessity for longevity and growth in an online landscape marked by ever-evolving, complex threats. To promote its expansion initiatives, the company also needed robust, well-documented security processes that could satisfy a host of international and regional regulatory requirements, particularly for Pagsmile, its payment services business.

“We needed to satisfy the regulators but, from a purely practical perspective, eliminating online fraud was our most pressing concern — database breach attempts and criminal activity aimed at compromising our customer accounts were increasingly common,” explains Jack Wang, Pagsmile’s Director of Business. “Most businesses in the payment industry have had money stolen at least once, so we needed to make sure that our office network and developer and production environments were safe as we pushed forward.”

As a startup with typically limited resources, Pagsmile faced additional growing pains as it expanded at pace. To efficiently manage its growing customer base and workforce, Pagsmile turned to the connectivity cloud, Cloudflare’s unified platform of cloud-native services, to accelerate digital transformation and improve its IT environments by:

• Ensuring robust security to protect its data, employees, and customers against fraud, BEC, and data breaches
• Maintaining a safe and scalable international work-from-anywhere application infrastructure
• Streamlining compliance with international security standards
• Providing a consistent, performant customer experience across unpredictable international network conditions

“In the last four years we have expanded the business dozens of times, growing our product and our staff and extending our market to areas with problematic network coverage,” says Wang. “Cloudflare gives us a way to provide our clients with a top-notch customer experience while balancing cost against security, performance, and efficiency.”

Solving problems in the connectivity cloud — securing public applications and websites against fraud and other online threats

Pagsmile began its quest to deliver superior experiences by improving security and performance with Cloudflare’s integrated and easy-to-use application services. As a starting point, the company implemented the Cloudflare web application firewall (WAF) , DDoS protection , rate limiting , and bot management services.

“We selected Cloudflare because of its unique ability to solve problems,” says Wang. “Most companies in our industry use Cloudflare for its products' efficacy and broad functionality.”

Pagsmile relies on Cloudflare and the threat intelligence it collects natively across the connectivity cloud to keep its web platforms, applications, and customers safe against emerging online threats, particularly layer 7 Challenge Collapsar (CC) attacks that overwhelm their targets with complex, high-volume database operations.

“Before Cloudflare, our defenses were simplistic. We faced each attack independently, constantly adapting our strategies to cope,” says Wang. “Now, we still see advanced security attacks, but with Cloudflare as our front line of defense, we deal with them automatically so they don't affect our users or our business.”

Minimizing threats and optimizing resource workloads with Cloudflare automated detection and mitigation tools

Using technology like machine learning, Bot Management, and JA3 fingerprint , Cloudflare can mitigate complex layer 7 Challenge Collapsar (CC) attacks very effectively, such as low speed attack( 10 attack requests per IP per minute). Cloudflare application services also make it simple for the Pagsmile security team to differentiate between malicious and beneficial traffic.

“Cloudflare easily identifies the difference between genuine users and potential attackers,” says Wang. “That allows us to better categorize site traffic, and implement automated defensive measures to fit every circumstance. We commit the time and money we save towards expanding our products and improving our user experience.”

Thwarting BEC with cloud email security

Cloud email security is another solution in the connectivity cloud that protects Pagsmile staff and customers, this time against phishing, malware, business email compromise (BEC), and other socially-engineered email-borne threats. Wang recalls one BEC instance that underscored the urgency of implementing effective email security throughout the organization.

“BEC and phishing are terrifying — we once received a very convincing statement of accounts from one of our banking partners that contained a JavaScript application that would have severely compromised us if opened,” he recalls. “That is no longer an issue. Cloudflare email security is so effective that when we turned it on we stopped seeing threats overnight with no extra configuration — it intercepts thousands of problem emails every month.”

Work-from-anywhere employee access to applications and internal tools with Zero Trust Network Access (ZTNA)

Cloudflare’s Zero Trust platform provides the last piece of Pagsmile’s security and accessibility puzzle. The company secures its global offices, production environments, and data centers using Cloudflare Access for clientless context- and identity-based user identification. Access helps Pagsmile improve tech efficiency and protect the company’s critical apps and highest-risk user groups while promoting on-demand, frictionless global access from anywhere.

“Traditional safety is based on trusting IP addresses or geographic locations, but as a payments processor we need to accurately identify and audit each individual in every one of our offices,” says Wang. “With Cloudflare, we can add layers of protection — even to potentially insecure applications — and ensure we never expose our internal tools on the public network while maintaining seamless availability for employees worldwide.”

Enhancing the international user experience and improving infrastructure and application performance

To ensure optimal performance even in areas with limited international connectivity, Pagsmile leverages Cloudflare performance services on the global network. These include static content delivery via the Cloudflare global network, and Workers , globally deployed modern cloud applications from the Cloudflare Developer Platform that improve performance and scalability by avoiding round trips to the company’s origin servers.

Pagsmile uses the Developer Platform’s edge-based R2 global object storage to further improve performance and reduce bandwidth costs in the connectivity cloud. Eliminating fees for data egress, R2 integrates seamlessly with Workers to accelerate dynamic content delivery.

Using Workers, Smart Placement intelligently executes code in the connectivity cloud either closer to the data or closer to the user, whichever provides the best performance.

“Bandwidth, especially CDN traffic in Latin America, is expensive,” says Wang. “Not only does Cloudflare bring us cost savings, it is a networking pioneer that brings us tangible performance and user experience gains without ever compromising safety.”

With their portable multi-cloud architecture, Workers and R2 also simplify Pagsmile’s new product and application deployment efforts, speeding Pagsmile’s development, testing, and time to market as a growing enterprise.

Accelerating compliance efforts with out-of-the-box Cloudflare solutions

As well as protecting and accelerating Pagsmile’s day-to-day operations, Cloudflare plays a key role in helping the company maintain regulatory security compliance by meeting several fundamental Payment Card Industry Data Security Standard (PCI DSS) and ISO 27001 requirements out of the box.

Cloudflare compliance features like one-click certified region setup are ISO 27001 certified, and Cloudflare became a certified Publicly Identifiable Information (PII) Controller and Processor in 2021, laying the groundwork to help expedite Pagsmile’s certification process.

“Almost every Cloudflare product addresses one or another of our security, performance, or compliance use cases,” says, Wang. “It’s almost impossible for other vendors to compare with the confidence and variety of solutions Cloudflare brings to the table.”

It is that broad functionality in the connectivity cloud that has fuelled the Pagsmile-Cloudflare partnership since 2017. Pagsmile plans to continue the collaboration into the future, relying on Cloudflare to provide even greater technical advancements and unparalleled customer service.

“I admire Cloudflare’s people and the culture of innovation it has created,” says Wang. “Its products are strong, flexible, and solve a more comprehensive list of challenges than any other vendor in the industry.”

• Web Application Firewall (WAF)
• DDoS Mitigation
• Rate Limiting
• Bot Management
• Email Security
• Blocked complex layer 7 Challenge Collapsar (CC) attacks very effectively, safeguarding sensitive data and securing customer transactions
• Improved scalability and performance across international markets, ensuring a consistent, high-quality user experience for all
• Accelerated regulatory compliance efforts
• Reduced operational costs and increased efficiency through automated detection and threat mitigation
• Enabled secure, work-from-anywhere infrastructure for a growing global workforce

“ Almost every Cloudflare product addresses one of our security, performance, or compliance use cases. It’s almost impossible for other vendors to compare with the confidence and variety of solutions Cloudflare brings to the table. ”

Jack Wang Director of Business, Pagsmile

“ Cloudflare email security is so effective that once we turned it on, we stopped seeing threats overnight with no extra configuration — it intercepts thousands of problem emails every month. ”

Getting Started

• For enterprises
• Compare plans
• Get a recommendation
• Request a demo
• Contact sales
• Learning center
• Analyst reports
• Cloudflare Radar
• Cloudflare TV
• Case studies
• White Papers
• Developer docs
• Architecture Center
• Find an expert
• Connectivity cloud
• SSE and SASE services
• Application services
• Network services
• Developer services
• Community hub
• Project Galileo
• Athenian Project
• Cloudflare for Campaigns
• Critical Infrastructure Defense Project
• Connect 2024
• Help center
• Cloudflare status
• Trust & safety
• About Cloudflare
• Investor relations
• Diversity, equity, & inclusion
• Network map
• Logos & press kit
• Become a partner

Search the site

Links to social media channels

Can Behavioural Science Help Scale Climate Change Adaptation Solutions?

Applying behavioural science to climate change adaptation solutions might feel resource intensive, but research shows it is likely less costly than an intervention that doesn’t work.

Adapting to the impacts of climate change requires changing behaviour on an individual and a collective level—from how households make a living to how communities manage ecosystems, as well as how governments make investments. So why do we ignore the factors that drive how, when, and why people make decisions as we’re designing and implementing climate change adaptation solutions? IISD and Rare ’s new report illustrates how behavioural science can help to question and reframe our assumptions about people’s decision making while supporting us in designing interventions that are grounded in a greater understanding of the psychological, social, and structural drivers of human actions. 

The Challenge of Understanding People 

Several factors prevent countries from implementing and accelerating climate change adaptation solutions. Lack of financial resources and the uncertainties associated with future climate risks are just two of them. But these aren’t the only barriers. Specifically, the psychological and socio-cultural drivers of behaviour are often left unaddressed.  

In other words, we ignore the factors that drive how, when, and why people make decisions and take action when designing and implementing adaptation solutions.

Scientific bodies like the Intergovernmental Panel on Climate Change (IPCC), in its Assessment Report Six (IPCC, 2022), recognize the importance of understanding the behavioural dimensions of climate change adaptation. However, in practice, the psychological and socio-cultural factors that influence the adoption of climate change adaptation solutions are often under-researched or ignored.    

This is a major hurdle, considering that adapting to the impacts of climate change requires changing behaviour on both an individual and a collective level—from how households make a living to how communities manage their ecosystems, as well as how governments make investments.   

Tackling behaviour directly can feel quite complex. First, various historical, politico-economic, socio-cultural, and psychological factors can shape people’s decision-making processes.  

Second, people’s actions are situated within a decision-making system comprised of multiple actors, including governments, development partners, civil society organizations, the private sector, communities, and individuals—all facing unique incentives.  

Third, our understanding of how people make decisions is often based on assumptions, which leads to ineffective interventions.  

Conscious and unconscious processes—such as habits, emotions, biases, and social influence—impact people’s decisions. This means that even when people understand the relevance of a specific solution and shift their attitudes or intentions toward it, this often is not enough for them to adopt the solution.  

Most interventions designed to change behaviour tend to overlook such insights, so applying behavioural science to the design and implementation of climate change adaptation initiatives could help us address past failings and improve the acceptability, effectiveness, and sustainability of solutions. 

Aerial view of Naveiveiwali village and Wainibuka river and riverbank.

Case Study on Ecosystem-Based Adaptation in Fiji 

To pilot and apply a behavioural science lens to a climate change adaptation solution, we focused on a past ecosystem-based adaptation (EbA) project implemented by the Fijian government. 

EbA, also called nature-based solutions for adaptation, is an approach for adjusting to the impacts of climate change that focuses on protecting, restoring, and enhancing ecosystem services, all while improving communities’ well-being. The Fijian government is seen as a leader on this topic because it recognizes the need to prioritize EbA in key strategic policy documents. 

Between 2019 and 2020, the Fijian government implemented a project that supported communities vulnerable to riverine erosion and flooding by giving them vetiver grass to plant along the riverbanks. Vetiver is a non-invasive species of grass with a fast-growing and deep root system that helps stabilize the soil. It is a robust solution to manage climate uncertainties because of its tolerance to both prolonged drought and waterlogging.  

The government deployed a one-off intervention in the villages that did three things: i) they provided free vetiver seedlings through a new vetiver grass nursery at the provincial level; ii) they provided payment for ecosystem services, meaning that each village—through existing community groups—got paid to collectively plant vetiver along the riverbank; and iii) government officials hosted awareness-raising sessions on vetiver planting targeted at men and young people. 

However, in 2023, 3 years after the communities had planted the seedlings, there had been no maintenance of the vetiver along the riverbanks in any of the villages.  

Our research, therefore, sought to explore the behavioural variables that could have contributed to (or impeded) the adoption of vetiver as an erosion-reducing practice among target communities. We selected three rural Indigenous Fijian communities that benefited from this project and a fourth one that did not receive support as a comparison site.  

Six Main Drivers of Adoption 

Our research found that the key drivers influencing vetiver grass adoption for riverbank rehabilitation in selected communities in Fiji are complex but identifiable.  

Many factors likely influence decision making around vetiver grass adoption at the household and community levels. Our analysis revealed that the six main drivers influencing the adoption (or non-adoption) of vetiver grass for riverbank erosion control against flooding were 

salience of loss : whether villagers feel strongly about the negative impacts that erosion and flooding have on their lives 

choice uncertainty : whether villagers are certain about the options available to them to reduce erosion 

outcome efficacy : whether villagers feel vetiver grass will successfully reduce erosion 

collective efficacy : whether villagers feel their community can plant and maintain vetiver to reduce erosion 

self-efficacy : whether villagers feel they personally can successfully plant and maintain vetiver grass to reduce erosion 

material access : whether villagers feel they can easily access and afford vetiver 

We found that together, these drivers worked in concert to push and pull decision-makers toward or away from adopting and maintaining vetiver grass. 

Each of these variables was identified from the data and further broken down into its constituent factors. The first two examples listed are salience of loss and choice uncertainty.  

Salience of loss refers to the emotional and cognitive responses individuals had toward flood risks and riverbank erosion. When discussing vetiver, several aspects repeatedly surfaced. Participants frequently mentioned experience with flooding and erosion, noting that riverine erosion and flooding seemed to be becoming more frequent and intense. One respondent noted, “The floods have become more often than normal [and] more intense, and the currents are way more swift and bold now that it eats away at our riverbanks every time it floods.” 

Another said, "We are very concerned that our village is going to be washed off one day. Flooding is occurring more regularly now as the river has become shallow and wider in some places where erosions have happened. The erosion keeps moving inland; we are concerned that one day it is going to take away houses too." 

These comments tied into the emotional salience of flooding, which was also a recurring theme. Participants expressed strong negative emotion related to the impact of riverine erosion and flooding on their lives and those of others.  

What was particularly striking was the way participants referred to the loss of land as a direct dilution of their cultural identity. Their attachment to place was obvious, with respondents' cultural identity being closely linked to their land, including the riverbank, heightening their concern about erosion.  

One participant said, “[The riverbank] is also a place where we rest and talk about our issues, it’s a bonding place for us women while we’re washing, fishing, or harvesting vegetables,” while another respondent mentioned, “The riverbanks are eroding fast, and we are losing land. Land is an important inheritance culturally as the size of the land depicts the strength of the clan.” 

Choice uncertainty involved the perceived lack of clear information about the options available for reducing flood risks. Participants often wondered what other solutions might be available for the community to use. This uncertainty can diminish people’s sense of agency, and respondents felt they lacked information about the choice set available to them and their outcomes. Community members weren’t clear on all the options at hand to help fight erosion or how these options compared to one another—or even to doing nothing. As one participant said, "We want to continue with vetiver but also want to know what other interventions are out there that we can probably choose from." 

In scenarios where such decisions could reduce farming land’s immediate potential, combined with our human propensity for preferring known, predictable risks over unknown, ambiguous ones, this uncertainty could be particularly problematic.  

The semi-structured interviews revealed that approximately 43% of respondents expressed uncertainty regarding the relative effectiveness of both hard and natural infrastructure. Opinions were evenly split on whether natural infrastructure like vetiver is more effective than hard infrastructure like walls. It was the same with the benefits of vetiver, with only half of respondents (48%) believing that planting vetiver would benefit them personally. Qualitatively, respondents also noted a perceived lack of relevant information on vetiver itself, with comments such as, "[We've received] no trainings/awareness on vetiver grass and its benefits," and "We've heard about it during the community planting program but there was no training or awareness done."  

Trust in authorities was another recurring theme, particularly related to how much faith villagers put in key messengers and their information. 

For a further breakdown of the other variables, you can read our full report here .

Lessons in Addressing Climate Change Adaptation by Understanding People  

This case study illustrates how behavioural science can help to question and reframe our assumptions about people’s decision making and support us in designing interventions that are grounded in a greater understanding of the psychological, social, and structural drivers of human actions. 

Behavioural science research shows that a combination of interventions addressing multiple drivers is often required to drive and sustain collective action, and a singular intervention is unlikely to address all variables driving decision making at the household and community levels. 

This means that while each of the six drivers is important to support vetiver grass adoption, addressing each variable in a siloed manner will likely not be sufficient to bring sustained change.  

In this case, the Fijian government and development partners need to craft interventions that specifically target and address the drivers of vetiver grass adoption identified through research, rather than relying on the assumptions that we all too often fall prey to, for example, that more information will lead to behaviour change. In doing so, they can then test and validate whether those interventions lead to the psychological, social, or structural changes predicted to result in greater adoption (and to identify how a change in a specific driver influences behaviour downstream). 

More broadly, expanding the application of behavioural science into the realm of climate change adaptation calls for establishing new partnerships between climate change adaptation experts and behavioural scientists.  

Behavioural scientists are already engaging in many fruitful areas of collaboration, such as on financial, public health, and food choice decision making.

Our analysis highlights how important—and urgent—it is for climate change adaptation professionals to also engage with behavioural scientists early, at the start of project formulation rather than in the diagnosis phase, to ensure that initiatives are informed by a deep understanding of human behaviour.  

This is alongside real and considered community engagement, which is essential to understanding current behaviour and what it means for enhancing resilience and consideration of the adoption of EbA solutions within the broader context of climate change adaptation and development. In this case, the focus on vetiver adoption at the local level should not overlook the broader and more systemic issues that are causing riverbank erosion, likely driven by unsustainable development such as deforestation, poor road drainage systems, and gravel extraction from the riverbed. Climate change is exacerbating the negative impacts of these factors on communities that are dependent on riverine ecosystems for their livelihoods, and focusing solely on changing behaviour at the household and community levels is not enough to effectively address climate change adaptation.  

Finally, applying behavioural science can feel fairly resource intensive, and identifying ways to make this cost-benefit ratio relevant to policy-makers might be necessary if we are to scale climate change adaptation solutions more globally. Understanding current behaviour, and what determines behaviour, often requires collecting and analyzing multiple rounds of primary data at the household and community levels. However, this approach is likely a lot less costly than having an intervention not work, as it’s clear that failure to properly engage with communities in understanding and testing the factors that influence their climate change adaptation behaviour can backfire.  

Deep Dive details

You might also be interested in, behavioural science for climate change adaptation.

Applying behavioural science to climate change adaptation solutions may feel resource intensive, but research shows it is likely less costly than an intervention that doesn't work.

August 19, 2024

Biodiversity Is in Crisis—Here's one way to fix it

A growing movement of projects and partnerships is using locally driven and gender-responsive nature-based solutions to address the twin crises of climate change and biodiversity loss. Scaling up this work to match the urgency and reach of the crises will be a challenge—but it’s one we must embrace.

May 21, 2024

New initiative harnesses power of nature to build resilience and protect biodiversity

The Climate Adaptation and Protected Areas (CAPA) initiative will use nature-based solutions to support local communities in adapting to climate change while safeguarding critical ecosystems in and around protected areas.

Press release

September 8, 2023

How Fiji Is Using the National Adaptation Plan (NAP) Process to Scale Up Ecosystem-Based Adaptation (EbA)

Fiji is using its national adaptation planning efforts to scale up and make Ecosystem-based Adaptation (EbA) a strategic priority.

June 1, 2021

• College of Nursing
• Location Location
• Contact Contact
• Colleges and Schools
• Nursing News

Breastfeeding Awareness Month: The Gift of Donor Milk

Breastfeeding Awareness Month celebrates the significant health benefits of breastfeeding for both mothers and infants. For families facing hurdles with breastfeeding who still wish to provide their babies with the nutritional benefits of human breast milk, donor milk offers a solution. Donor human milk, collected by lactating mothers who have excess milk supply, is carefully collected, screened, processed, and distributed by milk banks to support infants in need. We talked with two supporters involved with Mocha Mamas Milk , a breastfeeding research and support initiative co-led by the College of Nursing’s Dr. Tisha Felder and Dr. Joynelle Jackson , to share their journey with donor milk.

Common barriers faced by new mothers that can impact milk supply:

• Health Complications
• Breastfeeding Difficulties
• Environmental Conditions
• Socioeconomic Challenges

"Human milk is unparalleled in providing infants with essential nutrients and antibodies. Access to donor milk removes obstacles for mothers who cannot provide their own, ensuring their infants still receive the nourishment they need to grow and thrive." - Dr. Tisha Felder

In 2016, DeOnna Greenwood’ s first pregnancy was marked by an early labor. Her newborn son faced challenges with latching due to his small size. During this challenging period, her Neonatal Intensive Care Unit (NICU) nurse introduced her to the concept of donor milk. The nurse explained that donor milk could offer crucial nutrition for her premature baby, highlighting its potential benefits. This conversation was a pivotal moment for DeOnna, as it helped her recognize the immense value of donor milk. As the weeks went by, DeOnna discovered she was an overproducer—her milk supply far exceeded her baby’s needs. Her nurse shared the surplus milk could be donated to other infants facing similar challenges. Eager to support other families in need, DeOnna embraced the opportunity to donate her excess milk during both pregnancies, totaling over 10,000 ounces of milk donated.

Longtime breastfeeding advocate, Jessica Vann , discovered she was an overproducer during her first pregnancy in 2012, when she noticed the large quantities of milk she was able to store and provide for her child until age two. Motivated by her experience, she decided to become a milk donor during her second pregnancy in 2018, successfully supplying milk not only for her own daughter but also for five other babies. Jessica has also witnessed the tangible benefits of donated milk firsthand. When her sister gave birth to twins, Jessica's sister chose to use donor milk from the hospital’s milk bank, rather than formula, to meet the increased caloric needs of her newborns, highlighting a crucial instance where donated breast milk can significantly support a family in need.

Challenge the conventional. Create the exceptional. No Limits.

• Icon Twitter
• Subscribe to our newsletter

• Agriculture and Food Systems
• Biodiversity Conservation
• Climate Finance
• Conflict and Governance
• Gender and Social Inclusion
• Humanitarian Assistance
• Infrastructure
• Natural Climate Solutions
• Natural Resource Management
• Water and Sanitation
• Where We Work
• All Resources
• Climate Risk Management
• Climate Strategy Implementation
• Monitoring & Evaluation
• Tools & Support
• Engage with Us
• Photo Gallery
• Climate Strategy

The RISE Grants Challenge: Addressing Gender-based Violence in Climate and Environmental Contexts

Climate resilience includes adapting to changes in both physical surroundings and social environments. For example, women around the world have demonstrated resilience to climatic changes that jeopardize their safety. Gender-based violence (GBV) occurs when women are targeted and harmed based on their gender. As the likelihood of GBV rises with increasing environmental degradation, women need to continue to adapt to climate change to strengthen their resilience to its impacts.

The Resilient, Inclusive and Sustainable Environments (RISE) grants challenge is a first-of-its-kind grant fund that supports activities designed to address GBV in environment and climate change programs and generate evidence on promising interventions. Managed by IUCN and funded by USAID and Norad , the RISE grants challenge supports projects in preventing, mitigating, and responding to GBV across environment and climate contexts in Asia, Latin America, and sub-Saharan Africa. Its mission is to produce learning and knowledge tools that can be adapted and used in environmental activities in other areas and regions. The 2023 Call for Proposals resulted in the submission of 814 applications, 663 of which focused on climate change and GBV linkages. 

This year, IUCN and its partners announced four projects as the newest cohort of the RISE grants challenge:

The resource-ful empowerment project: addressing gbv for the green transition in the democratic republic of the congo.

The extraction of tin, tantalum, and tungsten—the 3Ts—is considered vital for greening the global economy. However, women workers at the artisanal and small-scale mining (ASM) sites where extraction occurs in eastern Democratic Republic of the Congo have experienced sexual harassment and sexual exploitation. Action pour la Sauvegarde de l’Enfant et de la Femme Abandonnés (ASEFA) is leading the Resource-ful Empowerment Project to address sexual exploitation in ASM sites through grassroots community education and social norms change mobilization. Continuing a previous RISE grants challenge project, ASEFA will also promote environmental sustainability training on safe mining practices, focusing on the protection of the environment and the people in ASM sites.

Women RISE for Nature: Identifying GBV and Land Rights Violations in Kenya

Competition for land has increased since the introduction of carbon credit projects in several regions of Kenya , negatively impacting women's land rights. Because of harassment, threats, and physical assault by those close to them, women have been forced to give up their land to protect their safety. In  response, TMG Research gGmbH (TMG) developed Haki Ardhi , a decentralized tenure rights reporting and monitoring tool. Haki Ardhi, which means “land justice” in Swahili, records GBV related to land disputes in order to provide legal and psychosocial referrals. Collected data will be used to identify GBV and land rights violation hotspots. Along with Haki Ardhi, the Women RISE for Nature project will also work on sensitization of male community members to mitigate rights violations and support women's equitable participation in carbon credit projects.

Cultivating Change and Breaking Barriers: Combating GBV Through Women’s Cooperatives in Guatemala

GBV threatens Indigenous women at higher rates than any other group in Guatemala . The city of Totonicapán has seen an increase in physical, sexual, and psychological violence against these women as a result of climate and conflict-related outmigration by men into the area. Gender norms have restricted their ability to engage in economic growth. Justice Education Society of BC has partnered with local organizations to establish COPRODA, Guatemala’s newest women-owned farming cooperative. The initiative seeks to empower women and men to address GBV together through both active participation of women in the cooperative and GBV mitigation training.

RESIST: Raising Awareness of GBV Against Women Environmental Human Rights Defenders in Nepal

Indigenous women in Nepal’s Kailali District have been targeted because of their practice of managing and using natural resources for their livelihoods. Community Forest User Groups (CFUGs) restrict these women from decision making, and forest guards use physical violence to deny them access to essential timber and non-timber products. Providing safe access to forest resources through GBV mitigation, DanChurchAid will work to ensure these women can contribute to climate adaptation and mitigation. The RESIST project will use survivor-centered storytelling to raise awareness of GBV in the sector and male champions to advocate for gender equality within CFUGs.

For more information on the RISE grants challenge, please visit https://genderandenvironment.org/rise-challenge/ .

Strategic Objective

Jason ocampo.

Jason Ocampo is a Gender Programme Support Officer for the Human Rights In Conservation Team at IUCN. His work focuses on gender-based violence, primarily through supporting the management of the RISE grants challenge. He is a graduate of Binghamton University, with a degree in Human Development from the College of Community and Public Affairs.

Related Resources

Climate Risk Management Portal

Case Study: A Health Early Warning System to Reduce Extreme Heat Impacts in Senegal

Case Study: PEPFAR’s El Nino Response: Lessons Learned from Food Security and HIV/AIDS Crisis Funding

Case Study: Anticipatory Action to Reduce the Impact of Extreme Weather Events on Health

More on the blog, building effective monitoring networks: a locally led approach to fighting climate change.

• Shannon Vasamsetti

USAID Receives Recognition for Leadership on Climate-Related Risk Disclosure in Financial and Performance Reporting, Enhancing Climate Resilience

• Greg Shanahan

Climate and Mobility: USAID Addresses Migration as an Engine for Resilience

• Laurie Ashley

AFAC Conference & Exhibition 2024

Panasonic TOUGHBOOK is proud to be exhibiting at this year's AFAC24, Australasia’s largest and most comprehensive emergency management conference and exhibition.

3rd-5th September 2024

Share this link via:

Or copy link:

Link has been copied

Select your language

• Asia-Pacific

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

Solutions for #8WeekSQLChallenge using SQL Server.

qanhnn12/8-Week-SQL-Challenge

Folders and files.

Repository files navigation

🔥 8-week sql challenge.

This repository contains my solution for the #8WeekSQLChallenge using MS SQL Server.

Thanks @DataWithDanny for interesting SQL case studies! 👋🏻

📕 Table of Contents

• Case Study #1 - Danny's Diner
• Case Study #2 - Pizza Runner
• Case Study #3 - Foodie-Fi
• Case Study #4 - Data Bank
• Case Study #5 - Data Mart
• Case Study #6 - Clique Bait
• Case Study #7 - Balanced Tree Clothing Co.
• Case Study #8 - Fresh Segments

🍜 Case Study #1 - Danny's Diner

Danny seriously loves Japanese food so in the beginning of 2021, he decides to embark upon a risky venture and opens up a cute little restaurant that sells his 3 favourite foods: sushi, curry and ramen.

Danny’s Diner is in need of your assistance to help the restaurant stay afloat - the restaurant has captured some very basic data from their few months of operation but have no idea how to use their data to help them run the business.

View the case study here and my solution here .

🍕 Case Study #2 - Pizza Runner

Danny was scrolling through his Instagram feed when something really caught his eye - “80s Retro Styling and Pizza Is The Future!”

Danny was sold on the idea, but he knew that pizza alone was not going to help him get seed funding to expand his new Pizza Empire - so he had one more genius idea to combine with it - he was going to Uberize it - and so Pizza Runner was launched!

Danny started by recruiting “runners” to deliver fresh pizza from Pizza Runner Headquarters (otherwise known as Danny’s house) and also maxed out his credit card to pay freelance developers to build a mobile app to accept orders from customers.

🥑 Case Study #3 - Foodie-Fi

📊 Case Study #4 - Data Bank

There is a new innovation in the financial industry called Neo-Banks: new aged digital only banks without physical branches.

Danny thought that there should be some sort of intersection between these new age banks, cryptocurrency and the data world…so he decides to launch a new initiative - Data Bank!

The management team at Data Bank want to increase their total customer base - but also need some help tracking just how much data storage their customers will need.

This case study is all about calculating metrics, growth and helping the business analyse their data in a smart way to better forecast and plan for their future developments!

🛒 Case Study #5 - Data Mart

Data Mart is Danny’s latest venture and after running international operations for his online supermarket that specialises in fresh produce - Danny is asking for your support to analyse his sales performance.

In June 2020 - large scale supply changes were made at Data Mart. All Data Mart products now use sustainable packaging methods in every single step from the farm all the way to the customer. Danny needs your help to quantify the impact of this change on the sales performance for Data Mart and it’s separate business areas.

🐟 Case Study #6 - Clique Bait

Clique Bait is not like your regular online seafood store - the founder and CEO Danny, was also a part of a digital data analytics team and wanted to expand his knowledge into the seafood industry!

In this case study - you are required to support Danny’s vision and analyse his dataset and come up with creative solutions to calculate funnel fallout rates for the Clique Bait online store.

👕 Case Study #7 - Balanced Tree Clothing Co.

Balanced Tree Clothing Company prides themselves on providing an optimised range of clothing and lifestyle wear for the modern adventurer!

Danny, the CEO of this trendy fashion company has asked you to assist the team’s merchandising teams analyse their sales performance and generate a basic financial report to share with the wider business.

🍊 Case Study #8 - Fresh Segments

Danny created Fresh Segments, a digital marketing agency that helps other businesses analyse trends in online ad click behaviour for their unique customer base.

Clients share their customer lists with the Fresh Segments team who then aggregate interest metrics and generate a single dataset worth of metrics for further analysis. In particular - the composition and rankings for different interests are provided for each client showing the proportion of their customer list who interacted with online assets related to each interest for each month.

Danny has asked for your assistance to analyse aggregated metrics for an example client and provide some high level insights about the customer list and their interests.

✨ Contribution

Contributions, issues, and feature requests are welcome!

To contribute to this project, see the GitHub documentation on creating a pull request .

Please give me a ⭐️ if you like this project!

© 2022 Anh Nguyen

• TSQL 100.0%

• Share full article

For more audio journalism and storytelling, download New York Times Audio , a new iOS app available for news subscribers.

• Apple Podcasts
• Google Podcasts

The Republican Plan to Challenge a Harris Victory

How a right-wing takeover of an obscure, unelected board in georgia could swing the election..

Hosted by Michael Barbaro

Featuring Nick Corasaniti

Produced by Olivia Natt Asthaa Chaturvedi and Eric Krupke

Edited by Patricia Willens

With Lexie Diao and Michael Benoist

Original music by Dan Powell Corey Schreppel Rowan Niemisto and Diane Wong

Engineered by Chris Wood

Listen and follow ‘The Daily’ Apple Podcasts | Spotify | Amazon Music | YouTube | iHeartRadio

At the Democratic National Convention, party officials are celebrating polls showing that Kamala Harris is now competitive with Donald Trump in every major swing state across the country.

But in one of those swing states, Republicans have laid the groundwork to challenge a potential Harris victory this fall, by taking over an obscure, unelected board.

Nick Corasaniti, a Times reporter who focuses on voting and elections, explains.

On today’s episode

Nick Corasaniti , a reporter covering national politics for The New York Times.

Background reading

The unelected body that shapes voting rules in Georgia has a new conservative majority, whose members question the state’s 2020 results. They now have new power to influence the results in 2024 .

Kamala Harris and Donald Trump are in close races across Arizona, Georgia, Nevada and North Carolina , crucial swing states that Mr. Trump had seemed poised to run away with.

There are a lot of ways to listen to The Daily. Here’s how.

We aim to make transcripts available the next workday after an episode’s publication. You can find them at the top of the page.

Fact-checking by Susan Lee .

The Daily is made by Rachel Quester, Lynsea Garrison, Clare Toeniskoetter, Paige Cowett, Michael Simon Johnson, Brad Fisher, Chris Wood, Jessica Cheung, Stella Tan, Alexandra Leigh Young, Lisa Chow, Eric Krupke, Marc Georges, Luke Vander Ploeg, M.J. Davis Lin, Dan Powell, Sydney Harper, Michael Benoist, Liz O. Baylen, Asthaa Chaturvedi, Rachelle Bonja, Diana Nguyen, Marion Lozano, Corey Schreppel, Rob Szypko, Elisheba Ittoop, Mooj Zadie, Patricia Willens, Rowan Niemisto, Jody Becker, Rikki Novetsky, Nina Feldman, Will Reid, Carlos Prieto, Ben Calhoun, Susan Lee, Lexie Diao, Mary Wilson, Alex Stern, Sophia Lanman, Shannon Lin, Diane Wong, Devon Taylor, Alyssa Moxley, Olivia Natt, Daniel Ramirez and Brendan Klinkenberg.

Our theme music is by Jim Brunberg and Ben Landsverk of Wonderly. Special thanks to Sam Dolnick, Paula Szuchman, Lisa Tobin, Larissa Anderson, Julia Simon, Sofia Milan, Mahima Chablani, Elizabeth Davis-Moorer, Jeffrey Miranda, Maddy Masiello, Isabella Anderson, Nina Lassam and Nick Pitman.

Nick Corasaniti is a Times reporter covering national politics, with a focus on voting and elections. More about Nick Corasaniti

Advertisement