Excited to share my Dashboard in Excel.
This project taught me that Data Analysis is beyond numbers, but about telling stories that drives business decision. Thank you @ezekiel_aleke for your guidance.
@TechSphereAcad
What's your taught on the dashboard?
#TSAcademy#Excel
@ezekiel_aleke@TechSphereAcad I used power query to calculate Total Revenue, Total Profit, Total COGS, I created column for month and calculate Total Customer.
#DataAnalytics
We made use of some formulas like Concatenate/Concat: combine multiple text together.
Textjoin: join text with delimiter
We also have Textsplit, though some excel don't have it, you can always use Text to column to replace it.
I'm so excited for what is to come.
#TSAcademy
Learning data analysis with Excel.
It has been an amazing journey at TS Academy. Learning and Practicing
We talked about Cell Referencing: when doing calculations always reference the cell, so that when you make a change in your cell, it won't affect your calculations.