How Does Power BI Fit Into My Business Intelligence Plans?

Things change pretty fast in the business intelligence arena. Terms can change pretty fast, too. A little more than a year ago, many people used the phrase “Power BI” to refer to Excel Add-Ins of particular interest in BI, notably Power Pivot and Power Query. Now, the same phrase refers to a distinct and separate […]
Read More ›

Using Matlab Functions in Microsoft Excel

If it wasn’t already clear, the world of big data and analytics has brought home the point that applications can no longer function alone. Many applications must live, work, and play together seamlessly in what some folks call an “ecosystem”. Today we will see that it is very easy to use the advanced capabilities of […]
Read More ›

Creating Rollover Interaction in Excel Dashboards

Excel Dashboards can be great for conveying critical summary data regarding the state of investments, an important project, or even an entire business enterprise. Dashboards also pose many challenging problems for developers; one of the more important ones being, how to convey information using a limited amount of monitor real estate. One solution is to […]
Read More ›

Creating Excel Pivot Tables from Power BI Report Data

One thing that Microsoft has always done well is get its wide variety of services and applications to work together seamlessly (well, relatively seamlessly at any rate). We have previously looked at Power BI and noted that Power BI exploits the same in-database Analysis Services engine that powers the Excel Power Pivot data model. Many […]
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 ›

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.