Lovelytics has secured strategic investments from Databricks Ventures and Interlock Equity. Having two industry-leading partners supporting our team, our mission, and the vision of Lovelytics helps us accelerate the growth of our amazing team and culture. 

Photo Courtesy of Philadelphia Union Innovations In Analysis Innovations and advancements in technology have provided a way to gather real-time precise data points during any sporting event. The result is better insights into hundreds if not thousands of variables that might give a team a strategic advantage on the field and in the team’s back office as … Read more

The View from the Lakehouse Blog Series PART 2 Over the past few years, the term “data lakehouse” has grown in popularity. Why?  Fundamentally, a data lakehouse combines the best of data warehouses and data lakes, supporting business intelligence and advanced analytics workloads in a single platform. In other words, a data lakehouse provides a … Read more

The View from the Lakehouse Blog Series PART 1 Recently, Lovelytics held our first in-person all-hands meeting in more than a year. We gathered at our headquarters in Arlington, VA to socialize, strategize, and evaluate past decisions.  A major theme this year (and in years past) was the changing needs of our clients, and how … Read more

Most of us are inevitably going to be asked one of the most common questions this time of year: “What are you thankful for?”  Of course, I am grateful for my husband, my maniac of a dog, my family, and the food I’m fortunate enough to have on the table every day. But let’s be … Read more

Using the Blob Tools to Output Data into Formatted Excel Templates While “the Blob” might sound like a cheesy horror movie or an unidentified substance you scrape off the bottom of your shoe, in Alteryx it can be a very powerful tool. “Blob” is an acronym for “Binary Large OBject” data, which is a collection … Read more

I’ve always found web scraping interesting, there’s a massive trove of data available to us in a wide array of formats- it presents the perfect ‘big data’ problem, how can we capture, ingest, analyze, and leverage this data? To keep things relevant for a broader audience, I’m going to focus on the capture and ingest … Read more

Have you ever added a formula tool to your Alteryx workflow and suddenly realized that your IF/THEN logic is starting to look more like a book and less like a logical function? Or maybe you really miss the ability to simply reference a prior row’s result within an Excel function? In either scenario, you might … Read more

Synopsis: This article is a 101 level introduction to Databricks SQL, and will walk you through the steps to build simple visualizations directly within a Lakehouse environment. The article is focused around the UI and workflow of DBSQL and assumes the reader has basic SQL knowledge.  Databricks SQL (DBSQL) forms one of the three main … Read more

Has your organization recently deployed Tableau Mobile or is planning to deploy soon? Not sure how to optimize all your existing Tableau dashboards for mobile devices? Then keep reading for tips and tricks on making your desktop dashboards mobile-friendly! You may be thinking, “Wait, I thought Tableau automatically created dashboards that would look great on … Read more

We use data and analytics every day to answer those “W” questions: Who purchased our new product? Which carrier has the best on-time delivery record? What customer segment drove our change in sales? But how often are you faced with a “Where” question and you’re unable to find a quick and easy answer? Say you … Read more