class: center, middle, inverse, title-slide .title[ # Scraping Google Trends Data and Building Interactive Dashboards (maps) with R ] .author[ ### Dr. Zhenning ‘Jimmy’ Xu, California State University Bakersfield, followe me on Twitter: <a href="https://twitter.com/MKTJimmyxu" class="uri">https://twitter.com/MKTJimmyxu</a> or find me on my website at utjimmyx.github.io ] .date[ ### 2024/06/08 ] --- background-image: url(https://upload.wikimedia.org/wikipedia/commons/b/be/Sharingan_triple.svg) ??? Image credit: [Wikimedia Commons](https://commons.wikimedia.org/wiki/File:Sharingan_triple.svg) --- class: center, middle # xaringan ### /ʃaː.'riŋ.ɡan/ --- class: inverse, center, middle # Get Started --- # Agenda for today - Which one should I choose, Excel, Tableau(or Alteryx, Qlik), R, or Python? - Estimated time to download data manually and build a map - more than 10 mins if you were to use Tableau - Estimated time to scrape Google Trends data and build a customized map to show at least two layers of information using R - 30 seconds to 1 min - **Procedures** - Set Up RStudio Cloud (free) -> Install and load Necessary Packages -> Scrape Google Trends Data -> Process Geographic and numeric Data -> Transform Data for Mapping -> Create a customized map with different layers of information - **You will be able to create the following interactive map today (even without any background in R) in 30 seconds** - https://rpubs.com/utjimmyx/analyst_hits - **syntax you will be using for today's tutorial is named - gtrendsR_business_analyst.txt**] you can download it from this Website: https://github.com/utjimmyx/resources - Other similar examples - Query Google Trends using R-https://rpubs.com/utjimmyx/egg; SEO basics-https://rpubs.com/utjimmyx/seobasics; Developing a Mapbox application - https://rpubs.com/utjimmyx/mapboxapp; **Analyzing the Nvidia Stock data - https://rpubs.com/utjimmyx/nvda** - Any ideas for making this Meetup group a better place for learning and sharing: https://www.meetup.com/valley-data-analytics-using-r-meetup-group --- background-image: url(https://github.com/yihui/xaringan/releases/download/v0.0.2/karl-moustache.jpg) background-position: 50% 50% class: center, bottom, inverse # You only live once! --- # Why is Marketing important? .center[<img src="https://raw.githubusercontent.com/utjimmyx/resources/master/cartoon.jpg" width='50%' align="middle"/>] --- # What kind of jobs can I get by developing these skills? ### Two stories https://github.com/utjimmyx/resources/blob/main/Tableau_interview.png https://github.com/utjimmyx/resources/blob/main/job_offer_mktg4000.PNG Ref: How one university is instilling data skills in the next generation of business leaders - https://www.tableau.com/blog/university-embracing-data-skills-next-generation-business-leaders --- # Essential R packages to be used - What is an R package? An package is like a toolkit for the R or Python programming language. Imagine you want to build a piece of furniture. Instead of making your own tools from scratch, you would buy a toolkit that includes a hammer, nails, a screwdriver, and screws. Similarly, a package is a bundle of tools (functions, data, examples, and documentation) that helps you perform specific tasks in R without having to create everything from scratch using the C language. For example, if you want to draw graphs or analyze data, you can use an R package that has pre-made functions to do these tasks easily. Packages save time and effort by providing ready-made solutions for common problems. - **Essential R packages like gtrendsR, dplyr, mapview, and ggplot2 will be used for today's session.** Reference: ggplot2. https://ggplot2-book.org/. gtrendsR. https://github.com/PMassicotte/gtrendsR --- #Top hard skills employers are looking for ##*Social media marketing* - abilities to integrate design thinking and strategic marketing (e.g., communication, design, call to action) into a social media marketing ## *Content management systems (CMS)* - abilities to manage the creation and modification of digital content (content management) using web management platforms (WordPress, Wix, Squarespace, etc.) ##*Analytics* - using data and analytics to inform future actions --- #Top hard skills employers are looking for (continued) - *Search engine marketing (SEM/SEO)* - SEM is probably one of the most critical marketing strategies and tools used for branding, promotion, digital marketing, and sales. - Many SEM specialists work on executing high-level digital solutions and strategies (keyword strategies, website optimization, link building, etc.). - As a marketing generalist, you are expected to know the basic ins and outs of SEM. Reference: https://twitter.com/MKTJimmyxu/status/1505768307093254144 --- # What is the job outlook for business analytics jobs? - According to Indeed.com, there are more than 25,000 business analytics jobs. The number goes up to about 80,000 if you use the query "data analytics." - Let's do some searches at **Indeed.com** - Indeed.com job search/LinkedIn job search - Networking (Meetups, Webinars, etc.) --- ## Thank you all for your participation! ### Questions ### How to make these slides for your creative work - https://www.rstudio.com/about/customer-stories/ xaringan Presentations and R - - Markdown https://bookdown.org/yihui/rmarkdown/xaringan.html - Slides for today can be accessed at my Rpubs.com website [**rpubs.com**](https://rpubs.com/utjimmyx). ### Fun and useful staff - [**syntax you will be using for today's tutorial is named - gtrendsR_business_analyst.txt**] you can download it from this Website: https://github.com/utjimmyx/resources - [**my website - recently rebuilt using R for free**]Website: utjimmyx.github.io - [**my Tableau site**]https://public.tableau.com/app/profile/zhenning.xu - [**my Github website**]https://github.com/utjimmyx. - [**Co-organizer - Central Valley Data Analytics and R Users Meetup Group**]https://www.meetup.com/valley-data-analytics-using-r-meetup-group/. - [**My YouTube channel**]please consider following or subscribing to my YouTube channel at https://www.youtube.com/@jimmyxu4015