“It’s the most wonderful time of the year,” sang Andy Williams about the Christmas season, but a “wonderful time” might not be how analysts working in e-commerce and retail see the incredibly busy and stressful season. According to the National Retail…
Continue reading How Ecommerce Analysts Can Prep for the Holiday Season
You’ve spent a bunch of time figuring out the best data stack for your company. It was hard work, and occasionally it was frustrating, but mostly it was fun. Now for the un-fun part of the process: putting together a proposal…
If you work with data of any real size, chances are you’ve heard of ETL before. If not (or if you just like having your memory refreshed), here’s a summary: ETL is a framework for moving data from transactional databases,…
There’s nothing more aggravating for a data analyst than sweating over a great analysis or dashboard only to have it go unused.It’s easy to feel that the problem is your (ungrateful) users. Most of the time, it isn’t.The real issue…
Continue reading Why Data Analysts Should Adopt a Product Mindset
If you’re thinking about creating a data warehouse from scratch, one of the options you are probably considering is Amazon Redshift. Redshift is very powerful, but figuring out how much it’ll cost can be tricky.In this article, we’ll explain how…
Every week, analysts around the globe are working hard to create data warehouses.And far too often, most of their effort is wasted.Why? Because it’s easy to create the right solution for the wrong problem.If you build a data warehouse that’s…
Continue reading Analyzing Business Needs: The First Step in Your Data Warehouse Project
Some people think you only need a data warehouse if you have huge amounts of data. That used to be true. It’s not anymore.These days, any business that uses Salesforce, Shopify, Twitter, an online accounting tool, and other online systems is…
LendStreet is a consumer financial health platform that offers loans to assist Americans who are deeply indebted. The product is quite complex and what we build internally is the entire customer experience as well as administrative software, which works with…
Continue reading How Financial Tech Company LendStreet Embraces Financial Data
You need a data warehouse, but a data warehouse is worth nothing if it doesn’t contain – data! The first step to start seeing benefits from your data warehouse is to ingest data, and there are two main data ingestion…
Continue reading Views: The Key to a Successful ELT Data Warehouse
A data warehouse is a place to store data solely for the purpose of analysis. That may not seem that interesting—and it isn’t—but its the capabilities that a data warehouse offers for optimizing your ecommerce business that makes things interesting.…
Continue reading Shopify Business Intelligence And Data Warehousing Step-by-Step
Good analytics is no match for bad data. Bad data wins every time. That’s why we’re talking about the tools to create a clean, efficient, and accurate ELT (extract, load, transform) pipeline so you can focus on making your “good analytics”…
Continue reading ELT Data Pipeline Tools: Find the Best Options
Your company has reached the point where the only way to analyze your data – on the scale needed for your business to succeed – is to build or buy a data warehouse. How do you figure out how much…
Continue reading How to Estimate Cloud Data Warehouse Costs and Pricing Comparison
