Power BI is the self service BI (Business Analysis) tool from Microsoft. Load data from various different sources and use Business Analysis tools including Power Query, Power Map and DAX to mash your data into a format that you can work with. More can be found on the Computer Tutoring YouTube channel.
You know of Power BI. But to use you'll need to install. It's good to know if you have the 32 or 64bit version of office installed before you start. This short video will show you what to do.
If you're having trouble connecting to an acccess database then you might want to check out this video.
Get your data from Microsoft Access into Power BI. This way you can reap all the benefits that Power BI gives.
Power BI is a big animal. So when you look at your humble spreadsheet you may ask yourself what you need to do to get the data into Power BI. Although that this is one of the longer of our videos. However this is really a must, if you want to get started with the online version of Power BI. You will need a Microsoft Account and have logged in to Power BI before following this video.
Find out how to create the traffic light RAG (Red,Amber,Green) status icons in a table within Power BI.
This tutorial will show you how to group values using Power BI. This guide shows you on how to use DAX and in particular the CALCULATE function to group values.
What can you get out of Date Tables? Surely you've got dates in your main "fact" table so why should you need to add another table? This video tutorial will show you how to create a date table, integrate it with your data model along with a couple of handy fiscal calculations.
This tutorial will show you how to sort by month in Power BI. Understanding the fundamentals with regard to sorting by month can help open the door to many other sorting options in Power BI.
Use the DATEADD function to look at the previous year. Then go further and work out the percentage difference between this year and last year.
Find out how to create a DAX formula to work out year to date with the DATESYTD function in Power BI. This short tutorial will take you step by step.
Now you've discovered how to work out year to date what about year to date for the previous year? This short tutorial will show you how.
This tutorial will show you how to create a DAX formula in Power BI for cumulative totals specifically for financial accounts of 4 week periods.
Tutorial showing how to create RAG KPI icons. We did this in an early video but since then Microsoft have added icons to conditional formatting.
See how you can calculate and display the difference from the Average Mean of sample data in an Evaluation context and Average Mean of the Total range of data.
This tutorial will guide you through how to use PowerBI do display financial totals for the financial year and display them on a line graph.