- Oct 18, 2021
- 10 min read
Google Data Analytics Capstone Project
Updated: Jul 5, 2023
I worked on the Google Data Analytics Capstone Project, Track 1, Case Study 1. I will be diving into the background, my full process of cleaning, analyzing and visualizing the data, along with my final suggestions and summary of the data.
Quick Links :
Tableau Dashboard | Github R Code for Analysis | Github R Code for Tableau Visualization | LinkedIn Post
Below is a table of contents in case you want to go to a specific section.
Table of Contents:
Microsoft excel.
Finished Project
Summary of Data
Business Suggestions
What I Learned
Cyclistic is a bike sharing program which features more than 5,800 bikes and 600 docking stations. It offers reclining bikes, hand tricycles, and cargo bikes, making it more inclusive to people with disabilities and riders who can't use a standard two-wheeled bike. It was founded in 2016 and has grown tremendously into a fleet of 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.
Previously, Cyclistic's marketing strategy tried to build the general awareness and appeal to broad consumers. It has flexible pricing plans: single-ride passes, full-day passes, and annual memberships. Those who purchase single-ride or full-day passes are referred to as casual riders while those who purchase annual memberships are Cyclistic members .
My Role : In this scenario I am a junior data analyst at Cyclistic and my team has been tasked with the overall goal (see below) of designing marketing strategies
Overall Goal : Design marketing strategies aimed at converting casual riders into annual members.
Business Question : "How do annual members and casual riders use Cyclistic bikes differently?"
Below I will describe step-by-step the process I used to for this project. If you want to skip ahead to the business suggestions move onto the section "Insights".
Overview : I first analyzed the data separately (each month) in Excel, then used R to analyze the data as a whole (one year). Finally I created a dashboard in Tableau and used Figma to support the design elements.
I initially wanted to gather and analyze my data in Excel because it was the tool I was most familiar with and I could get a general understanding of the data quicker. I did not combine all of the spreadsheets into one because that would've taken more processing power than my computer had.
I began downloading the data from divvy-tripdata , and turning the .csv files into excel spreadsheets. I downloaded the most recent year of data which was at the time of starting my project:
August 2020
September 2020
October 2020
November 2020
December 2020
January 2021
February 2021
Added two columns to all of the months:
ride_length calculated the total ride length for each trip using the start_at column which was: ending time minus starting time.
day_of_week calculated the day of the week for each trip using the start_at column date.
Went over the business task and the information I had at hand and how that could be used to figure out how members and casual riders use the bike service differently
Came up with metrics to look at such as :
total number of rides per hour, per day of the month, per season, per day of the week, and for different bike types
Average ride length between members and casual
For every month in Excel created pivot tables and charts to go with the analysis on (this took the longest):
Total Rides per Weekday - calculated the total rides for members and casual and separated it by day of the week; used a cluster column chart
Average Ride Length - calculated the average ride length for members and casual and separated it by day of the week; used a cluster column chart
Total Rides per Hour - calculated the total rides for members and casual separated by the time of the day (24hr); used a line comparison chart
Total Rides per Day - calculated the total rides for members and casual separated by the day of the month; used a line comparison chart
Total Rides per Bike Type - calculated the total rides for members and casual separated by Bike type; used stacked column chart
I also created a Google docs Notes list where I wrote down the exact steps for each month (had a checklist) and included my insights for each month
Time Spent:
535 minutes or just under 9 hours to complete.
I originally wanted to use SQL but the files were too big to upload and I couldn't figure out how to utilize Google Cloud Platform. Instead I used R to analyze the data because it could handle all of the information quicker than Excel, and I wanted to work on my R skills. Below is my general process in R, I didn't include my mistakes/missteps or errors for the sake of brevity.
View my full code on my Github for this capstone project here .
Load all of the libraries I used: tidyverse, lubridate, hms, data.table
Uploaded all of the original data from the data source divytrip into R using read_csv function to upload all individual csv files and save them in separate data frames. For august 2020 data I saved it into aug08_df, september 2020 to sep09_df and so on.
Merged the 12 months of data together using rbind to create a one year view
Created a new data frame called cyclistic_date that would contain all of my new columns
Created new columns for:
Ride Length - did this by subtracting end_at time from start_at time
Day of the Week
Time - convert the time to HH:MM:SS format
Season - Spring, Summer, Winter or Fall
Time of Day - Night, Morning, Afternoon or Evening
Cleaned the data by:
Removing duplicate rows
Remove rows with NA values (blank rows)
Remove where ride_length is 0 or negative (ride_length should be a positive number)
Remove unnecessary columns: ride_id, start_station_id, end_station_id, start_lat, start_long, end_lat, end_lng
Calculated Total Rides for:
Total number of rides which was just the row count = 4,152,139
Member type - casual riders vs. annual members
Type of Bike - classic vs docked vs electric; separated by member type and total rides for each bike type
Hour - separated by member type and total rides for each hour in a day
Time of Day - separated by member type and total rides for each time of day (morning, afternoon, evening, night)
Day of the Week - separated by member type and total rides for each day of the week
Day of the Month - separated by member type and total rides for each day of the month
Month - separated by member type and total rides for each month
Season - separated by member type and total rides for each season (spring, summer, fall, winter)
Calculated Average Ride Length for:
Total average ride length
Type of Bike - separated by member type and average ride length for each bike type
Hour - separated by member type and average ride length for each hour in a day
Time of Day - separated by member type and average ride length for each time of day (morning, afternoon, evening, night)
Day of the Week - separated by member type and average ride length for each day of the week
Day of the Month - separated by member type and average ride length for each day of the month
Month - separated by member type and average ride length for each month
Season - separated by member type and average ride lengths for each season (spring, summer, fall, winter)
Then using all of this data I created my own summary in my case notes and took note of the: total rides for each variable, average ride lengths for each variable, and the difference between members versus casual riders. I originally wanted to create a report using R Markdown as well but for the sake of time (I had already spent over 20 hours on the project so far), I decided to skip this step, and write this article instead.
1045 minutes or about 17 and a half hours to complete.
While I learned the basics of Tableau in the Google Course I wanted more practice with visualizing data and creating dashboards.
To view my completed dashboard click here .
I created a separate R code (you can view it here on Github) that made some changes for specifically the Tableau portion.
For ride length I rounded the digits by 1, meaning my numbers were 29.8 or 12.5.
Revised how I created my "month" column. I used mutate() to create a column that had the month in ___ format and not number format. So instead of 01 it would say "January"
Cleaned the data: removed rows with NA values, removed duplicate rows, removed where ride_length was 0 or negative and removed unnecessary columns like: ride_id, start_station_id, end_station_id, start_lat, start_long, end_lat, end_lng
Created a new dataframe with this information so I could test the difference between the original data frame (cyclistic_date) that I used for my analysis and the data frame I would use for Tableau (cyclistic_tableau).
In this new data frame I removed more columns to make calculations quicker in Tableau. I removed: start_station_name, end_station_name, time, started_at, ended_at
Downloaded this data frame into a .csv file which I uploaded to Tableau
Created graphs similar to those I created in Excel but added a few:
Total Rides by Bike Type
Ride Length by Weekday
Total Rides by Weekday
Total rides by hour, total rides by month.
Then I created a basic dashboard with all of that information, a prototype for me to view while I was creating the final dashboard ( Figure 1 below).
Created a prototype mockup in Figma
Created a final version of the mockup in Figma
Edited Dashboard in Tableau to reflect design in Figma
Edited graphs in Tableau
Made bar graphs round
Added annotations
Highlights to specific important notes
Got rid of labels for visual purposes
Combined Figma and Tableau (used dashboard created in Figma as the background for my Tableau Dashboard) to create a final prototype ( Figure 2 below)
Made minor edits to design elements and created final dashboard ( Figure 3 - Cyclistic Dashboard V1 )
On April 24, 2023 I decided to update my dashboard (See Finished Project , image Final Dashboard - Cyclistic Dashboard V2 ). All of the analysis is the same. The only changes have been to the dashboard. Which include:
Adding horizontal grid lines to a few of the charts
Updating the tool tips.
Making all of the top metric values (e.g. Total Rides, Average Ride Length, etc.) interactive in Tableau instead of in Figma.
765 minutes or almost 13 hours to complete.
Tableau Prototype
Below was my first draft of the dashboard only using Tableau.
Prototype using Figma Background
Combined Figma and Tableau (used dashboard created in Figma as the background for my Tableau Dashboard) to create a final prototype.
Final Dashboard V1
Made minor edits to design elements and created final dashboard. This was the original final dashboard.
I am including the other tools I used.
Figma to create my background and help develop the dashboard aesthetics.
Google Docs helped me keep track of all of my documents for this project like:
Date Log - I wrote down what I did that day related to my project
Resources - A list of resources I frequently used
Case Notes - Notes for the case study including the final insights, what I was looking for, and anything else having to do with the case
Evernote to draft this article before I uploaded it here.
FINISHED PROJECT
Here is my finished project: Google Capstone Project (V2) . You can view the links to my R code on Github used for analysis here and the code for Tableau here .
Note: This is V2 with a few minor changes to the dashboard. Including:
SUMMARY OF DATA
Those who purchase single-ride or full-day passes are referred to as casual riders while those who purchase annual memberships are Cyclistic members .
Total Rides by User Type
Average Ride Length per User Type
Average Ride per Weekday
Members had more rides with 2,328,763 total rides or 56% and casual riders had 1,823,376 total rides or 43%.
Total Rides per Bike Type
Both casual riders and members used the classic bike the most with 1,777,593 rides or 43% of total rides, followed by docked bikes with 1,545,936 rides or 37% of total rides, and lastly with electric bikes at 828,610 rides or 20% of total rides.
Average Ride Length by User Type
The total average ride length was 24 minutes. For casual riders it was longer at 27 minutes while members was 14 minutes.
Average Ride Length per Weekday
For the average ride length per weekday both casual riders and members had an increase in the average ride length on the weekends. For both Sunday was the longest at 31 minutes.
Saturday was the most popular weekday combining casual riders and member rides with 784,239 rides or 19% of total rides. But for member rides only Wednesday was the most popular day with 356,060 rides, 5,407 rides more than Saturday.
5PM or 17:00 was the busiest hour for both members and casual riders with 426,685 rides or 10% of the total rides. Typically rides began increasing in the morning at 6AM and rose until 5PM then dropped afterwards. The afternoon was the busiest for both rider types with 1,905,797 rides or 45% of total rides. 4AM was the least popular hour.
July was the busiest month combining casual riders and member rides at 691,476 rides or 16% of total rides. While summer was the most popular season for both at 1,903,446 rides or 46% of total rides. Looking at just members August is actually the busiest month with 323,140 rides, 816 rides more than July. Winter is the least popular season and February is the least popular month.
Final Summary
The most popular bike among with riders was the classic.
Busiest time was afternoon and the peak time was at 5PM for both casual riders and members.
Busiest weekday was Saturday, casual riders used the service the most on the weekends.
Busiest season was Summer for both types of riders.
Most rides by User Type was members but casual riders weren't far behind.
The average ride length was 24 minutes but casual riders on average rode 23 minutes longer than members.
BUSINESS SUGGESTIONS
This was the hardest part for me for the whole project. I have never provided suggestions for a business nor worked in marketing. Any feedback here would be appreciated.
These are my suggestions for the marketing team to convert casual riders to annual members:
Personalize discounts and show perks in the membership program based on their preferences and riding habits.
Emphasize the benefits of memberships, including discounts during busy times of the year like during Summer, or on the weekends.
Have existing members to share their stories about how using Cyclistic's system has changed their life, to create a sense of community, offer a discount if they do so this will help encourage new riders to join the program.
WHAT I LEARNED
Below is what I learned/practiced from over 40 hours spent on this project:
Pivot Tables in Microsoft Excel
Practice using R for data analysis and cleaning specifically using the tidyverse package for data analysis
Graphs in Tableau, edited visual elements along with creating different charts and filters.
Design elements of an effective dashboard
Combining the design feature of Figma with the functionality of Tableau
R portion of my project I found Itamar's case study on Kaggle using R as well, a helpful resource.
Tableau portion I used Navneet Singh's Tableau Dashboard as inspiration.
- Data Analytics
- Portfolio Projects
Recent Posts
How I Solve Business Problems with SQL
Maven Analytics - Live Show Notes - Level Up: From Analyst to Sr. Analyst 6-13-24
How I Saved 10 Minutes with a Python Script
100 Most Popular Courses For September
Harvard and MIT’s $800 Million Mistake: The Triple Failure of 2U, edX, and Axim Collaborative
The future of Coursera’s only credible alternative for universities rests in the hands of 2U’s creditors.
- 7 Best Autodesk Maya Courses for 2024: Exploring 3D Animation
- [2024] The 100 Top FREE EdX Courses of All Time
- 15 Best Lisp Courses for 2024
- 8 Best Adobe XD Courses for 2024
- [2024] 250 Top FREE Coursera Courses of All Time
600 Free Google Certifications
Most common
- data science
- machine learning
Popular subjects
Computer Networking
Digital Marketing
Artificial Intelligence
Popular courses
A Life of Happiness and Fulfillment
Arab-Islamic History: From Tribes to Empires
Inglés empresarial: ventas, gestión y liderazgo
Organize and share your learning with Class Central Lists.
View our Lists Showcase
Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
IBM Data Analyst Capstone Project
IBM via Coursera Help
- Learn How to Sign up to Coursera courses for free
- 1700 Coursera Courses That Are Still Completely Free
- Data Collection
- Data Collection is the first step in solving any analysis problem and can be collected in many formats and from many sources. In the first module of the Capstone, we will collect data by scraping the internet and using web APIs.
- Data Wrangling
- In this module, you will be focusing on the cleaning of your dataset with various techniques. With these techniques you will be identifying duplicate rows, finding missing values, and normalizing the data.
- Exploratory Data Analysis
- In this module, begin working with the cleaned dataset from the previous module. You will now begin to analyze the dataset to find the distribution of data, presence of outliers and the correlation between different columns.
- Data Visualization
- In module 4 of the Capstone, you will be required to create visualizations using the developer survey data. The visualizations you create should highlight the distribution of data, relationships between data, the composition of data, and comparison of data.
- Building A Dashboard
- In this module, you will create a dashboard using IBM Cognos Analytics or Google Looker Studio. This platform will give you the ability to create various charts while assembling a dashboard that is appealing and easy to understand. Your dashboard will contain your data analysis, which should be intuitive and allow for the drill-down of data.
- Final Assignment: Present Your Findings
- You have analyzed the data in the previous modules, and now it is time to demonstrate your storytelling skills. In this module, you will create a compelling story that helps to clarify your analysis in an easy-to-understand presentation.
- united states
Related Courses
Data science with r - capstone project, bi dashboards with ibm cognos analytics and google looker, data wrangling with python project, data visualization and dashboards with excel and cognos, data engineering capstone project, ibm data analyst, related articles, from data to insights: 10 best data analysis courses for 2024, 10 best free sql courses for 2024, 1700 coursera courses that are still completely free, 250 top free coursera courses of all time, massive list of mooc-based microcredentials.
4.6 rating at Coursera based on 1129 ratings
Select rating
Start your review of IBM Data Analyst Capstone Project
Never Stop Learning.
Get personalized course recommendations, track subjects and courses with reminders, and more.
- Corporate Relations
- Future Students
- Current Students
- Faculty and Staff
- Parents and Families
- High School Counselors
- Academics at Stevens
- Find Your Program
- Our Schools
Undergraduate Study
- Majors and Minors
- SUCCESS - The Stevens Core Curriculum
- The Foundations Program
- Special Programs
- Undergraduate Research
- Study Abroad
- Academic Resources
- Graduate Study
- Stevens Online
- Corporate Education
- Samuel C. Williams Library
Discover Stevens
The innovation university.
- Our History
- Leadership & Vision
- Strategic Plan
- Stevens By the Numbers
- Diversity, Equity and Inclusion
- Sustainability
Student Life
New students.
- Undergraduate New Students
- Graduate New Students
The Stevens Experience
- Living at Stevens
- Student Groups and Activities
- Arts and Culture
Supporting Your Journey
- Counseling and Psychological Services
- Office of Student Support
- Student Health Services
- Office of Disability Services
- Other Support Resources
- Undergraduate Student Life
- Graduate Student Life
- Building Your Career
- Student Affairs
- Commencement
- Technology With Purpose
- Research Pillars
- Faculty Research
- Student Research
- Research Centers & Labs
- Partner with Us
Admission & Aid
- Why Stevens
Undergraduate Admissions
- How to Apply
- Dates and Deadlines
- Visit Campus
- Accepted Students
- Meet Your Counselor
Graduate Admissions
- Apply to a Graduate Program
- Costs and Funding
- Visits and Events
- Chat with a Student
Tuition and Financial Aid
- How to Apply for Aid
- FAFSA Simplification
- Undergraduate Costs and Aid
- Graduate Costs and Funding
- Consumer Info
- Contact Financial Aid
- International Students
Veterans and Military
- Military Education and Leadership Programs
- Stevens ROTC Programs
- Using Your GI Bill
- Pre-College Programs
SM Team Capstone Project: Mitigating Waste Across Marriott Properties
Department of Civil, Environmental, and Ocean Engineering
Speakers: Keilly Valverde, Giridhar Gopalakrishnan, Christos Tsitouras, Mrudula Mallidi, Anisha Tiwari and Sabrina Benayoun
PRESENTATION ABSTRACT
This presentation serves as an example of a Sustainability Management capstone project. While we will primarily discuss our capstone project deliverables and work breakdown, the panel will also be happy to answer any questions regarding time management, client (external partner) meetings, or presentations to update the class on work completed.
PROJECT ABSTRACT
The client asked us as sustainability consultants to analyze, research, and provide clear implementation strategies for waste reduction across Marriott properties. They provided us with their current methodology and existing waste data through MESH, a waste data management system. We were also given comprehensive information on branding, logos, occupancy, and hotel locations across the U.S. We also reviewed general corporate guidelines to gain a better understanding of their existing operations.
BIOGRAPHIES
Keilly Valverde is a sustainability professional with an expertise in environmental engineering. She has a B.E. in Environmental Engineering and M.S. in Sustainability Management, both from Stevens. Currently, she works at AKRF inc. as an Air Quality Analyst in NYC. In this role, she utilizes models and projections to ensure construction projects meet air quality standards and regulations as well as going to sites to conduct opacity tests. Her department is also responsible for supporting sustainability assessments.
Giridhar Gopalakrishnan graduated from Stevens with a dual MBA/MS in Sustainability Management. He has a background in sales and sales operations and currently works as a sales packaging analyst at a food packaging and processing company.
Christos Tsitouras holds an M.E. in Chemical and Environmental Engineering from the Technical University of Crete. As a dual-degree graduate student at Stevens Institute of Technology, he has completed an M.S. in Sustainability Management and he is one semester away from finishing the MBA. During his recent summer internship at PwC in the “ESG, Sustainability, and Climate Change” team, part of the advisory division, Christos supported the development of a TNFD report for an electric utility company, created a comprehensive citation library documenting the team’s projects, and contributed to the Sustainability Report of an energy group. Another past position as a Junior Project Manager at a consulting company specializing in providing environmental services to marinas and port projects has helped him gain valuable experience in implementing sustainable practices and initiatives.
Mrudula Mallidi holds a Bachelor's degree in Information Technology and a Master's degree in Sustainability Management from Stevens Institute of Technology. With a solid background as a Data Analyst, she is currently working as a Business Analyst at Nomura. In this role, she focuses on handling ESG data for green consulting, leveraging her analytical skills to support sustainable business practices and drive impactful environmental initiatives.
Anisha Tiwari holds an M.S. in Sustainability Management degree from Stevens and currently works as an Energy Project Manager. In her role, she leads teams to conduct energy modeling, focus on energy savings, and prepare proposals for various energy programs across the country. Simultaneously, she is studying to prepare for PE examination and working to obtain her Certified Energy Manager certification.
Sabrina Benayoun holds a Bachelor’s degree in Environmental Engineering and a Master’s degree in Sustainability Management from Stevens Institute of Technology. She is an envisioned sustainability professional and hopes to become LEED-certified too. Her educational and professional experience has led her to seek jobs within corporate sustainability, helping companies succeed while being conscious of their environmental and social impacts.
https://stevens.zoom.us/j/95230825698
https://www.stevens.edu/sustainability-seminar-series
Jointly Sponsored by:
HUGO NEU Corporation Geosyntec Consultants WSP Brown and Caldwell H2M Architects and Engineers Catalyst Group Lozier Inc. Dewberry
Dr. Dibs Sarkar
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
Capstone project of Microsoft Power BI Data Analyst Professional Certificate
vatslarai/Microsoft_capstone_project
Folders and files.
Name | Name | |||
---|---|---|---|---|
7 Commits | ||||
Repository files navigation
Tailwind traders performace analysis, project overview.
This data analysis project aims to provide insights into the sales performance of Tailwind Traders over time. By analyzing various aspects of the sales data, we seek to identify trends, make data-driven recommendations, and gain a deeper understanding of the company's performance.
Data Sources
All the datasets has been provided by the certificate program.
- Excel - Data Cleaning
- PowerBI - Data Analysis and Report creation
Data Cleaning/Preparation
In the initial data preparation phase, we performed the following tasks:
- Data loading and inspection.
- Handling missing values.
- Data cleaning and formatting.
Exploratory Data Analysis
EDA involved exploring the sales data to answer key questions, such as:
- What is the overall sales trend?
- Which products are top sellers?
- What are the best performing areas?
Data Analysis
Analysed data by the means of various Visualizations like Bar Chart, Donut Chart, Line Chart, Area Chart, KPIs, etc. to map out a detail version of the performance of Tailwind Traders in various aspects.
Results/Findings
The analysis results are summarized as follows:
- The company's sales have been steadily increasing except in the month of September.
- Products like Floral Wallpaper, Porcaline Dinner Set are the best-performing in terms of sales but products like Modular Sofa Set, Bamboo Plant Pot generate higher revenue.
- France accounts for the highest Sales market but USA excels in Profit sector amounting to 30% of the whole.
Recommendations
Based on the analysis, I recommend the following actions :
- Invest in marketing and promotions during peak sales seasons to maximize revenue.
- Focus on expanding and promoting products in areas like UAE and Australia.
Limitations
The Sales dataset provided by the respective owner was merely for 3 months which cannot amount to a true depiction of the actual performance of the company.
IMAGES
VIDEO
COMMENTS
By completing this final capstone project you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business challenge ...
I completed this Data Analytics Capstone Project as a part of Google Data Analytics Professional Course on Coursera. Check even this blog for more about Business Intelligence v/s Business Analytics…
Google Data Analytics Capstone Project
This is my capstone project from the IBM Data Analyst course. In each analytics process, the data is stored in the Jupyter notebooks that are uploaded. Week 1 in the project is data collection; 2 is data wrangling, 3 is exploratory data analysis, 4 is Data visualisation, 5 is Building a dashboard and the last week is Presentation of findings.
When the data is ready you will then want to apply statistical techniques to analyze the data. Then bring all of your information together by using IBM Cognos Analytics to create your dashboard. And finally, show off your storytelling skills by sharing your findings in a presentation. You will be evaluated using quizzes in each module as well ...
IBM DA Capstone. This repository contains the Capstone Project for the IBM Data Analyst Certificate by Coursera. This repository contains the raw data, jupyter notebooks under Cheat Sheets, and visualizations of the results. The dashboard can be viewed from the link below:
There are 4 modules in this course. This course is the eighth and final course in the Google Data Analytics Certificate. You'll have the opportunity to complete a case study, which will help prepare you for your data analytics job hunt. Case studies are commonly used by employers to assess analytical skills. For your case study, you'll ...
1700 Coursera Courses That Are Still Completely Free. By completing this final capstone project you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the ...
Background. In this case study, I am assuming the position of 'Jr. Data Analyst' at Cyclistic, a bike-share company based in Chicago. Cyclistic offers over 6000 bikes at 800+ docking stations ...
Python is the fastest-growing major programming language. Bash/Shell/PowerShell appear to be falling out of favor as Python and. TypeScript emerge. Implications. Web development (HTML/CSS and JavaScript) experiences constant high demand. Python is a must-know language in today's tech industry. TypeScript skills can level up one's web ...
By completing this final capstone project you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business challenge ...
This is the seventh and final course of the Google Advanced Data Analytics Certificate. In this course, you have the opportunity to complete an optional capstone project that includes key concepts from each of the six preceding courses. During this capstone project, you'll use your new skills and knowledge to develop data-driven insights for a ...
This badge earner has demonstrated an application of Data Analytics skills and techniques using a hands-on project involving a real-world dataset. The individual has gathered the required datasets, cleaned and wrangled data, performed data mining and analysis, created charts and visualizations, built interactive dashboards, and presented the results using a PowerPoint presentation.
In this Capstone Project, as a newly hired Data Analyst, I'll delve into the dynamic world of IT skill trends. Tasked with aiding our organization's foresight in tech evolution, I'll collect and analyze data from job postings, training portals, and surveys. Our focus will be on discerning the most sought-after programming languages, database ...
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 ...
IBM Data Analyst Capstone Project; In this course you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business ...
Explore and run machine learning code with Kaggle Notebooks | Using data from multiple data sources. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it. Something went wrong and this page crashed!
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 ...
There are 5 modules in this course. The Business Analytics Capstone Project gives you the opportunity to apply what you've learned about how to make data-driven decisions to a real business challenge faced by global technology companies like Yahoo, Google, and Facebook. At the end of this Capstone, you'll be able to ask the right questions of ...
Explore and run machine learning code with Kaggle Notebooks | Using data from Divvy Chicago Bike-Sharing Data. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it. Something went wrong and this page crashed!
The attached file comprises a comprehensive collection of capstone projects from IBM's Data Analyst Profeesional Certificate program as the final project prior to completing the course. These projects showcase the practical application of data analysis methodologies and techniques to real-world scenario of Programming Languages that will be ...
While we will primarily discuss our capstone project deliverables and work breakdown, the panel will also be happy to answer any questions regarding time management, client (external partner) meetings, or presentations to update the class on work completed. ... With a solid background as a Data Analyst, she is currently working as a Business ...
Discover valuable insights from the Google Capstone Project by analyzing Cyclistic bike-sharing data using SQL, Power BI, and Python. Leverage data-driven insights to enhance membership strategies and unlock the full potential of bike-sharing data. The analysis now includes a comprehensive Python notebook utilizing pandas, matplotlib, and seaborn.
The analysis results are summarized as follows: 1.The company's sales have been steadily increasing except in the month of September. 2.Products like Floral Wallpaper, Porcaline Dinner Set are the best-performing in terms of sales but products like Modular Sofa Set, Bamboo Plant Pot generate higher revenue. 3.France accounts for the highest Sales market but USA excels in Profit sector ...