Statements (121)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:Model
|
| gptkbp:allows |
data analysis
data import from various sources creating calculated columns |
| gptkbp:allows_users_to |
create calculated columns
create measures |
| gptkbp:available_on |
add-in for Excel
|
| gptkbp:can_be_used_with |
Excel Power Query
|
| gptkbp:can_create |
data insights
dashboards data models data reports pivot tables interactive reports |
| gptkbp:can_handle |
large datasets
|
| gptkbp:connects |
gptkb:My_SQL
Access databases CSV files Excel files cloud data sources Azure data sources OData feeds No SQL databases |
| gptkbp:developed_by |
gptkb:Microsoft
|
| gptkbp:enables |
data import from various sources
data mashup capabilities creating relationships between tables |
| gptkbp:enhances |
Excel's data analysis capabilities
Excel's data processing capabilities |
| gptkbp:exported_to |
gptkb:Power_BI
Excel worksheets |
| gptkbp:features |
relationship management
|
| gptkbp:has_features |
gptkb:music_charts
pivot tables timelines slicers |
| https://www.w3.org/2000/01/rdf-schema#label |
Power Pivot
|
| gptkbp:integrates_with |
gptkb:Microsoft_Excel
gptkb:Power_BI |
| gptkbp:is_available_in |
Excel 2010 and later versions
Excel Online (limited features) Excel for Mac (limited features) |
| gptkbp:is_based_on |
Verti Paq engine
|
| gptkbp:is_compatible_with |
gptkb:Share_Point
Windows operating systems data lakes data warehouses Azure services |
| gptkbp:is_designed_for |
self-service BI
|
| gptkbp:is_enhanced_by |
gptkb:Power_Apps
gptkb:Power_Virtual_Agents gptkb:Power_Automate |
| gptkbp:is_integrated_with |
gptkb:Microsoft_Teams
gptkb:Microsoft_Flow gptkb:Power_View gptkb:Power_Map gptkb:Power_Query |
| gptkbp:is_known_for |
scalability
user-friendly interface fast data processing |
| gptkbp:is_optimized_for |
gptkb:performance
|
| gptkbp:is_part_of |
gptkb:Microsoft_data_platform
gptkb:Microsoft_Power_BI_suite gptkb:Microsoft_Office_suite gptkb:Microsoft_365 gptkb:Power_PC data science toolkit data analytics process data visualization ecosystem |
| gptkbp:is_supported_by |
Microsoft documentation
online tutorials training courses Microsoft community |
| gptkbp:is_used_by |
business analysts
data analysts data scientists business users |
| gptkbp:is_used_for |
business intelligence
data transformation reporting data aggregation data modeling data exploration sales analysis ad-hoc reporting project management analysis |
| gptkbp:is_used_in |
business intelligence
data governance financial analysis |
| gptkbp:is_utilized_for |
resource management
trend analysis operational reporting |
| gptkbp:is_utilized_in |
reporting
supply chain analysis marketing analysis |
| gptkbp:offers |
in-memory analytics
|
| gptkbp:part_of |
gptkb:Microsoft_Excel
|
| gptkbp:provides |
data visualization capabilities
advanced calculations data modeling features |
| gptkbp:released_in |
gptkb:2010
|
| gptkbp:supports |
data sharing
data visualization tools multiple data sources real-time data analysis DAX (Data Analysis Expressions) data refresh data aggregation data storytelling data collaboration data exploration custom calculations data mining. data refresh from external sources hierarchies in data models |
| gptkbp:used_for |
data analysis
|
| gptkbp:uses |
in-memory technology
|
| gptkbp:bfsParent |
gptkb:Microsoft_Excel
gptkb:Microsoft_Office_applications gptkb:Power_BI |
| gptkbp:bfsLayer |
4
|