Need help translating from IT-speak to plain English? Use the Contact form for assistance.
The writings of Matt Allington
The most valuable resources I've found so far were written by an Australian consultant, Matt Allington.
Matt Allington's blog, https://exceleratorbi.com.au/blog is a wealth of information. Here's some hand-selected treasures for my readers:
Allington's Supercharge books have step-by-step exercises. Buy only one as the content is the same in each book: just modified to the application.
- Supercharge Excel: When you learn to write DAX for Power Pivot
- Supercharge Power BI: Power BI Is Better When You Learn to Write DAX
On Microsoft.com
Power Query M function reference
Power Query User Forum
Power Pivot User Forum
Power BI User Forum
Books
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, 1st edition, Gil Raviv, 2018. Author is one of the developers of Power Query. Dives deep in to Power Query.
M is for (Data) Monkey: A Guide to the M Language in Excel Power Query, Ken Puls & Miguel Escobar, 2016. Provides tips for navigating through issues identified while using Power Query. For experienced accounting and finance users.
Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016, Second edition, Rob Collie & Avichai Singh, 2016. Colorful user manual to start working with DAX.
Power Query for Power BI and Excel, Chris Webb, 2014. Excel 2013 based. Materials are outdated but still have value. 2nd half focused on Power Query's M language.
Blogs
BI Accountant, www.thebiccountant.comCrossjoin, blog.crossjoin.co.uk Blog of Chris Webb, author of book on Power Query.
Data Chant, Datachant.com Blog of Gil Raviv, author of book on Power Query.
edureka, www.edureka.co/blog Power BI tutorial.
Excel City, https://excel.city
Excel Guru, www.excelguru.ca/blog Blog of Ken Puls, one of the authors of M is for Data Monkey.
Power Pivot Forum, powerpivotforum.com.au User forum managed by Matt Allington, author of Supercharge books.
Power Pivot Pro, powerpivotpro.com Blog of Rob Collie, author of book on Power Pivot and Power BI.
RADACAD, http://radacad.com Power BI focused blog by a Microsoft Director.
SQL BI, SQLBI.com Written by Marco Russo and Alberto Ferrari, two highly regarded experts in the Power BI space. Authors of a definitive guide on DAX (to be read) and creators of DAX Patterns, DAX Guide, and DAX Formatter.
Sum Product, www.sumproduct.com/blog
Websites
DAX Formatter Improves the readability of DAX.DAX Guide Reference guide on the DAX language.
DAX Patterns Collection of ready-to-use data models and formulas in DAX.
LinkedIn Learning Video courses. Platform which launched my Power Excel tools journey.
Manage Many to Many Relationships in Power Pivot YouTube video.
Top 10 Alternatives to Power BI Great article explaining pros of Power BI and then walking through other Power BI solutions.
Your post is very great.I read this post. It's very helpful. I will definitely go ahead and take advantage of this. You absolutely have wonderful stories. Cheers for sharing with us your blog.
ReplyDeletePython training in Noida
https://www.trainingbasket.in
Thank you so much for the feedback. It's very appreciated. Glad you are enjoying the blog. If you have questions during your journey, please don't hesitate to reach out.
Delete