Querying Analysis Services Data from 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 […]
Read More ›

Querying SQL Server Data from Matlab Using ADO

  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 […]
Read More ›

Solving Business Problems by Picking the Right Model

When you’re trying to figure out a better way of doing things, having a model can improve your ability to see what really matters in your business…and what the impact of your change will be. However, that will only work out well if you pick the right modeling tool. The first step in getting the […]
Read More ›

The Importance of Data Analytics

The current obsession with predictive analytics and big data has many organizations fixated on “bottom-up” analysis. Hype has resulted in business leaders thinking there are huge nuggets to be mined from their data lakes—if only they can find the right tools. Time and time again, I see this mindset result in disappointment and disillusionment with […]
Read More ›

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 ›

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.