Skip to main content

Home/ BI-TAGS/ Group items tagged forum

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

[Tutorial] VLOOKUP questions and answers (View topic) * OpenOffice.org Community Forum - 0 views

forum.openoffice.org/...viewtopic.php

tutorial openoffice excel

shared by cezarovidiu on 29 Jan 13 - No Cached
  • Summary: Check Search whole cells and uncheck Regular expressions
  • cezarovidiu on 29 Jan 13
     
    "Very important: Two of the options (OpenOffice.org > Preferences on a Mac, Tools > Options on other platforms) affect several functions, including VLOOKUP. Both of these options are in the Calc > Calculate section: Search criteria = and <> must apply to whole cells - If you uncheck this option text searches in VLOOKUP can match a substring of the values in the table so in the example a search for B will find B+. You almost certainly want to enable this option so that an exact match must occur. Enabling the option also makes your VLOOKUP formulas compatible with Excel. Enable regular expressions in formulas - Unless you understand what "regular expressions" are (see Help) and unless you specifically want to use them in your spreadsheet, you will want to uncheck Enable regular expressions in formulas because this option can make VLOOKUP difficult to use. Unchecking the option also makes your VLOOKUP formulas compatible with Excel. The questions below address what happens if you enable this option. Summary: Check Search whole cells and uncheck Regular expressions"
cezarovidiu

Should your company hire a Chief Data Officer? | Enterprise CIO Forum - 0 views

www.enterprisecioforum.com/...r-company-hire-chief-data-offi

customer knowledge chief data officer cio

shared by cezarovidiu on 08 Oct 14 - No Cached
  • Today, every business is a data business. If you’re a manufacturer of consumer goods, supply chain is absolutely central to what you do, and that’s software. It is all about data. That’s the back end. On the front end, social is absolutely critical if you’re in a consumer-facing business. This makes me recollect Geoffrey Moore’s notion about the implications of systems of engagement for corporations. Systems of engagement—such as Facebook, Google, and so on—generate vast amounts of information about consumer behavior.&nbsp;
  • And this is why enterprises are hiring CDOs. The information in systems of engagement becomes absolutely critical to large-scale successful consumer businesses. If you’re not leveraging it, then your competitor will outpace you in terms of customer knowledge.
  • CDO wears two hats. On one hand, the CDO is responsible for securing the customer data that’s inside the enterprise. In markets where the privacy laws are extremely strict (such as Germany or Canada), that’s a serious responsibility. At a global company, the CDO must manage consumer data at different levels in different countries in different ways, or creating an enterprise standard for data management globally that reflects the toughest regulation anywhere, which is what HP does.
  • ...1 more annotation...
  • The CDO must also deal with this new opportunity to exploit the much larger range of customer information that exists outside the enterprise. The challenge is to link customer information outside the enterprise with the information that’s inside, and do it in such a way that your data doesn’t leak. You want to run your analytics externally—on Facebook’s platform, for example, because it’s impossible to bring all of Facebook’s customer behavior information into your internal systems. So you never want to pass anything out, but you don’t want to bring everything in. It becomes a game of sophisticated integration.
  • cezarovidiu on 08 Oct 14
     
    "customer knowledge"
cezarovidiu

Analyzing Human Data: Take a Dive to Find Out What Your Customers Really Feel - Content... - 0 views

contentmarketinginstitute.com/...man-data-customers-really-feel

machine learning blog sentiment analysis customers marketing

shared by cezarovidiu on 30 Oct 14 - No Cached
  • What really interests me, and what I think should interest marketers, is what I’ll call signals – one of which is intent. Intent is critical because it can predict action. For example, “Is this person shopping to buy a product like my product?” “Is this person unhappy and needing some form of attention?” “Is this person about to return the product for a reason that is addressable?”
  • Sentiment is one ingredient of intent. If someone is happy, sad, angry … that can be determined via sentiment analysis technologies.
  • Many tools struggle with context.
  • ...9 more annotations...
  • An example I hear over and over again is “thin” – good when you’re talking about electronics, but bad if you’re talking about hotel walls or the feel of hotel sheets. To do sentiment analysis correctly, you need refinement. You need customization for particular industries and business functions.
  • The market, unfortunately, is polluted with tools that claim to have sentiment abilities, but are too crude to be usable. Even with refinement (e.g., the ability to handle negators and contextual sentiment), approaches that deliver only positive and negative ratings don’t take you very far.
  • There are definitely easy, inexpensive entry points that can meet basic, just-getting-started needs: tools for social listening, survey analysis, customer service (handling contact-center notes, for instance), customer experience (via analysis of online reviews and forums), automated email processing, and other needs. These technologies are user friendly, available on demand, as a service.
  • Text mining:
  • Digital Reasoning, Luminoso and AlchemyAPI.
  • Image recognition and analysis: Image analysis now automatically identifies brand labels in pictures.
  • VisualGraph (now owned by Pinterest), Curalate, Piqora (nee Pinfluencer), and gazeMetrix.
  • Emotional analysis in images, audio, and video: These companies promote analysis of speech and facial expression primarily for structured studies
  • • Affectiva conducts webcam emotional analysis for media and ad research, including development tools to integrate emotional study in mobile apps. • Emotient performs emotional analyses in retail environments, evaluating signage, displays, and customer service. • EmoVu by Eyeris tests the engagement level of both short- and long-form video content. • Beyond Verbal studies emotion based on a person’s voice in real time.
1 - 11 of 11
Showing 20▼ items per page