johnmackintosh · January 31, 2021 20:22
diff --git a/PBI.txt b/PBI.txt
 ----

 Power BI Official Software - Cost: $0 Dimes

 ----

 Power BI Desktop. From the Microsoft Store updates automatically. #WINNING
 URL: https://aka.ms/pbidesktopstore

 Power BI Desktop. From download center requires manual updating. #NOTWINNING
 URL: https://www.microsoft.com/en-us/download/details.aspx?id=58494

 Power BI Report Builder. Paginated Reports (like SSRS).
 URL: https://www.microsoft.com/en-us/download/details.aspx?id=58158

 Power BI. For displaying on digital displays. (think TVs)
 URL: https://www.microsoft.com/en-us/p/power-bi/9nblgggzlxn1?activetab=pivot:overviewtab


 ----

 Self-Paced General Content - Cost: $0 Dimes

 ----

 Earn points. Get badges. From beginner to expert.
 URL: https://aka.ms/pbilearn

 Every "In a (Day), (Hour)" session that you could possibly find to deliver yourself.
 URL: https://aka.ms/pbitraining

 Paginated Reports in a Day, great instructors. Chris made me say this.
 URL: https://aka.ms/priad-online-course

 Pro Level: Power BI Developer in a Day. Hands on keyboard for PBI Embedding.
 URL: https://aka.ms/deviad-online-course

 Pro Level: Power BI Dev Camp. This is the real deal.
 URL: https: https://powerbidevcamp.net

 Guy in a Cube - easy and fun way to stay up to date and learn.
 URL: http://youtube.com/c/guyinacube

 Radacad writes a lot and knows a lot. Enjoy.
 URL: https://radacad.com/online-book-power-bi-from-rookie-to-rockstar


 ----

 DAX Specific - Cost: $0 Dimes

 ----

 Follow this complete path. Yes, it's a long journey.
 URL: https://sqlbi.com/guides/dax/


 The ultimate go-to for documentation.
 URL: https:/www.dax.guide

 Wrap your head around context and DAX will reveal its true form.
 URL: https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

 Free YouTube series dedicated to the elements of DAX. WOW.
 https://www.youtube.com/watch?v=4j6EyelxJ3k&list=PLmRUwkEzqZzMnpBMwOzil0NiBtF3fHa3k

 Make your DAX formulas readable. (Also available in DAX Studio)
 URL: https://www.daxformatter.com/

 DAX Patterns: Copy+Paste and Replace Table/Field Names. You're an IT pro now.
 URL: https://www.daxpatterns.com/

 DAX 101 with Alberto Ferrari
 URL: https://youtu.be/klQAZLr5vxA

 Pro Level: Advanced DAX
 URL: https://youtu.be/6ncHnWMEdic


 ----

 Data Model Specific - Cost: $0 Dimes

 ----

 Learn how to create an optimal Tabular model.
 URL: https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/

 Why/When to use measures? Always... always use measures.
 URL: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 Pro Level: Calculated Columns vs. Computed Columns.
 URL: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

 Pro Level: Calculated Columns vs. Calculated Tables.
 URL: https://www.sqlbi.com/articles/storage-differences-between-calculated-columns-and-calculated-tables/

 Pro Level: The Vertipaq Engine. Learn it. Love it.
 URL: https://www.microsoftpressstore.com/articles/article.aspx?p=2449192

 Pro Level: Tune your models. You'll learn some Italian along the way.
 URL: https://www.sqlbi.com/tv/

 Pro Level: The best FREE tool on the internet. DAX Studio.
 URL: https://daxstudio.org/

 Pro Level: Do crazy things with your data model. Tabular Editor.
 URL: https://github.com/otykier/TabularEditor

 Pro Level: Migrate SSAS/AAS to Power BI Premium Datasets
 URL: https://data-marc.com/2020/06/16/migrate-analysis-services-models-to-power-bi-using-tabular-editor/


 ----

 Power Query Specific - Cost $0 Dimes

 ----


 Everything and anything.
 URL: https://docs.microsoft.com/en-us/power-query/

 Power Query Fundamentals from the greats.
 URL: https://www.skillwave.training/courses/power-query-fundamentals

 Fantastic series for learning M.
 URL: https://bengribaudo.com/blog/tag/power-query-m

 Pro Level: Overcome that Formula Firewall error, it's a doozy.
 URL: https://social.technet.microsoft.com/Forums/en-US/ca434e2d-88fe-4962-b46a-a1db51e8bd89/feedback-wanted-behind-the-scenes-of-the-data-privacy-firewall?forum=powerquery

 Pro Level: Deep Dive into M. Watch and re-watch with your family and friends.
 URL: https://www.youtube.com/watch?v=ecfRTEoYadI

 Pro Level: It's a dry read but, so good. It's the technical specifications guide.
 URL: https://docs.microsoft.com/en-us/powerquery-m/power-query-m-language-specification

 Pro Level: Create custom connectors.
 URL: https://github.com/Microsoft/DataConnectors

 Pro Level: Power Query SDK.
 URL: https://marketplace.visualstudio.com/items?itemName=Dakahn.PowerQuerySDK

 Pro Level: Power Query cmdlets (community built)
 URL: https://bengribaudo.com/blog/2020/04/14/5164/introducing-data-mashup-cmdlets


 ----

 Report Canvas - Cost $0 Dimes

 ----

 1/2 of the best in our business.
 URL: https://alluringbi.com/

 The other 1/2 of the best in our business.
 URL: https://www.youtube.com/channel/UCwfIR1yeBCmNSP0soX4Hb_g

 Custom Themes. Using your brand colors = bonus points with your boss.
 URL: https://www.kratosbi.com/power-bi-custom-theme-creation

 Visual Reference. Now you know.
 URL: https://www.sqlbi.com/ref/power-bi-visuals-reference/

 Build your own custom Power BI visuals. (Low-to-no-code).
 URL: https://charticulator.com/

 Intro to Charticulator series. You'll need it.
 URL: https://radacad.com/introduction-to-charticulator-create-custom-visual

 Build your own custom Power BI visuals (node.js):
 URL: https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial


 ----

 Application Lifecycle Management - Cost $0 Dimes

 ----

 Pro Level: Create versions of your stuff. Simple as that.
 URL: https://data-marc.com/2019/11/12/versioning-and-ci-cd-for-power-bi-with-azure-devops/

 Pro Level: Power BI Build Tools for Azure DevOps
 URL: https://marketplace.visualstudio.com/items?itemName=bguidinger.powerbi-build-tools


 ----

 Dataflows - Cost $0 Dimes

 ----

 Everything you ever needed to know.
 URL: https://ssbipolar.com/2018/10/23/dataflows-in-power-bi/


 ----

 Whitepapers / Recommended Practices - Cost $0 Dimes

 ----

 Official Whitepapers. Taught me everything I know.
 URL: https://docs.microsoft.com/en-us/power-bi/whitepapers

 Power BI Adoption Framework. It's where you start.
 URL: https://github.com/pbiaf/powerbiadoption


 ----

 Premium Capacity Administration and Optimization - Cost $0 Dimes

 ----

 Great introduction to Power BI Premium
 URL: https://www.fourmoo.com/2020/01/30/intro-into-power-bi-premium/

 Managing Premium.
 URL: https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-manage

 Optimizing Premium.
 URL: https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-optimize

 Dedicated Capacity Load Assessment Tool. Right size your premium needs.
 URL: https://github.com/microsoft/PowerBI-Tools-For-Capacities/tree/master/LoadTestingPowerShellTool/


 ----

 Tools / Software - Cost $0 Dimes

 ----

 DAX Studio. Enough said.
 URL: https://daxstudio.org/
 Getting Started:

 Power BI Helper. It helps you.
 URL: https://radacad.com/power-bi-helper

 BISM Normalizer. For all your XMLA needs.
 URL: http://bism-normalizer.com/

 Tabular Editor. Look behind the curtain.
 URL: https://tabulareditor.github.io/

 ALM Toolkit
 URL: http://alm-toolkit.com/

 Power Query SDK. Build your own custom connectors.
 URL: https://marketplace.visualstudio.com/items?itemName=Dakahn.PowerQuerySDK

 Power BI Data Connection file (PBIDS) creator.
 URL: https://connections.powerbi.tips/

 Data Mashup Explorer. See all your M code.
 URL: https://bengribaudo.com/tools/datamashupexplorer


 ----

 My Mount Rushmore of Resources- Cost $0 Dimes

 ----

 SQLBI - DAX and Data Modeling
 URL: https://sqlbi.com

 Chris Webb - Power Query and Performance Tuning
 URL: https://blog.crossjoin.co.uk/category/power-query/

 Miguel Escobar - Power Query Everything
 URL: https://www.poweredsolutions.co/author/psolutions/
	----

	Power BI Official Software - Cost: $0 Dimes

	----

	Power BI Desktop. From the Microsoft Store updates automatically. #WINNING
	URL: https://aka.ms/pbidesktopstore

	Power BI Desktop. From download center requires manual updating. #NOTWINNING
	URL: https://www.microsoft.com/en-us/download/details.aspx?id=58494

	Power BI Report Builder. Paginated Reports (like SSRS).
	URL: https://www.microsoft.com/en-us/download/details.aspx?id=58158

	Power BI. For displaying on digital displays. (think TVs)
	URL: https://www.microsoft.com/en-us/p/power-bi/9nblgggzlxn1?activetab=pivot:overviewtab


	----

	Self-Paced General Content - Cost: $0 Dimes

	----

	Earn points. Get badges. From beginner to expert.
	URL: https://aka.ms/pbilearn

	Every "In a (Day), (Hour)" session that you could possibly find to deliver yourself.
	URL: https://aka.ms/pbitraining

	Paginated Reports in a Day, great instructors. Chris made me say this.
	URL: https://aka.ms/priad-online-course

	Pro Level: Power BI Developer in a Day. Hands on keyboard for PBI Embedding.
	URL: https://aka.ms/deviad-online-course

	Pro Level: Power BI Dev Camp. This is the real deal.
	URL: https: https://powerbidevcamp.net

	Guy in a Cube - easy and fun way to stay up to date and learn.
	URL: http://youtube.com/c/guyinacube

	Radacad writes a lot and knows a lot. Enjoy.
	URL: https://radacad.com/online-book-power-bi-from-rookie-to-rockstar


	----

	DAX Specific - Cost: $0 Dimes

	----

	Follow this complete path. Yes, it's a long journey.
	URL: https://sqlbi.com/guides/dax/


	The ultimate go-to for documentation.
	URL: https:/www.dax.guide

	Wrap your head around context and DAX will reveal its true form.
	URL: https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

	Free YouTube series dedicated to the elements of DAX. WOW.
	https://www.youtube.com/watch?v=4j6EyelxJ3k&list=PLmRUwkEzqZzMnpBMwOzil0NiBtF3fHa3k

	Make your DAX formulas readable. (Also available in DAX Studio)
	URL: https://www.daxformatter.com/

	DAX Patterns: Copy+Paste and Replace Table/Field Names. You're an IT pro now.
	URL: https://www.daxpatterns.com/

	DAX 101 with Alberto Ferrari
	URL: https://youtu.be/klQAZLr5vxA

	Pro Level: Advanced DAX
	URL: https://youtu.be/6ncHnWMEdic


	----

	Data Model Specific - Cost: $0 Dimes

	----

	Learn how to create an optimal Tabular model.
	URL: https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/

	Why/When to use measures? Always... always use measures.
	URL: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

	Pro Level: Calculated Columns vs. Computed Columns.
	URL: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

	Pro Level: Calculated Columns vs. Calculated Tables.
	URL: https://www.sqlbi.com/articles/storage-differences-between-calculated-columns-and-calculated-tables/

	Pro Level: The Vertipaq Engine. Learn it. Love it.
	URL: https://www.microsoftpressstore.com/articles/article.aspx?p=2449192

	Pro Level: Tune your models. You'll learn some Italian along the way.
	URL: https://www.sqlbi.com/tv/

	Pro Level: The best FREE tool on the internet. DAX Studio.
	URL: https://daxstudio.org/

	Pro Level: Do crazy things with your data model. Tabular Editor.
	URL: https://github.com/otykier/TabularEditor

	Pro Level: Migrate SSAS/AAS to Power BI Premium Datasets
	URL: https://data-marc.com/2020/06/16/migrate-analysis-services-models-to-power-bi-using-tabular-editor/


	----

	Power Query Specific - Cost $0 Dimes

	----


	Everything and anything.
	URL: https://docs.microsoft.com/en-us/power-query/

	Power Query Fundamentals from the greats.
	URL: https://www.skillwave.training/courses/power-query-fundamentals

	Fantastic series for learning M.
	URL: https://bengribaudo.com/blog/tag/power-query-m

	Pro Level: Overcome that Formula Firewall error, it's a doozy.
	URL: https://social.technet.microsoft.com/Forums/en-US/ca434e2d-88fe-4962-b46a-a1db51e8bd89/feedback-wanted-behind-the-scenes-of-the-data-privacy-firewall?forum=powerquery

	Pro Level: Deep Dive into M. Watch and re-watch with your family and friends.
	URL: https://www.youtube.com/watch?v=ecfRTEoYadI

	Pro Level: It's a dry read but, so good. It's the technical specifications guide.
	URL: https://docs.microsoft.com/en-us/powerquery-m/power-query-m-language-specification

	Pro Level: Create custom connectors.
	URL: https://github.com/Microsoft/DataConnectors

	Pro Level: Power Query SDK.
	URL: https://marketplace.visualstudio.com/items?itemName=Dakahn.PowerQuerySDK

	Pro Level: Power Query cmdlets (community built)
	URL: https://bengribaudo.com/blog/2020/04/14/5164/introducing-data-mashup-cmdlets


	----

	Report Canvas - Cost $0 Dimes

	----

	1/2 of the best in our business.
	URL: https://alluringbi.com/

	The other 1/2 of the best in our business.
	URL: https://www.youtube.com/channel/UCwfIR1yeBCmNSP0soX4Hb_g

	Custom Themes. Using your brand colors = bonus points with your boss.
	URL: https://www.kratosbi.com/power-bi-custom-theme-creation

	Visual Reference. Now you know.
	URL: https://www.sqlbi.com/ref/power-bi-visuals-reference/

	Build your own custom Power BI visuals. (Low-to-no-code).
	URL: https://charticulator.com/

	Intro to Charticulator series. You'll need it.
	URL: https://radacad.com/introduction-to-charticulator-create-custom-visual

	Build your own custom Power BI visuals (node.js):
	URL: https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial


	----

	Application Lifecycle Management - Cost $0 Dimes

	----

	Pro Level: Create versions of your stuff. Simple as that.
	URL: https://data-marc.com/2019/11/12/versioning-and-ci-cd-for-power-bi-with-azure-devops/

	Pro Level: Power BI Build Tools for Azure DevOps
	URL: https://marketplace.visualstudio.com/items?itemName=bguidinger.powerbi-build-tools


	----

	Dataflows - Cost $0 Dimes

	----

	Everything you ever needed to know.
	URL: https://ssbipolar.com/2018/10/23/dataflows-in-power-bi/


	----

	Whitepapers / Recommended Practices - Cost $0 Dimes

	----

	Official Whitepapers. Taught me everything I know.
	URL: https://docs.microsoft.com/en-us/power-bi/whitepapers

	Power BI Adoption Framework. It's where you start.
	URL: https://github.com/pbiaf/powerbiadoption


	----

	Premium Capacity Administration and Optimization - Cost $0 Dimes

	----

	Great introduction to Power BI Premium
	URL: https://www.fourmoo.com/2020/01/30/intro-into-power-bi-premium/

	Managing Premium.
	URL: https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-manage

	Optimizing Premium.
	URL: https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-optimize

	Dedicated Capacity Load Assessment Tool. Right size your premium needs.
	URL: https://github.com/microsoft/PowerBI-Tools-For-Capacities/tree/master/LoadTestingPowerShellTool/


	----

	Tools / Software - Cost $0 Dimes

	----

	DAX Studio. Enough said.
	URL: https://daxstudio.org/
	Getting Started:

	Power BI Helper. It helps you.
	URL: https://radacad.com/power-bi-helper

	BISM Normalizer. For all your XMLA needs.
	URL: http://bism-normalizer.com/

	Tabular Editor. Look behind the curtain.
	URL: https://tabulareditor.github.io/

	ALM Toolkit
	URL: http://alm-toolkit.com/

	Power Query SDK. Build your own custom connectors.
	URL: https://marketplace.visualstudio.com/items?itemName=Dakahn.PowerQuerySDK

	Power BI Data Connection file (PBIDS) creator.
	URL: https://connections.powerbi.tips/

	Data Mashup Explorer. See all your M code.
	URL: https://bengribaudo.com/tools/datamashupexplorer


	----

	My Mount Rushmore of Resources- Cost $0 Dimes

	----

	SQLBI - DAX and Data Modeling
	URL: https://sqlbi.com

	Chris Webb - Power Query and Performance Tuning
	URL: https://blog.crossjoin.co.uk/category/power-query/

	Miguel Escobar - Power Query Everything
	URL: https://www.poweredsolutions.co/author/psolutions/