Category: Microsoft Office

Christine, a student in Learning Tree’s course SQL Server Analysis Services for Business Intelligence, writes “I just created my first Analysis Services tabular model database, and I am having lots of fun. But now I want to do some more sophisticated statistical analysis using R. I can’t seem to find a way to use DAX […]

Part One: Accessing a Web Service Using C# In the previous installment we saw how to create a COM server for use by Microsoft Excel. We will now look at how we can use this technology to create what Excel calls a “Real-time Data”, or RTD server. An RTD server is called at regularly scheduled […]

Creating Compiled Code Libraries for Excel Using C# Excel analysts and developers who create useful functions often wish to share their work with coworkers and others. For many applications, creating an Excel macro workbook (xlam file) is sufficient. But for some code, the need for more power requires the development of libraries of compiled code. […]

When Power Query was first introduced early in 2013 it was known as the Data Explorer. In some ways, Data Explorer was a better name. The primary job of Power Query is to enable Excel users to examine data, decide what values need to be imported into Excel, and then complete the import process. If […]

Many blogs, including some originating from our friends in the rainy Pacific Northwest, have referred to the “new” data models in Excel 2013. I’m not sure “new” is quite the right word. “Useful”, absolutely. “Interesting”, most definitely. But what we are really seeing here is not so much new as it is another step in […]