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...

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

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.

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

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.

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.

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.

The Project Portfolio Management (PPM) market, valued at $5.59 billion in 2025, is projected to experience robust growth, driven by increasing organizational complexity and the need for improved resource allocation and project success rates. A Compound Annual Growth Rate (CAGR) of 4.10% from 2025 to 2033 indicates a significant expansion of this market over the forecast period. Key drivers include the rising adoption of cloud-based PPM solutions, offering enhanced scalability, accessibility, and collaboration features. Furthermore, the increasing demand for data-driven insights and advanced analytics capabilities within PPM software is fueling market growth. The shift towards agile methodologies and the need for better alignment of projects with strategic business goals are also contributing factors. While the market faces challenges such as initial investment costs and integration complexities with existing systems, the overall positive trajectory is expected to continue. The various deployment types (cloud and on-premise) cater to diverse organizational needs and preferences, while solution and service offerings provide comprehensive support throughout the project lifecycle. Significant market segmentation exists across diverse end-user verticals including IT & Telecom, Healthcare & Life Sciences, Manufacturing, Construction, Retail & Consumer Goods, and BFSI, reflecting the widespread applicability of PPM across industries. Leading players like Workday, Wrike, Monday.com, Smartsheet, Microsoft, and others are continuously innovating to enhance their offerings and capture a larger market share. The competitive landscape is characterized by both established players and emerging startups, leading to continuous product improvement and innovation within the PPM market. The North American market currently holds a significant share, driven by early adoption of technology and a mature IT infrastructure. However, growth in regions like Asia and Europe is anticipated to accelerate, fueled by increasing digital transformation initiatives and growing awareness of the benefits of effective project portfolio management. The continued development of sophisticated PPM tools, encompassing features such as AI-powered predictive analytics and risk management functionalities, will play a crucial role in shaping the market's future landscape. This ongoing evolution will further enable organizations to optimize project performance, enhance resource utilization, and ultimately achieve their strategic objectives more effectively. This comprehensive report provides an in-depth analysis of the global Project Portfolio Management (PPM) market, offering invaluable insights for businesses seeking to navigate this rapidly evolving landscape. Covering the historical period (2019-2024), base year (2025), and forecast period (2025-2033), this study delivers a detailed understanding of market dynamics, trends, and future growth potential. The report's robust methodology and meticulous data analysis are designed to assist strategic decision-making, investment planning, and competitive analysis within the PPM sector. The market is valued in millions of USD. Recent developments include: May 2022 - Proggio, a next-generation Project Portfolio Management solution based in Tel Aviv with offices in Salt Lake City, closed a $ 7 million Series A round led by 2.0 Ventures (Salt Lake City) with participation from both existing investors Mangrove Capital Partners (Luxembourg) and Cresson Management (Israel) and use the funding to accelerate its operations and growth in the United States and continue to strengthen its enterprise solution., May 2022 - Onepoint Projects GmbH launched a new version of its ONEPOINT Projects, a web-based project and portfolio management (PPM) solution. This new version integrates support for the Scaled Agile Framework in a new optional module., March 2022 - ServiceNow announced its Now Platform San Diego release. With an upgraded, more modern visual design and new robotic process automation (RPA) capabilities that deliver on the promise of hyper-automation, the latest version of the Now Platform is designed to help organizations address the most pressing challenges facing every industry in every region, and transform businesses for a new economy.. Key drivers for this market are: Recent Changes In Work Culture and Move toward Remote Teams has Made It Imperative to Develop A Centralized View of Task Management and Resource Utilization, Long-term Cost Benefits Enabled By Timely Use of Planning & Scheduling Tools, Coupled With Growing Demand For Cloud-based Ppm; Integration Of Several Allied Modules And Collaborations Have Increased The Span of PPM to Cover The Entire Workspace Related Tasks. Potential restraints include: Evolving Market Regulations. Notable trends are: Recent Changes In Work Culture And Move Towards Remote Teams to Drive the Market.

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 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.

.

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.

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 & 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 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.

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

The Project & Portfolio Management (PPM) software market is booming, projected to reach $9.475 billion by 2033, with an 8.5% CAGR. Discover key market trends, leading vendors (Oracle, SAP, etc.), and growth drivers in this in-depth analysis.

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

Business Portfolio Organizer Market Outlook

According to our latest research, the global Business Portfolio Organizer market size reached USD 2.41 billion in 2024 and is expected to grow at a robust CAGR of 8.2% during the forecast period, reaching USD 4.78 billion by 2033. This impressive growth trajectory is attributed to the increasing demand for efficient business management tools, digital transformation initiatives, and the rising need for streamlined portfolio management across various industries. The market’s expansion is further propelled by technological advancements and the integration of smart features in portfolio organizers, catering to the evolving requirements of both individuals and organizations worldwide.

The primary growth factor driving the Business Portfolio Organizer market is the accelerating shift towards digitalization in business processes. Organizations are increasingly recognizing the importance of maintaining organized, accessible, and secure records of their business activities, projects, and investments. Digital portfolio organizers, equipped with cloud storage, real-time collaboration, and advanced analytics, have become essential tools for modern enterprises aiming to enhance productivity and decision-making. The rising adoption of remote work and hybrid office models has further intensified the need for digital solutions that can seamlessly manage and organize business portfolios from anywhere, at any time. These trends are particularly pronounced among tech-savvy small and medium enterprises (SMEs) and large corporations seeking to optimize workflow efficiency and gain competitive advantages.

Another significant growth driver is the expanding application of business portfolio organizers in educational and personal use cases. Educational institutions are increasingly adopting digital and hybrid portfolio organizers to facilitate student assessment, project tracking, and skill development documentation. Simultaneously, professionals and individuals are leveraging these tools for personal career management, freelance work organization, and continuous learning. The versatility and adaptability of modern portfolio organizers, which cater to a diverse set of users and applications, are fueling their widespread adoption across different end-user segments. Additionally, the growing awareness regarding the benefits of systematic portfolio management—such as improved organization, better resource allocation, and enhanced performance tracking—is contributing to the market’s upward momentum.

Technological innovation remains at the forefront of market growth. The integration of artificial intelligence, machine learning, and data analytics into digital portfolio organizers has revolutionized the way users interact with and derive value from these tools. Features such as automated categorization, predictive analytics, and personalized recommendations are transforming portfolio management into a more intuitive and insightful process. Moreover, the proliferation of mobile devices and the increasing penetration of high-speed internet are making advanced portfolio organizers more accessible to a broader audience. As a result, vendors are continuously investing in research and development to introduce innovative products that address the evolving needs of their customers, thereby sustaining the market’s growth trajectory.

From a regional perspective, North America currently dominates the Business Portfolio Organizer market, accounting for the largest revenue share in 2024, followed closely by Europe and the Asia Pacific. The North American market benefits from the early adoption of digital solutions, a mature IT infrastructure, and the presence of leading market players. Europe is witnessing steady growth driven by increasing investments in digital education and corporate management tools. Meanwhile, the Asia Pacific region is emerging as a lucrative market due to rapid economic development, rising digital literacy, and the growing number of SMEs embracing portfolio management solutions. The Middle East & Africa and Latin America are also expected to experience moderate growth, supported by ongoing digital transformation initiatives and increasing awareness of the benefits of business portfolio organizers.

Product Type Analysis

The Business Portfolio Organizer market by product type is segmented into Digital Portfolio Organizers, Physical Portfolio Organizers, and Hybrid Portfolio Organizers. Digital Portfolio Organizers have witnessed the fastest growth in recent years, primarily due to their ability to of

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