Do any of you guys use these ? Power BI is very clever but I'm tearing my hair out with how s**t Power query is, and how you're forced to use it to feed Power BI.
Power BI isn't perfect either. Excel has far better formatting abilities for example.
Power Query / Power BI
- Sundayjumper
- Posts: 6270
- Joined: Wed Apr 11, 2018 4:04 pm
- Currently Driving: Peugeot 406
Re: Power Query / Power BI
I was looking at it the other day as they've started doing analytics for an integration app we use. Not sure if we need analytics there though
An absolute unit
Re: Power Query / Power BI
We use PowerBI for lots of stuff at work, but I'm not involved any of the set up (which I assume is what you're interested in). I just use it to access pre-arranged datasets.
- Sundayjumper
- Posts: 6270
- Joined: Wed Apr 11, 2018 4:04 pm
- Currently Driving: Peugeot 406
Re: Power Query / Power BI
If you've not needed to touch Power Query you can count yourself lucky !
Power BI is my job now, so I'm frantically trying to learn it faster than they ask me to do stuff with it
Re: Power Query / Power BI
It's a good tool for what we need it for, if I had a minute to raise my head from the trough I could probably think of even more uses for it.
Re: Power Query / Power BI
What's Power Query? Is that the software that is used to bring in the data from the various sources?
Re: Power Query / Power BI
Could have a look at Metabase, it's a similar sort of tool but with less Microsoft twaddle attached.
- Sundayjumper
- Posts: 6270
- Joined: Wed Apr 11, 2018 4:04 pm
- Currently Driving: Peugeot 406
Re: Power Query / Power BI
I could, yeah, but persuading the MOD and by extension the wider Civil Service as well, to ditch Microsoft is just a tad above my pay grade
It seems to be an in demand skill and they're paying me to learn it, so I'm going to run with it.
Re: Power Query / Power BI
Ah, forgot you were deep in MOD/Civil Service land these days, common sense and flexibility are, er, not their strong suits.
Re: Power Query / Power BI
I also spend a fair bit of time in Power BI reports but don't have to get too involved in building them beyond some quick and dirty pages to explore some data. Thankfully have some good people who make
Can recommend datacamp.com, I've been using it for other bits but they have several Power BI courses on data modelling, M and DAX as well as the lighter stuff. I find it a lot more digestible than most training, short intros to topics then a lot of hands-on (virtual desktops for the Power BI stuff). $150 a year if your training budget will cover that.
Can recommend datacamp.com, I've been using it for other bits but they have several Power BI courses on data modelling, M and DAX as well as the lighter stuff. I find it a lot more digestible than most training, short intros to topics then a lot of hands-on (virtual desktops for the Power BI stuff). $150 a year if your training budget will cover that.