Shifting Gears -- Times 2 or 3

  • Mar 04, 2019

I'm excited to share news of a recent career change working with Floyd Medical Center as a Business Intelligence Analyst. This is a unique opportunity to help the largest health employer in NW Georgia deploy their first system-wide data warehouse. 

Georgia Exports – On Track for Topping $40 Billion in 2018

  • Jan 15, 2019

Export goods originating from Georgia reached an all-time high-mark of $39.4 billion in 2014. As a state, Georgia has been trying to exceed that banner year ever since.  Recent talk of tariffs and revisions to NAFTA have caused many Georgians to wonder what effect this may have on our economy.  We will have to wait until February 2019 for the US Census Bureau to publish complete 2018 export totals. But currently available data can help us understand the role that exports have in Georgia's economy and what countries dominate as our trade partners. 

Georgia Exports Change over time

Change over Time Analysis in Power BI

  • Jan 02, 2019

In an earlier post I showed you a Power BI interface for summarizing Georgia export data from the US Census Bureau. If your primary interest is year totals, that model is useful for understanding our State's export economy. 

But there are some questions that particular Power BI model does not answer. In particular, it does not address change over time questions like: 

Trade Data via the Census API and SSIS

  • Dec 05, 2018
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

  • Nov 30, 2018
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

  • Sep 13, 2018
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

  • Feb 01, 2018

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

  • Jan 18, 2018
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?