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 ›

The Six Challenges of Business Intelligence

  Business Intelligence (BI) is: “The processes, technologies, and tools needed to turn data into information, information into knowledge, and knowledge into plans that drive profitable business action. Business intelligence encompasses data warehousing, business analytic tools, and content/knowledge management.“ —The Data Warehouse Institute Faculty Newsletter, Fall 2002 BI should deliver: Accurate answers to questions about […]
Read More ›

Excel 2016: DAX Variables

  DAX Variables Well, DAX variables weren’t actually introduced with Excel 2016; they weren’t even introduced in 2016. Come to think of it, DAX variables aren’t even variables. Nevertheless, DAX variables are one of the most interesting and exciting recent additions to DAX. DAX variables were introduced to the Power Pivot engine in 2015, so […]
Read More ›

How Business Service Management Can Help Silo-ed Management of Technology?

Businesses, customers, and IT organization are impacted if IT is managed and operated in silos. If businesses are not realizing their true potential, because IT is unable to deliver on its commitments, then business will likely face losses, ultimately impacting IT in a negative fashion. This does not suggest that all business enterprises irrespective of […]
Read More ›

SQL Server 2016 – Analytic Revolution with R: Part 1

Architecture and Installation The folks at Microsoft have created quite a buzz with the integration of R scripting into SQL Server. In recent years, the open-source statistical program R has established itself as the de-facto statistics and analysis package for big data. But it has always been possible to query SQL Server from R 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.