Power BI For Excel 2016
The Power BI for Excel course is suitable for students who already have advanced Excel skills and wish to take the next stepin incorporating business intelligence reporting features and dashboards into their workflows.
This course will utilise Power Query (Get and Transform) to connect to various data sources such as SQL server databases,access database, data directly from the web, excel spreadsheets and process the dataset can be renamed, columns removed, split or merged, additional columns added using calculations along with aggregate calculations being applied. Students will also be taught how to manage relationships through table joins tocombine various datasets as well as sort and filter the results in the PowerPivot.
The Data Analysis Expression (DAX) language will also be introduced to allowed an extended set of calculations to create yourfinal results displayed in text based visualisations, charts and maps. This extremely powerful combined set of tools extendsExcel’s capabilities far beyond anyone’s expectations and it’s all at our fingertips.