Microsoft Power BI Weekly 2023/23

Hi everyone, we have another amazing week full of interesting articles about Power BI published on LinkedIn and Medium.com. We will start with those for beginners and continue up to the most advanced and complex topics.

This week:

• 8 articles from LinkedIn
• 7 free articles from Medium.com
• Power BI Tutorials for beginners
• DAX and Data Model basics
• Map visualizations
• Tutorial with advanced DAX scenarios.

#powerbi #dax #powerquery #datascience #datavisualization #dataanalytics

LinkedIn

Summary of Power BI May 2023 release by Brian Julius highlights two new features:

• Azure Maps
• Measure based data labels

?? Power BI May 2023 Release (linkedin.com)

#intermediate #visualization

Power BI Tutorial Newsletter, perfect for beginners. These episodes have been published so far:

?? Power BI Beginner Level: 1 - Power BI Overview | LinkedIn

?? Power BI Beginner Level: 2 - Power BI Advantages and Disadvantages | LinkedIn

?? Power BI Beginner Level: 3 - Power BI Workflow | LinkedIn

?? Power BI Beginner Level: 4 - Using Power Query in Excel (Part 1) | LinkedIn

?? Power BI Beginner Level: 5 -Using Power Query in Excel (Part 2) | LinkedIn

?? Power BI Beginner Level: 6 -Using Power Query in Excel (Part 3) | LinkedIn

?? Power BI Beginner Level: 7 - Understanding Power BI Pricing | LinkedIn

#beginner #powerquery

Medium.com

First article explains?DAX language?and its place in Power BI:

???DAX: A Powerful Tool for Data Analysis in Power BI | by Olajumoke Ajala | Jun, 2023 | Medium

#beginner #dax #free

Each report is just as good as is data model behind it. Amulya explains?basic data relationships?in Power BI:

???Understanding Model-View Relationships in Power BI: A Comprehensive Guide | by Amulya Kandukuri | Jun, 2023 | Medium

#beginner #datamodel #free

Learn key functions for?time-based calculations:

???Mastering Time Intelligence with DAX Functions: DATESMTD(), DATESQTD(), and DATESYTD() | by Andrew Hubbard | Jun, 2023 | Medium

#beginner #dax #free

Earlier or later, each Power BI developer needs to display some kind of maps in his reports. Here are?3 top map visuals:

???Top 3 Map Visuals in Power BI for Beginners | by Samarth Borade | Medium

#beginner #visualization #free

Security is also/always important. This tutorial shows how to manage?row level security:

???Securing Data Confidentiality with Row Level Security in Power BI | by Samarth Borade | Jun, 2023 | Medium

#intermediate #security #free

Financial specialists always need to compare KPIs between different periods. But how to compare KPI with its?average for last 3 months? Here is step by step tutorial:

???Analyzing Financial Trends in Power BI: Comparing Current Month with Average of Last 3 Months’ Data . | by Samarth Borade | May, 2023 | Medium

#intermediate #dax #free

Something for all?DAX Masters. Categorization of customers based on their behavior. 20+ DAX functions used.

Function used: LEFT, RIGHT, DATE, ADDCOLUMNS, CALENDAR, YEAR, QUARTER, MONTH, YEARMONTHNUM, MONTHYEAR, PREVIOUSMONTH, FORMAT, VALUES, ALL, EXCEPT, COUNTROWS, INTERSECT, CALCULATE, LASTDATE, ALLEXCEPT, ISBLANK, DATEIFF….

???Customer Analytics using Power BI. Categorize your customers based on their purchase behavior. | by Makis Makrandreou | Jun, 2023 | Medium

#intermediate #dax #free

That’s all for this week…

???Don’t forget to subscribe to our LinkedIn Newsletter or?Medium.com publication?and?newsletter…

???If you love this newsletter,?share your love?with others….

??And please give me your?personal?or?anonymous feedback…

Thank you and see you next week!

Tomas