# Regression Analysis and Power BI

Assume you work in the CFO’s office of a new startup retail company, supporting the marketing

department. The company is located only in Colorado now. The company is looking to expand into 2

new states located in the intermountain region of the U.S. This includes the states of Arizona, Idaho,

Montana, Nevada, New Mexico. The 2 states for the expansion must be unique across key characteristics. After 2 years, you plan to expand nationally.

The first step of the decision is to conduct an analysis of each state. The first analysis is to create two

separate, 2-year forecasts for 2 variables you feel that are key to analyze the future of each state. The

forecasts for each variable should be created using 2 distinct methods. One of the variables should be

GDP. You choose the 2nd variable.

You must also decide on what categories of items (1 Good, 1 Service) to sell in these 2 new states.

Answer the questions in Essay form. Conduct analysis in Excel and Tableau or PowerBI.

The next step of the analysis is to use Tableau or PoweBI and create Dashboard 1 to analyze State Economic Data using 2 unique worksheets. Use filters as [login to view URL] or PowerBI to create a Dashboard 2, using 1 worksheet to analyze Personal Consumption Expenditures. Use filters as necessary.

Develop and recommend a vision and strategy for the retail company. What 2 states should the

company expand into and why. Use your analysis as well and any other supporting information. What 2

categories of items should be sold; 1 from Goods and 1 from Services? The choice must align with the

vision and strategy. As a new retailer, what might be some challenges presented by similar

competitors?

Summarize the above and your analysis in a 2 page summary in Word. Turn in the word document as

well as the Excel file and the Tableau Packaged Workbook(.twbx file) or PowerBI(.pbix file)

Taidot: Excel, Microsoft PowerBI

Tietoa työnantajasta:
( 0 arvostelua ) Kenya

Projektin tunnus: #32292091

## Myönnetty käyttäjälle:

esraatarekyosef1

Hi, When seeing the details of your job, it really jumped out at me, I'm professional in Tableau and excel, also i can add AI to tableau like regression, classification and clustering. I have a good experience with Lisää

\$25 USD 2 päivässä
(3 Arvostelua)
2.0

## 4 freelanceria on tarjonnut keskimäärin \$29 tähän työhön

hemsingh1

Excel, Microsoft PowerBI skilled professional with over 5 years of expertise. Can deliver on the expected lines as needed in the defined timelines. Thanks.

\$40 USD 1 päivässä
(10 arvostelua)
3.4