Subscribe to DSC Newsletter

Nilesh Jethwa's Blog (19)

Meaning and purpose of Business Intelligence - Did we lose the true purpose somewhere?

Image

  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…

Continue

Added by Nilesh Jethwa on December 2, 2015 at 11:00am — No Comments

A to Z list of Google acquisitions and where they ended up within Google

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…

Continue

Added by Nilesh Jethwa on October 12, 2015 at 5:50am — No Comments

Knowing your zodiac - birth sign, what are the odds of you becoming the next President of USA?

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

Sankey diagrams are extremely powerful at expressing flow and relationships.

In the following visualization we are packing multiple dimensions in one big picture

Image

We have packed 5 dimensions namely President…

Continue

Added by Nilesh Jethwa on September 22, 2015 at 5:00am — 4 Comments

Most popular Data Science keywords - Visualization

A Quick chart illustrating the top Data Science keywords. The data was grabbed from this article

Most popular Data Science keywords -…

Continue

Added by Nilesh Jethwa on July 24, 2015 at 12:00pm — No Comments

Bigfoot vs UFO - Analyzing and Visualizing Keywords Trends

Quick chart comparing Bigfoot vs UFO news/search activity.

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

Looking at the Google Trends data for both the entities we clearly see the spikes in their news activities.…

Continue

Added by Nilesh Jethwa on July 24, 2015 at 6:00am — No Comments

Average attorney rate jumps 85% after first year in practice

"Consumer Law is recognized as a specialty area of law1 dealing with

issues arising from transactions involving one or more persons acting as

individuals or as a family. It typically includes the legal fields of

bankruptcy, credit discrimination, consumer banking, warranty law, unfair

and deceptive acts and practices, and more narrow topics of consumer law

such as consumer protection…

Continue

Added by Nilesh Jethwa on July 22, 2015 at 8:30am — No Comments

What is the most dangerous dish at Olive Garden?

Our entire family loves going to Olive Garden and every time we go, we order the same items from the menu!

Having access to the Olive Garden nutrition data is like stumbling on a pot of data gold, you never know that sinfully tasty food might be the most nutritious dish, or is it?

Let us start with the appetizers

 

Ouch!…

Continue

Added by Nilesh Jethwa on July 16, 2015 at 4:12pm — No Comments

List of acquisitions by Microsoft

Microsoft's first acquisition was in 1987 and it has purchased an average of six companies a year.

Microsoft has made eight acquisitions worth over one billion dollars: Skype (2011), aQuantive (2007), Fast Search & Transfer (2008), Navision (2002), Visio Corporation (2000), Yammer (2012), Nokia (2013) and Mojang (2014).

Check out …

Continue

Added by Nilesh Jethwa on July 15, 2015 at 6:38am — 1 Comment

Which drink is more popular Tea, Coffee, Beer, Wine?

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?

Let us analyze who wins the popularity contest by comparing the number of searches for each of the terms.

Data collection method: Each of the keywords Tea, Coffee, Beer and Wine were used with Google Trends to extract the weekly data and then plotted as below. Year 2015 is excluded due to partial…

Continue

Added by Nilesh Jethwa on July 6, 2015 at 6:35am — 4 Comments

NFL Play by Play analysis using Cloudera Impala

We had the chance to use the NFL play by play dataset all the way from 2002 through 2013 and the best part is the analysis was carried within Hadoop using Cloudera Impala.

For the analysis we wanted to be at the individual game level but the data contained mixed grain including the play by play data. So what we ended up doing was apply some SQL filters to restrict it to the first row of each play by play dataset.

Here are some interesting…

Continue

Added by Nilesh Jethwa on June 1, 2015 at 5:49am — 2 Comments

VC investment analytics with data visualization

In this article we perform analytics on a huge dataset available from https://www.pwcmoneytree.com. PWC Money tree provides 20 years of  Venture capital investment data from 1995 onward. Having data that goes far into the history should give us enough to extract the necessary analytical juice out of it.

VC Investment in Billions from 1995 through 2014

The year 2000 was…

Continue

Added by Nilesh Jethwa on January 14, 2015 at 9:46am — No Comments

Data Visualization of Employee metrics at the top Tech companies

The top tech companies by market capitalization are IBM, HP , Oracle , Microsoft , Cisco , SAP , EMC , Apple , Amazon and Google

All of the top tech companies are selected based on their current market capitalization with the exception of Yahoo. The year 2014 is not included as part of this analysis.

 

Data: The source of this data is from the public financial records from SEC.gov

 

All the sales figures are normalized and reported in USD…

Continue

Added by Nilesh Jethwa on December 15, 2014 at 11:01am — 8 Comments

What is the future of Data visualization and Dashboard solutions?



This article is not about any futuristic "Iron Man style dashboard/data visualization product" where you are combing through holographic cubic chunks from your ultra fast Big Data pipeline.

From time to time I keep pondering on what could be the future and I am sure lot of us get this science fiction imagery where…

Continue

Added by Nilesh Jethwa on December 8, 2014 at 7:30am — 1 Comment

Trends in Big Data Vs Hadoop Vs Business Intelligence

How has the interest in Big Data, Hadoop, Business Intelligence, Analytics and dashboards changed over the years?

One easy way to gauge the interest is to measure how much news is generated for the related term and Google Trends allows you do that very easily.

After plugging all of the above terms in Google…

Continue

Added by Nilesh Jethwa on December 2, 2014 at 10:37am — No Comments

Don’t Expect A Large Salary Increase If You Didn’t Go To College

As per US Census data, following chart illustrates that if you have less than "college degree" then the jumps in your salary is very less as you progress in your age

Small increase in salary for less than college degree

Notice the big…

Continue

Added by Nilesh Jethwa on November 20, 2014 at 8:30am — 2 Comments

Y Combinator companies has more funding than the sum total of all remaining accelerators

In this data analysis a very interesting and powerful fact emerges. The data is taken from seed-db.com and analyzed to create visualizations.…

Continue

Added by Nilesh Jethwa on October 20, 2014 at 10:00am — No Comments

Ebola Death Cases - Admitted , Recovered Cases

Having found a dataset on Ebola cases, thought of checking it out quickly what the statistics really look like.

The dataset contains 3 countries and within each there are multiple regions.

So just using the high level information at the country level this is what we can see in a simple line chart.

In the below Chart,

The blue line > Total Death cases

The green line > Total Cases

The Orange line > Currently admitted

And the Red…

Continue

Added by Nilesh Jethwa on October 6, 2014 at 6:57am — No Comments

Viz - Does your water contain fluoride?

Here is the USA map visual by state showing what percentage of people received flouride in their water.

https://my.infocaptor.com/dash/mt.php?pa=fluoridation_statistics_52cac4f7e248c

Here is the data source …

Continue

Added by Nilesh Jethwa on January 7, 2014 at 11:00am — No Comments

What will America pay for H1-B Jobs?

NOTE: H1b is a Visa program where people from outside countries are allowed to work with USA companies. The visa is valid for a 3 year period and is extensible for another 3 years. 

United States Department of Labor publishes quarterly data of H1-B and other visa applications. Below is an analysis and visualization of the same data.

What is in the Data…

Continue

Added by Nilesh Jethwa on September 5, 2013 at 12:20pm — 1 Comment

Blog Topics by Tags

Monthly Archives

2015

2014

2013

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service