(Solved) : Intern Hicks Financial Small Trading Company Located Toledo Ohio Intern Supervisor Wants C Q37157101 . . .
You are an intern for Hicks Financial, a small trading companylocated in Toledo, Ohio. Your intern
supervisor wants you to create a report that details all tradesmade in February using current pricing
information from the Dow Jones Index. To complete the task, youwill import and shape data
using Power Query. Then you will create data connections andvisualizations of the data.
a. Open Excel and create a new blank workbook.
b. Save the workbook as e10m1Dow_LastFirst.
c. Use Power Query to import the Dow Index information located inTable 2 from the URL
http://money.cnn.com/data/markets/dow.
d. Use the Query Editor to remove the columns P/E, Volume, and YTDchange. Name the
query Dow and load the data.
e. Name the newly created table Dow and name the worksheetCurrent_Price.
f. Use Power Query to import trade data located in the workbooke10m1TradeInformation.
g. Use the Query Editor to remove the NULL value columns, Use theFirst Row As Headers,
and split column 3 by the left most space delimiter.
h. Use the Query Editor to set the Date column Data Type toDate.
i. Use the Query Editor to rename the fourth column, Company Name.Load the data and
rename the worksheet Trades.
j. Create a Power View with a Staked Bar Visualization thatcompares the trading price of Apple
and Coca-Cola stocks.
k. Add the title Trading Report.
l. Create a footer for all worksheets with your name on the leftside, the sheet name code in the
center, and the file name code on the right side.
m. Save and close the workbook. Based on your instructor’sdirections, submit
e10m1Dow_LastFirst.
Expert Answer
Answer to You are an intern for Hicks Financial, a small trading company located in Toledo, Ohio. Your intern supervisor wants you…
OR