Skip to main content

DataBaselines Blog

Trade Data via the Census API and SSIS

An explanation of how to use the Census API for retrieving trade data and SQL Server Integration Services to import that data into a database. This is part of a larger series on using Census trade data sets. Please see links at bottom for additional resources.

Georgia Exports in Power BI

So exactly what does Georgia export to the world? Here is a brief video tutorial using US Census data and Microsoft Power BI to explore what's been going through terminals like the port in Savannah and Hartsfield airport. This is part of a series of articles for retrieving and summarizing public data from USA Trade Online.

Georgia Exports, A Tutorial for USA Trade Online

Trade exports account for $37 billion and 180,000 jobs in Georgia's economy. With all the tariff and NAFTA revisions taking place, you may wonder what effect these changes will have on our State's economy. In a series of videos and articles, we'll explore data available for Georgia Exports -- starting with this tutorial on the Census' bureau's USA Trade Online service.

The Value of a Good Name

Well it's done -- we have changed our company name to DataBaselines, Inc.

There are a couple of reasons for the name change. But the primary reason is symbolic. It marks a transition for our company. We no longer create any type of data entry applications. Our focus is squarely on business intelligence reporting and data science techniques.

Merriam-Webster will tell you that a baseline is a minimum or starting point used for comparisons. That dovetails neatly with our purpose. We help our customers:

Help me Make Sense of this Database

We use a proprietary software application that stores a great deal of operational data for our company. The product vendor does not provide any documentation. We want to extract and report from its tables. How would you go about investigating this system? What sorts of support could you offer on this type of project?

Improving Data Quality

Our customer address information is inaccurate and it contributes to delayed deliveries and frustrated customers. What general resources are available to improve the quality of our data?

Backup Horror Story

A business associate just spent two weeks in turmoil trying to recover data that was permanently lost. Their backup process was flawed. I've got a gnawing sense that this could happen to us too? What can I do to ensure my backups are occurring when they should and that they will be usable if I actually need them?