Skip to main content

Shifting Gears -- Times 2 or 3

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

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

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

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.