Showing posts with label Tips on SPARTA’s SP601 Data-Driven Research Fundamentals. Show all posts
Showing posts with label Tips on SPARTA’s SP601 Data-Driven Research Fundamentals. Show all posts

Monday, July 31, 2023

Learn From My Mistakes: SP401: Dashboard and Drill Down Analytics

This course is all about unlocking the true value of data, which is super important for us data analysts. In this course, it discussed KPI’s, metrics and we'll learn how to draw meaningful insights that can make a real difference in any company. 

Now, I want to share my very first dashboard with you! As I started my journey of upskilling, I must admit, I learned a lot from my experiences. Looking back, I can now critique my own work, and it's kinda funny too. Haha! 

Learn From My Mistakes: SP401: Dashboard and Drill Down Analytics
Learn From My Mistakes: SP401: Dashboard and Drill Down Analytics

Here are three important lessons I learned from my first dashboard: 
1. Research on Color Palettes: I realized that choosing the right colors for the dashboard is crucial to make it visually appealing and easy to understand. 

2. Tell a Story with KPIs: Instead of just showing raw numbers, I should focus on identifying related KPIs that can help me craft a compelling story or insight. That way, my data presentations will be more engaging and impactful. 

3. Embrace Different Charts: I could have done it better if I learned about different charts, it's usage and explanation it is portraying. 

As I recall, I didn't use any pivot table/chart in this dashboard. Even though I didn't use those in my very first dashboard, it was still a great starting point for me. I'm eager to enhance my skills and become more proficient in using various data visualization tools. 

Well, that is my first and I am glad I do start. This skill is an additional package of what I am now and I am grateful to SPARTA for giving out this kind of FREE education for all. 

If you want a copy of my Excel dashboard, feel free to drop us a message on our Facebook Page. Keep learning and enjoy your data analytics journey! Happy Learning!


Tuesday, February 7, 2023

SPARTA’s SP601 Data-Driven Research Fundamentals: ANALYTICS SOLUTION FOR DOOR-TO-DOOR SIM CARD DISTRIBUTION

CHAPTER 1 : INTRODUCTION

Background

The growing population of Philippines with regards to mobile phone usage as primary source of communication is a good sign of business for telecommunication companies but it comes with a massive competition not only with each other but also with the noise of other products.

Internet has pivoted many accustomed activities, and marketing is no exception. As more and more people are attached to their phones, companies develop a new era of advertising, the digital marketing. This study aims to solve the problems of marketing in the narrowing attention span of consumers and highlight the effectiveness of door-to-door marketing.

Smarta, a local telecommunications company, is considering to hire a marketing agency to do a door-to-door sampling caravan project to give out free prepaid SIM cards to households. The objective is to increase the subscriber base of the company while obtaining a net profit from this project by hoping that the free SIM card samples will eventually be activated in the future and revenue will flow from the activated SIMs.

Research Question

From the above background, the following question can be drawn the following main question.

- Is the door-to-door SIM card distribution effective to attract new customers?

Scope and Limitation

-The scope of this research is related to the business process proposal of sampling system given by the marketing agency to SMARTA.

-The study is limited to the population report published at the Philippine Statistics Authority website dated 2015.

CHAPTER 2 : LITERATURE REVIEW

Marketing and Its Growing Problem

Marketing refers to activities a company undertakes to promote the buying or selling of a product or service, (TWIN, 2020). Marketing evolves hand-in-hand with technology and thus produced digital marketing. But a problem arises on that, fierce competition on consumer attention (A new study in Nature Communications finds that our collective attention span is indeed narrowing, and that this effect occurs not only on social media but also across diverse domains including books, web searches, movie popularity, and more, (Technical University of Denmark, 2019)) and developing trust (Digital enables them to voice their concerns or dissatisfaction in an amplified way. In fact, we found that 40% of global consumers posted negative comments about an experience with a company via social media. Their digital distrust can easily influence thousands of potential customers to stay away (BENDER, BARTON, & MARQUE, 2017)).

Marketers Backtracked Towards Sampling

Marketers came up with different styles of product sampling and below are the two with direct access to household (University of Missouri, 2015):

Table 1: Product Sampling Method

SPARTA’s SP601 Data-Driven Research Fundamentals
Product Sampling Method

Product sampling continues to rank among the most effective tactics in the history of marketing because of its ability to do what no other medium can. Put the product directly in the customer’s hands.

Improved Door-to-Door Sampling

As above table portrays, available data and results are limited for marketers to implement the direct mail sampling. It also leaves a negative impact on potential clients due to the feeling of intrusiveness. Thus on reports of DMA UK Ltd (2014), door-to-door sampling is an extremely effective and impactful method of reaching and communicating with your target audience — which is why some 80% of the UK’s top advertisers use the medium.

Gap Analysis

Aim to further explore the relationships and effects in implementing the two marketing style (Door-to-door Sampling and Direct Mail Sampling) in the same adequate sample household.

CHAPTER 3: PROPOSED RESEARCH DESIGN

Research Design

This research applied quantitative and qualitative methods. The quantitative method was used to meet a reasonable cost for marketing with a time bound study of 100 days. Qualitative method used to explore the pertinent data to their conceptual framework that quantitative data could not facilitate (Crick, 2020).

Population and Sample

The door-to-door caravan used a non-probability quota sampling that was conducted around the City of Taguig and nearby city with a distance not more than 10-Kilometer and with approximate travel period that is not more than one hour.

Instruments

The data for this door-to-door caravan were collected by giving a standardized form for recipients to affix their signature to prove the acceptance of the SIM card.

Data Gathering

The instrument of this door-to-door caravan was administered and personally collected by the samplers. The SIM card distribution took 100 days.

PROPOSED DATA ANALYSIS METHOD

Quantitative

In cross-sectional design, we will use the descriptive and categorical analysis to illustrate the mean and deviation, percentage and frequency. In this study, prescriptive analysis will be utilized to determine the next decision to be taken by SMARTA.

Qualitative

On qualitative data, content analysis will be used to analyse the data from the door-to-door caravan marketing sampling conducted by 10 samplers.

CHAPTER 4: IMPLEMENTATION

Proposed Sampling System by Marketing Agency

The marketing agency proposed a Php5,000,000.00 contract (SIM card exclude SIM card costs) for SMARTA’s 100 day SIM card distribution. The marketing agency proposes the below sampling system.

Table 2: Marketing Agency Proposed Activity

SPARTA’s SP601 Data-Driven Research Fundamentals
Marketing Agency Proposed Activity

The above marketing agency’s proposed sampling system shows that the 10 samplers only have 6 hours per day to distribute SIM cards. Assuming that all the barangay that marketing agency will visit a population of 26,213 (average household size of 4 (Lungsod ng Makati, 2019)) that covers a lot area of 0.88km2 with approximately 5,698 of household like Barangay Bangkal of Makati (Lungsod ng Makati, 2018), samplers approximately 70.809 kilometers to cover per day.

Equation 1: Household Lot Length

SPARTA SP601 Capstone

Equation 2: Kilometers To Cover Per Barangay


SPARTA SP601 Capstone

In order to estimate the number of household that a sampler can visit in an hour, the marketing agency provided a 40km/hour as the velocity of the one sampler. Estimated of forty-five seconds spiel talk time (accepts/declines SIM card) and 30 seconds for household that do not answered the door was also provided by the marketing agency will total an average of 37.50 seconds. With the help Household Lot Length equation, the number of household per hour can be solved.

Equation 3: Number of Households Visited Per Minute

SPARTA SP601 Capstone

Equation 4: Walk Time Per Minute Per Household


SPARTA SP601 Capstone

Equation 5: Target Household Visits Per Hour


SPARTA SP601 Capstone

A target of sixty five (65) households visiting per hour with a six (6) working hours each for ten (10) samplers for one hundred days (100) days, there are 390,000 households could get in touch for the given sampling period.

Below chart is the expected hit and estimated conversion by the marketing agency:

Number of Expected Hit and Estimated Conversion
Number of Expected Hit and Estimated Conversion

Exclusion of SIM card Php40.00 manufacture and Php50.00 credit with total cost of Php35,100,000.00, the marketing agency estimated an average return of revenue of Php13,162,600 yearly for SMARTA’s newly acquired customers.

SMARTA Implementation Plan

The objective of this SMARTA implementation plan is to increase the estimated new subscribers advised by the marketing agency. With the current situation, home-based learning was on effect to minimize and stop the spread of the virus. Unlike the marketing agency’s proposal, this plan targets consumers not only the close proximity barangays but students with demographics of 5 to 24 years that currently attending online school.

As one of the parents told (REUTERS, 2021) “Sometimes we change the SIM card to a different provider so he doesn’t have to study on the roof, but there’s rarely enough money to spare for that”. Consumers are now resulting to be more engaged on benefits offered by different telecommunication providers (Pew Research Center, 2019). Based on a study (Capistrano, 2013), the overall data shows that promotions and giveaways rated the highest level of involvement. This implies that generally speaking, mobile phone users exert more effort in learning about the promotions and giveaways being offered to them by the service providers more than the other service offerings. Thus, the SMARTA’s is on the right time to pursue door-to-door sampling caravan and target the students that are definitely at home.

The sampling will a benefit student and parents on budget and a contribution to the government for its campaign to promulgate online classes.

With the above socio-economic objective, the target barangays that has a 25% and above students on their population and the visit should not be per barangay per day but to visit the number households as reported from PSA (Philippine Statistics Authority, 2017). Below are the list of barangay and corresponding number of target students and days need to spend in a barangay given the rates from marketing agency.


SMARTA Implementation Plan

SMARTA Implementation Plan

The above barangays are projected to get in touch on a total of 502,190 students in 100 days. On such case, it is not needed to push outside of NCR for a door-to-door caravan.

If SMARTA pushes to reach 500,000 hits with a hit rate of 75% (answered the door) we will need 19 samplers to knock 740,741 doors in 100 days or 10 samplers conducting the door-to-door in 190 days.

Equation 6 : Household Visits


SPARTA SP601 Capstone

Equation 7: Household Visits Per Hour Per Sampler


SPARTA SP601 Capstone

Equation 8: Calculating How Many Samplers Needed for 100 Days


SPARTA SP601 Capstone

Equation 9: Calculate How Many Days Needed for 10 Samplers


SPARTA SP601 Capstone

Table 4: SMARTA Strategic Sampling with Cost

SPARTA Strategic Sampling with Cost
Strategic Sampling with Cost


Inaccuracy and incompleteness of sourced out data from Philippine Statistics Office is not enough to analyse it. This is one of the foreseeing reasons that may change the result of this study. Weather changes, samplers’ attitude towards the public, problems over the van’s travel time, which may lead to a bigger problem of under coverage that will take an effect on the feasibility of this project.

To avoid these problems and yet reach the target hit of 500,000, this study strongly recommend that the SMARTA or marketing agency will based on the number of acceptance target number rather than the per day in to pursue this door-to-door sampling.


SPARTA’s SP601 Data-Driven Research Fundamentals CAPSTONE


Clearly, with a 53% ROI (marketing agency 46%) it will be cost efficient for SMARTA to take this study on their own. Sensitive variables will as mentioned above will be fully under control.

CHAPTER 5: BIBLIOGRAPHY

1. Technical University of Denmark. (2019, April 15). Abundance of information narrows our collective attention span. Retrieved from ScienceDaily: www.sciencedaily.com/releases/2019/04/190415081959.htm

2. TWIN, A. (2020, Aug 17). BUSINESS ESSENTIALS. Retrieved from Investopedia: https://www.investopedia.com/terms/m/marketing.asp

3. BENDER, M., BARTON, R., & MARQUE, F. (2017). Trust in the Digital Age .ACCENTURE. ACCENTURE.

4. University of Missouri. (2015, April 8). Course Hero. Retrieved from Course Hero: https://www.coursehero.com/file/p6o95um/Door-to-door-sampling-a-type-of-sampling-in-which-samples-are-brought-directly/

5. Frost & Sullivan. (2012). Research into the Door-to- Door Sales Industry in Australia. Frost & Sullivan for the Australian Competition and Consumer Commission (ACCC).

6. Lewis, J., & Ling, P. (2016). “Gone Are the Days of Mass-media Marketing Plans and Short Term Customer Relationships”: Tobacco Industry Direct Mail and Database Marketing Strategies. Tobacco Control.

7. Morimoto, M., & Chang, S. (2013, Jul 01). Consumers’ Attitudes Toward Unsolicited Commercial E-mail and Postal Direct Mail Marketing Methods. Journal of Interactive Advertising .

8. DMA UK Ltd. (2014). Door drop guide.

9. Crick, J. M. (2020, March). Qualitative research in marketing: what can academics do better? Journal of Strategic Marketing .

10. Lungsod ng Makati. (2018). Barangays. Retrieved January 2021, from Makati Portal: https://www.makati.gov.ph/assets/uploads/staticmenu/docs/1579227221918.pdf

11. Lungsod ng Makati. (2019). Facts and Figures. Retrieved January 2021, from Makati Portal: https://www.makati.gov.ph/cms/content/facts%20and%20figures/3241

12. REUTERS. (2021, Jan 7). ASIA. Retrieved from AsiaONe: https://www.asiaone.com/asia/scaling-roofs-and-mountains-philippine-students-battle-take-online-classes

13. Pew Research Center. (2019, November 20). Internet and Technology. Retrieved from Pew Research Center: https://www.pewresearch.org/internet/2019/11/20/mobile-owners-what-they-struggle-to-do/

14. Capistrano, E. (2013). Investigating Product Involvement Issues for Mobile Phone Services: A Study of Filipino Mobile Phone Users. Philippine Management Review 2013 .

15. Philippine Statistics Authority. (2017, June 30). Philippine Population Surpassed the 100 Million Mark (Results from the 2015 Census of Population). Retrieved from Philippine Statistics Authority: https://psa.gov.ph/population-and-housing/statistical-tables

16. Marikina City. (n.d.). The Shoe Capital of the Philippines. Retrieved from Marikina City: https://www.marikina.gov.ph/Our-City.html


Sunday, July 11, 2021

Tips on SPARTA’s SP601 Data-Driven Research Fundamentals


6.3.1 The Door-to-Door Caravan Sampling Problem is the capstone for the SPARTA’s SP601 and I am not proud to mention that I spent more than 2 months (yuletide season is my alibi haha) to finish the course and almost 3 weeks in capstone. 

After I finished all the lectures and the challenging quizzes, it’s time for capstone. My brain shut down after reading the instructions and seeing the downloaded dataset. I didn’t know where to start. Didn’t know what to do. Haha. But it is fine, just let your brain relax first before going to an all out war Naks! 

Why I am writing this? I do not want you to be like me, wasting time glaring at the ceiling while thinking how to slay the capstone. 



So let’s dive into it. 
1. Download the data. Read and re-read the instructions. The research paper should at least have the following parts: 
● Introduction 
    o Background 
    o Problem Statement 
    o Scope and Limitations 
● Literature Review 
    o Available Research on this 
    o Gap Analysis 
● Proposed Research Design 
    o Step by Step Research Design to Solve the Problem 
    o Proposed Data Analysis Methodologies 
         Quantitative 
         Qualitative 
● Implementation Plan 
● Bibliography 

2. Go back to your notes. What is the first lesson? Correct! First lesson is about PROBLEM STATEMENT. 
Do not be fooled by introduction or background. Skip it for now and focus on the problem statement. How to formulate it? Read again the dataset. There’s a guide question right? From there you map out a nice research questions for your to solve. 
From that too you can form your title too.. (wink-wink)    

3. Skip the scope and limitation.

4. Now let’s go on with the literature review. This is where the real grind starts. Haha. Inhale-exhale! Google your research questions, check-out Google scholars using keywords of the problem statement. 

Be a member of Academia. Do not forget what we have learned from week 2. 
    a. Identify the Research Topic You Want to Explore They should be flexible in their conceptualization of the research problem being investigated They should begin with broad idea and be prepared to narrow it down as they progress 
    b. Review the Sources to get an overview of that research topic 
    c. Develop a Search Strategy 
    d. Conduct the search and select specific articles to review 
    e. Obtain titles or full text references of journal articles or book 
    f. Read the artices and prepare bibliographic information and notes on each 
    g. Analyse the research findings and synthesise. 
Check out the integrity of the paper. Read, highlight and comprehend. From there you might see the light in the end of the tunnel. Haha.

5. While reading research you may ask your self that something is missing or further research can be done. Welcome that idea and include on the gap analysis. Remember to cite the papers properly to avoid plagiarism.

6. Go back to week 3 about research design. Here you can indicate the sampling, instruments and analysis method you will use. Where to get data? Data from Philippine Statistics Authority.

7. Implementation Plan. As the term implies, you can incorporate to answer all the capstone guide questions indicated on the downloadable data in this section. Explain how you implement the formula, your graphs or tables.

Tips on SPARTA’s SP601 Data-Driven Research Fundamentals -

Data-Driven Research Fundamentals Final Capstone Project The Door-to-Door Caravan Sampling Problem


8. Bibliography. Include all the citations you’ve used.

9. Then we go back on areas we have skipped. Give a background; a summary for what people will learn from your research. Indicate the scope of your study and limitations.

10. And you’re done! Hope you enjoyed the process. ;) 

Do not stress yourself too much. If you have questions replay again lessons from Ms. Regine Tejada. 
This is my very first time to do a proper research paper. Wala kami nito sa panahon namin. (Napaghahalataan na ang edad haha). 
If I can do it. Kayo din. Okay? Good luck classmates.  
PS: if you have other tips, comment it to our comment section.
Get this gadget at facebook popup like box