Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Big Data

Five Apps: Advanced tools for analyzing big data

By walterbahny November 12, 2013, 10:25 AM PST

Image
1
of 21

big-data-explosion.jpg
big-data-explosion.jpg
Five Apps: Advanced tools for analyzing big data

Five Apps to turn your data into big data

Five Apps to turn your data into big data

Thisrngallery is also available as a TechRepublic article.

Over the last few years, big data has become a big deal. Betweenrnsites like Data.gov, the massive amounts ofrndata each person generates both privately and on social media, and everyrnorganization’s rapidly increasing databases, big data is one of the mostrnimportant things IT professionals need to understand and deal with. Reports andrnDashboards are just the beginning with big data – requirements now includernpredictive analyses and other more advanced tools.

rnrnFor this edition of FivernApps, we take a look at five tools to help you analyze your big data.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

a1_datameer.JPG
a1_datameer.JPG
Five Apps: Advanced tools for analyzing big data

Datameer 1

Datameer 1

Five Apps

rnrn

1. Datameer

rnrn

Datameer is, on itsrnsurface, a basic analysis tool. It has a spreadsheet-like interface andrncontains many of the same charts and graphs. However, it surpasses Excel andrnother spreadsheet programs by allowing the user link to active data sources asrnwell as import flat files as well as joining two tabs together into a third, muchrnlike you join tables in a database.

rnrn

It also is much more column-focused than a spreadsheet – therntasks you perform, such as Group Bys, are all done with reference to a columnrnand occupy a column of their own on the destination sheet. Since it is so columnar,rnyou can also drag-and-drop columns into charts and graphs easily instead ofrnhaving to specify ranges like in Excel. Charts and graphs come with manyrnconfiguration options including manual colors, font sizes, layout, andrnpositioning.

rnrn

The final feature of Datameer is Smart Analytics whichrnincludes Clustering, Decision Trees, Recommendations (Heat Charts), and ColumnrnDependencies tools. Datameer starts at $299/year for a single user and hasrnWorkgroup and Enterprise licensing available.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

a2_datameer.JPG
a2_datameer.JPG
Five Apps: Advanced tools for analyzing big data

Datameer 2

Datameer 2

Credit: Image by WallyrnBahny for TechRepublic

a3_datameer.JPG
a3_datameer.JPG
Five Apps: Advanced tools for analyzing big data

Datameer 3

Wally

Datameer 3

Credit: Image by WallyrnBahny for TechRepublic

Wally
a4_datameer.JPG
a4_datameer.JPG
Five Apps: Advanced tools for analyzing big data

Datameer 4

Datameer 4

Credit: Image by WallyrnBahny for TechRepublic

a5_datameer.JPG
a5_datameer.JPG
Five Apps: Advanced tools for analyzing big data

Datameer 5

Datameer 5

Credit: Image by WallyrnBahny for TechRepublic

b1_jaspersoft.JPG
b1_jaspersoft.JPG
Five Apps: Advanced tools for analyzing big data

Jaspersoft 1

Jaspersoft 1

2. Jaspersoft

rnrn

Jaspersoft is arndrag-and-drop GUI that allows you to combine your data in various ways usingrnthe built-in charts, graphs, and crosstab views. You can see various types ofrndata side-by-side by dropping those as Columns and break it down by variousrncategories as Rows. One of the nicest features of Jaspersoft is the Data Levelrnfilter at the top right. It allows you to scale back your Rows or Columns to arnlower level of detail (such as viewing sales by Country instead of by Countryrnand then by Store Type) without having to remove those data points from therngraph altogether. Jaspersoft offers several different editions of theirrnsoftware from the free Community Edition to various on-site versions licensedrnby server processor to an AWS-based version licensed per-hour. Pricing info isrnavailable from the sales team.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

b2_jaspersoft.JPG
b2_jaspersoft.JPG
Five Apps: Advanced tools for analyzing big data

Jaspersoft 2

Jaspersoft 2

Credit: Image by WallyrnBahny for TechRepublic

b3_jaspersoft.JPG
b3_jaspersoft.JPG
Five Apps: Advanced tools for analyzing big data

Jaspersoft 3

Wally

Jaspersoft 3

Credit: Image by WallyrnBahny for TechRepublic

Wally
b4_jaspersoft.JPG
b4_jaspersoft.JPG
Five Apps: Advanced tools for analyzing big data

Jaspersoft 4

Jaspersoft 4

Credit: Image by WallyrnBahny for TechRepublic

b5_jaspersoft.JPG
b5_jaspersoft.JPG
Five Apps: Advanced tools for analyzing big data

Jaspersoft 5

Jaspersoft 5

Credit: Image by WallyrnBahny for TechRepublic

c1_penthallo.JPG
c1_penthallo.JPG
Five Apps: Advanced tools for analyzing big data

Pentaho 1

Pentaho 1

3. Pentaho

rnrnInstead of being a dynamicrnreporting tool, Pentaho allows you torncreate fixed structure reports and dashboards which are then tied to a dynamicrndata source. This is great for companies whose users do not have the skill orrnare unwilling to take the time to create their own visualizations. Pentaho hasrnthe typical charts and graphs, such as pie, bar, line, etc., as well asrncrosstab views. It also has heat grid reports to compare performance amongrnvarious measures. Like the other systems on this list, Pentaho can link up withrnvarious source databases. Pricing is available from the sales team.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

c2_penthallo.JPG
c2_penthallo.JPG
Five Apps: Advanced tools for analyzing big data

Pentaho 2

Pentaho 2

Credit: Image by WallyrnBahny for TechRepublic

c3_penthallo.JPG
c3_penthallo.JPG
Five Apps: Advanced tools for analyzing big data

Pentaho 3

Pentaho 3

Credit: Image by WallyrnBahny for TechRepublic

c4_penthallo.JPG
c4_penthallo.JPG
Five Apps: Advanced tools for analyzing big data

Pentaho 4

Wally

Pentaho 4

Going Deep on Big Data

rnrn

Big data isrntransitioning from one of the most hyped and anticipated tech trends of recentrnyears into one of the biggest challenges that IT is now trying to wrestle andrnharness. Wernexamine the technologies and best practices for taking advantage of big datarnand provide a look at organizations that are putting it to good use.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

Wally
d1_SAS_Vis.JPG
d1_SAS_Vis.JPG
Five Apps: Advanced tools for analyzing big data

SAS Visual Analytics 1

Wally

SAS Visual Analytics 1

4. SAS Visual Analytics

rnrn

Easily recognized as the biggest name on this list, SAS hasrnentered the big data fray with their Visual Analyticsrnsoftware. However, it is, for the most part, roughly equal to the otherrnproducts here. Data is brought into the system either by flat file or databasernlinks, and various charts, graphs, and visualizations are easily created.

rnrn

It stands out, however, in the way that it displays thatrninformation. Where the other products were somewhat vague as to what the datarnvalues were, SAS Visual Analytics always seems to provide a legend, especiallyrnin geographical visualizations, heat maps, and the like. One visualization Irndid not see present in their set was the pie chart, however they seem to havernreplaced it with a treemap, which can have the same effect, although may bernharder for some to understand.

rnrn

The other standout feature, to me was the quick glancernfeature when selecting data filters. You can easily see the relative size ofrnthe data in each data point so you know somewhat what you’re getting into. SASrnVisual Analytics pricing is available from the sales team.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

Wally
d2_SAS_Vis.JPG
d2_SAS_Vis.JPG
Five Apps: Advanced tools for analyzing big data

SAS Visual Analytics 2

SAS Visual Analytics 2

Credit: Image by WallyrnBahny for TechRepublic

d3_SAS_Vis.JPG
d3_SAS_Vis.JPG
Five Apps: Advanced tools for analyzing big data

SAS Visual Analytics 3

SAS Visual Analytics 3

Credit: Image by WallyrnBahny for TechRepublic

e1_splunk.JPG
e1_splunk.JPG
Five Apps: Advanced tools for analyzing big data

Splunk 1

Splunk 1

5. Splunk

rnrn

While it connects to traditional data sources like the otherrnsystems on the list, Splunk is the onlyrnproduct that can connect to system event logs, system performance monitors,rndirectory trees, TCP/UDP connections, and Active Directory systems. Given thatrnvast array of non-traditional data sources, Splunk is a great solution forrnmonitoring big data that, on the surface, doesn’t seem like big data. However,rnevent log monitoring alone can generate as much raw data as enterprise EHR andrnCRM systems.

rnrn

While it provides the common charts and graphs, Splunk alsornhas its own query language that makes it difficult to jump right in to. Anythingrnbeyond basic charts requires knowledge of the query language. Pricing isrnsimple: you pay by the gigabyte indexed per day by the system whether that isrnon-site or cloud-based.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

e2_splunk.JPG
e2_splunk.JPG
Five Apps: Advanced tools for analyzing big data

Splunk 2

Splunk 2

Credit: Image by WallyrnBahny for TechRepublic

e3_splunk.JPG
e3_splunk.JPG
Five Apps: Advanced tools for analyzing big data

Splunk 3

Wally

Splunk 3

Bottom line

rnrn

There are many more products available for analyzing yourrnown big data; these are just a handful offering necessary features. Has yourrnorganization delved into analyzing their big data? If so, have you used any ofrnthe tools above or different tools? Share your thoughts in the comments below.

rnrn

Going Deep on Big Data

rnrn

Big data isrntransitioning from one of the most hyped and anticipated tech trends of recentrnyears into one of the biggest challenges that IT is now trying to wrestle andrnharness. Wernexamine the technologies and best practices for taking advantage of big datarnand provide a look at organizations that are putting it to good use.

rnrn

Credit: Image by WallyrnBahny for TechRepublic

Wally
  • Big Data
  • Account Information

    Share with Your Friends

    Five Apps: Advanced tools for analyzing big data

    Your email has been sent

Share: Five Apps: Advanced tools for analyzing big data
Image of walterbahny
By walterbahny
  • Account Information

    Contact walterbahny

    Your message has been sent

  • |
  • See all of walterbahny's content

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic Premium

  • TechRepublic Premium

    AlmaLinux Checklist: 9 Things to Do after Installation

    This checklist from TechRepublic Premium consists of nine things you should do immediately after installing AlmaLinux. This list of items can be applied to all use-cases for your new server operating system. Although there will be plenty more to do (such as install the services and specific software you need), you can count on this ...

    Published:  December 4, 2023, 4:00 PM EST Modified:  December 5, 2023, 9:00 AM EST Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    What is Generative AI?

    Generative artificial intelligence refers to deep learning models that can generate content such as images, code, text and other forms of media. These algorithms are trained to identify patterns using large datasets, enabling them to produce similar output. TechRepublic Premium presents this explanation of generative AI, including its evolution, features, examples, drawbacks and benefits. From ...

    Downloads
    Published:  December 4, 2023, 4:00 PM EST Modified:  December 5, 2023, 7:59 AM EST Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Hiring Kit: Technical Writer

    Businesses of all sizes are spending a good bit of time and energy digitizing their operations. While a business’s digital transformation may make systems more efficient and workers more productive, digital enterprises still require extensive documentation and the technical writers who create it. This hiring kit from TechRepublic Premium provides an adjustable framework your business ...

    Published:  December 4, 2023, 4:00 PM EST Modified:  December 5, 2023, 9:00 AM EST Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    New Employee Checklist and Default Access Policy

    Onboarding new employees and providing them with the equipment and access they need can be a complex process involving various departments. This New Employee Checklist and Default Access Policy from TechRepublic Premium enables the IT and HR departments to effectively partner and ensure new hires receive a standard set of equipment and features. From the ...

    Published:  December 3, 2023, 4:00 PM EST Modified:  December 4, 2023, 9:00 AM EST Read More See more TechRepublic Premium articles

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • Editorial Policy
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add newsletters@nl.technologyadvice.com to your contacts list.

Back to Home Page