Census Exports

Georgia exports goods worth tens of billions of dollars a year, and the U.S. Census publishes the detail by product and country. This project pulls that data into SQL Server and models it in Power BI.

Start with the

Georgia Exports - Primer on Using Census Data

Jan 11, 2019·318 words·2 mins

Reporting & Dashboards Public Data Census Power BI

Our company is interested in exporting our products. What data sources are available and how can we evaluate our prospects? The U.S. Census Bureau has a wealth of information for evaluating both domestic and international markets. In this series of blog articles, I’ve documented the methods for retrieving Census export data and analyzing it in Power BI. Topics include: the product classifications used by the Census, the mechanics for retrieval and how Power BI and the Tabular data model can make quick work of a 5 million row data set. Viewed in aggregate, you can see that exports have an important and growing role in our state’s economy (graph below.) That data really comes alive when you can drill down and explore data trends in your own industry.

The articles so far are collected in the Georgia Exports guide.

There are no articles to list here yet.