Archive | BI Tools RSS for this section

Getting People to Click » Data Revelations

Great insights in regards to change management.  It is difficult to get people to understand that Tableau is not set to replace other tools as much as it is to compliment.  The immediate expectation, when discussing creating items in Tableau, is to make it a static dashboard or report and just recreate old reports so that they are now accessible in Tableau.  The discussion needs to be made about what makes sense to develop in Tableau and what may be best developed in a report writer or kept as is.  Getting people to realize that Tableau is not a report writer is essential when implementing and seeking user adoption, otherwise users won’t see the value in the analytical functions.

Getting People to Click » Data Revelations.

Decision time: Automated data integration tools versus manual coding

Like how the interview addresses the fact that you can, and probably should, have both ETL/Warehousing and other Data Integration tools.  Use the solution that is best suited for the specific data and the business need.

 

 

Decision time: Automated data integration tools versus manual coding.

Magic Quadrant for Business Intelligence and Analytics Platforms

Wow, I found the statement below, from Magic Quadrant for Business Intelligence and Analytics Platforms, very interesting.  I have found that having the best of both worlds; ease of use/availability for business users and the ability to maintain enterprise wide governance has been an issue.  It will be interesting to see what products emerge that can provide for both.

 

 

The most notable change in this year’s Magic Quadrant is that all the vendors in the

Leaders quadrant have been moved to the left in terms of Completeness of Vision. This

reflects the fact that no one vendor is fully addressing the critical space in the

market for “governed data discovery” — in other words, platforms that address both

business users’ requirements for ease of use and enterprises’ IT-driven requirements.

via Magic Quadrant for Business Intelligence and Analytics Platforms.

Leverage Data Visualization Tools, But Avoid Anarchy – Kimball Group

Interesting article that helps explain the increasing issue with mass reliance on using Data Visualization tools to blend data and define business rules.  These tools are great, but not a replacement for proper data management.  Data Viz tools empower the end user, one user at a time.  Data management should not be defined at the desktop, by individuals, and within mutliple tools.  The possiblility for data inconsistencies are increased and there is no longer a clear-cut definition of what the data is that is being reported, it now becomes dependent on  the definition created by an individual at that specific moment in time for that specific tool.

 

Design Tip #162 Leverage Data Visualization Tools, But Avoid Anarchy – Kimball Group.

Wanted: BI Data Analyst/Data Mining Specialist

Looking for a BI opportunity?  Want to work in beautiful northern Michigan?  Do you have the desire to be part of a Great Place to Work?  Check out this opportunity to work for Hagerty Insurance.

Hagerty Insurance, headquartered in Traverse City, MI, has an opening for a BI Data Analyst/Data Mining Specialist.  To find out more about this position and check out more about Hagerty’s great career opportunites visit here!

Follow @Hagerty on Twitter to experience what we are all about!  Trust me, it is an AWESOME place to work.

Does your business excel or just use Excel…?

All pitfalls mentioned here are pains when working with Excel, but sharing data is one of the biggest pitfalls when using Excel. Determining what version of the truth is accurate can become very frusterating and also very dangerous.

From the Construction Industry Benchmarking Survey we launched last year, where we have asked business’s about how they are using systems and technology in their core business processes, we have found that ALL businesses, no matter their size or discipline who participated in the survey, appear to be extensively using excel within many of their key processes.  From developing reports to undertaking forecasting and business planning to the development of tender estimates, it appears Excel has got a tight grip on the Industry.  Does this mean that businesses are excelling at what they are doing…. or are they just using Excel?  This post will look at why Excel has such a tight grip, what the pitfalls are of being overly reliant on it and then to look at how you might be able to move away from a Excel driven business to make your business more robust, transparent , controllable, effective…

View original post 1,519 more words

Free Infographic Tools

Now if I could just find some time to play around with FREE tools…

The word “Infographic” may not yet be in the Merriam-Webster dictionary, but it’s a word that every good marketer and lots of other savvy business people know well. Converting data into pictures that communicate the primary message at a glance has become valuable content for companies to create. Recently, I shared a link to Hubspot author, Ginny Sosky,’s post, “How Does Your Content Stack Up”. According to the study recently released by Content Marketing Institute, Marketing Profs, and Brightcove, infographic use increased 51% from 2012 to 2013.

The pressure on B2B marketers to produce useful content continues to increase. Naturally, we welcome any tools that help us meet the nearly insatiable need. AWeber shared a list of free Infographic Tools, which I am listing here:

And from Guy Kawalski’s site Alltop post, “6 Tools to Help You Create Fab Infographics”…

View original post 48 more words

New tool lets you visualize just about anything in 5 minutes (maybe less)

Need to play around with this tool some more, but from what I can tell, it looks to be very interesting. A nice, quick way to be able to vizualize the data you already have on hand

Gigaom

There’s a new web tool called Raw that makes it really easy to do some advanced visualizations on data in just a few minutes. (Hat tip to Nathan Yau of FlowingData for pointing it out.) The way it works is pretty simple: You paste data from a table (this can be a spreadsheet or even a web page), choose from a handful of visualization types (Raw explains what each one is best for) and then drag the variables you want to analyze into the predefined mapping categories (as you can see below, it’s really self-explanatory). Then you download it as a vector, PNG or JSON file and do with it what you will.

raw screen

The only drawbacks I found are that the charts can get a little crowded, data points cross the outer border and get cut off, and if there’s a way to label the axes, I can’t figure…

View original post 302 more words

BI Corner

At the intersection of Business Intelligence & Analytics

Data and Analytics with Dustin Ryan

Dustin Ryan is a Data Platform Solutions Architect with Microsoft interested in Azure, SQL Server, and Power BI.

Data Visualization

Discover, Analyze, Explore, Pivot, Drilldown, Visualize your data... “How do I know what I think until I see what I say?” [E.M. Forster, G. Wallas, A. Gide]

Data Science 101

Learning about Data Science

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

InterWorks

All Data and BI

VizCandy

All Data and BI

citizenintelligence

The business blog

Dave Alper: Business Intelligence and Data Visualization

Lessons Learn from 20+ Years in the Trenches

Live, Nerd, Repeat

Making life better through the perfect application of humor and nerdery

digiphile

We're already living in the future. It's just not evenly distrbuted yet.

The Daily Post

The Art and Craft of Blogging

SNF All Access

Behind the scenes access into the world of Sunday Night Football

Insight Extractor - Blog

Paras Doshi's Blog on Analytics, Data Science & Business Intelligence.

PCIT Plus

A KMG Property & Casualty Insurance Initiative

TED Blog

The TED Blog shares news about TED Talks and TED Conferences.