Our primary use cases for this product are monitoring and reporting. I have some dashboards for the sales department and a little bit for operations. I'm going to create a new dashboard for marketing.
What I like about Power BI compared to Tableau, for example, is that Tableau is mostly a visualization program, but Power BI is a more complete solution, because it has DAX, Power Query, and a presentation and graphic layer. So, I use it not only for reporting and graphic purposes on the frontend, but also for doing things like modeling. It is very flexible, a lot more flexible for than Tableau for what I need.
One of the things that I appreciate is that premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month. I'm investigating in that because I think the price is good.
I would like to be able to use more predicting data science features without having to use R. If I were able to do most of the data science that I normally do inside Power BI without using R, I would decrease my use of R and mostly use Power BI.
I have been using Microsoft Power BI for four and a half to five years. I have been using it since they created in basically. I started using it when it was Power Pivot in Excel and as soon as they created Power BI, I started using it.
I recommend easing into Microsoft Power BI gradually. I started by creating models and graphics in Excel first. Then, when I learned a little bit about modeling, I started moving to Power BI and working there.
So, I recommend starting with Excel and practicing there first. Power Pivot is the app that you can use in Excel for this kind of work. Before switching to Power BI, learn about data modeling and dashboarding in Power Pivot in Excel first.
Before switching to Microsoft Power BI, I evaluated Tableau. It's a lot cheaper to use Power BI. The cost per user in Power BI is around $10 per month, while the cost per user for Tableau is a lot more expensive. That was a deciding factor for me.