There are many ETL (extract, transform and load) tools out there but Oracle Data Integrator (ODI) has gained a lot of ground because of its ability to perform event-driven, high-volume batch uploads from disparate data sources and to the variety of target applications/data storages. Having worked on a recent implementation, I have come to appreciate […]
Posts Tagged ‘Business Intelligence’
Ahhhh!! There’s data everywhere!!
In a world where data is collected for almost everything, companies often find they have trouble figuring out what to do with it. Theoretically companies could report on all their data, however, the larger the dataset gets the more money it will take to setup the infrastructure to support it. For most companies, especially those […]
Protecting Sensitive Data in a Multi-Shoring Development Environment
As more and more companies are “going global” to grow their business and share more data with more users, it is extremely important to secure data privacy and confidentiality. Perficient’s latest free whitepaper, Protecting Sensitive Data in a Multi-Shoring Development Environment, outlines a method for securing tremendous amounts of sensitive data. Highlights from this whitepaper […]
Problem installing PowerPivot on SharePoint server with existing SQL components
If you happen to install PowerPivot on a SharePoint server that has prior SQL Server installation (SQL engine, Analysis Services, Reporting Services etc.) you will run into problems. You may see error that the installation was unable to register Microsoft.AnalysisServices.SharePoint.Integration.dll assembly. Or if you are really lucky, you may get by far more helpful […]
Listening Deeply: Using Text Mining on Social Media Data
Social media means big business for a lot of brands. Many companies jump into social media outlets with great gusto and litter the place with ethusiastic diatribes about how great they are. They release tweets with no greater value proposition than “try our great product now”, and then they wonder why their social media efforts are not […]
Life Style Analytics: The Wave of the Future?
There has been ample hype surrounding how the health care industry is using business intelligence to improve quality and decrease costs associated with providing care. The hurdles and benefits of overcoming siloed data, gathering more data (ICD-10), and transmitting data to the right people (portals, security) are well-documented. This has encouraged the industry to look […]
OBIEE 11.1.1.5 Project Log, Part 1: Operating Systems
Welcome to my Oracle BI 11.1.1.5 Project Log series. This will be an open ended series related to decisions made and lessons learned in a live Perficient project. I will be focusing on the technology questions which should be generic to any OBIEE implementation. Which Operating System Should We Use? If a client has a […]
Managing BI Performance Problems Series Part 2: Indexing
When it comes to performance problems indexing is the bread and butter of most data warehouse developers. And why not? It’s a cheap and easy way address simple performance problems. However, like anything cheap and easy it can only fix the cheap and easy problems. Indexing will not solve large underlying performance problems, but it […]
Customer-Centric Business Intelligence: Predicting the Future
Faster analysis and decision making can create a powerful strategic advantage. Enterprise Performance Management (EPM) can be used as a powerful diagnostic tool through the use of automated scorecards and dashboards. A company can identify potential flaws and short-comings in the cause-and-effect relationships that drive company performance. Reaction times can be cut from hours and […]
Customer-Centric Business Intelligence: Viewing Customers through the Dashboard
The customer-centric scorecard provides managers with the vital customer data that drives performance. Using the scorecard and dashboards, managers are not only able to watch the long term trends in customer data, but they can also be alerted when shifts and changes in the customer base require action. Enterprise Performance Management (EPM) creates additional value […]
Does Health Information Technology & Primum non Nocere Live in the Same House?
In a recent American Medical News post, Doctors and Pharmacists unite to improve outcomes, the finding’s of an impressive pilot program were published. The program was focused on examining the impact of patient’s health when physicians and pharmacists collaborate. Results confirmed that individuals with chronic illnesses take their medications only 60-70% of time, but when […]
Customer-Centric Business Intelligence: Capturing Customer Data
In order to create a customer-centric organization that capitalizes on the power of Business Intelligence, companies must identify the goals they would like to achieve and incorporate them into a formal business strategy. The strategy map found in the balanced scorecard approach is a widely-used method for achieving this challenging task. Ultimately, understanding your customers […]