I trained my junior analyst with the help of one - I can't find it right now, but she came in with zero experience (I didn't hire her lol) and I got her up to speed on Power BI, Power Query, and Pivot Tables. If you have zero experience with Power BI, go snag a Udemy course for cheap. They both use DAX with slightly different syntax (power BI uses "," and I think Power Pivot uses " ") This is mainly dependent on your audience. I don't know much about Python - and combining it with excel may be overkill, but if you already have this skill, it's worth looking into.ĭecide if you really need Power BI, or if you can get by using Power Pivot in excel. Look at ways that you can use python with Power Query (querying part of excel and power BI) and vanilla excel. For adhoc analyses and a few periodically updated reports, they're usually the last step after I query and clean my data. If your experience is with python, I would focus my time on the following:īrush up on pivot tables first.
0 Comments
Leave a Reply. |