u/Mysterious_Method_39

I am currently reading soft copy books but I love the beauty that comes with hard copies,any directions on where to find and purchase books,a place where they deliver anywhere (Kenya)

Hello everyone, I just completed this end-to-end retail sales analysis project as part of my personal project

I used Excel(pivot tables,power query),the key features are the dynamic KPIs and interactive dashboard finally the challenges I faced is doing the data cleaning.

https://preview.redd.it/fyaunungmiyg1.png?width=1920&format=png&auto=webp&s=a82b9f3e7d28a585fc0276e4154064a77509dc39

https://github.com/rutomustgo
Thanks for your time

https://preview.redd.it/20ggp2i3p3yg1.png?width=908&format=png&auto=webp&s=4a39bbce2a08a882ac1e54334200fcc4b1513192

I was cleaning data and noticed that the profit column has a value yet the sales column had a zero in it,using conditional formatting I highlighted the cells and trying to solve this mess,the formula I used to check was if E2>C2

I also introduced the profit margin column using the formula E2|C2,data cleaning can really humble you

I was asking for a clear guidance on where to start and develop a clear understanding of what philosophy entails?

If you're looking at a Pivot Table summary and wondering where did this specific number come from, just double-click the cell.

>