Querying Analysis Services Data from Matlab
dec 14,
2016
Virtually all major statistical and analytical software packages have provision for obtaining data from a relational data source using SQL queries. Unfortunately, many of the tools that work with SQL do not help when the data source is an Analysis Services database and the query language is MDX or DAX. As mentioned in the previous […]
Querying SQL Server Data from Matlab Using ADO
nov 11,
2016
Matlab has a database toolbox, but there are several reasons why you might decide to take matters into your own hands and query SQL Server data using the ADO library. One simple reason might be that you have not yet purchased the database toolbox but you want to get started now. Another reason is […]
Using Matlab Functions in Microsoft Excel
sep 8,
2016
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 […]
How to Link Excel to MATLAB to Solve Complex Equations
apr 28,
2015
Solving Linear System and Linear Optimization Equations Using Microsoft Excel and MATLAB In the previous instalment on linear systems we saw that Excel can easily invert a modest-sized matrix and find solutions to a set of simultaneous linear equations. In the real world, a place I allude to frequently and try to avoid as much as […]