PowerQuery: Retreive several web-pages

(page as number) as table =>
let
    Source = Web.Page(Web.Contents("http://boxofficemojo.com/yearly/chart/?page=" & Number.ToText(page) & "&view=releasedate&view2=domestic&yr=2013&p=.htm")),
    Data1 = Source{1}[Data],
    RemoveBottom = Table.RemoveLastN(Data1,3)
in
    RemoveBottom


Link: http://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/

Upload, Download DAX tables

Source: http://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/

Power BI Designer & Analytics

Power BI Made Simple from James Serra

Power BI: Get started, Installing, Support blog

Power Query Function example video

Power BI summary, recommendations

Power BI Designer review

Power BI Designer: 5 play list

How to AutoRefresh Excel data via O365. 

Picture: Picture summary, will Tabular replace MultiDim ?


Video:
1. Create Tabular Cube with SQL Server, Analysis Services, Tabular Model
2. Scaling from PowerPivot (XL) --> PowerPivot (SharePoint) --> SSAS, Tabular Model -->

BI and statistics: link to video

Video: Predictive Analytics