Forum Discussion
Courses
Hi guys, I am new to Power BI and I am looking for recommendations for beginner courses? Preferably free but any recommendatiosn welcome. Thanks.
Hi Anonymous ,
Here is a good list of resources from AlexPowers
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/