Материалы по Power BI , Power Query, Power Pivot

Подборка ссылок про Power Query

Power Query: стероиды для MS Excel
https://habrahabr.ru/post/271019/


Microsoft Power Query for Excel: Discover and Refine Your Data
TechEd North America
https://www.youtube.com/watch?v=tObdiGDDNds

Introduction to Power Query
https://www.youtube.com/watch?v=LACjRvxl_2w

Power Query - Overview and Learning
https://support.office.com/en-gb/article/Power-Query-Overview-and-Learning-ed614c81-4b00-4291-bd3a-55d80767f81d?ui=en-US&rs=en-GB&ad=GB


Excel PowerPivot Tutorial Dashboards with Power Query, Power View and Power Map BI
https://www.youtube.com/watch?v=zaCPprDxB0w

Инструкции и статьи
http://www.myonlinetraininghub.com/category/power-query


How Power Query and Power Pivot work together
https://support.office.com/en-us/article/How-Power-Query-and-Power-Pivot-work-together-a5f52cba-2150-4fc0-bb8f-b21d69990bc0


Start the Power Pivot in Microsoft Excel add-in
https://support.office.com/en-gb/article/Start-the-Power-Pivot-in-Microsoft-Excel-add-in-a891a66d-36e3-43fc-81e8-fc4798f39ea8?ui=en-US&rs=en-GB&ad=GB

Power Query 101
https://support.office.com/en-gb/article/Power-Query-101-008b3f46-5b14-4f8b-9a07-d3da689091b5

Excel 2016 и Power Query
http://www.planetaexcel.ru/forum/index.php?PAGE_NAME=read&FID=5&TID=73189&TITLE_SEO=73189-excel-2016-i-power-query


--


Power Query If Example

The IF Function In Power Query
http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/

Power Query if Statements
http://www.myonlinetraininghub.com/power-query-if-statements

IF function in Power Query
https://social.technet.microsoft.com/Forums/en-US/c94378ec-98ac-42c6-8a92-5f247b9e3b25/if-function-in-power-query?forum=powerquery


--------


Power BI Guided learning - Направляемое обучение
https://powerbi.microsoft.com/ru-ru/guided-learning/powerbi-learning-0-3-dashboards-cloud-services/