Creating Power BI Reports with Project Desktop Data
Hello, and welcome to the channel.
A very frequent question from people who use Microsoft Project and are starting to use Power BI is whether it's possible to create reports and dashboards in Power BI using data from Project Desktop...
Here on the channel, all the videos about Power BI use data from Project Online as a reference, so I believe this is causing some confusion for the audience watching the videos.
The simple answer to the question is YES: it is possible to create reports and dashboards in Power BI with data from Project Desktop, that is, without needing to use an integrated project management platform like Project Online or Project Server.
However (and there are always buts...), although the creation process is relatively simple, it can be quite laborious (and even unproductive to some extent) when managing multiple schedules.
And these are the points I would like to discuss in this video. I hope you enjoy it!
......................................................................................................................................................................
In the video, I mentioned that I would share some links to help you go further and understand the technical aspects of creating reports by exporting data from Microsoft Project to an Access database. Here they are:
► Creating visual reports in Microsoft Project (part 1): https://goo.gl/Soc4r6
► Creating visual reports in Microsoft Project (part 2): https://goo.gl/tt7kjS
► Custom reports in Microsoft Project: https://goo.gl/h4pEsN
......................................................................................................................................................................
I also mentioned in the video that I would make available the Power BI file I used in this example. As promised, here's the download link:
► Status Report with Project Desktop data: https://goo.gl/eA42PE
......................................................................................................................................................................
Want to learn how to use Project? Watch the videos in the ‘Microsoft Project Mini-Course’:
► Microsoft Project Mini-Course: https://goo.gl/N8DWY4
......................................................................................................................................................................
If you're ready to get your hands dirty and want to start simulating the construction/creation of new projects, you can follow my ‘Project in Practice’ series:
► https://goo.gl/J3nZAZ
......................................................................................................................................................................
Are you already an advanced Microsoft Project user? You can purchase my book ‘Creating Formulas and Indicators in Microsoft Project’ to learn how to customize your own indicators and custom fields:
► http://www.raphael-santos.net/p/livro...
......................................................................................................................................................................
Don't forget to subscribe to the channel to stay up-to-date on all the videos in this series, as well as numerous other topics we'll cover about Excel, Project, Power BI, and everything else that helps you increase your productivity!
My social media:
► Facebook: / raphaelsantosnet
► LinkedIn: / raphaelrsantos
► Twitter: / _raphaelrsantos
► Blog: http://www.raphael-santos.net/