Soren Laney's Senior Project

---

Course Objectives

1. Integrate previously learned material in a novel application area of data science.
2. Complete a significant project using data science methods and principles.
3. Present results of your project in a professional forum or to a business client.
4. Document your data science journey and skills through a blog.
5. Leverage modern data science tools to share your work (e.g. GitHub)

---

Requirements

Blog

Soren Laney's Blog

Github Repo

Resume

Soren Laney's Resume

Senior Project

---

Objectives

• Create Dashboard to Comunicate Internal Company Stats
• Store data from GA4 and other Sources in Big Query
• Display Data in a Dashboard
• Develop an ML to Predict Something

Project Ouitline

Data Sources

• Google Analytics 4
• Acuity
• Mighty Networks
• Kartra
• Bitly
• Pipe Drive

Big Query

• Wrangle Data if Necessary
• Establish Views
• Figure out how to Connect

Power Bi

• Connect Power Bi to Big Query Database

Identify ML Unit Target

• Sales Calls Booked
• Sales Closed
• Views / Traffic

---

Packages, Skills & Libraries Learned

Api's

• TikTok Api
• ClickUp Api
• Google Api

Libraries

Languages

• SQL
  SQL Union
  SQL Wildcard Tables
  SQL Destruct a Struct
  SQL Destruct a struct Example
  

Apps

• Sreamlit
• Tableau

---

Research Links

-Time Series Prediction Website Traffic
-Predicting if a Website User will become a Lead
-Get multiple dates from GA4 in SQL
-Set up GA4 Event
-SQL Queries for GA4 Metrics that aren't imported
-Docuementation for BigQuery API
-Bigquery API reference PAge
-Bigquery Authentication Information
-Pitching an Idea