Business Intelligence

Analyzing Data with Power BI course
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