Skip to main content

Home/ BI-TAGS/ Group items tagged warehouse

Rss Feed Group items tagged

cezarovidiu

Magic Quadrant for Data Warehouse Database Management Systems - 0 views

  • relational database management systems (DBMSs) used as platforms for data warehouses
  • It is important to note that a DBMS does not in itself constitute a data warehouse — rather, a data warehouse can be deployed on a DBMS platform.
  • a data warehouse is simply a warehouse of data, not a specific class or type of technology
  •  
    "Magic Quadrant for Data Warehouse Database Management Systems"
cezarovidiu

Using the JDBC Connectivity Layer in Oracle Warehouse Builder - 0 views

  • For example, suppose you want to add support for MySQL. (As of OWB 11g R2, MySQL is not on the list of supported by default platforms.) All you need to do, though, is download the MySQL JDBC driver to put it into the OWB_HOME/owb/lib/ext directory, and add the platform definition for MySQL via a Tcl script that you can run from the OMB Plus console. The contents of such a script is beyond the scope of this article. However, if you want to look at one, check out this post by David Allan, where you’ll find a detailed example of how you can add support for MySQL to Oracle Warehouse Builder 11g Release 2. Also, there is a whitepaper on OTN called the "OWB Platform and Application Adapter Extensibility Cookbook", which goes into more depth than David’s post.
cezarovidiu

Does Excel Power Pivot Replace the Data Warehouse? | SQL Server BI Blog - 0 views

  • Excel Power Pivot is targeted for Personal and Team Business Intelligence (BI) solution use cases.
  • Power Pivot also is excellent for quick prototypes and proofs-of-concept.
  • no row level security,
  • ...2 more annotations...
  • The more advanced features include partitioning for large-scale data sources and role based security.
  • A data mart or data warehouse is often the blessed, single version of the truth since it uses governed, controlled data loading and ETL processes to combine disparate data sources, applies extensive business logic and proven data modeling design patterns that can securely, accurately and efficiently report data changes over time periods.
cezarovidiu

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

  • 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

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

You Probably Need Parallel Except When You Don't - 0 views

  • f you are running a large Oracle data warehouse you should be using parallel
  • Like all tools you have to use parallel correctly; no more would we think of using a wrench to hammer a nail then should you think parallel is the answer to all performance problems. Sometimes parallel will make things worse, sometimes parallel will make performance less predictable.
  • Parallel introduces additional work to a query, simplistically we need to: split the query into multiple parallel processes, execute them, wait for the processes to complete and finally coordinate the results. This all takes time to do. Our time saving comes from being able to process multiple smaller chunks of data simultaneously. If the time to execute the step in parallel is not significantly faster than doing it without parallel then the additional overhead may make parallel processing a slower option; this is typically the case with small tables where a full tablescan or an indexed access is fast. Use too few parallel processes and we will not gain much in performance, too many and we risk starving the database of resource for other work or even slow our own process as it waits for resource. If you have implemented some form of CPU resource management on your system you may find that you experience delays as your parallel slaves ‘wait their turn’
cezarovidiu

Rittman Mead Consulting » Blog Archive » Using OBIEE against Transactional Sc... - 0 views

  • The best practice in business intelligence delivery is always to build a data warehouse.
  • Pure transactional reporting is problematic. There are, of course, the usual performance issues. Equally troublesome is the difficulty in distilling a physical model down to a format that is easy for business users to understand. Dimensional models are typically the way business users envision their business: simple, inclusive structures for each entity. The standard OLTP data model that takes two of the four walls in the conference room to display will never make sense to your average business user.
cezarovidiu

Art Of BI Coverage of Business Analytics in 2013 | Art of Business Intelligence - 0 views

  • By the end of 2013, 72% of business executives will have tablets as their main means of consuming an Organization’s KPI’s and other analytics, scorecarding, etc
  • Although Roambi, and Microstrategy seem to be doing all of the right things with Mobile BI, there are several major BI Vendors that are not or there is simply room for improvement.  Also on the topic of Mobile BI, one of the barriers of 2012 was the concern for securing Mobile BI within an organization.  There has been a rise of solutions but no true standardization.  Oracle has produced their Mobile Security Tool Kit for Oracle BI and we will dive into that very soon as well (have Mac OS, will travel).
  • We hope this year to compare Oracle Endeca along with QlikView, and Spotfire to break apart the vendor specific functionality and give rise to insights on how to form successful solutions to the overall problem of self-service analysis of Big Data and traditional Data Warehouse data.
  •  
    "By the end of 2013, 72% of business executives will have tablets as their main means of consuming an Organization's KPI's and other analytics, scorecarding, etc."
cezarovidiu

Tableau Software's Pat Hanrahan on "What Is a Data Scientist?" - Forbes - 0 views

  • In the contemporary enterprise, almost everyone will need to have data-science skills of some kind.
  • “When most people think of a data scientist, they think of a statistician, a guy with ‘analyst’ in his title,’” Hanrahan says. “Or, someone who works in IT and manages the data warehouses. To do these jobs, you certainly needed programming skills; you probably needed advanced statistics skills, or some combination of those skills.”
  • “At the most basic level, you are a data scientist if you have the analytical skills and the tools to ‘get’ data, manipulate it and make decisions with it,” he says.
  •  
    "What is a Data Scientist?"
1 - 17 of 17
Showing 20 items per page