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 ›

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 ›

Excel: Some Range Selection Quickies

Selecting a range of cells in an Excel worksheet, is such a common thing to do that many take it for granted. However, there are a few shortcuts that are worth reviewing, and a very useful formula technique called dynamic named ranges, that in my opinion, is underutilized by many Excel analysts. A Review of […]
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 ›

Excel RTD Servers: Using Topics

In the previous installment, we saw how to flesh out the IRtdServerinterface to create a functioning RTD server. We simplified this task by considering only one possible topic. We will now examine the topic of topics, so to speak, by creating an RTD server to provide recent trade prices for stocks. There will be several […]
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.