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 …
How to create and manage relationships in Excel Power Pivot
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 →
How to understand filter direction 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 →
Algorithm on Board
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 …