Laserfiche WebLink
Section III: Description of products' capabilities <br /> Microsoft Power BI for Office 365 is a collection of features and services that will enable the city to <br /> visualize data,share discoveries, and collaborate in intuitive new ways via a series of executive <br /> dashboards with customizable reports from the city's various systems. Microsoft Power BI for Office 365 <br /> provides an organization-wide self-service business intelligence (BI) infrastructure, and brings Excel <br /> workbook sharing, online collaboration, and IT infrastructure together into a holistic offering. <br /> Discover& Combine <br /> Find, connect to, explore, and compile data easily from various sources. <br /> Search and find data <br /> Online search helps you easily find data from both inside and outside your organization.Just type what <br /> you're looking for and in seconds Power Query will give you a list of all the available data sources that <br /> match your criteria. Preview the contents of the data and import the data source that you want directly <br /> into Excel. <br /> Data sources <br /> Power Query allows you to extract data from all sorts of compatible sources: <br /> • Web page <br /> • Excel or CSV file <br /> • XMLfile <br /> • Text file <br /> • Folder <br /> • SQL Server database <br /> • And more. <br /> Clean, merge, transform and shape your data <br /> View your data and clean it up even before loading it into a spreadsheet. Create queries that you can <br /> save and use again later to refresh your data. Merge different tables in one step; rename, delete or even <br /> create fields.Transform your data before even importing it into a spreadsheet.Get your data 'analysis <br /> ready'with Power Query <br /> Model and Analyze <br /> With Power Pivot,you create your own data model from various data sources, modeled and structured <br /> precisely to fit your needs.You can refresh from its original sources as often as you want. You can <br /> format and filter your data,create calculated fields, define key performance indicators(KPI5)to use in <br /> PivotTables and create user-defined hierarchies to use throughout a workbook.You can even author <br /> your own calculations by writing advanced formulas that use the Data Analysis Expressions (DAX) <br /> expression language. No need to be a SQL expert: manage the model and create relationships using drag <br /> and drop in the Diagram View. <br /> Visualize <br /> Map(previously codenamed "GeoFlow") allows you to quickly transform public or corporate data into <br /> dynamic and breathtaking 3D map visualizations and then easily share as cinematic tours that tell <br /> captivating narratives of your data.And do all of this within the familiar environment of Excel. <br /> 6 <br /> 174 Glen Street 1 Glens Falls,NY 12801 T:518.338.1551 F:866.252.1251 aeonnexus.com <br />