Recommended Prerequisites: Understanding of Python (pandas & working with dataframes), Jupyter Notebook, SQL table operations, Tableau Desktop (calculated fields, parameters) and GitHub

Codes can be found here. Below are the separate dashboards created for desktop and mobile.

https://public.tableau.com/views/InvestmentDashboardDesktop/401kDashboard?:language=en&:display_count=y&:origin=viz_share_link

For this project, I want to create an interface that presents information relevant to my 401k investment in one place instead of having to switch between different platforms. My solution is to combine data from Fidelity Investment, Yahoo Finance, Morningstar, Investopedia and mutual fund universe data from Kaggle for both tracking and research purposes. …


Continuation of the ETL Data Pipeline Workflow

Recommended Prerequisites: Understanding of Python (pandas & working with dataframes), Jupyter Notebook, SQL table operations and GitHub

Codes can be found here.

This is a continuation of the COVID-19 dashboard I posted 2 weeks ago, this tutorial shows how to utilize built-in machine learning models provided by BigQuery in order to forecast the number of cases (confirmed & deaths) in the next 30 days using ARIMA (Auto Regressive Integrated Moving Average). Read more about ARIMA here. We’ll be walking through the model_update.py file in the repository.

  1. SETUP
  2. CREATE MODELS & GET PARAMETERS
  3. FORECAST FOR THE NEXT 30…


- perspective and journey of a beginner coder

Recommended Prerequisites: Understanding of Python (pandas & working with dataframes), Jupyter Notebook, SQL table operations and GitHub

Codes can be found here.

Next part (ARIMA model) is now live.

For better viewing, please open on a new tab or go full screen.

Having learned & used Python for about a year, I am no expert when it comes to data pipeline and cloud platform in general. This guide is my personal journey on learning new techniques and some things to keep in mind when developing a data solution.

  1. WHY CLOUD PLATFORM?
  2. BIG DATA / BIG LEARNING CURVE
  3. SETUP YOUR CLOUD PROJECT
  4. JUPYTER NOTEBOOK SETUP
  5. BIGQUERY SETUP
  6. SET UP WORKFLOW TEMPLATE TO BE RUN ON…

About

Ryder Nguyen

Data Analyst | A self-identified creative mind trapped inside a mathematical brain | https://rydernguyen.github.io/Portfolio/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store