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 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 →
How to load a data model from Excel to Power BI
One of the best things about Power Pivot and Power Query is that once you've learned how to use them in Excel, you can easily transfer that knowledge to Power BI: But not only do your skills …
Continue Reading about How to load a data model from Excel to Power BI →
How to add tables to the data model in Excel
Het kopen van Cialis Generiek, ook wel bekend onder de naam Tadalafil, is een goedkoper alternatief voor het bestellen van de originele merkgeproduceerde hulpmiddel. Dit houdt echter niet in dat er …
Continue Reading about How to add tables to the data model in Excel →
A tour of the Power Query Editor in Excel
Power Query is possibly the most exciting new Excel feature of its generation... but you might never know it considering how hidden it is from the Excel interface! If you're looking to connect a data …
Continue Reading about A tour of the Power Query Editor in Excel →
Marshall on Modeling
The 19th Century economist's famous steps on building and communicating economic models. One of my all-time favorite quotes. …