Group items tagged

Integration BI infrastructure: All tools in the platform use the same security, metadata, administration, portal integration, object model and query engine, and should share the same look and feel. Metadata management: Tools should leverage the same metadata, and the tools should provide a robust way to search, capture, store, reuse and publish metadata objects, such as dimensions, hierarchies, measures, performance metrics and report layout objects. Development tools: The platform should provide a set of programmatic and visual tools, coupled with a software developer's kit for creating analytic applications, integrating them into a business process, and/or embedding them in another application. Collaboration: Enables users to share and discuss information and analytic content, and/or to manage hierarchies and metrics via discussion threads, chat and annotations.

Information Delivery Reporting: Provides the ability to create formatted and interactive reports, with or without parameters, with highly scalable distribution and scheduling capabilities. Dashboards: Includes the ability to publish Web-based or mobile reports with intuitive interactive displays that indicate the state of a performance metric compared with a goal or target value. Increasingly, dashboards are used to disseminate real-time data from operational applications, or in conjunction with a complex-event processing engine. Ad hoc query: Enables users to ask their own questions of the data, without relying on IT to create a report. In particular, the tools must have a robust semantic layer to enable users to navigate available data sources. Microsoft Office integration: Sometimes, Microsoft Office (particularly Excel) acts as the reporting or analytics client. In these cases, it is vital that the tool provides integration with Microsoft Office, including support for document and presentation formats, formulas, data "refreshes" and pivot tables. Advanced integration includes cell locking and write-back. Search-based BI: Applies a search index to structured and unstructured data sources and maps them into a classification structure of dimensions and measures that users can easily navigate and explore using a search interface. Mobile BI: Enables organizations to deliver analytic content to mobile devices in a publishing and/or interactive mode, and takes advantage of the mobile client's location awareness.

Analysis Online analytical processing (OLAP): Enables users to analyze data with fast query and calculation performance, enabling a style of analysis known as "slicing and dicing." Users are able to navigate multidimensional drill paths. They also have the ability to write back values to a proprietary database for planning and "what if" modeling purposes. This capability could span a variety of data architectures (such as relational or multidimensional) and storage architectures (such as disk-based or in-memory). Interactive visualization: Gives users the ability to display numerous aspects of the data more efficiently by using interactive pictures and charts, instead of rows and columns. Predictive modeling and data mining: Enables organizations to classify categorical variables, and to estimate continuous variables using mathematical algorithms. Scorecards: These take the metrics displayed in a dashboard a step further by applying them to a strategy map that aligns key performance indicators (KPIs) with a strategic objective. Prescriptive modeling, simulation and optimization: Supports decision making by enabling organizations to select the correct value of a variable based on a set of constraints for deterministic processes, and by modeling outcomes for stochastic processes.

Leaders headed by Microsoft (NASDAQ MSFT), the world's biggest software company; Oracle (NASDAQ: ORCL), the No. 1 database developer, and International Business Machines Corp. (NYSE: IBM), the No. 2 computer maker, showed off new software and analysis tools to enable retailers to make more from the consumer dollar.

The company also said that using in-house software analysis permits retailers to forecast trends and have merchandise made quickly to capitalize on them. Its “birth of a trend” analytics has determined what it calls “steampunk,” or a science-fiction and fantasy mix based around gothic machinery and 19th-century geniuses like Jules Verne and H.G. Wells will be a big trend in 2013.

a lot of articles calling data scientists and statisticians the jobs of the future

there are more immediate needs that, when addressed, will have a much greater business impact.

Right now we have huge opportunities to make the data more accessible, more “joinable” and more consumable. Leaders don’t want more data – they want more information they can use to run their businesses.

1. Uninstall BIP desktop from control->Add or remove programs. 2. Open explorer and go to "C:\WINDOWS\assembly". 3. Check if there are assemblies which start with "TB" If present, remove them all. 4. Open the MS Word startup directory and check there are no files there. The directory is normally the following. C:\Documents and Settings\<user name><Application Data\Microsoft\Word\STARTUP5. Open MS Word and check that you don't see the BIP tool bar. -> If you see it, please move Normal.dot to another directory and try again.6. Please check that the OS user you use has an administrator privilege on the PC, this is really important. 7. Please go to Control Panel -> Add or Remove programs and check if the followings have been installed. Shared Add-in Extensibility Update for Microsoft .NET Framework 2.0 (KB908002) Shared Add-in Support Update for Microsoft .NET Framework 2.0 (KB908002) 8. Install BIP Desktop again

Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access.

Power Query enables users to easily discover, combine, and refine data for better analysis in Excel. Power Query includes a public search feature that is currently intended for use in the United States only.

In this lesson you will use PowerPivot to create and manage a measure and a Key Performance Indicator. A measure is a formula that is created specifically for use in a PivotTable (or PivotChart) that uses PowerPivot data. Measures can be based on standard aggregation functions, such as COUNT or SUM, or you can define your own formula by using DAX. For more information about measures, see Measures in PowerPivot.

With their inclusion in Excel standalone, at a cost of less than £100, any financial barrier to obtaining the benefit of these features is greatly reduced.

Excel 2013 Standalone Volume License and Standalone Retail 32-bit and 64-bit.

PowerPivot and the two new add-ins - PowerView and Inquire, are only available on certain SKUs (versions). These include:

Companiile locale încep să resimtă acum nevoia utilizării unor soluţii software de business intelligence (BI) cu ajutorul cărora să interpreteze şi să analizeze datele colectate, precum şi să facă prognoze, astfel încât să dispună de informaţiile necesare pentru luarea deciziilor de management.

„Până de curând, acum doi ani, discutam de partea de raportare, analiza evenimentelor post-factum. În general analizezi un eveniment după ce acesta s-a întâmplat. În momentul de faţă se simte nevoia de un element de business intelligence, care adaugă elementele de predicţie. Spre exemplu, în cazul în care creşte temperatura afară, se pune problema impactului asupra logisticii, relaţiei cu furnizorii etc“

ERP vendor selection. As the following graph shows, the primary candidates for ERP software were SAP, Oracle, Microsoft, Epicor, and Infor:

The cloud question. Despite the hype, only 14 percent of respondents are using ERP delivered as Software as a Service (SaaS). Although the best cloud vendors can deliver superior security and reliability than most internal IT departments, market momentum to ERP in the cloud is not there yet, as the following diagram illustrates:

Important lessons. Implementing an ERP system is always complex because the deployment drives changes to both data and processes that extend across departmental boundaries inside the organization.