Προαπαιτούμενα:
- Εξαιρετική γνώση σχεσιακών βάσεων δεδομένων και αναφοράς
- Γνωριμία με τις εφαρμογές του Microsoft Office – ιδιαίτερα το Excel
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
- Exploring an Enterprise BI solution
- Viewing reports
- Creating a Power BI report
- Creating a Power BI dashboard
2. Introducing Power BI
- Power BI
- The Power BI service
- Creating a Power BI dashboard
- Connecting to Power BI data
- Create 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
- Importing data into Power BI
- Importing Excel files into Power BI
- Viewing reports from Excel files
4. Shaping and Combining Data
- Power BI desktop queries
- Shaping data
- Combining data
- Lab : Shaping and combining data
- Shape power BI data
- Combine Power BI data
5. Modeling data
- Relationships
- DAX queries
- Calculations and measures
- Modeling Data
- Create relationships
- Calculations
6 Interactive Data Visualizations
- Creating Power BI reports
- Managing a Power BI solution
- Creating a Power BI reportConnecting to Power BI data
- Building Power BI reports
- Creating a Power BI dashboard
7. Direct Connectivity
- Cloud data
- Connecting to analysis services
- Direct Connectivity
- Direct connectivity from Power BI desktop
- Direct connectivity from the Power BI service
8.The developer API
- The developer API
- Custom visuals
- Using the developer API
- Using custom visuals
9. Power BI mobile app
- Power BI mobile apps
- Using the Power BI mobile app
- Power BI embedded
