Demand for data visualisation skills is showing no signs of slowing. There are many BI tools available, and this can make knowing which one to learn overwhelming.
Global research and advisory firm, Gartner, has recognised Power BI as the Magic Quadrant Leader in analytics and business intelligence platforms for 13 consecutive years. This is just one of many reasons you should learn how to build Power BI dashboards and reports like the ones below:
Tip: click the bars/columns/lines/labels in the charts to interact with the report and trigger cross filtering and highlighting.
Mac Users: the Power BI Desktop app used to build the reports and dashboards is not available for Mac. However, you can view completed Power BI reports and dashboards using the online Power BI Service or mobile app, and depending on your dataset, in some cases you can author reports in the Power BI service.
How to Build Power BI Dashboards Video
In the video below I teach you step by step how to build the reports you see above. Starting with the process of getting data, modelling it, and then visualising it with Power BI Desktop, before publishing your reports to the Power BI service for secure sharing with your audience.
Download the Power BI Desktop and Data Files
Enter your email address below to download the files.
More Power BI Resources
Learn Power BI, Power Query and Power Pivot with Mynda. Get up to speed fast with these focussed courses that’ll have you impressing your boss and co-workers with amazing interactive Power BI reports that refresh without you lifting a finger. Get all 3 courses in a discounted bundle from the Power BI course page.
Download Power BI tools including the Desktop and Mobile apps (free)
Sign up for a Power BI Service account (requires work or school email address)
Don't have a work or school address? Use this workaround to get Power BI without a valid email address.
Create a List of Matching Words When Searching Text in Power Query
Nkitseng
Thanks for this tutorial. Mind blowing stuff. Between PBI premium and pro, which one is more ideal for organizations? I would like to share reports with executive management and they should be able to interact with the visuals.
Mynda Treacy
Premium is for organisations with hundreds of Power BI users, Pro is for everyone else
Tes
Hello!
Do you know any good tutorial to build databases in MS Access and use them in Power BI?
Mynda Treacy
No, I don’t, sorry.
Bianca
Just want to say Thank You for the youtube video showing how to create a PBI dashboard and put it up on the web. Following through on an actual case study is far more effective than reading a book. It’s good to see how one can interact with a PBI dashboard from a blog like this one. And your example .pbix file was built in 2020, making it usable to my version of PBI Desktop which is the limit of what I could install because of Windows 7. All in all, thanks for a job well done!
Mynda Treacy
Wonderful to hear, Bianca!
Ria
hi, I am trying to get data from mpp file into Power BI to create dashboard. I dont have project web app and there is no functionality I could find in sharepoint to design one. Can you please guide what’s the way around? I tried with export of project online to excel and bring excel data into Power BI but then the data doesnt get transformed into useful dataset. Can you please guide?
Mynda Treacy
Hi Ria,
You can try using the Odata feed connector as explained here.
Mynda
Heather
I cannot get the line chart to work for month or year. It will only form a line if I only select “day,” because the Forecast and Budget files only contain information from January 2020.
Mynda Treacy
Hi Heather,
Great to see you’re having a go at building the dashboard. Please read the file called ‘READ_ME_FIRST.txt’ as this explains the issue you’re having and how to fix it so you’re not just seeing January data.
Mynda
Madhabi
Madhavi says
Here I have a question..
In power bi of financial report there some problem occurs me. That is in the report of header part the visualization part has been occupied by format text box and subtitles are same only the heading name changed.How can i replace it?
Mynda Treacy
Hi Madhabi,
I’m not sure what you mean. Please post your question and sample file or screenshots on our Dashboards forum where we can help you further: https://www.myonlinetraininghub.com/excel-forum
Mynda
Ayobami Oni
please, i would like to download the dataset used in the tutorial video. Thank you
Mynda Treacy
The link is above, under the video.
Sanket
The link for download the files are not working, please let us know is there any other option to download the data.
Thanks in advance.
Philip Treacy
Hi Sanket,
The file download link works fine for me. What exactly is the issue/error message you are getting?
Regards
Phil
Henri Dormoy
The data Provided has “dd/mm/yyyy” format which was giving me errors throught the excercise. I had to reformat so it coincides with the format in my PC… You might want to mention this
Mynda Treacy
Hi Henri, you can just use Change Type Using Locale to convert the dates to your format. I’ve put a note in the zip file for future. Mynda
Patrick Pierre
Hi, Simply amazing content! I’m new to Power Bi is there a way to make Power Bi look and feel like a website. I want to provide the end user something there already familiar with. Thanks for your help.
Pat
Mynda Treacy
Glad it was helpful, Patrick! You can embed your Power BI reports in web pages so they are seamless. See the example on my Power BI course sign up page.
Faramarz Hozouri
Hello
Most of my zip files open, except BI desk top and data files. zip.
Mynda Treacy
Not sure why that would be, Faramarz. I assume you have downloaded and installed the Power BI desktop app?a
Ved parkash aseri
Mem thanks