“Excel running slow” is a common complaint for more and more users. Excel’s ubiquity and ease of use are its strengths, but Excel runs slow when tackling large data sets. We’ve said it before: the simple fact is that Excel’s framework for data processing wasn’t made for big data. It’s not just that Excel becomes […]
More Paige Schaefer • July 25, 2020 To make data useful for collaborative study, modeling, and large-scale analytics, data standardization is a necessary process. Standardizing data—such as matching the terms “Ave vs. Avenue vs. Ave.” to “Ave.”—increases the speed at which data analysts can work. The need for data standardization has grown exponentially as data sources become more and more diverse, regardless […]
More Paige Schaefer • June 17, 2020 Most Excel users know their way around a pivot table. A pivot table can quickly summarize basic statistical information (with sums or averages, for example) and display that data in a more meaningful format. But before you can start pivoting your data, you may need to rearrange your data —in other words, you need to […]
More Paige Schaefer • May 14, 2020 Data is the lifeblood of contemporary businesses and is used to formulate marketing, sales and customer service strategies. It is at the core of every decision business leaders make to promote the growth and profitability of their organizations. Data empowers leaders to make precise decisions based on facts and trends rather than speculations. Excellent business […]
More Paige Schaefer • May 11, 2019 Today, we announced the results of our first-ever survey on the state of data preparation, which includes responses from nearly 300 analysts and IT professionals. At a high-level, the results show that organizations are spending too much time preparing data, and this wasted time is hindering analytic progress. When we crunched the numbers, however, we […]
More Paige Schaefer • May 17, 2018 At Trifacta, one of the tenets of our company culture is to always be learning, and we put that into practice with monthly “fireside chats,” where we invite leaders in the tech and data science community to share their experiences with our team. We’ve been lucky enough to host some illustrious guests, including Mike Olson […]
More Paige Schaefer • April 25, 2018