Conversão de Intervalo de Datas em Minutos no Power BI

Learn to analyze time data in Power BI! This comprehensive course guides you through calculating total time spent between two dates and converting it into meaningful units like months, days, hours, minutes, and seconds.

What you'll learn:

• Data Connection: Connect Power BI to a CSV file containing user activity data (downloadable from GitHub).
• Data Transformation: Convert date columns to the correct data type and calculate the duration between start and end dates. Learn to create a "total minutes" column for further analysis.
• Date Table Creation: Build a robust date table to effectively filter and visualize user log data.
• DAX Measures & Calculated Columns: Master DAX to calculate the overall total time in minutes and convert it into a user-friendly format (years, months, days, hours, minutes, seconds). Create a calculated column to display the total time in a readable format (e.g., "23 days 7 hours 6 minutes 9 seconds").
• Interactive Visualizations:
  • Card Visual: Display the overall total time in a clear, concise card.
  • Clustered Column Chart: Visualize total time per user, highlighting the top 10 most active users.
  • Bar Chart: Analyze total time by month and year, presented in descending order for easy trend identification.
  • Pie Chart: Show the distribution of total time per user, focusing on the top 5 contributors.
  • Matrix Visual (Pivot Table): Examine total time per user, start date, end date, duration, and the calculated total time in a detailed table.
• Power BI Theme & Formatting: Apply a branded theme to ensure visual consistency and enhance dashboard aesthetics. Adjust formatting for optimal readability.
• Report Publication: Publish your interactive Power BI report to a Power BI Pro workspace. A link to the published report is provided.

Key Takeaways:

This course emphasizes the importance of data organization and transformation for effective data visualization. You'll gain practical experience using DAX measures and calculated columns to unlock deeper insights from your time-based data. The final dashboard provides a powerful example of how to visualize and analyze time-related information in Power BI. Ideal for anyone looking to gain control and understanding of time data within Power BI.