I have used Excel for 20+years and would consider myself an advanced user. I have read about people who have used Excel for 20 years now hardly / never use it and instead use PowerBI. At present, I can’t imagine that even by different means PowerBI can do all that Excel can do. So I am very unsure when to use Excel and when to use PowerBI. My IT department is having difficulty get Excel connected to our databases but PowerBI seems to be working ok. I envisage that I will need to do an analysis of the data before then designing a PowerBI.
Is there a way I can, if necessary connect each time to my data sources using PowerBI and then from then on use Excel. Or is there a need just to stop using Excel and commit to using PowerBI.
I am interested in the views of far-more experienced people than myself.
Can someone direct me to some EDNA training or other sources that would help explain when to use Excel and when to use PowerBI.