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 […]
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 […]
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 […]
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 […]
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 […]