The Importance of Data Analytics

The current obsession with predictive analytics and big data has many organizations fixated on “bottom-up” analysis. Hype has resulted in business leaders thinking there are huge nuggets to be mined from their data lakes—if only they can find the right tools. Time and time again, I see this mindset result in disappointment and disillusionment with […]
Read More ›

Excel: Principal Component Analysis (PCA)

Learning PCA with Excel A student in Learning Tree’s Course 195, Power Excel: Analyzing Data to Make Business Decisions, asked “can you do Principal Component Analysis using Excel?” The answer that popped into my head was, “sure, but why would you want to?” If all you want are the results, you’re much better off using […]
Read More ›

Editing DAX Queries with DAX Studio

Among the new features sported by Excel 2016 is the highlighting of DAX keywords in the Power Pivot formula bar. (Just as an aside, this example definition makes use of the new DAX variables.) Any help writing DAX is greatly appreciated, but while the colorization is a nice feature, it would be nicer still to […]
Read More ›

Charts are Bad — Less UI, More UX

In my work as a decision science oriented software developer, I often explain to my clients that what they really want is a big green button that, when pressed, gives them the answer to the question they are currently wrestling with—a Magic 8-Ball that dispenses specific, data-driven advice. The challenge is, how close I can […]
Read More ›

SQL Server 2016 – Analytic Revolution with R

Part 3 – Implementing a Data Science Workstation SQL Server Architecture for R and Data Science We have previously seen how to integrate R with SQL Server. While executing R scripts in stored procedures is tremendously valuable, the methods lacks the interactivity required by most analysts. To appreciate how SQL Server’s R services can provide […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.