Regression Analysis and Power BI
Budget: $10 – $30 USD
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)
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)