Make sure items for portfolio project are displayed on the right order
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-44
Enhance Descriptions
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-43
Update Website with each partial progress
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-42
Enable Power Bi public portal
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-41
Test visuals
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-40
Invoke Big Query connector and configure pipeline
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-39
Define set of graphics and visual aids that we'll use
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-38
Code Script to extract data from Big Query and load data to Azure Backup DB
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-37
Test data base and perform basic SQL operations
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-36
Create instance on Azure SQL
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-35
Perform SQL statements to find and capture insights to feed all outlets for end system
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-34
Configure Joins and Keys according to ERD,
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-33
Import data from all established sources
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-32
Test instance with scripts that are already operational
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-31
Create instance on Big Query
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-30
Make the script to Establish connection with Big Query and send the data frames as Tables
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-29
Create Python Script to grab Gsheets from Drive Folder, convert them into pandas Data Frames
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-28
Wrangle and perform action to Clean Tables
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-27
Collect all Related Data Frame into G-sheets within Google Drive
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-26
Test API with another script
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-25
Expand functionality
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-24
Code the script back bone
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-23
Enable connection to Big Query
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-22
Test the script
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-21
Enhance the Notebook by adding text to describe steps
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-20
Code The Script
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-19
Update Portfolio Website
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-18
Configure Backup SQL data base on Azure
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-17
Set up Power Bi Instance and create visual Dashboard
Assignee:
Diego Oroza
Priority:
Status:
To Do
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-16
Configure Big Query Instance, set up data base Model and perform SQL queries to capture insights
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-15
Clean tables on Google Sheets and upload data to Cloud DB as tables by using Python Script
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-14
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
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-13
Code Python Script to consume information from Census.gov API
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-12
Outline the Stament of Work Document
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-11
Create Rest API to enable external users to consume information from our Data Base
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-10
Send all data Frames to cloud DB instance (Big Query)
Assignee:
Diego Oroza
Priority:
Status:
In Progress
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-9
Create instance on GCP - Big Query
Assignee:
Diego Oroza
Priority:
Status:
Done
Diego Oroza
None
No time logged
None
None
None
X - Data Pipeline
Key:XDP-8
Test the result by sending resultant data frame to Google Sheets