External Share for Jira

XDP board

To Do (16 issues )

To Do

Data Pipeline for analysis on simulated online store for computer components.

Expand functionality

Test API with another script

Collect all Related Data Frame into G-sheets within Google Drive

Wrangle and perform action to Clean Tables

Enable connection to Cloud DB

Configure Joins and Keys according to ERD,

Perform SQL statements to find and capture insights to feed all outlets for end system

Configure Backup SQL data base on Azure

Test data base and perform basic SQL operations

Code Script to extract data from Big Query and load data to Azure Backup DB

Set up Power Bi Instance and create visual Dashboard

Define set of graphics and visual aids that we'll use

Enhance Descriptions

Make sure items for portfolio project are displayed on the right order

In Progress (14 issues )

In Progress

Create the workflow with all the logos and Icons

Send all data Frames to cloud DB instance (Big Query)

Create Rest API to enable external users to consume information from our Data Base

Code the script back bone

Clean tables on Google Sheets and upload data to Cloud DB as tables by using Python Script

Update content and wording

Code Python Script to consume information from Census.gov API

Enable connection to Big Query

Code Python Script to scrape sales data from multiple PDF files, clean info and consolidate results on one single CSV file that will be sent to Google Drive

Configure Big Query Instance, set up data base Model and perform SQL queries to capture insights

Test instance with scripts that are already operational

Import data from all established sources

Update Portfolio Website

Update Website with each partial progress

Done (23 issues )

Done

Create Workflow Diagram

Sign up to Lucid Chart

Python script to scrape Item descriptions and prices from NewEgg portal and then injecting info on Cloud Data Base

Code the script

Test the result by sending resultant data frame to Google Sheets

Create instance on GCP - Big Query

Create Python Script to grab Gsheets from Drive Folder, convert them into pandas Data Frames

Make the script to Establish connection with Big Query and send the data frames as Tables

Outline the Stament of Work Document

Sign up for Confluence

Create Template and link it to Jira Project

Attach Jira's Road Map

Publish document on Website

Code The Script

Enhance the Notebook by adding text to describe steps

Test the script

Code the Script

Enhance Notebook comments

Test the script with 100 pdfs samples

Create instance on Big Query

Create instance on Azure SQL

Invoke Big Query connector and configure pipeline

Enable Power Bi public portal