#DataAnalysis Posts

The Toptal Finance Blog is a hub for in-depth studies and analysis on all facets of finance, ranging from innovative strategies on raising capital to detailed coverage of new finance trends and technologies.
Ellen Su
Exploring Excel's Get & Transform Functionality

Hidden in Excel and Power BI is a powerful data analysis pack named Get and Transform (previously known as Power Query). It is an ETL pack for cleaning and sorting raw data from a range of input sources, such as CSV and text files. This tutorial demonstrates how Get & Transform can help the data analyst both save time and uncover more insight.

Continue reading →
Erik Warren
How to Build a Budget that Lasts the Full Year

Budgeting can be a drawn-out process, yet oftentimes once the year starts and results diverge, they become forgotten. Instead of budgeting just with qualitative methods, managers should combine them with quantitative tools. Comparing regressed historic trends with future expectations can be more accurate and ultimately ensure the budget survives the year.

Continue reading →