Show me the steps to solve Load the data into Power BI

a$.$ Use Power Query to fix the issues

b$.$ Sales and Net income columns have to be modified, both columns values are in

thousands convert it into millions. Add $M to the columns names

c$.$ For the Market Cap column, divide it by a $Billion, make the appropriate adjustment for

the name as well

d$.$ Close and apply

e$.$ Check the format for all the columns

$3.$ Report view $$ Create$/$use your own theme

a$.3$ Pages

i$.$ First page $$S&P $500$ Report$$ Should include title and three pages names

$($below$).$ Use a button or print screen names so whenever the user clicks on

each Page name it will direct the person to the appropriate tab $($page$)$ in the

report

ii$.$ Second page $$Sector Overview$$ We want to find out which sector offers the

most dividends with lowest Beta$($we need average beta per secot and average

dividend yield$).$ Use any chart$/$Table you like $($scatter chart is quite good$)$

$($Does not work the way it should? Create a measure to get the average

for every sector.... Still having an issue? Remember what was the

difference between SUM and SUMX, maybe it will work the same way

with Average?$)$ Be careful with Beta column, make sure the values are

correct there

Add a pie chart use sectors to differentiate the data and market cap for

the size