Etikett: Matlab

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

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

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

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