Скачать или смотреть Power BI 👉🏼 Earthquakes data🌐Calculated Columns & Measures ➡️ Magnitude & Energy Analysis ☑️Video #2

👉 Microsoft Power BI ➡️
➡️ Using Real-World Data 🌎🌐🌍🌏
👉 Earthquakes Data 🫨
👉 Magnitude & Energy Analysis ☑️
** Please watch this video to the end and Learn Important Concepts **
👉 Data Source: U.S. Geological Survey Earthquakes (earthquakes.usgs.gov )
https://earthquake.usgs.gov/earthquak...

👇👇 AI Summary of this Video 👇👇

This video demonstrates how to use Power BI to analyze real-world earthquake data from the U.S. Geological Survey.

The creator showcases how to import the data and perform several key analytical steps:

• Creating a 'Region' Calculated Column (0:51):

Learn how to copy down DAX line of code(1:54-2:05)

The video explains how to add a new calculated column called "Region" using the `SWITCH` and `CONTAINSSTRING` DAX functions to categorize earthquake locations based on keywords in the 'place' column (e.g., Oklahoma, Texas, California).

• Calculating 'Seismic Energy' (3:08): A new calculated column named "Seismic Energy" is created using a standard formula involving the `POWER` DAX function. This calculates the seismic energy in joules based on the earthquake's magnitude.

• Calculating 'Energy Equivalent to TNT' (4:11): Another calculated column is added to compute the energy equivalent in tons of TNT, providing another perspective on the earthquake's power.

• Creating Measures for Analysis (4:39): The video demonstrates creating two measures:
• Total Seismic Energy: Using the `SUMX` function to aggregate seismic energy across the dataset.
• Significant Events: Utilizing the `CALCULATE` function to count earthquakes with a magnitude greater than or equal to 5.

• Building an Interactive Report Page (6:15): The creator presents a Power BI report page featuring various visuals:
• A relative date slicer (6:24) to filter data by rolling time period.
• Card visuals (6:31) displaying total seismic energy, average magnitude, and significant events.
• Slicers for Magnitude and Region (6:38) to enable interactive filtering.
• A scatter plot (6:49) and a table visual (6:52) for data visualization.

• Adding a 'Clear All Slicers' Button (7:50): A button is added to easily reset all slicer selections to their default state, enhancing user experience.
The video also shows how to customize this button's appearance (8:17).

• Formatting and Swapping Visual Elements (9:06): The video concludes by demonstrating how to change the formatting of calculated columns and how to swap between using a calculated column and a measure in report page