Skip to main content

Home/ BI-TAGS/ Group items tagged microsoft

Rss Feed Group items tagged

cezarovidiu

Magic Quadrant for Business Intelligence and Analytics Platforms - 0 views

  • 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.
  • ...7 more annotations...
  • These capabilities enable organizations to build precise systems of classification and measurement to support decision making and improve performance. BI and analytic platforms enable companies to measure and improve the metrics that matter most to their businesses, such as sales, profits, costs, quality defects, safety incidents, customer satisfaction, on-time delivery and so on. BI and analytic platforms also enable organizations to classify the dimensions of their businesses — such as their customers, products and employees — with more granular precision. With these capabilities, marketers can better understand which customers are most likely to churn. HR managers can better understand which attributes to look for when recruiting top performers. Supply chain managers can better understand which inventory allocation levels will keep costs low without increasing out-of-stock incidents.
  • descriptive, diagnostic, predictive and prescriptive analytics
  • "descriptive"
  • diagnostic
  • data discovery vendors — such as QlikTech, Salient Management Company, Tableau Software and Tibco Spotfire — received more positive feedback than vendors offering OLAP cube and semantic-layer-based architectures.
  • Microsoft Excel users are often disaffected business BI users who are unable to conduct the analysis they want using enterprise, IT-centric tools. Since these users are the typical target users of data discovery tool vendors, Microsoft's aggressive plans to enhance Excel will likely pose an additional competitive threat beyond the mainstreaming and integration of data discovery features as part of the other leading, IT-centric enterprise platforms.
  • Building on the in-memory capabilities of PowerPivot in SQL Server 2012, Microsoft introduced a fully in-memory version of Microsoft Analysis Services cubes, based on the same data structure as PowerPivot, to address the needs of organizations that are turning to newer in-memory OLAP architectures over traditional, multidimensional OLAP architectures to support dynamic and interactive analysis of large datasets. Above-average performance ratings suggest that customers are happy with the in-memory improvements in SQL Server 2012 compared with SQL Server 2008 R2, which ranks below the survey average.
  •  
    "Gartner defines the business intelligence (BI) and analytics platform market as a software platform that delivers 15 capabilities across three categories: integration, information delivery and analysis."
cezarovidiu

Tech Leaders Microsoft, IBM, Oracle, NCR Roll Out New Retail Apps For Stores - 0 views

  • 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.
cezarovidiu

From Raw Data to Insight using HDP and Microsoft Business Intelligence - Hortonworks - 0 views

  •  
    "From Raw Data to Insight using HDP and Microsoft Business Intelligence"
cezarovidiu

Filling a Critical Role in Business Today: The Data Translator - Microsoft Business Int... - 0 views

  • 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.
  • ...5 more annotations...
  • Every company has hundreds of millions of records about their sales, expenses, employees and so on, with dozens of insights yet to be discovered through simple comparison or triangulation of relevant data.
  • Why don’t we focus on this? I think because it’s very difficult to do – being successful in this “data translator” role requires a unique set of skills and knowledge, the combination of which I call the BASE skillset: Business understanding Ability to synthetize and simplify Storytelling skills Expertise in data visualization
  • Business Understanding This one seems obvious, but it doesn’t mean simply understanding the financials of a business. Rather, it means truly knowing the operational details, the incentives, the install base, market growth, penetration, the competition, etc. An analyst can’t just know the technical aspect of a report or the math behind the numbers, but what is truly driving a pattern in terms of product quality, competition, incentives and/or offerings. The best analysts are able to mathematically isolate the key levers of a trend and then suggest actions to react to or take advantage of those trends. Ability to Synthetize and Simplify This is, in my opinion, the most underrated and underappreciated skill. Combing through thousands of data points and netting out 3-4 key issues in under 10 minutes, and then communicating these to a group of execs with very different analytical skills, is truly difficult. The key is to make it simple but not simplistic, which means you still capture the complexity even as you get to the few core insights. It requires a very thorough effort to gather all the relevant information before categorizing, prioritizing and deciding if it is significant. After a while, you become an expert and can sniff things out quickly. At the same time, there is the danger of missing anomalies when you jump to conclusions based only on a summary look.
  • Storytelling Skills There are stages that should be followed when explaining complex ideas, something data translators are frequently expected to do. The best storytellers start by giving context and trying to couple the current discussion to something the audience already knows, ensuring the story is well structured and connected. We have to move from a “buffet style” business review with thousands of numbers packed in tables to a layered approach that will guide the audience to focus first on the most relevant messages, diving deeper only when necessary. Minto Pyramid Principles, which are built around a process for organizing thought and communication, are helpful in making sure you really focus on what is important and relevant, versus being obsessed in telling every fact. Expertise in Data Visualization I am glad to finally see so much focus on Information Visualization and I believe this is correlated to the explosion of data. Traditional methods of organizing data do not facilitate an intuitive understanding of key information points or trends. For instance, the two examples below contain data on car sales across the U.S. The first, an alphabetized list, is much less intuitive than the second, which shows those sales on a map in Power View. With Power View, right away you can identify the states with the highest sales: CA, FL, TX, NY. (Workbook available here)
  • There is no better way to see patterns or trends than data visualization, making expertise in this area – both technical and analytical – critical for data translators.
cezarovidiu

Template Builder Woes! (Oracle BI Publisher Blog) - 0 views

  • 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
cezarovidiu

Download Microsoft Power Query for Excel - Office.com - 0 views

  • 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.
cezarovidiu

Create a Measure and KPI (Tutorial) - 0 views

  • 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.
  •  
    "Create a Measure and KPI (Tutorial)"
cezarovidiu

Veeam Backup Free Edition for VMware and Hyper-V - 0 views

  •  
    "What's Inside Veeam Backup Free Edition contains useful utilities for day-to-day VM management: VeeamZIP: Backup a VM on-the-fly for operational, archival or portability purposes Instant File-Level Recovery: Restore individual guest files directly from a VeeamZIP backup NEW! Veeam Explorer™ for Microsoft Exchange: Get instant visibility into VeeamZIP backups of Exchange VMs for quick recovery of individual items (emails, contacts, notes, etc.) NEW! Veeam Explorer™ for SAN Snapshots: Restore individual VMs, guest files and Exchange items from SAN snapshots* File Manager: The easy way to manage VM and host files Quick Migration for VMware: Migrate a live VM to any host or datastore *Currently available for VMware only"
cezarovidiu

PowerPivot, Power View and Inquire availability - the definitive Microsoft answer - 0 views

  • 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:
cezarovidiu

Microsoft Summit 2014: „Piaţa soluţiilor de business intelligence este la înc... - 0 views

  • 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“
cezarovidiu

Raportare sau BI C - 0 views

Raportare sau BI Ce sau de ce? http://www.marketwatch.ro/pdfs/MW%20131.pdf Controlul asupra companiei, obiectiv pe care îl doreºte orice manager, poate fi  exercitat numai p...

started by cezarovidiu on 17 Jan 13 no follow-up yet
cezarovidiu

2013 ERP research: Compelling advice for the CFO : Enterprise Irregulars - 0 views

  • 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.
  • ...4 more annotations...
  • Software projects aren’t just technical endeavors. They’re also political, financial, emotional, structural, strategic, process and people-centric initiatives. Ignoring any one of these dimensions is done at the project manager’s peril.
  • Today’s CFO must balance the demands of two competing forces: the extraordinary wave of innovation (and the process changes these bring) against the regulatory, control-driven forces who want every process, every exception, and device to be documented, controlled and secured. In recent years, CFOs have spent tens of billions of dollars (or more) with audit firms to document the control points and risks within their existing ERP solutions.
  • ERP can bring significant benefit but implementation requires careful attention to both business planning and technology activities. For this reason, achieving project success and business value demand that CFO and CIO work together as a collaborative unit.
  • Therefore, it is essential to create this partnership and show your entire organization that the business and technology teams can communicate, collaborate, and share knowledge on a systematic and consistent basis. This collaboration is the true underlying strategy for gaining maximum value from ERP or any other enterprise initiative.
1 - 20 of 38 Next ›
Showing 20 items per page