One of the most common challenges that faces Excel users is having two separate sets of data that need to be referenced for reporting purposes.
In this video I show you how to use Power BI to create a relationship between two spreadsheets in order to create a report using information from both.
I've used a common challenge which many HR professionals encounter, where there are two sets of data, an employee training file (which records all training done by every employee) and an employee master file (which has details for each employee such as department, gender, marital status etc). I show you how to create quick reports and graphs to easily visualise information such as total training cost by department or percentage training costs by gender. In Excel, these reports traditionally take a long time because they require complicated formulas and VLookUps but in Power BI it's done in a few simple clicks.
For more information on our training, please look at our classroom training courses.