Model, Excel with Tabular AS & SharePoint

Model Related: Tabular or UDM, we need to extend join condition like equal join with extended condition let’s say Snapshot between StartDt & EndDt .We need left JOIN in MODEL Excel with Tabular & AS: I think MS is investing lot in PowerView, Power BI etc. I am from finance industry and in BI space since more than 14 years, these tools are very basic and no one wants to see basic reports like what these tools are capable for. My suggestion is your winning world so far is MS AS with Excel. Excel as browse with Pivot & Tabular form. Pivot form will not work every time you need to extend excel as creating reports from Tabular AS in Tabular format. SharePoint: Now SharePoint excel services with connecting to cubes are almost useless. If you give online brosing facility and cannot see pivot table fields to do some changes, what’s the point? Need to extend this functionality to complate cube & do slice/dice. Any next changes you do, make excel as online with all functions, Tableau is going in this directions.