Skip to main content

Home/ BI-TAGS/ Group items tagged explorer'

Rss Feed Group items tagged

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

Angel's BI Blog: Excel Data Explorer and the Twitter Search API - 0 views

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

OpenRefine - 0 views

  • Introduction to OpenRefine 1. Explore Data OpenRefine can help you explore large data sets with ease. You can find out more about this functionality by watching the video below and going through these articles
  • 2. Clean and Transform Data
  • 3. Reconcile / Match
cezarovidiu

Google Reader (250) - 0 views

  • What this means in practice is that when the BI Server component starts up, it creates and reserves a number of threads in advance, determined by a number of parameters including SERVER_THREAD_RANGE.
  • You can see these threads running and ready to perform tasks for the BI Server component by using a tool such as Process Explorer for Windows
  • Thinking it through a bit, any given single query is, to a certain extent, only really going to use a small part of the total amount of CPUs available on a server, because it’s not the BI Server that runs queries in parallel, it’s the underlying database. For example, a single analysis against a single Oracle Database datasource would only really need a single BI Server thread to handle the query request, but when the underlying database receives the query, it might use a large number of its CPUs to process the query, returning results back to the BI Server to then pass back to the Presentation Server for display to the user.
  • ...2 more annotations...
  • The BI Server wouldn’t have any use for any more query threads, as it can’t really do anything with them – the exception to this being queries that generate multiple physical SQLs, for example to join data from multiple sources together and return a single set of data to the user, for which the BI Server could benefit from a higher CPU count if each of these queries in turn led to lots of threads being used – but two queries, in themselves, don’t neccessarily require two CPUs, because of course the BI Server, and the underlying CPUs, are themselves multi-threaded.
  • To conclude then – all things begin equal, the BI Server should make use of all of the CPUs that the underlying operating system presents to it, with the OS itself deciding what threads are scheduled against which CPUs. In-theory, all CPUs on the server are available to each BI Server component, but each OS is different and it might be worth experimenting if you’re sure that certain CPUs aren’t being used – but this is most probably unlikely and the main reason you’d really consider vertical scale-out of BI Server components is for fault-tolerance, or if you’re using a 32-bit OS and each process can only see a subset of the total overall memory. And, bear in mind that however many CPUs the BI Server has available to it, for queries that send just a single SQL statement down to the underlying database server, adding more CPUs or faster CPUs isn’t going to help as only a single (or so) thread will be needed to send the query from the BI Server to the database, and it’s the database that’s doing all of the work – all that this would help with is compilation and post-aggregation work, and enabling the server to handle a higher number of concurrent users. Invest in a better underlying database instead, sort out your data model, and make sure your data source back-end is as optimised as possible.
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

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

Using Email to Get the Conversion (Without Stalking) | ClickZ - 0 views

  • The reality of the inbox is that people subscribe to a lot more stuff than they are committed to reading. As a result, they sift through the advertising and marketing noise to find the gems--the messages they connect with and that add value to their lives.
  • your email has to add value to your customers' lives
  • From your initial sign up process to the content and frequency of your messaging, your most important job is showing your audience that you respect the privilege of being invited into their inbox.
  • ...15 more annotations...
  • Rule #1: Don't ask for more information than you'd personally be willing to give. Asking for too much information in an opt-in form can be a major deterrent to visitors who would otherwise be likely to sign up.
  • Make signing up as simple as possible by requiring only the bare minimum. In many cases, this means just the email address. Every field you add to your form beyond that will decrease the chances of someone filling it out.
  • Here's another tip: If you really want to convince a visitor to opt in to your communications, make it clear that the value they'll receive greatly outweighs the hassle of signing up
  • An opt-in form that says something like "Sign up for our newsletter," doesn't offer any benefit to the visitor. Give people a reason to opt-in by offering them something they'll care about, like: "Sign up for our monthly newsletter and gain instant access to our 57-page e-book on X."
  • Offers of buying guides, e-books, case studies, online videos, and instant coupons are all great incentives to test.
  • I recently welcomed two kittens into the family and we buy our supplies from Petco. As soon as I signed up for Petco's Pals Rewards program, the store proceeded to email me every single day with a new coupon offer. Can you guess what I did? Yep, I opted out. I'll still buy pet supplies from Petco, but at some point, the annoyance became greater than the value of the coupons.
  • One of the most critical steps in structuring your e-commerce email campaign is to set the publish frequency to align with the types of products you're selling and who you're selling to. At a bare minimum, segment your audience into two broad categories of current customers and prospects.
  • When you're communicating with prospective customers, offer discounts, promotions and pre-sale notifications and buying tips in your emails, to move them along the conversion path.
  • You can further segment your email list by those you send to frequently, those you send to less frequently and those you send to only sometimes.
  • You'll find your sweet spot by tracking conversions from the list, looking at the opt-out rate and by allowing your audience to manage the frequency of the communications (for example, by giving them the option to change the frequency before they opt out entirely).
  • When most people opt in to receive B2B email communications, they are at the top of the conversion funnel; the "awareness" stage. A smart B2B email campaign will then provide the right content to bring the buyer deeper into the conversion funnel, with content specific for each stage of the buying cycle.
  • Here are some ideas to get you started: Explore learning concepts that get the reader up to speed on the ideas surrounding your services, and that demonstrate your brand's unique perspective.  Dive into the ideas behind why a service like yours is so important to customers, what to look for in a company, and how your service or ideas compare to others.  Answer common questions your prospective customers have at each stage of the buying cycle and even after the purchase.
  • Don't forget you're not selling to rational people. Most of the buying decisions in a B2B environment are based on what could happen if the choice is wrong. Unlike the consumer market, where an item can be easily returned if it doesn't meet the buyer's needs, making the wrong purchase decision in the B2B arena could be extremely costly.
  • Your goal as the marketer is to arm the potential buyer with content that will reduce any fear and uncertainty about selecting your business over the competition.
  • Think of topics like, "7 Biggest Mistakes People Make When Choosing [insert your service here]" as a basis for building your case. If you have a sales team, ask them for the most common objections they hear from prospects, and create your content around the specific concerns known to be top-of-mind for many buyers.
cezarovidiu

Installing Hadoop for Fedora & Oracle Linux(Single Node Cluster) | accretion infinity - 0 views

  • Hadoop is a framework written in Java for running applications on large clusters of commodity hardware and incorporates features similar to those of the Google File System (GFS) and of the Map Reduce computing paradigm. Hadoop’s HDFS is a highly fault-tolerant distributed file system and, like Hadoop in general, designed to be deployed on low-cost hardware. It provides high throughput access to application data and is suitable for applications that have large data sets.
  • Some of the Hadoop projects we will talk about are: HDFS : A distributed filesystem that runs on large clusters of commodity machines. Map Reduce: A distributed data processing model and execution environment that runs on large clusters of commodity machines. Pig: A data flow language and execution environment for exploring very large datasets. Pig runs on HDFS and MapReduce clusters. HBase: A distributed, column-oriented database. HBase uses HDFS for its underlying storage, and supports both batch-style computations using MapReduce and point queries (random reads). ZooKeeper: A distributed, highly available coordination service. ZooKeeper provides primitives such as distributed locks that can be used for building distributed applications. Oozie: Oozie is a workflow scheduler system to manage Apache Hadoop jobs.
  • Oracle Linux as the operating system and Hadoop 1.1.2 or 1.2.0
1 - 14 of 14
Showing 20 items per page