Closed

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)

Skills: Excel, Microsoft PowerBI

See more: 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

About the Employer:
( 0 reviews ) Aurora, United States

Project ID: #32282669

17 freelancers are bidding on average $176 for this job

(17 Reviews)
6.4
AccountantArman

"Sir, I can do regression analysis. I am Accounting, finance, Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than More

$85 USD in 1 day
(127 Reviews)
6.2
(19 Reviews)
6.1
bdrudra

Hello, I hope you're doing really well. We are reviewing your requirements and we can do this work. We are a team of highly skilled individuals having 8+ years of experience in the IT Industry. We have worked with Mi More

$180 USD in 2 days
(13 Reviews)
5.9
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

$250 USD in 7 days
(12 Reviews)
5.2
(9 Reviews)
3.7
varimaxanalytic

Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills i More

$100 USD in 1 day
(2 Reviews)
3.5
VBAautomation

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010. I can handle your project in a very prudent manner. Give me a chance s More

$200 USD in 7 days
(2 Reviews)
2.8
esraatarekyosef1

Hi, When seeing the details of your job, it really jumped out at me, I'm professional in Tableau and i can make AI including regression or clustering or forcasting with tableau and apply any function you need I also More

$200 USD in 7 days
(3 Reviews)
2.0
ba9519301

Dear hiring manager!! Please check my profile at least once time it's owner-able for me. I understand your work, and I'm ready to perform your work. Please send me a message. You give me this project. I know that you' More

$30 USD in 1 day
(0 Reviews)
0.0
nirajphadtare7

I am Capable for this project and I will perform my best . First I will do small research on this project and think about some new better Ideas which will help to improve project . And complete as soon as possible with More

$200 USD in 7 days
(0 Reviews)
0.0
ajaynaik1234a

I am ready for a data class at the earliest to 7 to the earliest to 7 and I will call kar ke phone pe hi I have not a data class

$200 USD in 7 days
(0 Reviews)
0.0
(0 Reviews)
0.0
koppularavikiran

Hello this is Ravikiran i have knowledge on building of dax and also on visual tools in power Bi. I hav knowledge to work on this project.

$200 USD in 7 days
(0 Reviews)
0.0
minaximarvaniya

Hello, I hope you are doing well. I am interested to help you with this requirement. I have more than 6 years of working experience with Microsoft SharePoint. Well versed with all its version. I can also help you in More

$150 USD in 7 days
(0 Reviews)
0.0
chirag9700

Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have more than 7 years of experience in More

$150 USD in 2 days
(0 Reviews)
0.0
srajeev7012

Dear It was great to speak with you about your new project [Regression Analysis and Power BI] the budget I’ve estimated based on the scope of the services required. If you have any questions about pricing or need to i More

$200 USD in 7 days
(0 Reviews)
0.0