<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Adeola Shogbaike on Medium]]></title>
        <description><![CDATA[Stories by Adeola Shogbaike on Medium]]></description>
        <link>https://medium.com/@shogbaikeadeola?source=rss-3e5fce03121f------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*KqUvnlbmFpEDipAXFDGa6g.jpeg</url>
            <title>Stories by Adeola Shogbaike on Medium</title>
            <link>https://medium.com/@shogbaikeadeola?source=rss-3e5fce03121f------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 23:52:08 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@shogbaikeadeola/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Building a Resilient Healthcare System: Insights from My First Health Summit.]]></title>
            <link>https://medium.com/@shogbaikeadeola/building-a-resilient-healthcare-system-insights-from-my-first-health-summit-d2b8fe49b991?source=rss-3e5fce03121f------2</link>
            <guid isPermaLink="false">https://medium.com/p/d2b8fe49b991</guid>
            <category><![CDATA[summit]]></category>
            <category><![CDATA[digital-health]]></category>
            <category><![CDATA[healthtech]]></category>
            <dc:creator><![CDATA[Adeola Shogbaike]]></dc:creator>
            <pubDate>Thu, 27 Jul 2023 14:37:15 GMT</pubDate>
            <atom:updated>2023-08-01T13:32:02.884Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*k3K07X1rQ93iWSmnNEIesQ.jpeg" /></figure><p>As the second half of the year unfolds, I’ve made a resolution to step out of my comfort zone, explore new opportunities, and connect with like-minded individuals in the digital health sphere and beyond. Yesterday marked a pivotal moment as I attended my first health summit, not as a mere attendee, but as an enthusiastic volunteer. With the theme “Building a Resilient and Responsive Healthcare System,” the event promised to be both inspiring and informative, setting the stage for an enriching experience.</p><p>The summit began with a warm welcome address from the Executive Director, Dr. Moshood Habeeb, who paved the way for an engaging day ahead. Throughout the event, inspiring speakers from diverse healthcare field shared valuable insights, emphasizing the need for collaboration, cooperation and coopetition to overcome challenges and improve our healthcare system.</p><p>A captivating keynote address was delivered by Mrs. Clare Omatseye, Founder and Managing Director of JNC International, a leading medical equipment services company in Nigeria. She shed light on the crucial impact of the Healthcare Supply Chain, highlighting its role in accessibility, efficiency, emergency preparedness, cost management, and quality of care using real-world examples like the surge in demand for surgical masks during the Covid-19 pandemic.</p><p>Another attention-grabbing session was led by Dr. Ibukun Tunde-Oni, CEO of Eight Medical, who delved into the future of pre-hospital care. He showcased how technology integration and data-driven decision-making will revolutionize emergency medical services, ultimately leading to better patient outcomes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QAObKHWdIcBsaXk_nmxkVw.jpeg" /><figcaption>A picture with Dr Tunde Ajayi, Special Assistant to Honorable Commissioner (Health), Lagos State</figcaption></figure><p>The summit also highlighted how Nigeria’s reactive nature, instead of being proactive, worsened the impact of Covid, leading to delayed responses, insufficient preparation, overwhelmed healthcare resources, and limited accessibility to urgent care, resulting in greater suffering.</p><p>In one of the panel discussions, Senior Associate at HELC, Ifeoma Okemini Arowolo, stressed the importance of proper documentation and agreement when collaborating in the HealthTech space. Establishing a legal framework for digital healthcare in Nigeria was a key takeaway.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dEvKKku6duNMJ0uVay87jw.jpeg" /><figcaption>A picture with the CEO AfriHealth, Linda Obi</figcaption></figure><p>In addition, one of the panelist also explored the progressive steps involved in leveraging technology to modernize healthcare, drawing a parallel with the digital innovations in the banking sector:</p><ul><li>Internet of Medical Things (IoMT) for remote monitoring.</li><li>Sensors collecting real-time patient data.</li><li>Electronic Medical Record (EMR) replacing paper records for easy access to medical history.</li><li>Health Information Exchange (HIE) for secure data sharing and coordinated care.</li></ul><p>The comparison to the banking sector highlighted the importance of data flow and seamless coordination among healthcare stakeholders. These technological advancements play a vital role in building a resilient and compassionate healthcare system, ultimately leading to improved health outcomes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SeBy8sFqs5h_45JsuMd--A.jpeg" /><figcaption>With Dr Oluwatosin Kolade, Director at Health System Consults and other volunteers</figcaption></figure><p>As I left the summit, I felt inspired and determined to contribute to the digital health revolution. We need more discussions like this, educating people about the importance of digital health. Together, with dedication and collective efforts, we can transform healthcare and make a positive impact on the lives of millions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ayXI-RlHoroiecoLon04Ow.jpeg" /></figure><p>Digital healthcare is no longer a nice-to-have, it’s the future of healthcare and the possibilities are endless!</p><p><em>Thank you for reading. Looking forward to sharing more with you in the future.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d2b8fe49b991" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Google Data Analytics Capstone Project: Bellabeat Case study]]></title>
            <link>https://medium.com/@shogbaikeadeola/google-data-analytics-capstone-project-bellabeat-case-study-48431571702?source=rss-3e5fce03121f------2</link>
            <guid isPermaLink="false">https://medium.com/p/48431571702</guid>
            <category><![CDATA[google-data-analytics]]></category>
            <category><![CDATA[google-capstone-project]]></category>
            <category><![CDATA[r-programming]]></category>
            <dc:creator><![CDATA[Adeola Shogbaike]]></dc:creator>
            <pubDate>Wed, 12 Jul 2023 13:17:46 GMT</pubDate>
            <atom:updated>2023-07-12T13:17:46.821Z</atom:updated>
            <content:encoded><![CDATA[<p>This is a project documentation for Bellabeat case study from the <a href="https://www.coursera.org/professional-certificates/google-data-analytics">Google Data Analytics Course</a>. The analysis follows the 6 steps of Data Analysis : Ask, Prepare, Process, Analyze, Share and Act, taught in the Google course. The code for this project is also available on <a href="http://kaggle.com/code/adeolashogbaike/capstone-project-bellabeat-case-study">Kaggle</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*i2vR9_OCZUC728Fl" /><figcaption>Photo by <a href="https://unsplash.com/@joshduke10?utm_source=medium&amp;utm_medium=referral">Josh Duke</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><strong>Introduction</strong></p><p>I am a junior data analyst working on the marketing analysis team at Bellabeat, a high-tech manufacturer of health-focused products for women. As a data analyst, I have been asked to focus on one of Bellabeat’s products: Bellabeat app and analyze smart device fitness data to gain insights into how customers use their smart devices.The insights gained from my analysis will help guide Bellabeat’s marketing strategy. I will present my findings and recommendations to Bellabeat executive team.</p><p><strong>1.1 About the company</strong></p><p>Bellabeat, a high-tech manufacturer of health-focused products for women. Although, a successful small company, they have the potential to become a larger player in the global smart device market.<br>Urška Sršen and Sando Mur founded Bellabeat. Sršen used her background as an artist to develop beautifully designed technology that informs and inspires women around the world. Since it was founded in 2013, Bellabeat has grown rapidly and quickly positioned itself as a tech-driven wellness company for women.</p><p><strong>1.2 Characters and products</strong></p><ul><li><strong>Characters</strong></li></ul><p>○ <strong>Urška Sršen</strong>: Bellabeat’s cofounder and Chief Creative Officer</p><p>○ <strong>Sando Mur</strong>: Mathematician and Bellabeat’s cofounder; key member of the Bellabeat executive team</p><p>○ <strong>Bellabeat marketing analytics team</strong>: A team of data analysts responsible for collecting, analyzing, and reporting data that helps guide Bellabeat’s marketing strategy. I joined this team six months ago and have been busy learning about Bellabeat’’s mission and business goals — as well as how you, as a junior data analyst, can help Bellabeat achieve them.</p><ul><li><strong>Products</strong></li></ul><p>○ <strong>Bellabeat app</strong>: The Bellabeat app provides users with health data related to their activity, sleep, stress, menstrual cycle, and mindfulness habits. This data can help users better understand their current habits and make healthy decisions. The Bellabeat app connects to their line of smart wellness products.</p><p>○ <strong>Leaf</strong>: Bellabeat’s classic wellness tracker can be worn as a bracelet, necklace, or clip. The Leaf tracker connects to the Bellabeat app to track activity, sleep, and stress.</p><p>○ <strong>Time</strong>: This wellness watch combines the timeless look of a classic timepiece with smart technology to track user activity, sleep, and stress. The Time watch connects to the Bellabeat app to provide you with insights into your daily wellness.</p><p>○ <strong>Spring</strong>: This is a water bottle that tracks daily water intake using smart technology to ensure that you are appropriately hydrated throughout the day. The Spring bottle connects to the Bellabeat app to track your hydration levels.</p><h3>First Phase; ASK Phase</h3><p><strong>2.1 Business Task</strong></p><p>Identify trends in how consumers use non-Bellabeat smart devices to apply insights into Bellabeat’s marketing strategy.</p><p><strong>Stakeholders</strong></p><ul><li>Urška Sršen — Bellabeat’s cofounder and Chief Creative Officer</li><li>Sando Mur — Bellabeat’s cofounder; key member of the Bellabeat executive team</li><li>Bellabeat marketing analytics team</li></ul><h3>3. Second Phase; PREPARE Phase</h3><p><strong>3.1 Dataset used:</strong></p><p>The data source used for our case study is FitBit Fitness Tracker Data. This dataset is stored in Kaggle and was made available through Mobius.</p><p><strong>3.2 Accessibility and privacy of data:</strong></p><p>Verifying the metadata of our dataset we can confirm it is open-source. The owner has dedicated the work to the public domain by waiving all of his or her rights to the work worldwide under copyright law, including all related and neighboring rights, to the extent allowed by law. You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission.</p><p><strong>3.3 Information about the dataset:</strong></p><p>These datasets were generated by respondents to a distributed survey via Amazon Mechanical Turk between 03.12.2016–05.12.2016. Thirty eligible Fitbit users consented to the submission of personal tracker data, including minute-level output for physical activity, heart rate, and sleep monitoring. Variation between output represents use of different types of Fitbit trackers and individual tracking behaviors / preferences.</p><p><strong>3.4 Data Organization:</strong></p><p>There are 18 CSV documents made available for the analysis. Each document represents different quantitative data tracked by Fitbit. The data is considered long since each row is one time point per subject, so each subject will have data in multiple rows.Every user has a unique ID and different rows since data is tracked by day and time.</p><p><strong>3.5 Data Integrity and Credibility:</strong></p><p>Due to the limitation of size (30 users) and not having any demographic information we could encounter a sampling bias. We are not sure if the sample is representative of the population as a whole. Another problem we would encounter is that the dataset is not current and also the time limitation of the survey (2 months long). That is why we will give our case study an operational approach.</p><h3>4.Third Phase; PROCESS Phase</h3><p>I choose to use R for my analysis due to accessibility, the amount of data I will be working with, and being able to create data visualization to share my results and recommendations with stakeholders.</p><h4>4.1 Setting up my environment by loading the packages</h4><p>I will choose the packages that will help in working on my analysis and open them. Packages to be used for my analysis includes;</p><ul><li>tidyverse</li><li>here</li><li>skimr</li><li>janitor</li><li>lubridate</li></ul><pre>library(tidyverse)<br>library(here)<br>library(skimr)<br>library(janitor)<br>library(lubridate)</pre><p>4.2 Importing dataset</p><pre>daily_activity &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/dailyActivity_merged.csv&quot;, header = TRUE)<br>daily_steps &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/dailySteps_merged.csv&quot;, header = TRUE)<br>daily_sleep &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/sleepDay_merged.csv&quot;, header = TRUE)<br>hourly_steps &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/hourlySteps_merged.csv&quot;, header = TRUE)<br>hourly_calories &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/hourlyCalories_merged.csv&quot;, header = TRUE)<br>hourly_intensities &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/hourlyIntensities_merged.csv&quot;, header = TRUE)<br>weight &lt;- read.csv(&quot;/kaggle/input/fitbit/Fitabase Data 4.12.16-5.12.16/weightLogInfo_merged.csv&quot;, header = TR</pre><p>4.3 Preview the data</p><pre>head(daily_activity)<br>head(daily_sleep)<br>head(daily_steps)<br>head(hourly_calories)<br>head(hourly_intensities)<br>head(hourly_steps)<br>head(weight)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/919/1*NAAf642wRrX5Se8JbAqINA.png" /><figcaption>This is only a screenshot of the table. Full table is <a href="https://www.kaggle.com/code/adeolashogbaike/capstone-project-bellabeat-case-study">here</a>. Applies to all tables and visuals below.</figcaption></figure><h4>4.4 Check the structure of the data sets using str()</h4><p>I will check the summary of the selected data frames.</p><pre>str(daily_activity)<br>str(daily_sleep)<br>str(daily_steps)<br>str(hourly_calories)<br>str(hourly_intensities)<br>str(hourly_steps)<br>str(weight)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/758/1*tgO_rRcn6PZEpuHlYtmnUg.png" /></figure><h4>4.5 Cleaning and formatting</h4><p>Now that I know more about the structure of the data. I will check for inconsistencies and errors.</p><h4>4.5.1 Check the number of participants for each data set</h4><p>I will make sure to check the number of unique users per data frame before coming on with the cleaning process.</p><pre>n_unique(daily_activity$Id)<br>n_unique(daily_sleep$Id)<br>n_unique(daily_steps$Id)<br>n_unique(hourly_calories$Id)<br>n_unique(hourly_intensities$Id)<br>n_unique(hourly_steps$Id)<br>n_unique(weight$Id)</pre><p>All data sets have 33 participants each except the daily_sleep and weight data set which has 24 and 8 participants respectively.<br>I will drop the weight data set because 8 participants is too small a sample to draw conclusions and make recommendations.</p><h4>4.5.2 Check for duplicates</h4><p>I will check for any duplicates in the data</p><pre>sum(duplicated(daily_activity))<br>sum(duplicated(daily_sleep))<br>sum(duplicated(daily_steps))<br>sum(duplicated(hourly_calories))<br>sum(duplicated(hourly_intensities))<br>sum(duplicated(hourly_steps))</pre><h4>4.5.3 Remove all duplicates and missing values</h4><p>I will remove all duplicates and missing values from my data</p><pre>daily_activity &lt;- daily_activity %&gt;%<br>  distinct() %&gt;%<br>  drop_na()<br>daily_sleep &lt;- daily_sleep %&gt;%<br>  distinct() %&gt;%<br>  drop_na()<br>daily_steps &lt;- daily_steps %&gt;%<br>  distinct() %&gt;%<br>  drop_na()<br>hourly_calories &lt;- hourly_calories %&gt;%<br>  distinct() %&gt;%<br>  drop_na()<br>hourly_intensities &lt;- hourly_intensities %&gt;%<br>  distinct() %&gt;%<br>  drop_na()<br>hourly_steps &lt;- hourly_steps %&gt;%<br>  distinct() %&gt;%<br>  drop_na()</pre><h4>4.5.4 Clean and rename columns</h4><p>I will ensure that column names are in the right syntax and same format in all datasets since datasets will be merged later on. I will are change all columns to lower case format.</p><pre>clean_names(daily_activity)<br>daily_activity &lt;- rename_with(daily_activity, tolower)<br>clean_names(daily_sleep)<br>daily_sleep &lt;- rename_with(daily_sleep, tolower)<br>clean_names(daily_steps)<br>daily_steps &lt;- rename_with(daily_steps, tolower)<br>clean_names(hourly_calories)<br>hourly_calories &lt;- rename_with(hourly_calories, tolower)<br>clean_names(hourly_intensities)<br>hourly_intensities &lt;- rename_with(hourly_intensities, tolower)<br>clean_names(hourly_steps)<br>hourly_steps &lt;- rename_with(hourly_steps, tolower)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/924/1*2P6MWb1b10e_lvU-8vBHgQ.png" /></figure><h4>4.5.5 Make date and time columns consistent</h4><p>I will clean date-time format for daily_activity and daily_sleep since I will merge both data frames. Note that we can disregard the time on daily_sleep data frame we are using as_date instead as as_datetime.<br>For our hourly_calories, hourly_intensities and hourly_steps dataset, I will convert date string to date-time.</p><pre>daily_activity &lt;- daily_activity %&gt;%<br>  rename(date = activitydate) %&gt;%<br>  mutate(date = as_date(date, format = &quot;%m/%d/%Y&quot;))<br>daily_sleep &lt;- daily_sleep %&gt;%<br>  rename(date = sleepday) %&gt;%<br>  mutate(date = as_date(date, format =&quot;%m/%d/%Y %I:%M:%S %p&quot;, tz = Sys.timezone()))<br>hourly_calories &lt;- hourly_calories %&gt;% <br>  rename(date_time = activityhour) %&gt;% <br>  mutate(date_time = as.POSIXct(date_time, format =&quot;%m/%d/%Y %I:%M:%S %p&quot; , tz=Sys.timezone()))<br>hourly_intensities &lt;- hourly_intensities %&gt;% <br>  rename(date_time = activityhour) %&gt;% <br>  mutate(date_time = as.POSIXct(date_time, format =&quot;%m/%d/%Y %I:%M:%S %p&quot; , tz=Sys.timezone()))<br>hourly_steps&lt;- hourly_steps %&gt;% <br>  rename(date_time = activityhour) %&gt;% <br>  mutate(date_time = as.POSIXct(date_time, format =&quot;%m/%d/%Y %I:%M:%S %p&quot; , tz=Sys.timezone()))</pre><h3>4.6 Merging data sets</h3><p>I will merge the daily_activity and daily_sleep data sets together.</p><pre>daily_activity_sleep &lt;- merge(daily_activity, daily_sleep, by=c (&quot;id&quot;, &quot;date&quot;))</pre><h3>5. Fourth and Fifth Phase; ANALYZE and SHARE Phases</h3><p>I will analyze trends of the users of FitBit and determine if that can help me on BellaBeat’s marketing strategy.</p><h4>5.1 Summarize and explore each data set</h4><h3>5. Fourth and Fifth Phase; ANALYZE and SHARE Phases</h3><p>I will analyze trends of the users of FitBit and determine if that can help me on BellaBeat’s marketing strategy.</p><h4>5.1 Summarize and explore each data set</h4><pre>daily_activity %&gt;%  <br>  select(totalsteps,<br>         totaldistance,<br>         sedentaryminutes, calories) %&gt;%<br>  summary()</pre><h3>Discoveries from the summary</h3><ul><li>Average total steps is 7638 in a day. The daily recommended amount of steps to be taken per day is 7500</li><li>Sedentary minutes on a average is 991(~17 hours). This needs to be reduced.</li><li>Majority of the participants are light users.</li><li>Participants sleep for an average of 419 minutes (~7 hours).</li><li>A total of 97 calories is burned per hour on a average.</li></ul><h4>5.2 Steps taken and Calories burned</h4><p>I will make a visualization to check if there’s a correlation between steps taken and the amount of calories burned.</p><pre>ggplot(data = daily_activity, aes(x = totalsteps, y = calories)) + <br>  geom_point() + geom_smooth() + labs(title =&quot;Total Steps vs. Calories&quot;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*MdyO9t7wvB6sbG8C.png" /></figure><p>I see a positive correlation between total steps taken and the amount of calories burned.​</p><h4>5.3 Steps per weekday</h4><p>To know what day of the week users are more active.</p><pre>weekday_steps &lt;- daily_activity %&gt;%<br>  mutate(weekday = weekdays(date))<br>weekday_steps$weekday &lt;-ordered(weekday_steps$weekday, levels=c(&quot;Monday&quot;, &quot;Tuesday&quot;, &quot;Wednesday&quot;, &quot;Thursday&quot;,<br>                                                                &quot;Friday&quot;, &quot;Saturday&quot;, &quot;Sunday&quot;))<br>weekday_steps &lt;-weekday_steps %&gt;%<br>  group_by(weekday) %&gt;%<br>  summarize (daily_steps = mean(totalsteps))<br><br>head(weekday_steps)</pre><p>Now that we have gotten the steps taken for each day of the week. I will make a visualization to better understand the data.</p><pre>ggplot(weekday_steps, aes(weekday, daily_steps)) +<br>  geom_col(fill = &quot;#d62d58&quot;) +<br>  geom_hline(yintercept = 7500) +<br>  labs(title = &quot;Daily steps per weekday&quot;, x= &quot;&quot;, y = &quot;&quot;) +<br>  theme(axis.text.x = element_text(angle = 45,vjust = 0.5, hjust = 1))</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*PtvrFBE9MpkBr-nS.png" /></figure><h4>5.4 Sleep per weekday</h4><p>To know what day of the week users sleep the most</p><pre>weekday_sleep &lt;- daily_sleep %&gt;%<br>  mutate(weekday = weekdays(date))<br>weekday_sleep$weekday &lt;-ordered(weekday_sleep$weekday, levels=c(&quot;Monday&quot;, &quot;Tuesday&quot;, &quot;Wednesday&quot;, &quot;Thursday&quot;,<br>                                                                &quot;Friday&quot;, &quot;Saturday&quot;, &quot;Sunday&quot;))<br><br>weekday_sleep &lt;-weekday_sleep %&gt;%<br>  group_by(weekday) %&gt;%<br>  summarize (daily_sleep = mean(totalminutesasleep))<br><br>head(weekday_sleep)</pre><p>Make a visualization</p><pre>ggplot(weekday_sleep, aes(weekday, daily_sleep)) +<br>  geom_col(fill = &quot;#db7992&quot;) +<br>  geom_hline(yintercept = 480) +<br>  labs(title = &quot;Minutes asleep per weekday&quot;, x= &quot;&quot;, y = &quot;&quot;) +<br>  theme(axis.text.x = element_text(angle = 45,vjust = 0.5, hjust = 1))</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*pBFMQ_YhOfcweA3J.png" /></figure><h4>Discoveries from the above analysis</h4><ul><li>In the graphs above we can deduce that users don’t take the recommended amount of sleep of 8 hours​</li><li>Users take recommended number of 7500 steps a day excepts for Sundays.​</li></ul><h3>5.5 Hourly intensities throughout the day</h3><p>​Split the datetime column into date and time columns</p><pre>hourly_intensities &lt;- hourly_intensities %&gt;%<br>  separate(date_time, into = c(&quot;date&quot;, &quot;time&quot;), sep= &quot; &quot;) <br><br>head(hourly_intensities)<br><br>hourly_intensities &lt;- hourly_intensities %&gt;%<br>  group_by(time) %&gt;%<br>  drop_na() %&gt;%<br>  summarise(mean_total_int = mean(totalintensity)</pre><p>I will make a visualization of the hourly intensities data</p><pre>ggplot(data = hourly_intensities, aes(x = time, y = mean_total_int)) + geom_histogram(stat = &quot;identity&quot;, fill=&#39;purple&#39;) +<br>  theme(axis.text.x = element_text(angle = 90)) +<br>  labs(title=&quot;Average Total Intensity vs. Time&quot;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*bxDjIgsPpzNuAJXv.png" /></figure><h4>Discoveries after analyzing intensities(hourly)</h4><ul><li>I found out that people are more active between 5am and 10pm.</li><li>Most of the activity happens between 5 pm and 7 pm — I suppose that when people are done with work for the day, they go to the gym or take a walk. We can use this period of time to remind and motivate users to go for a run or walk using the Bellabeat app.</li></ul><h3>5.6 Hourly steps throughout the day</h3><p>Separating the datetime column into date and time column</p><pre>hourly_steps &lt;- hourly_steps %&gt;%<br>  separate(date_time, into = c(&quot;date&quot;, &quot;time&quot;), sep= &quot; &quot;) %&gt;%<br>  mutate(date = ymd(date)) <br><br>head(hourly_steps)</pre><p>I will make a visualization of the hourly steps throughout the day.</p><pre>hourly_steps %&gt;%<br>  group_by(time) %&gt;%<br>  summarize(average_steps = mean(steptotal)) %&gt;%<br>  ggplot() +<br>  geom_col(mapping = aes(x=time, y = average_steps, fill = average_steps)) + <br>  labs(title = &quot;Hourly steps throughout the day&quot;, x=&quot;&quot;, y=&quot;&quot;) + <br>  scale_fill_gradient(low = &quot;red&quot;, high = &quot;green&quot;)+<br>  theme(axis.text.x = element_text(angle = 90))</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*ndLgXyCJ0sHGSBqp.png" /></figure><h4>Discoveries</h4><ul><li>Users are more active from 8am to 5pm and they walk more steps from 12pm to 2pm and 5pm to 7pm.</li><li>I assume that most users are working class women and the time more steps are recorded suggests that they have their lunch break (12pm-2pm) and close for the day (5pm-7pm) during those period.</li></ul><h3>5.7 Type of user based on the number of days smart device was used</h3><p>Calculate the number of users that use their smart device on a daily basis, classifying our sample into three categories knowing that the duration of the survey is 31 days:</p><ul><li>High user — users who use their device for 21–31 days</li><li>Moderate user — users who use their device for 10–20 days</li><li>Low user — users who use their device for 1–10 days</li></ul><p>Next, I will create a new data frame grouping by id, calculate the number of days smart device was used and create a new column with the classification explained above.</p><pre>daily_use &lt;- daily_activity_sleep %&gt;%<br>  group_by(id) %&gt;%<br>  summarize(days_used=sum(n())) %&gt;%<br>  mutate(user_type= case_when(<br>    days_used &gt;= 1 &amp; days_used &lt;= 10 ~ &quot;low user&quot;,<br>    days_used &gt;= 11 &amp; days_used &lt;= 20 ~ &quot;moderate user&quot;, <br>    days_used &gt;= 21 &amp; days_used &lt;= 31 ~ &quot;high user&quot;, <br>  ))<br><br>head(daily_use)</pre><p>Create a percentage data frame to better visualize the results in the graph</p><pre>daily_use_percent &lt;- daily_use %&gt;%<br>  group_by(user_type) %&gt;%<br>  summarise(total = n()) %&gt;%<br>  mutate(totals = sum(total)) %&gt;%<br>  group_by(user_type) %&gt;%<br>  summarise(total_percent = total / totals) %&gt;%<br>  mutate(labels = scales::percent(total_percent))<br><br>daily_use_percent$user_type &lt;- factor(daily_use_percent$user_type, levels = c(&quot;high user&quot;, &quot;moderate user&quot;, &quot;low user&quot;))<br><br>head(daily_use_percent)</pre><p>Make a visualization of the smart device usage per user</p><pre>daily_use_percent %&gt;%<br>  ggplot(aes(x = &quot;&quot;,y = total_percent, fill = user_type)) +<br>  geom_bar(stat = &quot;identity&quot;, width = 1)+<br>  coord_polar(&quot;y&quot;, start=0)+<br>  theme_minimal()+<br>  theme(axis.title.x= element_blank(),<br>        axis.title.y = element_blank(),<br>        panel.border = element_blank(), <br>        panel.grid = element_blank(), <br>        axis.ticks = element_blank(),<br>        axis.text.x = element_blank(),<br>        plot.title = element_text(hjust = 0.5, size=14, face = &quot;bold&quot;)) +<br>  geom_text(aes(label = labels),<br>            position = position_stack(vjust = 0.5))+<br>  scale_fill_manual(values = c( &quot;#d62d58&quot;,&quot;#db7980&quot;,&quot;#fc9fb7&quot;),<br>                    labels = c(&quot;High user - 21 to 31 days&quot;,<br>                               &quot;Moderate user - 11 to 20 days&quot;,<br>                               &quot;Low user - 1 to 10 days&quot;))+<br>  labs(title=&quot;Daily use of smart device&quot;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*Kr2Ux9SaDHUo6pd9.png" /></figure><p>From the above visualization we can deduce that:</p><ul><li>50% of the users of our sample use their device frequently — between 21 to 31 days.</li><li>12% are moderate users (they use their device for 11 to 20 days).</li><li>38% of our sample rarely used their device.</li></ul><h3>6. Sixth Phase; ACT Phase (Conclusion)</h3><p>Bellabeat companmy was created with a mission to empower women by providing them with the data to discover more about their health and habits.</p><p>I did an analysis on the average number of steps, hours of sleep and calories burned.I also focused on the days which users are most active, the time of the day with the most activity and went further to analyze how the device was used by each user.</p><p>After analyzing the FitBit Fitness data, I will respond to the business task of helping Bellabeat on its marketing stratergy based on my results;</p><p>I would advice that for further analysis, we use tracking data from Bellabeat’s device.</p><p>The datasets used have a small sample and can be biased since we didn’t have any demographic details of users.</p><ul><li><strong>Target audience</strong></li></ul><p>Our main target are young and adult women who work full-time jobs(according to hourly intensities data) and these women do some light activity to stay healthy (according to the activity type analysis). I would encourage to continue finding trends to be able to create a marketing stragety focused on them and provide knowledge about developing healthy habits.</p><p>That being said, these are my recommendations for Bellabeat company;</p><ul><li><strong>Recommendation for the app</strong></li><li><strong>Daily notification on steps taken</strong></li></ul><p>According to CDC taking 8,000 steps per day was associated with a 51% lower risk for all-cause mortality (or death from all causes). Taking 12,000 steps per day was associated with a 65% lower risk compared with taking 4,000 steps. Bellabeat can encourage people to take at least 8 000 explaining the benefits for their health. Sending notifications daily at different times will make users conscious of the number of steps achieved so far and encourage them to meet the set target of 8000 steps according to CDC. The app can also educate users on the health benefits of walking the daily recommended number of steps.</p><ul><li><strong>Daily notification on sleep</strong></li></ul><p>From the results of my analysis, I can see that users have less than the recommended amount of sleep in a day. We can enable a feature on the app that allows user set up a desired time to go to sleep and receive a notification minutes before to prepare to sleep or set up an alarm to sleep.</p><ul><li><strong>Notification based on user needs</strong></li></ul><p>If users want to lose weight, controlling daily calorie consumption is a good idea.The Bellabeat can suggest some ideas for low-calorie food to such users.</p><ul><li><strong>Reward system</strong></li></ul><p>We can cvreate a reward system based on the level of activity on the app. The app could consist of stages to reach based on the amount of steps walked everyday. You need to maintain activity level for a period of time (maybe a month) to pass to the next level. For each level you would win certain amount of stars that would be converted into discount on other Bellabeat products.</p><ul><li><strong>Recommendation for the online campaign</strong></li></ul><p>Make sure the online campaign portrays the Bellabeat app more than just a fitness activity app. It should be seen as a guide that empowers women to strike a balance in their personal and professional life and their health habits by educating and motivating them through daily app recommendations.</p><p>The dataset and the complete code can be found <a href="https://www.kaggle.com/code/adeolashogbaike/capstone-project-bellabeat-case-study">here</a></p><p><em>Thanks for reading.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=48431571702" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Mastering Data Visualization: A journey to building my first dashboard]]></title>
            <link>https://medium.com/@shogbaikeadeola/mastering-data-visualization-a-journey-to-building-my-first-dashboard-c787fb257fec?source=rss-3e5fce03121f------2</link>
            <guid isPermaLink="false">https://medium.com/p/c787fb257fec</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Adeola Shogbaike]]></dc:creator>
            <pubDate>Tue, 27 Jun 2023 15:41:40 GMT</pubDate>
            <atom:updated>2023-06-27T15:44:38.316Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*gS2a64dFWW9504aE" /><figcaption>Photo by <a href="https://unsplash.com/@pathdigital?utm_source=medium&amp;utm_medium=referral">path digital</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Hello 👋<br>I’m Adeola, and I love analyzing data.<br>Guess what? I just created my very first dashboard using Excel and I would love to share the thought process behind its creation with you. Wanna know how it’s done? Join me and let’s dive in together!</p><p><strong>Demystifying Dashboards</strong><br>A dashboard is a visual interface that consolidates key information and data metrics to help achieve objectives. It uses graphs, charts, tables, and visual elements to present data in an easily understandable format. It aids in tracking performance, measuring KPIs, and making data-driven decisions.<br><strong>Preparation is key</strong><br>Before starting the dashboard creation process, follow these essential steps for a successful implementation:<br><strong>Define the objectives:</strong> Clarify the purpose and goals of the dashboard. For this project, the goal is to uncover insights from Maven marketing campaign data and use the insights to improve their campaign effectiveness and increase revenue.<br>Questions the dashboard is expected to answer<br>1. What factors are significantly related to the number of web purchases?<br>2. Which marketing campaign was the most successful?<br>3. What does the average customer look like?<br>4. Which products are performing best?<br>5. Which channels are underperforming<br>6. Provide recommendations.<br><strong>Identify data sources:</strong> Determine where to obtain the necessary data. Know what the data is made of and determine what is relevant to your objectives. In this project, I used a <a href="https://drive.google.com/drive/folders/18o4QrU4Ider8GT4Kx_YRLLfT2VwEBhyc?usp=sharing"><strong>dataset</strong></a><strong> </strong>from the resources made available to newbies by Tina Okonkwo (@Rita_tyna) on Twitter. Thank you Tina for making the dataset and the learning resources available to newbies like me.<br><strong>Analyze requirements: </strong>Understand stakeholders’ needs and determine necessary visualizations or features.<br><strong>Data cleaning and processing:</strong> Clean and process the data for accurate analysis. Cleaning data is crucial to avoid inaccurate analysis and biased insights.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*S7XTnnlB75zTh8QojLd-MA.png" /><figcaption>Data before cleaning</figcaption></figure><p>Here are the steps I took to clean the data:<br>• Freeze the header row<br>• Adjust column width to fit content<br>• Removed duplicates.<br>• Checked for spelling errors ( e.g the education and marital status columns)<br>• Format columns appropriately such as changing income, amount spent on products to currency format with zero decimal place<br>• Find and Replace blank cells in the income column with the average income ($52,247).<br>• Created a new column (Age).<br>• Format data as a table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FXve2FHaoK5d6mZ2iK8SXQ.png" /><figcaption>Data after cleaning</figcaption></figure><p><strong>Visual magic: Pivot Tables and Charts</strong><br>I created pivot tables and charts for the dashboard. To insert Pivot table, format your data as a table, click on table design, select summarize with PivotTable under tools, choose the table range and where the pivot table should be placed as shown in the picture below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bs3gkBg4rxqrOiD44fAoMw.png" /></figure><p>Each chart was created in a separate sheet for organization. Unnecessary chart elements were removed for clarity. I created 7 charts in total, two doughnut charts, a bar chart, a map and three column charts. I also inserted two text boxes, one for the recommendation and the other for the average customer profile. To create a chart, Go to PivotChart under PivotTable Analyze and select your preferred chart type as shown below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/918/1*r3A7YWTyDjRtE-q1-d2mig.png" /><figcaption>choosing a chart</figcaption></figure><p><strong>Crafting the Dashboard</strong><br>I created a new sheet for the dashboard and assembled the charts onto it. Grid lines were removed to enhance visual appeal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/469/1*lXdj__9Wj4YreH4_NmkH3A.png" /><figcaption>A picture of the dashboard I created</figcaption></figure><p><strong>Conclusion and Actionable insights</strong><br>Creating a dashboard requires understanding its purpose, asking the right questions, and cleaning the data properly. Here are my recommendations for Maven marketing based on the dataset:<br>• Allocate more resources to the most successful campaign.<br>• Target marketing strategies at the average 54-year-old customer for improved sales.<br>• Prioritize wines and meat products in campaign strategies, ensuring availability in all countries and stores.<br>• Analyze weaknesses in underperforming channels and prioritize the website as the top-performing channel.<br>• Target marketing campaigns at Spain due to higher income and purchasing ability.</p><p><em>Thank you for reading. I hope you enjoyed it!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c787fb257fec" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>