Teaching analytics with modern Excel
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
Data modeling, contrary to be nearing obsolescence, remains crucial for data analysts aiming to enhance their reporting speed and deepen their insights into business operations. Bernard Obeng …
At the core of Power Pivot is relational data modeling, which allows users to create relationships between tables for efficient calculation and data analysis. With Power Pivot, users can create and …
Continue Reading about How to create and manage relationships in Excel Power Pivot →
If you're using Power Pivot, you're probably dealing with table relationships and applying filters to refine results. This blog post explores filter direction in Power Pivot and how it enables …
Continue Reading about How to understand filter direction in Excel Power Pivot →
Working in healthcare, labor scheduling is a critical part of data analysis. It's important to meet demand while not scheduling unneccessary shifts. When framing these problems, I look for inspiration …
