Skip to main content

Home/ BI-TAGS/ Group items tagged action

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

Saving Current Values with Cascading LOVs - 0 views

www.danielmcghan.us/...ent-values-with-cascading.html

apex cascading lov

shared by cezarovidiu on 05 Jan 14 - No Cached
  • cezarovidiu on 05 Jan 14
     
    "Saving Current Values with Cascading LOVs A friend, Monty Latiolais, recently asked an interesting question regarding cascading LOVs: Say you've got two LOVs...STATES and CITIES. They both default to 'ALL' and 'ALL'. Since CITIES is dependent on STATES, as soon as STATES is changed, CITIES is blanked out. What should happen is that CITIES gets re-evaluated as in the following example... let's say STATES is ALL and CITIES is "Houston". If one then changes STATES to "Texas", CITIES should remain "Houston" as that is a valid value for CITIES. So basically, is it possible to maintain the selected value of an item if that same value exists in the list of values after refreshing? That's a great question! Thanks to new events in the APEX framework and Dynamic Actions the solution is far easier than it would have been in the past! Click here to see the demo but continue reading to learn how it all works… There are a three main events you need to be concerned with when it comes to cascading selects: change apexbeforerefresh apexafterrefresh The change event is a standard part of JavaScript and the DOM. This event fires when the user manually changes the value of the select list but can also be triggered programmatically via JavaScript. The apexbeforerefresh and apexafterrefresh events are custom events in the APEX framework. They fire just before and just after AJAX requests refresh something on the page. The events work with many items and regions that utilize this technology. In this example we have two select lists: parent and child. If you change the value of the child select list then the change event will fire and that's it. But if you change the value of the parent select list a lot more happens to the child select. Here are some of the highlights: The current LOV values are cleared out The apexbeforerefresh event is triggered An AJAX request brings back new values. This only happens if optimize refresh is set to false optimize refresh is set to true and
cezarovidiu

Data Quality, Data Governance, and Master Data Management (MDM) - 0 views

www.oracle.com/...index.html

data quality governance mdm

shared by cezarovidiu on 29 Jan 13 - No Cached
  • Modern business applications produce ever more relevant and actionable information for decision makers, but in many cases the data sources are fragmented and inconsistent. Despite tremendous advancements at the application layer, nearly all IT initiatives succeed or fail based on the quality and consistency of the underlying data.
  • CIOs are responsible for making information available to their businesses in a consistent and timely basis, but in most organizations, information management is seen as a delegated set of tasks and is not the CIO’s top priority.
  • “Key initiatives such as master data management, data virtualization, data quality, data integration and data governance are employed by just a fraction of organizations that should be mastering the science of information management,”
  • ...1 more annotation...
  • While CIOs are aware that effective information management results in faster decision-making, according to the Ventana study, only 43% of organizations have undertaken information management initiatives in data governance, data integration, data quality, master data management and data virtualization during the last two years, and less than one fifth have completed those projects. The largest obstacles to completing information management projects are insufficient staffing (68%), inadequate budget (63%) and insufficient training and skills (59%).
  • cezarovidiu on 29 Jan 13
     
    "Modern business applications produce ever more relevant and actionable information for decision makers, but in many cases the data sources are fragmented and inconsistent. Despite tremendous advancements at the application layer, nearly all IT initiatives succeed or fail based on the quality and consistency of the underlying data."
cezarovidiu

Building Dynamic Actions in Oracle Application Express 4.1 - 0 views

www.oracle.com/...dynactions.htm

apex obe action links

shared by cezarovidiu on 13 Nov 13 - No Cached
  • cezarovidiu on 13 Nov 13
     
    "select d.loc location, count(e.empno) num_employees from dept d, emp e where d.deptno = e.deptno(+) and d.deptno = :P3_DEPTNO group by d.loc"
cezarovidiu

10 Reasons Why CEOs Don't Understand Their Customers - Forbes - 0 views

www.forbes.com/...ont-understand-their-customers

crm

shared by cezarovidiu on 28 Feb 13 - No Cached
  • 1) Do bad customer experiences cause people to switch brands? In a 2011 research project conducted by CX application vendor RightNow, 89% of consumers said that yes, a bad experience has spurred them to switch brands. But in the brand-new study of business-executive perceptions that’s the subject of this column, only 49% of the surveyed executives said yes.  QUESTION: What steps do you need to take to close this dangerous perception gap? 2) While 97% of executives say CX is critical to the success of their company, and 91% say they’re committed to making their company a CX leader, only 20% would rate their own CX initiatives as “advanced,” with a dedicated CX leader in place, initial projects pushed to the optimization phase, and the overall project extended to new channels and groups . QUESTION: What are the obstacles preventing you from aligning your actions with your words? If you say it’s a “budget” issue, aren’t you really talking about strategic priorities rather than line items? 3) Most companies have a clear and direct understanding of the looming CX challenge and the powerful interaction of social media. The study found that the top two drivers for CX initiatives are (a) rising expectations from customers (59%),  and (b) the impact of social media on customers’ ability to broadcast good and bad experiences (37%). Now, even if you’re able to somehow rationalize those findings, here’s one that not even the most-accommodating executive can dismiss:
  • 4) Being a CX laggard can cost those companies many tens of millions or even hundreds of millions of dollars in lost revenue: executives estimated that the lack of positive, consistent, and brand-relevant customer experience can cause them to lose out on a staggering 20% in annual revenue.
  • Worse yet, all that money’s likely to wind up in the pockets of your competitors!
  • ...1 more annotation...
  • 5) While 81% of execs said they believe that social media is an essential ingredient in delivering great customer experiences, 35% of responding companies still do not have social media for sales channels, and another 35% still do not have social media for customer service. QUESTION: How do you plan to close that dangerous gap?
cezarovidiu

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

blogs.msdn.com/...today-the-data-translator.aspx

BI microsoft

shared by cezarovidiu on 07 Mar 13 - No Cached
  • 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

SugarCRM - Install Settings - 0 views

support.sugarcrm.com/...02_On_Site

sugarcrm crm install

shared by cezarovidiu on 27 Mar 13 - No Cached
  • memory_limit - Recommended setting: 512M or higher. The memory_limit parameter mainly comes into play when executing large transactions such as mass update, export and import. If this setting is too low when trying to perform one of these actions, the end user will encounter a fatal error and the process will not complete. upload_max_filesize and post_max_size - Recommended setting: 30M or higher. Both of these settings work in conjunction with each other when uploading files through SugarCRM which includes future upgrades as well as document and note attachments. Please note that there is also a setting in the application which can limit file upload file size for end users so the settings in PHP should be high enough to allow any future upgrade files to be loaded without error. max_execution_time = Recommended setting: 300. This setting controls how long a PHP process will remain active. It is important to set this parameter to a value that will allow for large requests to complete if necessary but also will not hamper performance of the server if running too long.
  • In regards to PHP setup, the following parameters should be set with values as indicated:
  • Maximum upload size Admin > System Settings 30000000 (~30 MB) The 'Maximum upload size' controls the maximum file size your users can upload into Sugar. This setting should not exceed the post_max_size and upload_max_filesize parameters in your PHP configuration.
  • cezarovidiu on 27 Mar 13
     
    "memory_limit"
cezarovidiu

Connecting Infobright and Talend - 1 views

www.infobright.org/...nnecting_infobright_and_talend

infobright DW

shared by cezarovidiu on 16 Feb 13 - No Cached
  • These instructions assume that you have Infobright installed and running.   First and foremost, download Talend.  In this example, we will download Talend Open Source Data Integrator v5.0. (http://www.talend.com/download.php)  Once fully installed, download the Talend/Infobright Connector.  Ensure you download the right connector; instructions are on the download page (http://www.infobright.org/Downloads/Contributed-Software/) If you download Talend 4.0+, you’ll want the latest connector For older versions of Talend, you’ll want the 3.7 connector and lower. Once downloaded, perform the following actions: [For Windows] Copy the infobright_jni([_32|_64])bit.dll to C:\Windows\infobright_jni.dll Copy the zipped “tInfobrightOutput” directory to this directory: [Install Root of Talend] \plugins\org.talend.designer.components.localprovider_5.0.1.r74687\components\tInfobrightOutput Copy “infobright-core-3.4.jar” to [Install Root of Talend]\lib\java Running Talend in Windows If using Windows, run talend as Administrator.  If you don’t, you will see odd “Access Denied” or “Accesse Refuse” error messages when trying to use the connector.
  • You need to do some work on these instructions. Version 5 is not like version 4. You must run Talend 5 before the “lib\java\” folder appears.  Once it does appear, it no longer contains the .jar files like version 4; just a file “index.xml” that you have to edit to point to the infobright jar file in the components folder.
cezarovidiu

What is business intelligence (BI)? - Definition from WhatIs.com - 0 views

searchdatamanagement.techtarget.com/...business-intelligence

business intelligence definition

shared by cezarovidiu on 21 Jan 15 - Cached
  • Business intelligence is a data analysis process aimed at boosting business performance by helping corporate executives and other end users make more informed decisions.
  • Business intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information to help corporate executives, business managers and other end users make more informed business decisions.
  • BI encompasses a variety of tools, applications and methodologies that enable organizations to collect data from internal systems and external sources, prepare it for analysis, develop and run queries against the data, and create reports, dashboards and data visualizations to make the analytical results available to corporate decision makers as well as operational workers.
  • ...9 more annotations...
  • The potential benefits of business intelligence programs include accelerating and improving decision making; optimizing internal business processes; increasing operational efficiency; driving new revenues; and gaining competitive advantages over business rivals. BI systems can also help companies identify market trends and spot business problems that need to be addressed.
  • BI data can include historical information, as well as new data gathered from source systems as it is generated, enabling BI analysis to support both strategic and tactical decision-making processes.
  • BI programs can also incorporate forms of advanced analytics, such as data mining, predictive analytics, text mining, statistical analysis and big data analytics.
  • In many cases though, advanced analytics projects are conducted and managed by separate teams of data scientists, statisticians, predictive modelers and other skilled analytics professionals, while BI teams oversee more straightforward querying and analysis of business data.
  • Business intelligence data typically is stored in a data warehouse or smaller data marts that hold subsets of a company's information. In addition, Hadoop systems are increasingly being used within BI architectures as repositories or landing pads for BI and analytics data, especially for unstructured data, log files, sensor data and other types of big data. Before it's used in BI applications, raw data from different source systems must be integrated, consolidated and cleansed using data integration and data quality tools to ensure that users are analyzing accurate and consistent information.
  • In addition to BI managers, business intelligence teams generally include a mix of BI architects, BI developers, business analysts and data management professionals; business users often are also included to represent the business side and make sure its needs are met in the BI development process.
  • To help with that, a growing number of organizations are replacing traditional waterfall development with Agile BI and data warehousing approaches that use Agile software development techniques to break up BI projects into small chunks and deliver new functionality to end users on an incremental and iterative basis.
  • consultant Howard Dresner is credited with first proposing it in 1989 as an umbrella category for applying data analysis techniques to support business decision-making processes.
  • Business intelligence is sometimes used interchangeably with business analytics; in other cases, business analytics is used either more narrowly to refer to advanced data analytics or more broadly to include both BI and advanced analytics.
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 - 14 of 14
Showing 20▼ items per page