سرفصل و اهداف دوره:

نکته : پاور بی ای دکستاب = pbd

Introducing the Power BI Ecosystem

• Desktop, Service and Mobile
• Installing and setting u
• Setting up a MS Power BI account

Getting started with PBD

• Visualisation and Fields Panes
• Create visualisations with Report View
• Sort and format data with Data View

Power BI and Data sources

• How to import from various data sources
• Connectivity with MS Office apps – Excel, Access
• Using other data sources such as databases and CSV Files

Power BI to create Data Models

• Getting to grips with the Data Model
• Using the Relationship View
• Many-to-one relationships
• Filter propagation

pbd for Visualisation Workshop

• Adding visualisations to Report Canvas
• Managing visualisation relationships
• Drill Down and Drill through techniques
• Use of Hierarchies
• Importing and using custom visualisations

pbd and DAX

• Custom calculation and the Data Model
• Calculated Columns and Measures
• Evaluation Context
• CountRows and DistinctCount Functions

pbd and Advanced DAX functions

• SUMX and CALCULATE
• Time Intelligence functions

pbd and Queries

• Data import and the role of Queries
• ETL: Extract, Transform and Load
• Data transformations
• Using Applied Steps
• Query Parameters

Power BI Service Publishing

• Report publishing to PowerBI.com
• Dashboards
• Quick Insights
• Data searching with Q&A

Power BI Service and Importing Cloud-based Data

• Google Analytics
• OneDrive
• Azure SQL Websites and Databases

Power BI Service and Excel PowerPivot

• Creating a PowerPivot Data Model
• Import data from PowerPivot
• Using PowerPivot data to create visualisations

Sharing Data

• Share interactive Power BI dashboards
• Share through Power BI, PowerPoint, the web and other mediums
• Content Packs

Refreshing Data

• Refreshing data manually
• Scheduled Refresh
• Personal Gateway
• Enterprise Gateway

 Mobile Devices

• Meeting different mobile clients’ requirements
• Windows 10, Ipad, Android and Tablet