51蹤獲Business Students Develop 10-Year R.I. Business and Economic Report for State Government Officials

Analyzing key business and economic factors from 2008-2017, findings from the report have been released on the R.I. Secretary of State website

By Jill Rodrigues '05
Students present their report to state officials.
Undergraduate business and master of business administration students present their findings on types of businesses and economic trends in Rhode Island to state officials.

PROVIDENCE, R.I. If youre thinking about opening a business in Rhode Island and want to know how much competition is out there, or youre simply interested in reading about trends in the states economic climate, 51蹤獲 students have helped to bring that information to the public.

Through a collaboration between the and 51蹤獲Mario J. Gabelli School of Business, students have created one of the first data-driven reports on this scale providing a picture of the states economic climate for state government officials. The report, Rhode Island Secretary of State Business & Economic Report, 10-Year Overview (2008-2017), has been made accessible to the general public and presents an analysis of the states key business and economic factors.

With data on tens of thousands of business entities captured by the Department of States office, they wanted to transform that data into consumable information that enables state policy-makers a wider view when making policy decisions. Thats when they reached out to the experts at Gabelli School of Business.

We want to make a hub of information that can be used by government officials and the public. Information is particularly key for our business community, because information helps fuel our economy and fuels businesses, Rhode Island Secretary of State Nellie Gorbea said in a recent presentation of the reports findings to state officials. The challenge is, how do you get that done?

Working through the 51蹤獲Community Partnerships Center, Assistant Professor of Management Farbod Farhadi led undergraduate business students and master of business administration students on consolidating and aggregating the data and analyzing economic trends.

The State Department has been collecting data on all business entities in Rhode Island, and through this project we have been able to transform this data in a meaningful way into valuable information for impactful communication with other government agencies, policy makers, and the public, Farhadi said.

Bubble chart depicting types of industries and by scale in Rhode IslandDuring a nearly year-long effort last spring and fall, students created a report that translated raw datasets into an overview of Rhode Islands economy. The report consolidated information on more than 70,000 active entities in 2017, categorizing them by industry sector, location within the state, and type of business entity. It also examined economic trends over 10 years, looking at a number of economic factors, including the states unemployment rate, median household income, and housing prices, and comparing Rhode Island to the national average as well as its ranking among New England states. Their data was drawn only from the Department of States office, and does not include labor statistics within businesses or revenue generated by businesses.

Based on information and analysis in the report, the R.I. Department of State created interactive data visualizations that enables business owners and community members to explore trends in Rhode Island's business landscape, right down to what type of industries are located in each community. In the "" webpage, interactive tools display the entity types registered throughout the state, how long entities remain in operation, and the types of common business activity across the state. Interested in knowing how many chiropractors, painting companies or marinas are doing business in Barrington? Search the database on the "" webpage, drawn from business data and census information.

Inside the Report

According to the business students report, Rhode Islands largest industry by total numbers in 2017 is real estate, followed by other services (see chart above); construction; and professional, scientific and technical businesses. Not surprisingly, the majority of businesses are located in Providence, Warwick, and Cranston. But outliers like Westerly, Bristol, and Wakefield made the top 15 cities and towns with the most entities, each with a healthy, 1,000-plus businesses.

What they discovered about the states economic trends was good news.

Most of the economic factors showed promising trends the median household income is growing and unemployment decreasing, Farhadi said.

Unemployment in Rhode Island rose to 11 percent following the recession, but dropped to 4.4 percent in 2017 and is closing the gap with the national unemployment rate of 4 percent, according to Farhadi. During the same time, the states median household income performed stronger than a decade ago, increasing by nearly $5,000 per household after adjusting to 2008 dollars.

Chart depicting Rhode Island active entities from 2008-2017.According to their findings on business trends, the students observed a steady increase in total number of entities and in new business filings during 2008-2017, bouncing back from the 2007 recession, with an annual compound growth rate of 2.18 percent, rising from 66,352 to 82,319 total entities in 10 years. When you segment that further, Foreign Profit Corporations, Foreign Nonprofit Corporations, and Domestic LLCs experienced the largest growth, averaging 9.44, 4.88, and 4.84 percent annually, respectively.

The report goes much more into detail, providing the public never-before-accessed information on the recent business and economic trends in the state. A time-consuming and challenging effort, it enabled students to gain experience working with real data sets and applying analytical and problem-solving skills while offering the community the ability to become better informed about the states economic climate and how it affects their lives.

We put the information out there for everyone to access easily, said Megan Roach, a student in the Master of Business Administration (4+1) program at RWU. It took us so long to dig through the databases, find all the numbers and put all the information on charts, and then look at 10 years. Its hard to look at trends when its just numbers in a database.

And for the Secretary [Gorbea], this is the standing of Rhode Island in the U.S. its important for her to know whats going on in the state, and its important for people who want to start a business to know whats going on with other entities in the state, added Roach, noting that this exercise in generating a picture of the states business and economic trends merged together all of her classroom learning from data analytics to economics, marketing and management.

Brittany Watson, a senior marketing major with minors in business analytics and psychology, said that working on the report for the Secretary of State offered a meaningful way for her to give back to the community while providing her with real project experience that will give her an edge in getting into graduate school or the workforce.

Working for a client adds another element to the work that you do because you know this is someone who is expecting helpful, meaningful results, said Watson, who has conducted marketing research for the Town of Bristol and for the Nature Conservancy in other courses. Its not just for class where you get a grade back and can work on it to get it better next time. This is the next time. It pushes you further. Every time I work with a client, it progresses my skills to the next level, because youre always pushing yourself to get better insights when youre working for someone.

Students and state officials pos for group photo.
Undergraduate business and master of business administration students presented their report in December to members of the Rhode Island Department of State, in a collaboration between the 51蹤獲Mario J. Gabelli School of Business and R.I Secretary of State Nelli Gorbea (center).

After receiving the students analysis, Secretary Gorbea recently invited state governmental officials and members of the business community to hear the presentation.

Its great that we have these numbers so we can have the picture of the last 10 years of the behavior of the economy and we can think, how can we improve? said Oscar Mejias, chief executive officer of the .

What were finding in the East Bay is that businesses are limited by talent attraction. We know that most new jobs are created by current businesses how do we add employees and help those businesses grow? Some of the data is showing that housing costs are really limiting the talent attraction in some areas, Ashley Medeiros, a member of the Newport County Chamber of Commerce.

Several others in the business community and state government affirmed the value of the information students had generated with the report, encouraging the project to continue and collect additional data sources. Through the collaboration with the Gabelli School of Business and Department of State, reports on business and economic trends will be generated more frequently and be made available to the public through .

The undergraduate and graduate students who worked on this project were amazingly good, Secretary Gorbea said. It speaks to the kind of talent were growing in our state and how its contributing to the betterment of our government and of our economy.

Read the full report: Rhode Island Business & Economic Report 10-Year Overview (2008-2017)