Google dashboard for lazy businessman

Once you start your own business or startup, the very first thing that comes to mind is "How many visitors did my website receive?"

Google Analytics provides tons of metrics and it becomes quite a chore to keep up with all the dashboard pages and filter options. As a small biz owner myself, I went through a phase where I ended up spending significant amount of time checking out Google Analytics

To save time and (more...)

How to optimize you reporting with Google Analytics

There are lot of ways you can optimize your reporting with Google Analytics and I would like to bring your attention to a very powerful solution as described below.

Our solution is not an Excel plugin but it is a packaged Datawarehouse. Let me assure and explain in very simple terms.

  1. Connect to your profile [or as many profiles]
  2. Pick your metrics
  3. Save your query

This 3 step process will let you define a complete (more...)

Google analytics datawerhouse

So far InfoCaptor has been just a Business Intelligence application with excellent Data visualization and dashboard capabilities.

With the new release of InfoCaptor, we are introducing a data-warehouse that is packaged with the software.

What is meant by packaged Datawarehouse?

We have built a framework for collecting data into a mysql database. This means you can upload any CSV file and convert into a database table. Along with this release we are also releasing two builtin connectors for Google (more...)

Importance of visualizations and analytics for small business owners

Small business owners are all about "Getting the biggest bang for the buck". We as small biz owners want everything to work efficiently and make sure no resources are wasted that includes human resources, time and money.

The question now is "How do you make sure your operation is efficient?" Not by any magic! But you already have the data that can be used to your advantage. Times have changed and Business Intelligence tools are no (more...)

How to create a Sankey Diagram

What is a sankey diagram?

Sankey Diagram is kind of a flow chart that has multi-purpose use. It can be applied in lot of different domains. Even though they are popular to visualize manufacturing flow or energy flow diagrams, there are other domains like HR, Finance, Web analytics etc where you can find the benefit of using Sankey visualization. As part of data visualization best practices, it is highly recommended to incorporate Sankey Visualizations as your new pie (more...)

Differences between charting engine, analytics software and dashboard software

Every often we would get users asking us 'How different is your dashboard software from XYZ Business Analytics?'

The XYZ spans across the entire Business Intelligence umbrella and often into the Website development and applicaton side as well.

Some of the questions are like

'How different is infocaptor dashboards from Tableau?"

'How is it infocaptor unique from Qlikview'

'How is it different from Oracle BI or SAP BI', the list goes on. But these are the questions we are prepared (more...)

Real World OBIEE: Demystification of Variables Pt. 2

In part one of this blog series, I went over using bins and presentation variables to dynamically create groups and switch between them in a report and on a dashboard. In part two, I am going to talk about making reports dynamic for periods of time using repository, system and presentation variables. Before I dive into an example, there are a couple of things I would like to cover first.

SYSDATE

The sysdate function returns (more...)

Find out the true benefit of Dashboards or Business Intelligence Software

In fact, the question should be "What should be the true benefit of Dashboards or Business Intelligence software? "
Whether you are using dashboard in excel, Dashboards in Microsoft Access, Quickbooks, business objects, Salesforce or big ERP like Oracle EBS or SAP, there are numerous tangible benefits of using InfoCaptor as your primary BI and dashboard app compared to other business intelligence software or reporting tools.

Now, well-designed dashboards are more interesting than most "old-fashioned" tabular reports [lot of the old sytle reporting software vendors have begun calling (more...)

A Performance Analytics Application Case Study: Challenges and Successes

The Performance Analytics application is a collection of open source technologies that aids users in: identifying performance bottlenecks, identifying causes for slow report execution, discovering areas for performance optimization, and gathering meaningful insights into the health of an OBIEE environment.

This post focuses on lessons learned after a successful Performance Analytics application installation, where within one day of being operational it enabled us to identify and isolate a long-standing memory issue. Here's how.

OBIEE Performance Analytics Dashboards

Overview

Rittman (more...)

OBIEE 11G: Setting multiple values to Presentation Variables through goURL and conditional filtering

I am writing this blog after a loooooong gap and I can tell you that it is worth the wait. In this blog, we discuss about the process of setting multiple values to a presentation variable through goURL. This blog also introduces the concept of CONDITIONAL FILTERING in OBIEE.

Do not confuse the setting (more...)

What is the true meaning and purpose of Business Intelligence?

Companies in a variety of industries are still data-rich but information-poor and this ratio keeps increasing every day. The rate of data generation is so high that organizations simply cannot keep up with generating insights out of it.

These enterprises lack the kind of actionable information and analytical tools needed to improve profits and performance. Business intelligence (BI) is the next logical step by management to start thinking about how to capitalize on the potential of BI to (more...)

Presentations from OUGN17

Here are the presentations I gave at OUG Norway last week. These are also available on SlideShare

Google acquisitions samples with vizualizations

Google has acquired around 184 companies as of October 2015, with its largest acquisition being the purchase of Motorola Mobility, a mobile device manufacturing company, for $12.5 billion. Not all the acquisition figures are available but aggregating all the public known amounts, Google has spent atleast 28 billion USD on acquisitions.

With the recent re-structuring, Google became a subsidiary of Alphabet Inc., which now owns most of the parts.

Using infocaptor dashboard (more...)

Property Graph in Oracle 12.2

The latest release of Oracle (12.2) includes support for Property Graph, previously available only as part of the Big Data Spatial and Graph tool. Unlike the latter, in which data is held in a NoSQL store (Oracle NoSQL, or Apache HBase), it is now possible to use the Oracle Database itself for holding graph definitions and analysing them.

Here we'll see this in action, using the same dataset as I've previously used - the (more...)

Accelerating Your ODI Implementation, Rittman Mead Style

Introduction

Over the years, at Rittman Mead, we've built up quite a collection of tooling for ODI. We have accelerators, scripts, reports, templates and even entire frameworks at our disposal for when the right use case arises. Many of these tools exploit the power of the excellent ODI SDK to automate tasks that would otherwise be a chore to perform manually. Tasks like, topology creation, model automation, code migration and variable creation.

In this blog (more...)

Create Your Own DVD Plugin in 22 minutes

Introduction

Oracle DVD played well for the task of elections data analysis. But I faced some limitations and had to curtail my use of one of my favourite charts - Scatter chart. While DVD’s implementation of it looks good, has smooth animations and really useful, it is not suitable for visualisations of huge datasets. Election dataset has about 100K election precinct data rows and if I try to plot all of them at one chart (more...)

A Case for Essbase and Oracle Data Visualization

So it’s the end of the month, or maybe even the end of the quarter. And you’ve found yourself faced, yet again, with the task of pulling whatever data will be needed to produce the usual standardized budgetary and / or finance reports. You’re dreading this as it will probably eat up most of your day just getting the data you need, combing through it to find the metrics you need, and plugging them into (more...)

Real World OBIEE: Demystification of Variables Pt. 1

OBIEE has some very powerful features and capabilities when it comes to how we visualize and present our data. There are some features which almost everyone uses (filters, prompts, rename columns ect.) and then some that are less common. In part, I think there is a lot of "noise" that surrounds the explanation of some of these features. Another reason, and probably the most likely, is that a lot of report developers may just (more...)

Amazon Launches Prime in India. Can Flipkart Stay ‘First’?

O
n the 27th of June, 2016, Amazon launched the first of its first AWS (Amazon Web Services) data centers in India, in Mumbai.

Amazon India announcing the launch of Prime (July 26, 2016) 
Less than a month later, on the 26th of July, 2016, Amazon launched Amazon Prime in India. After a free, trial period of 60 days, customers would be able to sign up for what it calls a “special, introductory price” of (more...)

Blog posts on Oracle Advanced Analytics features in 12.2

A couple of days ago Oracle finally provided us with an on-premises download for Oracle 12.2 Database.

Go and download load it from here

or

Download the Database App Development VM with 12.2 (This is what I did)

Over the past couple of months I've been using the DBaaS of 12.2, trying out some of the new Advanced Analytics option new features, and other new features. Here are the links to the (more...)