Sat.Mar 26, 2016 - Fri.Apr 01, 2016

article thumbnail

Analyzing Tabular Model in Excel 2016

Ms SQL Girl

It’s been a long time since I wrote an article on Tabular Model. This week, one of my good readers, Andrew posted me a question. In this article, I want to show you how to connect to your Tabular Model database and use it as the underlying model for either Pivot Table, Pivot Chart, or Power View. As a side note, I actually was struggling to find Power View button in Excel 2016 as it was missing from the ribbon.

article thumbnail

Using random effects models in prediction problems

The Unofficial Google Data Science Blog

by NICHOLAS A. JOHNSON, ALAN ZHAO, KAI YANG, SHENG WU, FRANK O. KUEHNEL, and ALI NASIRI AMINI In this post, we give a brief introduction to random effects models, and discuss some of their uses. Through simulation we illustrate issues with model fitting techniques that depend on matrix factorization. Far from hypothetical, we have encountered these issues in our experiences with "big data" prediction problems.

article thumbnail

Analyzing Tabular Model in Excel 2016

Ms SQL Girl

It’s been a long time since I wrote an article on Tabular Model. This week, one of my good readers, Andrew posted me a question. In this article, I want to show you how to connect to your Tabular Model database and use it as the underlying model for either Pivot Table, Pivot Chart, or Power View. As a side note, I actually was struggling to find Power View button in Excel 2016 as it was missing from the ribbon.