1 – INTRODUCTION TO SELF-SERVICE BI SOLUTIONS – Introduction to business intelligence – Introduction to data analysis – Introduction to data visualization – Overview of self-service BI – Considerations for self-service BI – Microsoft tools for self-service BI – Lab : Exploring an Enterprise BI solution
2 – INTRODUCING POWER BI – Power BI – The Power BI service – Lab : Creating a Power BI dashboard
3 – POWER BI – Using Excel as a data source for Power BI – The Power BI data model – Using databases as a data source for Power BI – The Power BI service – Lab : Importing data into Power BI
4 – SHAPING AND COMBINING DATA – Power BI desktop queries – Shaping data – Combining data – Lab : Shaping and combining data
5 – MODELLING DATA – Relationships – DAX queries – Calculations and measures – Lab : Modelling Data
6 – INTERACTIVE DATA VISUALIZATIONS – Creating Power BI reports – Managing a Power BI solution – Lab : Creating a Power BI report
7 – DIRECT CONNECTIVITY – Cloud data – Connecting to analysis services – Lab : Direct Connectivity
8 – DEVELOPER API – The developer API – Custom visuals – Lab : Using the developer API
9 – POWER BI MOBILE APP – The Power BI mobile app – Using the Power BI mobile app – Power BI embedded
OLAP Essentials (3D Database) course
– Describe OLAP concepts and terminology – Examine the role of Oracle OLAP within the Oracle BI / DW Platform – Design and create OLAP Cubes – Enable query rewrite to OLAP Cube MVs for summary management – Create OLAP calculated measures – Query stored and calculated OLAP data with simple SQL – Use ad hoc query and reporting tools against OLAP data