Group items tagged

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.

Summary: Check Search whole cells and uncheck Regular expressions

its a very powerful query engine/data transformation tool.

what's fascinating is its ability to load web data from static html pages, tables on web pages, web services, etc. I had a need to search recent activity on Twitter and decided to test drive Data Explorer in Excel.

Note: Power Pivot and Power View on the standalone retail 32-bit and 64-bit SKUs were added with the October 2013 updates. If you have one of these SKU's but do not see the add-in, please apply the most recent updates and test for improvement. 

Excel Power Pivot is targeted for Personal and Team Business Intelligence (BI) solution use cases.

Power Pivot also is excellent for quick prototypes and proofs-of-concept.

no row level security,

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.

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:

Great design, high-quality code, strong business sponsorship, accurate requirements, good project management, and thorough testing are some of the obvious requirements for successful analytics systems.

As a professional in the field, you must be able to do these things well because they form the foundation of a good analytics implementation.

Successful analytics professionals should follow a set of guiding principles.

OBIEE 11G configuration’s Maximum Limits

Be careful when you are setting the Cache attribute values. For implementations under significant stress increase this value to 1000 or a higher value as mentioned below. The main factor that affects its size is the memory consumption. Maximum range of Global Cache storage size (in Megabytes) to use when BI Server cache is enabled – 9,999 Maximum number of cache entries; used to tune cache performance – 99,999 Maximum size (in Megabytes) for individual server cache entries – 9,999 Data Display/Download: The Maximum no.of rows that we can set to display/download in the Table/Pivot views. But keep in mind OBIEE is NOT meant to be a tool to extract huge amounts of information. Maximum number of rows of data to include in Table views – 9,999,999 Maximum number of rows of data to include in delivered emails – 9,999,999 Maximum number of rows to export to excel – 9,999,999

In OBIEE 11G, The instanceconfig.xml file stores the OBI PS configuration settings. Many configuration settings are available in EM and those should be controlled within EM only unless if we disabled centralConfigurationEnabled option. If any particular setting is not available in EM then we should make changes directly in instanceconfig.xml file. There are many situations where we need to change the default OBI configuration settings to a new value.

Dezvoltarea afacerilor aduce cu sine întrebări din ce în ce mai complexe: care este cel mai profitabil produs pe care îl vând? Care este evoluţia marjei mele de profit pe produsul X de-a lungul ultimilor ani? Cum pot fi reduse eficient cheltuielile operaţionale fără a afecta performanţa afacerii? Cum pot fi reduse pierderile pe lanţul de aprovizionare sau pe circuitul de producţie? Care este volumul de afaceri pe care îl fac cu furnizorul Y şi ce discount aş putea solicita în perioada următoare? Care este cel mai performant vânzător al meu? etc…

Sigur, răspunsuri la întrebări complexe pot fi obţinute şi fără aportul soluţiilor de „business intelligence” insă de cele mai multe ori obţinerea rezultatelor dorite presupune cel puţin: personal specializat (analişti), inevitabila eroare umană şi mai ales timp. Timp petrecut cu activităţi repetitive de extragere a datelor, de formatare a acestora, de definire a diverselor formule şi calcule necesare etc. Mai mult decât atât, datele odată extrase din sistemul de gestiune şi „împrăştiate” la diverse nivele din organizaţie (sub forma de fişiere text, Excel sau DBF) îşi pierd proprietăţi precum integritate, acurateţe, confidenţialitate şi, poate cea mai importantă, credibilitate.

Alternativa? Un sistem ce poate gestiona în mod automat transformarea datelor în informaţie şi accesul la aceasta în funcţie de rolul utilizatorului în cadrul organizaţiei, în mod securizat, cu posibilitatea interacţiunii facile cu datele şi generarea de rapoarte şi analize complexe din câteva click-uri de mouse. Şi acestea sunt numai câteva din facilităţile oferite de furnizorii soluţiilor de „business intelligence”.