Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard.

[@saloriasaxon7323]

Can't wait to tackle this one!!😃

[@datalab365]

🙏

[@ismaelkourouma5558]

Hello Ismael 😊, quick question, I thought there was no relationship between the fact table and the target table in the first video? Maybe I am wrong!

[@datalab365]

@@ismaelkourouma5558 The target table only has relationship with the date table and the sales person table. Not the FactTable.

[@njabulosidwell1586]

i love your projects , they always teach me a new way to work with data

[@datalab365]

I welcome you to my new Analytics Channel: kzbin.info/www/bejne/qqXQpKlmg5d-a5Y

[@freez166]

Very nice job❤ can’t wait to see how you made the filter part mine is awful 😢

[@datalab365]

Link the target month to the date table you created and the store id to the to sales person id. You might be missing it there.

[@pasha9806]

when i'm using the slicer, my excel is not responding and it gets closed. also after using zebra bi tables for office, excel is really slow. please help me with this?

[@datalab365]

That has to do with your RAM or your Excel version. You need spacious RAM to run swift Excel.

[@pasha9806]

@@datalab365 What amount of RAM can be considered good for this to work efficiently? Also what can I do now for this to resolve?

[@datalab365]

@@pasha9806 core i5 or latest core i7 Watch this: facebook.com/share/r/mCDHv4DKVjNB7Ak7/?mibextid=oFDknk It will guide you to get a better PC. RAM minimum 8 GB

[@pasha9806]

@@datalab365 core i5. Thanks for sharing let me go through this. Also needed to ask that you have total target for every month but in the data provided it was all for January.

[@datalab365]

@@pasha9806 is for every month. Check your relationships