Thanks for enrolling in the Business Intelligence Workshop. In this training you’ll be learning to work with the Business intelligence tools of Excel – Power Query, Power Pivot and Power View alongside we’ll also be working with Power BI which is a standalone BI tool from Microsoft.
You MUST come prepared for the workshop. Below are some resources to help you get ready for the workshop. I’ll strongly recommend you to go through this page in detail
Install Applications
In case you have Excel 2016 (Pro Plus), there is a good chance that you have all the BI Addins in Excel pre-installed but in-case you don’t, then use the links below to install the add-ins. And needless to say but please carry your individual laptop
- Install Power Query
- Install Power Pivot – It comes pre-installed in Excel 2013 and above. Check if you have the correct version
- Install Power View – You would also need to install Microsoft Silverlight and Internet Explorer 9 or above for working with power view
If you aren’t able to get any or all of the above applications, you can only install Power BI. It inherently has power query, power pivot and power view installed
- Install Power BI Desktop, its free again
Solve these Data Analysis Questions
These questions will help me understand your current level of skill. Once you are done solving these questions, please attach your excel file and send it at [email protected] with the subject line “BI Training Questions”
- Please follow general spreadsheet hygiene practices
- Clearly display your answer in a form of a table or charts
- Write comments or notes if needed
DOWNLOAD QUESTIONS – Solve in 60 mins (max)
In this training you’ll NOT be learning excel but having a good grasp on commonly used features in Excel helps you understand Power BI better. Note that Excel and Power BI have almost NO similarities
Pivot Table Videos
Some Essential Formulas
Post Training Resources
- DAX Reference Card from Rob Collie
- Power Query Book from Chris Webb
- Power BI Mobile Book from Alberto Ferrari and Marco Russo
- Power BI Book from Microsoft
Thank you so much, if you have any questions please let me know in the comments below. I’ll see you in the training
Cheers