Power BI Masterclass - Growth Insights - Profit and Sales Evaluation for Customer Base

The video tutorial covers how to analyze company growth using DAX by examining sales and profit growth. It guides viewers through creating new measures for growth percentages, visualizing data with scatter plots, filtering data by year, and analyzing growth by country. Additionally, it demonstrates adding trend lines to better understand growth trends, providing insights into which countries are performing well.

Why is it important to analyze both sales and profit growth?

• To only consider short-term growth

• To ignore profit trends

• To focus solely on increasing sales

• To ensure that increasing sales are not accompanied by decreasing profits

What function is used to avoid division by zero when calculating growth percentages?

• DIVIDE

• SUBTRACT

• SUM

• MULTIPLY

What is the purpose of creating a new measure for total profit growth percentage?

• To focus only on sales growth

• To ignore profit growth

• To calculate the difference between current and previous year's profits

• To compare total profits with total sales

Which visualization tool is used to display sales and profit growth?

• Pie Chart

• Scatter Plot

• Line Graph

• Bar Chart

How can you differentiate data points in a scatter plot?

• By using dimensions like customer countries

• By changing the background color

• By using different shapes

• By adding more axes

What additional feature can be added to a scatter plot to identify trends?

• A grid

• A title

• A trend line

• A legend

What insight can be gained by adding a trend line to the scatter plot?

• It indicates the most popular products

• It displays the total number of customers

• It highlights countries with above-average profit growth

• It shows the average sales growth