Posts Tagged ‘analytics’

Perficient is exhibiting and presenting this week at KScope14 in Seattle, WA. On Monday, June 23 I presented my retail-focused solution offering built upon the success of Perficient’s Retail Pathways, but using the Oracle suite of products. In order to focus the discussion to fit within a one hour window I chose restaurant operations to […]

Some interesting facts and figures for your consideration: 90% – of stored data in the world today was created in the past 2 years 50% – annual data growth rate 34,000 – tweets sent each minute 9,000,000 – daily Amazon orders 7,000,000,000 – daily Google Page Views 2.5 Exabyte – amount of data created every day (an Exabyte […]

Because of the popularity of mobile devices and other reasons, nowadays more and more companies have a large data store than before. The unit of data in big Internet companies like Google or Alibaba is PB or even EB.  How to store and fetch big data efficiently becomes a very interesting topic. There are three […]

Why do we Purge Cache Automatically? The cache option in OBIEE 11g can help us to improve query performance greatly. But sometimes when we refresh the data mapping or reload the transaction data, the result over report will be out of date and not refreshed immediately due to cache. The best way is that we […]

I remember that I heard the cloud concept about ten years ago while now the real cloud age is here. The cloud deployment and practice in CRM area might be the pioneer comparing with others. It is glad that we are seeing more and more BI vendors are boosting their cloud strategy and product development […]

Solution Writing column names in the first row of a flat file target using PowerCenter (version 8.1 or update) session, do the following: Edit the session with the flat file target in Workflow Manager. Select the Mapping tab. Select the target file. Scroll to the Header Options attribute. Select Output Field Names from the attribute list. NOTES: By default, this option […]

Recently we experienced the Data Warehouse Admin Console (DAC) notification configuration issue in the Oracle BI project and finally resolved that. It would require the configuration in two parts. 1. Configure Email Recipients in the DAC Client Follow this procedure to configure email recipients in the DAC Client. 1). In the Setup view, click the […]

Yammer contains some basic standard reports to help you understand the status of your Enterprise Social Network. These reports are available in the Apps section of Yammer in both the ‘freemium’ and enterprise versions. From the Apps Directory, find the My Apps section, which is just below the Featured Apps section. In here you will […]

Several years ago, when I started using QlikView (QlikTech’s flagship product), I had a strong preference for more traditional BI tools and platforms, mostly because I thought that QlikView was just a visualization tool. But after some first-hand experience with the tool, any bias I had was quickly dissipated and I’ve been a QlikView fan […]

GeoIP GeoIP via MaxMind is a great feature of Sitecore Analytics. Everything is built-in and all you need to do is inspect various attributes of the VisitorDataSet.VisitsRow, such as Region, Country, City, MetroCode, etc. Here’s how it works (simplified, of course). Sitecore runs UpdateGeoIpData as part of two Analytics pipelines: and In the Sitecore MVC […]

SQL Server 2012 introduces new analytical functions LEAD () and LAG (). These functions accesses data from subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join. The syntax for the Lead and Lag functions is: Note that: −        “Partition by clause” is optional, “order […]

  There have been numerous discussions and even arguments in terms of a better implementation strategy in BI projects. But there is no doubt that more and more teams are adopting agile processes or spirit into the team as of its value. When we have conversations on agile methodology or agile teams we usually start […]