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


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

Näytä lisää: power bi trend analysis, power bi work from home, power bi retail analysis sample data, power bi cluster analysis, power bi statistical analysis, how to work with r in power bi, power bi connecting to azure analysis services, connect power bi to analysis services, power bi analysis services, power bi azure analysis services, explain new mexico's role in the international water agreement between the u.s. and mexico., power bi sales analysis, power bi keyword analysis, power bi email analysis, data analysis using power bi, power bi dataflow analysis services, cfo dashboard power bi, power bi investment analysis, spend analysis in power bi, how does power bi work

Tietoa työnantajasta:
( 0 arvostelua ) Kenya

Projektin tunnus: #32292091

Myönnetty käyttäjälle:


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)

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


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)

Hi, I believe I can help you in this project . If you are interested, feel free to message me and I will help you immediately. I am available right now.

$25 USD 7 päivässä
(0 arvostelua)

I will do this job perfectly. I have training for this type of job. Can I get your contact. With Regards Bajrangi

$25 USD 7 päivässä
(0 arvostelua)