Is learning power pivot worth it? Do I need to learn power BI also to be able to use power pivot completely? Also what are the best sources to learn about power pivot from the scratch?
Hi Kalin,
Is it worth learning? Depends on whether or not you will use it. If you are doing work that requires reporting and analysis then yes you will probably see a benefit to learning PP.
You can see an overview of what PP is and how it can help you here
https://www.myonlinetraininghub.com/power-pivot-course
You do not need to learn PBI. PP is part of Excel so you can still use this analysis provided by PP in excel. However if you want to create visualizations and share your reports/error-refreshing-connections-dashboard-reports with others, then learning PBI will be useful too. Again the answer here is, it depends on your situation. What do you do and what do you want to do with the data you have?
More about what PBI is here
https://www.myonlinetraininghub.com/power-bi-course
You can learn both PP and PBI from the courses I just linked to.
Regards
Phil
