Analyzing and Visualizing Data with Power BI

Προαπαιτούμενα:

Εξαιρετική γνώση σχεσιακών βάσεων δεδομένων και αναφοράς
Γνωριμία με τις εφαρμογές του 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 report Connecting 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

Διάρκεια: 20 ώρες