Column Standardizer – Power Query Function

Column Standardizer – Power Query Function

Have you worked with an Excel or CSV file that changes slightly their column names? Whatever the reason, this seems to make your Power BI refresh crash.As you know, Power Query is very susceptible to any change, especially using Functions such as Table.ReorderColumns or Table.SelectRows. To solve that problem we have developed a function called […]

How to become a data driven organization

How to become a data driven organization

In the era of Machine Learning, there is still an uncountable number of organizations that rely heavily on systems of the 80’s – excel spreadsheets. The problem is not the tool per se, but the strategy across the organization,  where data is imprisoned in different silos, full of mistakes and where data governance is nonexistent. Creating […]