557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
The aim of this exercise is to get to this state:
Your flow should open Power BI, clear the splash screen which appears, choose to connect to the Excel workbook in the above folder and load the list of films. The answer doesn't then expand the Top films table to show the fields in it (as shown in the diagram above), but you could do this as an optional extra!
Listed below are the ways that Wise Owl managed to get this to work, but our solutions aren't necessarily the best ones, and you'll get much more out of this exercise if you try working out how to solve all the problems yourself without reading on.
Here are the steps Wise Owl took to solve this problem, using a new flow called Open Power BI and connect, with notes of where we got stuck. There are almost certainly better ways to create this flow:
|Open Power BI||We couldn't find the executable for Power BI, so instead ran it by clicking on one of our Windows task bar icons (cheating a bit!).|
|Clear the splash screen||This was hard! The splash screen seems to run in the background, so we ended up creating an image showing the cross in the top right corner, then selecting this (with a left click following).|
|Choose to load an Excel workbook||This was easy: just create a UI element for the ribbon tool, and click on it.|
|Choose the file||This was relatively easy: create a UI element for the file name box, go to it and use a Send keys action to type in the file name and to then press Enter.|
|Choose which table to load||Search as we might, we couldn't find a short-cut key to accomplish this (and even had we done so, we couldn't find a way to send keystrokes to the right window). We ended up using two images: one for the check box next to the table name, and one for the Load button. Not a good solution!|
If you get this all working and still have spare time and energy, you could always try creating a Power BI visual (probably best to stick to a table) showing each film title with its number of reviews. Still have time? You could try formatting this!
When you're happy with the state of your flow (and you've checked it works OK) save it and close it down.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street