Skip to main content

Home/ BI-TAGS/ Group items tagged fonts

Rss Feed Group items tagged

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

How Do I Find The Largest Top 10 Files and Directories On a Linux / UNIX / BSD? - 0 views

  • # du -a /var | sort -n -r | head -n 10
  • find /path/to/dir/ -printf '%s %p\n'| sort -nr | head -10 find . -printf '%s %p\n'| sort -nr | head -10
  •  
    "# du -a /var | sort -n -r | head -n 10"
cezarovidiu

BI-ul se democratizeaza la nivel operational - 0 views

  • Practic, avem de-a face cu coborârea din sferele abstracte a BI-ului tradiţional către „enterprise intelligence“; o formă de „democratizare“ a BI-ului a devenit accesibilă maselor de utilizatori finali, pe baza ideii că instrumentele specifice acestui concept (analiză, raportare, semnalare etc.) trebuie să permită şi să ofere suport pentru luarea deciziilor în timp real.
  • Potrivit specialiştilor, „mutaţia“ menţionată reprezintă o evoluţie naturală, realizată sub presiunea pieţei, care impune luarea tot mai rapidă a unor decizii din ce în ce mai complexe la nivelul managementului operaţional în mod cotidian. Este vorba, practic, de o reorientare a conceptului de BI, de la tradiţionalul „data-centric“ spre mai pragmaticul „process-centric“, menit să permită un răspuns mai agil la provocările din piaţă.
  • Astfel, aplicaţiile de BI operaţional nu mai sunt rezervate doar analiştilor de business din top management, ci sunt accesibile şi directorilor executivi, managerilor şi utilizatorilor finali cu putere decizională. Prin intermediul acestui nou concept, managerii departamentelor de vânzări şi staff-urile din centrele de suport beneficaiză de informaţii relaţionate cu lista de activităţi zilnice şi de workflow-uri şi ghiduri de analiză, care îi ajută să interpreteze şi să analizeze informaţiile pe baza cărora trebuie să ia deciziile.
  • ...3 more annotations...
  • Astfel, potrivit rezultatelor finale, 66% dintre respondenţii studiului realizat de Ventana au indicat faptul că cel mai important câştig obţinut la nivelul întregului business în urma implementării unor soluţii de BI operaţional în cadrul companiilor lor este în creştere în eficienţă la toate nivelurile. (În completare, 60% dintre subiecţi au indicat faptul că îmbunătăţirea serviciilor oferite clienţilor reprezintă principala prioritate urmărită prin dezvoltarea aplicaţiilor de BI operaţional.) Alţi 53% consideră ca principal beneficiu faptul că au realizat reduceri importante de costuri, în timp ce 48% creditează orientarea spre abordarea operaţională a BI-ului drept principalul factor diferenţiator faţă de concurenţă.
  • Factorii diferenţiatori Rezultatele evidenţiate de studiul Ventana sună mai mult decât promiţător şi confirmă previziunile optimiste ale analiştilor privind creşterea pieţei pe această zonă, cotată cu o evoluţie chiar mai rapidă decât a pieţei aplicaţiilor de BI tradiţional. Pentru a evidenţia mai clar distincţia, iată punctele esenţiale în care abordarea operaţională diferă de cea tradiţională: audienţă, granularitate, timp de răspuns şi disponibilitate. Iată, pe scurt, fiecare parametru explicitat: Audienţa: plaja de utilizatori ai dezvoltărilor de BI operaţional include angajaţi implicaţi în activităţi operaţionale (agenţi de vânzări, personal tehnic, personal din contact centere etc.), care trebuie să ia rapid decizii cu impact semnificativ la acel nivel, dar şi manageri care trebuie să urmărească în mod curent indicatorii de performanţă operaţionali pe anumite niveluri. În cazul în care compania ce a implementat o dezvoltare de BI operaţional a reuşit să stabilească o corelare clară între indicatorii de performanţă strategici (Key Performance Indicators) şi metricile din plan operaţional, audienţa include şi persoane din senior management, care pot investiga în adâncime modul în care sunt respectate direcţiile strategice stabilite. Concluzia - audienţa aplicaţiilor de BI operaţional este mult mai mare decât în BI-ul tradiţional.
  • Timpul de răspuns: intervalul de răspuns pentru aplicaţiile de BI operaţional este semnificativ mai mic decât în BI-ul tradiţional. Cele mai multe module operaţionale necesită date al căror „grad de prospeţime“ poate varia de la câteva secunde la câteva minute. Acest fapt impune condiţii speciale în ceea ce priveşte furnizarea datelor în timp real, pentru că sunt necesare în luarea deciziilor în procesele operaţionale, care necesită un timp scurt de reacţie. Granularitate: spre deosebire de soluţiile de BI tradiţional care agregă date pentru a furniza o perspectivă ideală asupra performanţelor companiei, aplicaţiile de BI operaţional necesită un nivel mult mai mare de granularitate al datelor pentru a adresa nevoile specifice la nivel operational. (Nu este valabil însă în cazul tuturor aplicaţiilor de „operational BI“ - anumite date necesită date agregate provenind din data warehouse. Exemplul cel mai uzitat: parametrul „customer lifetime value“ utilizat de agenţii din contact center.) Disponibilitate: Aplicaţiile de BI operaţional sunt menite să furnizeze suport direct proceselor tranzacţionale de business sau de suport. Ceea ce înseamnă că perioada de inactivitate a acestor aplicaţii afectează direct abilitatea companiei de a încheia tranzacţii şi de a oferi suport clienţilor. Consecinţa logică – aplicaţiile trebuie să prezinte un grad ridicat de anduranţă.
cezarovidiu

Moving Sugar to Another Server - SugarCRM Support Site - 0 views

    • cezarovidiu
       
      japtone   Senior Member Join Date Nov 2010 Posts 49  Re: Transferring SugarCRM to a new server If you're using Linux try to have the same version of PHP, Apache, and DB (MySQL for instance) in order to avoid compatibility issues. In your production server tar up the sugarcrm root directory, transfer it to the new server and untar wherever your new root directory will be.  Next take a db dump of your database, transfer it to the new server and do a restore. Make sure apache is configured on the new server to point to the root of sugarcrm and start it up.  Make sure to modify config.php to account for any change in paths and hostname.  that's what I've found to be the easiest way to 'clone' sugar.
  • mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
  • Extract the Database
  • ...5 more annotations...
  • Copy Filesystem Copy all your files to the new server.  This can be done simply by locating the root directory on your old instance and copy and pasting it to the new server location.
  • Import Database Import the mysql database into the new server.  Here's how you would restore your custback.sql file to the Customers database. mysql -u sadmin -p pass21 Customers < custback.sql Here's the general format you would follow: mysql -u [username] -p [password] [database_to_restore] < [backupfile]
  • Check Files and Permissions Check Config.php Open <sugarroot/config.php> and make sure that all settings still apply to the new server, such as: array ( 'db_host_name' => 'localhost', 'db_user_name' => 'root', 'db_password' => 'PASSWORD', 'db_name' => 'DATABASE_NAME', 'db_type' => 'mysql', ), 'site_url' =>, etc...
  • Check htaccess Open <sugarroot/.htaccess> and ensure that the new server URLs are used correctly.
  • Check Permissions Check that the permissions are correct on the new server. That is the entire custom and cache directories (and all the sub directories) in addition to the config.php file are owned and writable by the user that runs the application on the server.
cezarovidiu

Dancing and Wrestling with Oracle APEX: Apex and FusionCharts (or There be dragons at t... - 0 views

  • All of which led me to FusionCharts, which is a brilliant set of flash charts and widgets.
  • All I had to do was figure out how to integrate it into my app. First I had to write a function to extract the data I needed from my database and output it as correctly-formatted XML. That bit was easy so I won't bore you with it.
  • Next I uploaded the Flash (SWF) file for my chart into my workspace. (Tell me something: when you upload an image to your application using Apex's image uploader you refer to it by pointing at # APP_IMAGES#, so how do you think you'd refer to a file you've uploaded using Apex's file uploader? #APP_FILES#? Wrong! Illogically, all files uploaded into your application should be pointed at using the #APP_IMAGES# substitution string.)Finally, I created a dynamic PL/SQL content region outputting the necessary wrapper tags for my Flash movie (which I copied from the FusionCharts examples), pointing it to my uploaded swf file and feeding it the XML from my database function (which I call in "before regions" page process).
cezarovidiu

Cora Romania implementeaza solutia IBM SPSS - 0 views

  • Cora România a implementat cu succes soluţia completă de analiză predictivă - IBM SPSS Statistics, prin intermediul IBM Innovation Centre şi cu suportul IBM Business Partner.
  • Cora România urmărește creşterea nivelului de satisfacere a clienţilor, fidelizarea acestora şi crearea de oferte personalizate.
  • Soluţia implementată de retailer satisface nevoia de îmbunătăţire a ofertelor de produse pentru clienţii săi.
  • ...3 more annotations...
  • Soluţia de analiză predictivă va ajuta Cora România să înţeleagă mai bine nevoile clienţilor și schimbările survenite în comportamentul de cumpărare al acestora, astfel încât va putea să dezvolte noi produse şi servicii care să corespundă dorințelor acestora. Totodată, retailer-ul va putea preveni plecarea cumpărătorilor majori, va putea vinde servicii adiţionale clienţilor actuali, va dezvolta produse mai eficiente şi va putea identifica şi minimiza frauda şi riscurile.
  • Soluţia IBM implementată ne va permite să evaluăm corect gradul de informare asupra brandului Cora. În viitor, vom fi capabili să identificăm direcţiile noi de business ce trebuie urmate şi să economisim timp preţios prin automatizarea proceselor de colectare a datelor, concomitent cu creşterea satisfacţiei clienţilor”, a declarat Simona Sahin, responsabil cercetare de marketing Cora România.
  • •Optimizarea tuturor tipurilor de decizii utilizând informațiile cheie obţinute cu ajutorul soluţiilor analitice;•Furnizarea de informaţii care ţin cont de perspectivele şi orizonturile de timp, de la raportarea istorică până la analiza în timp real şi la modelarea predictivă;•Îmbunătăţirea rezultatelor de business şi a managementului riscurilor;Creşterea nivelului de retenţie (menţinere) a clienţilor.
cezarovidiu

Install Oracle Java 7 in Ubuntu 12.10/12.04/11.10/Any Ubuntu or Linux Mint Version ~ No... - 0 views

  • For 64-bit users: wget -O jdk-64bit.tar.gz http://goo.gl/MSzBj wget -O jre-64bit.tar.gz http://goo.gl/yZgjI sudo -s cp -r jre-64bit.tar.gz /usr/local/java sudo -s cp -r jdk-64bit.tar.gz /usr/local/java cd /usr/local/java sudo -s chmod a+x jre-64bit.tar.gz sudo -s chmod a+x jdk-64bit.tar.gz sudo -s tar xvzf jre-64bit.tar.gz sudo -s tar xvzf jdk-64bit.tar.gz
  • sudo nano /etc/profile Add the following lines at the end of file: JAVA_HOME=/usr/local/java/jdk* PATH=$PATH:$HOME/bin:$JAVA_HOME/bin JRE_HOME=/usr/local/java/jre* PATH=$PATH:$HOME/bin:$JRE_HOME/bin export JAVA_HOME export JRE_HOME export PATH
  • Now enter following commands one by one in terminal: sudo update-alternatives --install "/usr/bin/java" "java" "/usr/local/java/jre1.7.0_12/bin/java" 1 sudo update-alternatives --install "/usr/bin/javac" "javac" "/usr/local/java/jdk1.7.0_12/bin/javac" 1 sudo update-alternatives --install "/usr/bin/javaws" "javaws" "/usr/local/java/jre1.7.0_12/bin/javaws" 1 sudo update-alternatives --set java /usr/local/java/jre1.7.0_12/bin/java sudo update-alternatives --set javac /usr/local/java/jdk1.7.0_12/bin/javac sudo update-alternatives --set javaws /usr/local/java/jre1.7.0_12/bin/javaws . /etc/profile
  • ...1 more annotation...
  • Check installed java version java -version
cezarovidiu

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

  • Summary: Check Search whole cells and uncheck Regular expressions
  •  
    "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

Oracle APEX Interactive report based on PLSQL function | Oracle Application Express - 0 views

  • Unfortunately Oracle have failed to allow the report to be based on a PLSQL function returning the query.
  • Step1.Create a collection based on a query. The code for this should be placed in a before header process APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY(p_collection_name =&gt; ‘IR_TEST’,p_query =&gt; function_returning_query );
  • Step 2.Create an interactive report querying a collection. Select *From apex_collectionsWhere collection_name = ‘IR_TEST’;
cezarovidiu

Raportare sau BI C - 0 views

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

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

OBIEE 11G configuration's Maximum Limits | OBIEE by Shiva Molabanti - 0 views

  • OBIEE 11G configuration’s Maximum&nbsp;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.
1 - 12 of 12
Showing 20 items per page