Register now or log in to join your professional community.
following are some tips please get a glance on it :
the first and most important step in data modeling is to define what you need the model to do.
then
mmmm
the first and most important step in data modeling is to define what you need the model to do.
then
Microsoft provide PowerQuery as another great tool build your data model.
this is just the basics.
You just need to arange raw data first. You may then select the data & use Pivot Table Option to design report to cater your requirements.
In case of further clarity, feel free to contact me on 0337-3167042