Salary
$30-250
Location
Palos Hills, IL, United States
Posted on
Jun 16, 2020
Profile
Google Data Studio Dash Boards
Ultimate Autographs is a company who sells sports memorabilia online and we have just merged into 3 tools that we use:
Quick Books
Shopify
Google Sheets
We are looking for a programer who knows how to take information from Quickbooks Online, Shopify, & Google Sheets to then set up Google Data Studio with easy to read pie charts, bar graphs, line graphs, etc with this company information.
We use quickbooks for our financial records, Shopify for sales records, & Google sheets for our inventory records. We are looking for all of this to connect to google data studio (through a connector, if needed) so we have up to data analytics in an easy to read dashboard.
Some of the reports include but are not limited to:
P&L (QB)
Balance Sheet (QB)
AR Aging (QB)
Sales by Item (Shopify)
Sales by Rep Summary (Shopify)
Sales by Class (Shopify)
Sales Source (Shopify as it connects to ebay & Amazon as well)
Inventory (Google sheets)
Attached is the work scope that will require programing for:
4 Graphs
2 Scroller Data fields
13 sets of data programs X 4 deep (by tier / total)
Please share examples screenshots on a link to drive or similar on your proposal. Also after this programing, please share how much it would be to use the same template but to tie into another item type.
Thank you in advance!
Skills:
Excel
, Google Sheets
, Shopify
, Intuit QuickBooks
Company info
Sign Up Now - WashingtondcCrossing.com
Recruiter job
90 Day Old Job