Case Study: How Does a Bike-Share Navigate Speedy Success?¶

Introduction

Welcome to the Cyclistic bike-share analysis case study! In this case study, you will perform many real-world tasks of a junior data analyst. You will work for a fictional company, Cyclistic, and meet different characters and team members. In order to answer the key business questions, you will follow the steps of the data analysis process: ask, prepare, process, analyze, share, and act. Along the way, the Case Study Roadmap tables — including guiding questions and key tasks — will help you stay on the right path. By the end of this lesson, you will have a portfolio-ready case study. Download the packet and reference the details of this case study anytime. Then, when you begin your job hunt, your case study will be a tangible way to demonstrate your knowledge and skills to potential employers.

Scenario

You are a junior data analyst working in the marketing analyst team at Cyclistic, a bike-share company in Chicago. The director of marketing believes the company’s future success depends on maximizing the number of annual memberships. Therefore, your team wants to understand how casual riders and annual members use Cyclistic bikes differently. From these insights, your team will design a new marketing strategy to convert casual riders into annual members. But first, Cyclistic executives must approve your recommendations, so they must be backed up with compelling data insights and professional data visualizations. Characters and teams ● Cyclistic: A bike-share program that features more than 5,800 bicycles and 600 docking stations. Cyclistic sets itself apart by also offering reclining bikes, hand tricycles, and cargo bikes, making bike-share more inclusive to people with disabilities and riders who can’t use a standard two-wheeled bike. The majority of riders opt for traditional bikes; about 8% of riders use the assistive options. Cyclistic users are more likely to ride for leisure, but about 30% use them to commute to work each day. ● Lily Moreno: The director of marketing and your manager. Moreno is responsible for the development of campaigns and initiatives to promote the bike-share program. These may include email, social media, and other channels. ● Cyclistic marketing analytics team: A team of data analysts who are responsible for collecting, analyzing, and reporting data that helps guide Cyclistic marketing strategy. You joined this team six months ago and have been busy learning about Cyclistic’s mission and business goals — as well as how you, as a junior data analyst, can help Cyclistic achieve them. ● Cyclistic executive team: The notoriously detail-oriented executive team will decide whether to approve the recommended marketing program.

About the company

In 2016, Cyclistic launched a successful bike-share offering. Since then, the program has grown to a fleet of 5,824 bicycles that are geotracked and locked into a network of 692 stations across Chicago. The bikes can be unlocked from one station and returned to any other station in the system anytime. Until now, Cyclistic’s marketing strategy relied on building general awareness and appealing to broad consumer segments. One approach that helped make these things possible was the flexibility of its pricing plans: single-ride passes, full-day passes, and annual memberships. Customers who purchase single-ride or full-day passes are referred to as casual riders. Customers who purchase annual memberships are Cyclistic members. Cyclistic’s finance analysts have concluded that annual members are much more profitable than casual riders. Although the pricing flexibility helps Cyclistic attract more customers, Moreno believes that maximizing the number of annual members will be key to future growth. Rather than creating a marketing campaign that targets all-new customers, Moreno believes there is a very good chance to convert casual riders into members. She notes that casual riders are already aware of the Cyclistic program and have chosen Cyclistic for their mobility needs. Moreno has set a clear goal: Design marketing strategies aimed at converting casual riders into annual members. In order to do that, however, the marketing analyst team needs to better understand how annual members and casual riders differ, why casual riders would buy a membership, and how digital media could affect their marketing tactics. Moreno and her team are interested in analyzing the Cyclistic historical bike trip data to identify trends

Three questions will guide the future marketing program:

How do annual members and casual riders use Cyclistic bikes differently? Why would casual riders buy Cyclistic annual memberships? How can Cyclistic use digital media to influence casual riders to become members? Moreno has assigned you the first question to answer: How do annual members and casual rid...

The dataset was created in partnership with Waze for the Google Advanced Data Analytics Professional Certicate Portfolio Project.

The original dataset’s provenance can be traced back to the Professional Certificate itself on Coursera.

The dataset consists of 1 .csv file, including 15,000 observations and 13 distinct variables. The data includes information regarding the activity of individual users of the Waze application, such as number of sessions, drives, kilometers driven, and other activity variables, both in total and on a given month.

The data consists of 13 variables: 8 integer variables, 2 string variables, and 3 float variables.

Qualitative data gathered from interviews that were conducted with case organisations. The data is analysed using a qualitative data analysis tool (AtlasTi) to code and generate network diagrams. Software such as Atlas.ti 8 Windows will be a great advantage to use in order to view these results. Interviews were conducted with four case organisations. The details of the responses from the respondents from case organisations are captured. The data gathered during the interview sessions is captured in a tabular form and graphs were also created to identify trends. Also in this study is desktop review of the case organisations that formed part of the study. The desktop study was done using published annual reports over a period of more than seven years. The analysis was done given the scope of the project and its constructs.

Waze’s free navigation app makes it easier for drivers around the world to get to where they want to go. Waze’s community of map editors, beta testers, translators, partners, and users helps make each drive better and safer. Waze partners with cities, transportation authorities, broadcasters, businesses, and first responders to help as many people as possible travel more efficiently and safely.

The dataset was created in partnership with Waze for the Google Advanced Data Analytics Professional Certificate Portfolio Project.

The dataset consists of 1 .csv file, including 15,000 observations and 13 distinct variables. The data includes information regarding the activity of individual users of the Waze application, such as number of sessions, drives, kilometers driven, and other activity variables, both in total and on a given month.

The data consists of 13 variables: 8 integer variables, 2 string variables, and 3 float variables.

Snapshot img

The cloud-based project portfolio management market share is expected to increase by USD 4.83 billion from 2020 to 2025, and the market’s growth momentum will accelerate at a CAGR of 18.26%.

This cloud-based project portfolio management market research report provides valuable insights on the post COVID-19 impact on the market, which will help companies evaluate their business approaches. Furthermore, this report extensively covers cloud-based project portfolio management market segmentations by end user (manufacturing, ICT, healthcare, BFSI, and others) and geography (North America, Europe, APAC, MEA, and South America). The cloud-based project portfolio management market report also offers information on several market vendors, including Atlassian Corp. Plc, Broadcom Inc., Mavenlink Inc., Micro Focus International Plc, Microsoft Corp., Oracle Corp., Planview Inc., SAP SE, ServiceNow Inc., and Upland Software, Inc. among others.

What will the Cloud-based Project Portfolio Management Market Size be During the Forecast Period?

Download the Free Report Sample to Unlock the Cloud-based Project Portfolio Management Market Size for the Forecast Period and Other Important Statistics

Cloud-based Project Portfolio Management Market: Key Drivers, Trends, and Challenges

The increasing requirements for large-scale project portfolio management is notably driving the cloud-based project portfolio management market growth, although factors such as challenges from open-source platforms may impede market growth. Our research analysts have studied the historical data and deduced the key market drivers and the COVID-19 pandemic impact on the cloud-based project portfolio management industry. The holistic analysis of the drivers will help in deducing end goals and refining marketing strategies to gain a competitive edge.

Key Cloud-based Project Portfolio Management Market Driver

The increasing requirements for large-scale project portfolio management is a major factor driving the global cloud-based project portfolio management market share growth. Currently, organizations are focusing on cultivating and managing the resources necessary for efficient product outputs, which increases the requirements for efficient solutions for large-scale project portfolio management. The primary purpose of the cloud-based project portfolio management software is to automate processes to ensure maximum outputs by managing resources and maintaining a regular follow-up. The main benefit of employing cloud-based project portfolio management software in large-scale project portfolio management is that automated services increase the connectivity so that organizations can handle the project-related inquiries easily and effectively. Also, automation decreases the response time and increases productivity, which ensures efficient process management. Additionally, by using cloud-based project portfolio management software, revenue possibilities can be rapidly increased by calculating conversion ratios and running reports to track the metrics detailed as per the customer demand. These features decrease the operating time. Due to such reasons, the demand for the market will grow significantly during the forecast period.

Key Cloud-based Project Portfolio Management Market Trend

The interlinking of software with project portfolio management is another factor supporting the global cloud- based project portfolio management market share growth. Since the demand for project portfolio management software is rising in the market, the stakeholders in several businesses are demanding new features in the software to increase their productivity. One of the main trends identified in the global cloud-based project portfolio management market is the interlinking of multiple software to match the requirements of the business. Currently, cloud-based project portfolio management software is deployed by several enterprises to give people access to documents, data, and reports from multiple devices at multiple locations. With all the data accessible centrally by numerous users, the accountability of the system will increase, which will provide enterprises with an instant overview of what everyone is working on. Additionally, interlinked project portfolio management software will enable the users to update data in real-time and will end the complication of sending endless email attachments of the same document. Moreover, the implementation of cloud-based project portfolio management will enhance the company's assurance for up-to-date data. Therefore, all such factor will contribute to the growth of the market.

Key Cloud-based Project Portfolio Management Market Challenge

The rising challenges from open-source platforms will be a major challenge for the global cloud-based project portfolio management market share growth during the forecast period. With the rising demand for digitalization in the current market s

Snapshot img

Project Portfolio Management (PPM) Software Market Size 2025-2029

The project portfolio management (PPM) software market size is valued to increase USD 4.79 billion, at a CAGR of 16% from 2024 to 2029. Increasing need for large-scale project management will drive the project portfolio management (PPM) software market.

Major Market Trends & Insights

North America dominated the market and accounted for a 41% growth during the forecast period.
By Deployment - On-premises segment was valued at USD 1.71 billion in 2023
By End-user - BFSI segment accounted for the largest market revenue share in 2023

Market Size & Forecast

Market Opportunities: USD 286.51 million
Market Future Opportunities: USD 4785.50 million
CAGR from 2024 to 2029 : 16%

Market Summary

The market represents a dynamic and continually evolving landscape, driven by the increasing need for effective project management solutions in today's business environment. Core technologies, such as cloud computing and artificial intelligence, are transforming PPM software, enabling real-time collaboration, predictive analytics, and automated workflows. Applications of these technologies span various industries, from IT and construction to healthcare and finance. Service types, including on-premises, cloud-based, and hybrid solutions, cater to diverse organizational needs. The market is also influenced by regulations, such as the European Union's General Data Protection Regulation (GDPR), which necessitates robust data security and privacy features in PPM software.
Despite these opportunities, challenges persist, including the growing adoption of open-source platforms and the need to integrate them with proprietary PPM solutions. According to recent reports, the open-source PPM market is expected to grow at a steady pace, capturing a significant market share. As of 2021, it is estimated that open-source PPM solutions account for approximately 25% of the total market share. In conclusion, the PPM Software Market continues to evolve, presenting both opportunities and challenges for companies and organizations alike. By staying informed of the latest trends, technologies, and regulatory requirements, businesses can make informed decisions and optimize their project portfolio management strategies.

What will be the Size of the Project Portfolio Management (PPM) Software Market during the forecast period?

Get Key Insights on Market Forecast (PDF) Request Free Sample

How is the Project Portfolio Management (PPM) Software Market Segmented ?

The project portfolio management (PPM) software industry research report provides comprehensive data (region-wise segment analysis), with forecasts and estimates in 'USD million' for the period 2025-2029, as well as historical data from 2019-2023 for the following segments.

Deployment

  On-premises
  Cloud-based


End-user

  BFSI
  Information and technology
  Healthcare
  Construction and infrastructure
  Others


Platform

  Software
  Services


Sector

  Large enterprise
  SMEs


Geography

  North America

    US
    Canada
    Mexico


  Europe

    France
    Germany
    UK


  APAC

    China
    India
    Japan


  South America

    Brazil


  Rest of World (ROW)

By Deployment Insights

The on-premises segment is estimated to witness significant growth during the forecast period.

Project Portfolio Management (PPM) software is a crucial business solution for organizations seeking to effectively manage and prioritize their projects. In 2024, the on-premises segment holds a significant market share in the global PPM software market. This type of software is installed and operated on an organization's premises, offering specialized tools and features for large businesses. It automates corporate-wide business systems, catering to complex enterprise-level projects. Currently, approximately 57.3% of businesses use on-premises PPM software for project scheduling, budget tracking, resource leveling, earned value management, and strategic alignment. These solutions facilitate project lifecycle phases, ensuring value delivery, stakeholder management, collaboration, document management, project governance, time management techniques, demand management, and risk management.

Request Free Sample

The On-premises segment was valued at USD 1.71 billion in 2019 and showed a gradual increase during the forecast period.

Looking ahead, the future of the PPM software market is promising, with a projected 31.5% increase in adoption by businesses. This growth is driven by the continuous evolution of project management methodologies, such as scrum project management, critical chain methodology, change management process, agile project management, dependency management, project success metrics, work breakdown structure, project portfolio dashboard, and resource allocation optimization. Moreover, P

Real Estate Database

This is a mock-up of a real estate company, this is based on an actual company that had a number of challenges - collection and revenue is the biggest issue. A deep dive into the available data will provide the possible reasons and is the purpose of the data analytics project.

Here's the fictional business scenario:

Ms. Aurora Sanchez, the Chief Operations Officer (COO) of Prime Estate talked to the operations data analyst team to discuss a couple of her requirements. Ms. Sanchez is responsible for sales, property and project management, customer service, collections, and several other operations departments under her umbrella. When she joined the organization in late 2018, she quickly got several escalations from buyers who were complaining about units, properties that were not turned over on time, and delays in the projects. Ms. Sanchez also noted problems with collections not meeting the targets, and inconsistent sales performance.

As the COO, Ms. Sanchez wants to identify and validate the history of these problems as well as see if there have been improvements in these pain points ever since she joined Prime Estate. Her focus points are Collections, Project Management, Customer Service, Collections, and Sales.

As the Business/Data Analyst Lead, your responsibility is to gather the performance data related to this part of operations, find trends, present findings, and provide recommendations that will help the organization improve the pain points of operations. You must work with the manager of customer service and collections, and the project and property management managers for this undertaking.

The data that is available is an inventory database that includes a listing of all projects, properties, their cost, package price, current status, and sales date. Another database provided is the project management database that tracks the construction initiation, time lapsed till the project is at 90% completion, and another date that tags it at 100% completed. Lastly, the collections database includes a listing of all units that are tagged as sold and tracks the turnover date (the date that the unit was turned over to the owner), collection date (the date that the full amount was based on the package price and all other charges) was collected from the buyer through multiple channels.

I created a web scraper to gather data from entry-level data analyst job postings from LinkedIn, as part of my data analyst portfolio project. I collected data on jobs related to Data analytics and Business Intelligence during the spring of 2023. This dataset is a small sample of the original data collected.

View a detailed description of the project and the analysis of the full data at:

https://terencicp.github.io/linkedin

Our model is examined based on an extensive data set. The values of model parameters are generated randomly using discrete uniform distribution.

Data exploration, cleaning, and arrangement with Covid Death and Covid Vaccination which is involved:

1. Data that going to be using

2. Shows the likelihood of dying if you contract covid in your country

3. Show what percentage of the population got Covid

4. Looking at Countries with the Highest Infection Rate compared to the Population

5. Showing the Country with the Highest Death Count per Population

6. Break things down by continent

7. Continents with the Highest death count per population

8. Looking at Total Population vs Vaccinations

9. Used CTE and Temp Table

10. Creating View to store data for later visualizations

Abstract This study presents a managerial tool for prioritization and portfolio selection of software development projects using the methodology Analytic Hierarchy Process (AHP). The need for better results with scarce resources is a challenge for organizations to generate competitive advantage. The tool is structured according to the analysis of articles related to project prioritization and selection, portfolio management and the AHP methodology. The research approach was quantitative through an applied case study. The case was developed in a medium-sized software company in Santa Catarina, a leader in solutions for management excellence, provider of software and services for automation and business process improvement, regulatory compliance, and corporate governance. It has more than 2000 clients, of diverse sizes and lines of action. A committee was set up with managers and analysts to define the groups and criteria, and the application of a pilot of projects. There were opportunities to use this managerial tool to minimize power play, integration, information sharing, learning, commitment among decision makers and selection of strategically aligned projects.

The size of the Project, Portfolio & Program Management Software market was valued at USD XXX million in 2024 and is projected to reach USD XXX million by 2033, with an expected CAGR of XX% during the forecast period.

The size of the Project Portfolio Management Solutions market was valued at USD XXX million in 2024 and is projected to reach USD XXX million by 2033, with an expected CAGR of XX% during the forecast period.

The size of the Project Portfolio Management Software Market was valued at USD 11.1 billion in 2023 and is projected to reach USD XXX billion by 2032, with an expected CAGR of XX% during the forecast period. Recent developments include: In March 2021, Symphony Technology Group, a U.S.-based private equity firm specializing in innovative software, data, and analytics, acquired Sciforma, a prominent PPM software provider. This acquisition aimed to expand Symphony's portfolio in the project management domain and leverage Sciforma's expertise to offer comprehensive solutions to a broader client base. . Key drivers for this market are: Growing Demand for Cloud-Based PPM Solutions, Need for Comprehensive Insights into Project Operations and Resource Management. Potential restraints include: Concerns Related to Data Confidentiality. Notable trends are: Artificial intelligence (AI) and machine learning (ML) are being integrated into PPM software to provide predictive analytics, automate routine tasks, and optimize resource allocation. These technologies enhance decision-making by identifying potential risks and opportunities.

.

Understand Cloud Project Portfolio Management Market potential with forecast data, size estimates, and growth opportunities through 2034.

The size of the Cloud Project Portfolio Management market was valued at USD XX Million in 2023 and is projected to reach USD XXX Million by 2032, with an expected CAGR of 17.00% during the forecast period. Key drivers for this market are: , Growing Use of BYOD and Mobile Devices; Increased Adoption of Cloud Analytics. Potential restraints include: , Absence of Technical Capabilities and Skills in Handling Complex and Changing Environments. Notable trends are: Healthcare is Anticipated to be One of the Fastest Growing Verticals.

The Project Portfolio Management Systems (PPM) market has become increasingly vital for organizations striving to optimize their project investments and align them with strategic objectives. These systems enable companies to manage multiple projects effectively while ensuring the best possible allocation of resource

Cristy Parsons · Geospatial Portfolio is a dynamic online platform that highlights my expertise and passion for geospatial technologies. This portfolio features a variety of GIS projects I've worked on, showcasing my skills in spatial analysis, mapping, and data visualization. Each project demonstrates the use of GIS tools to address real-world problems, from community art mapping to land use analysis. The site includes interactive maps, embedded StoryMaps, web mapping applications, and other geospatial content, offering visitors an in-depth look at my professional capabilities and projects. It's also a space where I can continue to grow, share new work, and connect with the geospatial community.

The dataset contains information related to supply chain operations, including orders, products, inventory, suppliers, logistics, and demand. It aims to optimize supply chain efficiency and improve performance through predictive analytics, inventory management, and logistics optimization.

Project Portfolio Management (PPM) Software Market Outlook

The Project Portfolio Management (PPM) Software market is experiencing significant growth, with a global market size of approximately USD 4.5 billion in 2023 and is projected to reach nearly USD 9.5 billion by 2032, growing at a compound annual growth rate (CAGR) of 8.5% during the forecast period. This substantial growth can be attributed to the increasing demand for efficient project management solutions across various industries, as businesses aim to optimize their resource allocation, improve project delivery times, and enhance overall productivity. The rising complexity and scale of projects in sectors such as IT, telecommunications, and manufacturing necessitate robust and flexible PPM software solutions, further driving market expansion.

One of the key growth factors in the PPM software market is the digital transformation initiatives undertaken by organizations worldwide. As companies strive to become more agile and competitive, there is a heightened focus on adopting digital tools that streamline operations and improve decision-making. Project Portfolio Management software plays a crucial role in this transformation by providing a centralized platform to manage multiple projects efficiently. It enables organizations to align their project goals with business objectives, facilitating better prioritization and resource management. The ability to gain real-time insights into project performance and resource utilization is particularly appealing to enterprises looking to maintain a competitive edge in today's fast-paced business environment.

Another significant driver of market growth is the increasing adoption of cloud-based PPM solutions. The shift towards cloud computing has been driven by the need for scalability, flexibility, and cost-efficiency. Cloud-based PPM software allows organizations to access their project data and analytics from anywhere, at any time, fostering collaboration among distributed teams. This is especially pertinent in the current global scenario where remote work and virtual collaboration have become the norm. The cloud deployment model also reduces the need for costly IT infrastructure, making it an attractive option for small and medium-sized enterprises (SMEs) that may lack extensive resources.

The integration of advanced technologies such as artificial intelligence (AI) and machine learning (ML) into PPM software is also contributing to market growth. These technologies enhance the capabilities of PPM tools by enabling predictive analytics, automation of repetitive tasks, and improved risk management. AI-powered PPM solutions can provide valuable insights by analyzing historical project data and predicting potential challenges, allowing project managers to make informed decisions proactively. As the technological landscape continues to evolve, the incorporation of such cutting-edge features is likely to become a standard expectation among end-users, further propelling the market forward.

The role of Capital Program Management Software has become increasingly crucial in the landscape of Project Portfolio Management. As organizations undertake large-scale infrastructure projects, the need for specialized software that can handle the complexities of capital program management becomes evident. These software solutions provide comprehensive tools for budgeting, scheduling, and resource allocation, ensuring that projects are completed on time and within budget. By integrating with existing PPM systems, Capital Program Management Software enhances the ability of organizations to manage multiple projects simultaneously, providing a holistic view of project performance and facilitating strategic decision-making. This integration is particularly beneficial for sectors such as construction and government, where the management of capital-intensive projects is a critical component of operational success.

In terms of regional outlook, North America currently holds a dominant position in the PPM software market, primarily due to the presence of a large number of technology giants and a robust IT infrastructure. The region is expected to maintain its leading status throughout the forecast period, driven by continued investment in digital transformation and the adoption of innovative project management solutions. Meanwhile, the Asia Pacific region is anticipated to exhibit the highest growth rate, with a CAGR surpassing 10%. This rapid expansion is attributed to the increasing industrialization, growing IT sector, and rising awarenes