Doing Your Job Well: What Kind of Factory are You?

There are four kinds of service processes in the world. Understanding which one you are gives you an opportunity to maximize your value to your organization while simplifying your life. As a bonus, it will also let you avoid making the same mistakes my employers made. This is obvious: For businesses to succeed, they have to become […]
Read More ›

Excel: Interpreting the Principal Components Analysis (PCA)

  What Does Principal Component Analysis Tell Us? In the first installment, we indicated that the primary reason to do a principal component analysis (PCA) in Excel was to increase our own understanding. If your goal is the PCA itself, a better choice of tool might be R, Matlab, or similar tool. Now that we […]
Read More ›

SQL Server 2016: R Integration Redux

SQL Server 2016 has now reached Release Candidate 3 (RC3). One of the new features that continues to foster interest in the analytics and data mining community is the integration of SQL Server with the open-source statistics toolset R. If you fall into this category, I’m inclined to suggest you remain patient and wait for […]
Read More ›

SQL Server 2016: Choosing Your R-Chitecture

Enthusiastic data miners are excited about the new possibilities which have opened up with Microsoft R. Not everyone, however, has realized that the so-called “in-database” R is not the best choice for every application of R to SQL Server data. One database administrator expressed concern about R competing with SQL Server for precious RAM. A […]
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 ›

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.