Configuring API access to Google BigQuery
Google BigQuery is a fully managed, serverless data warehousing service provided by Google Cloud for data analytics, machine learning, and other data management tasks. The BigQuery interface enables users to explore their data and derive valuable business insights with familiar tools such as SQL for a combination of performance, simplicity, and flexibility. Quite often we […]
How to use Asana
Asana is the project management tool used to track and manage all projects within route1.io. Asana allows you to track project tasks, and deadlines in an organized way, and collaboration within Asana is easy. For more resources on Asana visit their FAQ page. Each project is tracked on its own Asana board. You can add […]
Configuring OAuth 2.0 access to the Google APIs
Click the Select a project dropdown Click NEW PROJECT on the popup Type the name of your project Click CREATE Click the Navigation menu hamburger button Hover over APIs & Services and click OAuth consent screen Select External Click CREATE Fill out the App information form Keep clicking SAVE AND CONTINUE until you get to […]
What happens when you turn off paid search?
with the recent global pandemic, and potential economic downturn across markets, brands have been looking to either reduce marketing investment, make better use of their resources, or better understand how different elements of their mix are performing. one approach we ran was to turn off paid search in half of the country and track the […]
Connecting to socrata datasets from R
The socrata data platform allows governments to make data easily available, both for their own use and publicly. The easiest way to get data that is hosted on a socrata platform into R for analysis is through the RSocrata package. This post walks through how to do this First, we need to source some data. […]
How to connect to EuroStat with R
Eurostat is part of the European Commission and has responsibilities to harmonize statistical methods across member states. This includes countries in the EU, EFTA, and candidate countries. They provide statistical information to the institutions of the EU, as well as the public The data collected covers a range of population, social, economic, industrial, environmental and […]
How to connect to Quandl with R
Quandl, now part of Nasdaq, provide structured data, primarily for finance and economic analysis, but have also categorized and structured data that is useful for a range of population and business analysis. Quandl’s service has structured this information from a range of traditional and alternative data suppliers Some of the data available through Quandl comes […]
How to connect to AWS s3 buckets with python
The boto3 package provides quick and easy methods to connect, download and upload content into already existing aws s3 buckets.