Practical Excel & Power BI Learning Resources

Creating a comprehensive calendar table is crucial for time-based analysis in Power BI. Here are 15 essential DAX functions to enhance your calendar table: ShortDay ShortDay = FORMAT('Calendar'[Date], "ddd") Displays the day of the week as a short abbreviation (e.g., Mon, Tue). DayOfMonth DayOfMonth = DAY('Calendar'[Date]) Extracts the day of the month (1-31) from the date. StartOfWeek_Mon StartOfWeek_Mon = 'Calendar'[Date] - WEEKDAY('Calendar'[Date], 2) + 1 Returns the da

During my initial days of transitioning to the data analysis field, I used to think that the most crucial part was the ability to use all kinds of tools and software. I spent most of my time learning all sorts of tools like MS Excel, SQL, Power BI, Tableau, Python, and others. However, as I started to work on projects, I realized that there is much more compared to the tools and software. Here are 4 aspects which I thought are crucial when working in projects as Data Analyst