Nilesh Jethwa

Subscribe to Nilesh Jethwa feed
All about bigdata, dashboards, analytics and visualizations
Updated: 2 hours 17 min ago

5 reasons you should use dashboards in marketing industry

Tue, 2017-03-28 13:20

What's the first thing you look at when you flip on your computer screen in the morning? What's the item you peek at on your phone even when your dinner partner wishes you'd leave work behind for the evening? For most people that addictive checking-tendency applies to their emails, but the truly business-savvy marketers are addicted to looking at their dashboards!

And why is that? It's because dashboards provide a true and comprehensive look at everything important that is happening in your business.

With a well-constructed dashboard, you can see exactly where things stand with your business, literally at a glance. Let us just break down the benefits for you!

Read more at http://www.infocaptor.com/dashboard/5-benefits-of-dashboards-in-the-marketing-industry

Google dashboard for lazy businessman

Mon, 2017-03-27 15:20

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 mental energy on a daily routine task, I asked "What are the most basic metrics I need to measure from Google Analytics?"

The answer pretty much came down as a need to have "one page dashboard that displays various metrics".

Read more at http://www.infocaptor.com/dashboard/what-are-the-bare-minimum-traffic-metrics-that-i-can-track-easily

Google dashboard for lazy businessman

Sun, 2017-03-26 11:45

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 mental energy on a daily routine task, I asked "What are the most basic metrics I need to measure from Google Analytics?"

The answer pretty much came down as a need to have "one page dashboard that displays various metrics".

Read more at http://www.infocaptor.com/dashboard/what-are-the-bare-minimum-traffic-metrics-that-i-can-track-easily

How to optimize you reporting with Google Analytics

Sat, 2017-03-25 10:40

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 workflow of extracting your website metrics into a MySQL database table. Yes, you can import any combination of Google metrics and columns into any MySQL table.

Once you define the workflow, it will perform a full load and then on a daily basis it will keep appending new data to the same table. This happens without any intervention from your side.

Read more at http://www.infocaptor.com/dashboard/do-you-spend-too-much-time-building-reports-with-google-analytics-data

Google analytics datawerhouse

Fri, 2017-03-24 13:05

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 Analytics and Salesforce.

Read more at http://www.infocaptor.com/dashboard/social-datawarehouse-and-google-analytics-salesforce

Importance of visualizations and analytics for small business owners

Thu, 2017-03-23 11:30

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 longer limited to rich corporations. Forget the full Business Intelligence stack, with your data and an easy to use visualization tool can quickly help you deliver "Gold mine" of information.

There is no doubt that the right visualization tools can help small business owners in their way to success. It is just matter of putting your focus on "being more efficient and nimble".

Read more at http://www.infocaptor.com/dashboard/benefits-of-visualizations-and-analytics-for-small-business-owners

How to create a Sankey Diagram

Wed, 2017-03-22 11:45
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 chart replacement.

Build Sankey Diagram using InfoCaptor
In this tutorial, we shall learn about creation of Sankey diagrams using InfoCaptor. Using the tools you can visualize the flow from one node to another. It is a part of the visualization library, hence user does not to have to work on the complicated scripting. [NOTE: InfoCaptor is more than a sankey diagram creator, it contains other visualizations from d3.js charts]

Read more at http://www.infocaptor.com/dashboard/sankey-diagrams

Differences between charting engine, analytics software and dashboard software

Tue, 2017-03-21 13:25

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 for and have very good value propositions. We do have a general understanding for most of the top business intelligence tools so we are perfectly comfortable with such questions.

The tougher questions are when the users want to understand how different are we from different charting software like d3js, Highcharts etc.

To understand the difference let us understand the basics…

Read more at http://www.infocaptor.com/dashboard/charting-engines-vs-analytics-software-vs-dashboard-software

Find out the true benefit of Dashboards or Business Intelligence Software

Mon, 2017-03-20 12:45

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 themselves dashboard bi tools] but we are not interested in just fancy looks. So let us see several notable benefits and also certain features or aspects within InfoCaptor that help you achieve them.

Read more at http://www.infocaptor.com/dashboard/excel-dashboard-benefit

What is the true meaning and purpose of Business Intelligence?

Sun, 2017-03-19 13:15

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 improve profit and performance.

Many companies have embarked on the journey of data warehouses and yet failed to use them to achieve BI. If you think the purpose of data warehousing (DW) efforts is to simply keep producing more reports then the organization has failed to achieve true BI.

Read more at http://www.infocaptor.com/dashboard/business-intelligence

Google acquisitions samples with vizualizations

Mon, 2017-03-13 15:10

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 software, we analyze the list of companies, products and services that Google has acquired since 2001.

Read more at http://www.infocaptor.com/dashboard/list-of-google-acquisitions-explained-with-visualizations

Show me the money – Business Intelligence

Mon, 2015-11-02 06:33

This Business Intelligence article discusses one very important question “Have we lost the true meaning and purpose of Business Intelligence?”

In summary, it says that the bottom line for any Business Intelligence is to increase profit and performance and if done wrong it is absolute waste of time and money.

So if your management is hooked on the Big-Data wagon and fantasizing about the hidden gold behind the untapped data sources such as social media, click stream, web logs etc then it is time to keep the focus on the main purpose of “Business Intelligence”. All these systems help us to analyze big data or small data but whether they really impact our bottom line is the question that management needs to keep it as the top priority.

Every decision should flow and trickle down from this focus point “Show me the money!!”

Click here to read more about what business intelligence really means and what should be the core focus for management

How many startups did Google purchase and what did it do with them?

Mon, 2015-10-19 09:54

Ever wondered, how may startups or companies did Google acquire so far and how much did it pay for them?

But the main question is, what happened to the acquired companies? Was it all waste of money?

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

Using infocaptor kpi dashboard software, we analyze the list of companies, products and services that Google has acquired since 2001.

Google has acquired around 184 companies as of October 2015. Google has spent atleast 28 billion USD on acquisitions.

Read the complete list of top google acquisitions in an interactive dashboard

Presidents of USA and their Birth Signs – Sankey Visualization

Thu, 2015-10-08 14:00

In this analysis, we will visualize the relation between the Age at Presidency, State of Birth and birth sign.

Read more at: www.infocaptor.com/dashboard/presidents-of-usa-and-their-birth-signs-sankey-visualization

US Consumer Law Attorney Rates

Wed, 2015-09-16 22:27

The hourly rate in any consulting business or practice increases by the years of experience in the field.

Read more at: http://www.infocaptor.com/dashboard/us-consumer-law-attorney-rates

Bigfoot vs UFO analytics

Sat, 2015-09-12 21:29

Bigfoot and UFO remain elusive but know their ways to make news from time to time.

Read more at: http://www.infocaptor.com/dashboard/bigfoot-vs-ufo-analytics

What is the most dangerous food at Olive Garden?

Mon, 2015-08-31 22:24

Olive Garden is one of the favorite destination for Italian food and today we got hold of the entire Olive Garden menu along with their nutrition data.

A typical meal at Olive Garden starts with a drink, appetizers [free bread sticks], main dish and finally the desert.

So going in the same sequence let see what the data menu for Wine and Beer has to offer.

Amount of Carbs per serving in your favorite Wine at Olive Garden

Read more at: http://www.infocaptor.com/dashboard/what-is-the-most-dangerous-food-at-olive-garden

List of acquisitions by Microsoft a data journey

Thu, 2015-08-27 22:21

If we look into the SEC data for Microsoft and other tech companies, Microsoft spends the most in Research and Development from [by dollar]

Image

Read more at: http://www.infocaptor.com/dashboard/list-of-acquisitions-by-microsoft-a-data-journey

Popularity of Tea, Coffee, Beer and Wine Visualization

Thu, 2015-08-20 07:16

If number of searches were an indicator for gauging the popularity of a drink between Tea, Coffee, Beer and Wine then who wins the contest?

Which drink is gaining popularity and which is losing?

Read more at: http://www.infocaptor.com/dashboard/popularity-of-tea-coffee-beer-and-wine-visualization

Cloudera certifies InfoCaptor for Big Data analytics on Hadoop

Wed, 2015-08-12 14:12

Cloudera welcomes InfoCaptor as a certified partner for data analytics and visualization. InfoCaptor delivers self-service BI and analytics to data analysts and business users in enterprise organizations, enabling more users to mine and search for data that uncovers valuable business insights and maximizes value from an enterprise data hub

Rudrasoft, the software company that specializes in data analytics dashboard solutions, announced today that it has released an updated version of its popular InfoCaptor software, which includes integration with Cloudera Enterprise. The integration takes advantage of Impala and Apache Hive for analytics.

“Our clients are increasingly looking to adopt Hadoop for their data storage and analytics requirements and their common concern is the lack of an economical web-based platform that works with their traditional data warehouses, RDBMS and with Cloudera Enterprise,”

Cloudera-certified InfoCaptor, adds native Impala functionality within Visualizer so users can leverage Date/time functions for date hierarchy visualizations, time series plots and leverage all the advanced hierarchical visualization natively on Cloudera Enterprise.

“Impala is the fastest SQL engine on Hadoop and InfoCaptor can render millions of data points into beautiful visualizations in just a blink of an eye,” said Nilesh Jethwa [founder]. “This is a great promise for the big data world and affordable analytics with sub-second response time, finally CEOs and CIOs across industries can truly dream of cultivating a data driven culture and make it a reality.”

“Cloudera welcomes InfoCaptor as a certified partner for data analytics and visualization. InfoCaptor delivers self-service BI and analytics to data analysts and business users in enterprise organizations, enabling more users to mine and search for data that uncovers valuable business insights and maximizes value from an enterprise data hub,” said Tim Stevens, vice president of Business and Corporate Development at Cloudera.

InfoCaptor is an Enterprise Business Analytics and Dashboard software meant for:

  • Data Discovery
  • Visualizations
  • Adhoc Reports
  • Dashboards

InfoCaptor brings the power of d3js.org visualizations and the simplicity of Microsoft Excel and puts it in the hands of a non-technical user. This same user can build Circle Pack, Chord, Cluster and Treemap/Sunburst visualizations on top of Cloudera Enterprise using simple drag and drop operations.
InfoCaptor can connect with data from virtually any source in the world, including SQL database from Microsoft Excel, Microsoft Access, Oracle, SQL Server, MySQL, Sqlite, PostgreSQL, IBM DB2 and now Impala and Hive. It supports both JDBC and ODBC protocols.

InfoCaptor also serves as a powerful visualization software and it includes over 30 vector-based map Visualizations, close to 40 types of chart visualizations, over 100 flowchart icons and other HTML widgets. InfoCaptor also provides a free style dashboard editor that allows quick dashboard mockups and prototyping. With this ability users can place widgets directly anywhere on the page and use flowchart style icons and connectors for annotation and storytelling.

Users can download the application and install it within their firewall.
Alternatively, a cloud offering is also available at https://my.infocaptor.com or Download dashboard software

 

InfoCaptor is a very modestly priced Analytics and Visualization software
” Personal Dashboard License can be purchased for $149/year
” Server license starts at $599/year
” Cloud based subscription starts at $29/user/month

Visit http://www.infocaptor.com or email bigdata(at)infocaptor(dot)com for Demo and Price list

Pages