Download - SPUnite17 An End User Guide to Power BI
•
•
•
•
•
•
•
•
•
•
•
Data sources Power BI service
SaaS solutionse.g. Salesforce, GitHub, Google
On-premises datae.g. Analysis Services
Organizational content packsCorporate data sources or external data services
Azure servicesAzure SQL, Stream Analytics…
Excel filesWorkbook data / data models
Power BI Desktop filesData from files, databases, Azure, and other sources
Data refresh
Visualizations
Live dashboards
Content packs Sharing & collaborationNatural language query
Reports
Datasets01001
10101
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
••
•
•
•
••
•
••
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
••
••
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
• Merge or append queries to
combine data from multiple
queries into a single query
• Rename/Remove tables and
columns
• Remove rows
• Delete Relationships
• Change a data type
• Pivot columns and group rows
• Modify a table name
• Identify and fix errors
Common data
transformation tasks:
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Power BI REST APIsPower BI Desktop
Prepare Explore ShareReport
Data sources
SaaS solutionse.g. Salesforce, GitHub, Google
On-premises datae.g. Analysis Services
Organizational content packsCorporate data sources or external data services
Azure servicesAzure SQL, Stream Analytics…
Excel filesWorkbook data / data models
Power BI Desktop filesData from files, databases, Azure, and other sources
Power BI service
Data refresh
Visualizations
Live dashboards
Content packs Sharing & collaborationNatural language query
Reports
Datasets01001
10101
•
•
•
•
•
•
•
•
•
•
•
••
••
••
••
••
••
•
•
•
•
•
•