MongoDB is fantastic...and challenging. This database is popular among developers due to its flexibility, but getting your data out of Mongo and into a BI tool isn’t a ...
Databases
MongoDB Business Intelligence: Connector Challenges and Alternatives
By Alon Brody
|
December 6, 2020
Experienced data scientists and developers are spoilt for choice when it comes to data analytics tools. But for those who don't hail from a data-centric background, it ...
ETL/ELT
Top 5 Keboola Alternatives: Weighing Expertise and Ease of Use
By Andrew Zola
|
December 6, 2020
Data provides the foundation for innovation and enhanced efficiency. But anyone who's worked with it will tell you that it can be quite challenging. Without the ...
Data Stack
Top 5 Domo Alternatives: Capabilities and Usability Go Head-to-Head
By Andrew Zola
|
December 4, 2020
If you're building a data warehouse, you need ETL to move data into that storage. To do that, you first extract data from an array of different sources. Then you apply ...
ETL/ELT
Top Python ETL Tools for 2021
By Adam Murphy
|
December 2, 2020
Finding the right ETL tool for your business is essential. ETL pulls data out of a source (extract), makes changes according to requirements (transform), and then pushes ...
ETL/ELT
Top ETL Tools for Business... And The Case For Saying 'No ETL'
By Peter Weinberg
|
December 1, 2020
SQL and pandas are both invaluable tools for any analyst or data scientist. They tend to be mentioned in the same breath when talking about data manipulation and ...
Data Analysis
SQL and pandas: A Rosetta Stone for Analysts
By Peter Weinberg
|
December 1, 2020
We now generate more data in an hour than we did in an entire year just two decades ago. The same old tools simply don't cut it anymore. That's why Amazon came out ...
Data Warehousing
Top 5 Redshift Alternatives: Balancing Cost and Complexity
By Andrew Zola
|
November 30, 2020
Five years ago, MongoDB detailed new enhancements that enabled it to work with standard relational reporting tools like Cognos, Tableau, and Business Objects. That's ...
Data Stack
Top 8 MongoDB Analytics and Reporting Tools: SQL and NoSQL
By Alex Williams
|
November 28, 2020
The competition within the data analytics space is heating up, with all the players aim to make data collection and analysis more manageable. One of the leading ...
Data Warehousing
Top 5 BigQuery Alternatives: A Challenge of Complexity
By Andrew Zola
|
November 19, 2020
Data is the underlying force that drives modern marketing campaigns. But if you're an agency running multiple promotions across platforms, the data aggregation process ...
ETL/ELT
Top 5 Supermetrics Alternatives: Balancing Ease Of Use & Cost
By Andrew Zola
|
November 19, 2020
“To buy or not to buy, that is the question.”
ETL/ELT
Build or Buy ETL Tools: The Pros and Cons of Building a Pipeline
By Phillip Tanzer
|
November 19, 2020
You nailed your proof of concept project. Your initial group of users are happy, and they’re getting comfortable mining the first batch of data for insights that may ...
Best Practices
Deepening Your Approach to Data
By Anders Schneiderman
|
November 17, 2020
Until recently, data warehouses were largely the domain of big business. With a data warehouse, you could consolidate and analyze vast amounts of information, deriving ...
Data Warehousing
Understanding Data Warehouse-as-a-Service Benefits Today and Tomorrow
By Anders Schneiderman
|
November 17, 2020
When it comes to flavors of SQL, everyone’s got an opinion—and often a pretty strong one. While the SQL debates aren’t quite as intense as, say, the Python/R holy war in ...
ETL/ELT
Top 5 Microsoft SQL Server ETL Tools
By Peter Weinberg
|
November 7, 2020
In this unprecedented year, data analysts, engineers, and developers showed incredible adaptability and resilience. Companies that deployed robust cloud and data ...
ETL/ELT
Top 5 Etleap Alternatives: Weighing the Trade-offs of Cost and Support
By Andrew Zola
|
November 6, 2020
We’re excited to share some fantastic news: we recently received a $10 million investment to support our vision of helping companies of all sizes sync, store, and access ...
Panoply News
Panoply Announces An Additional $10M in Funding
By Roi Avinoam
|
October 27, 2020
Trying to transform your business into a data-driven powerhouse can feel overwhelming. Even if you've got amazing self-service tools, helping your team become ...
Best Practices
Why and How to Assemble Data-Loving Allies
By Anders Schneiderman
|
October 21, 2020
In an ideal world, when you create an amazing plan to build a world-class data stack, your coworkers' minds would be blown, your company's CEO would thank you for your ...
Best Practices
How to Get High-Level Buy-In for Your Data Warehouse Project
By Anders Schneiderman
|
October 6, 2020
“When you become an effective evangelist, you don’t just promote your organization—you set an example for other employees. You show that you are a passionate, engaged ...
Analytics Leadership
Data Evangelism: Not Just a Leap of Faith
By Dilan Jayasekara
|
September 28, 2020
The first iteration of your shiny new data warehouse is up and running, and folks are loving it. For example, Marketing is thrilled at how easy it is to pull up the data ...
Best Practices
What Is a Single Source of Truth (SSOT) and Why Do You Need One?
By Anders Schneiderman
|
September 22, 2020
Data is a good news/bad news situation. The good news is that companies have more information at their disposal than ever before. The bad news is that they may not know ...
Being Data-Driven
Collaboration: The Core of a Data-Driven Organization
By Paul Korzeniowski
|
September 15, 2020
“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 ...
Being Data-Driven
How Ecommerce Analysts Can Prep for the Holiday Season
By Andrew Pearson
|
September 8, 2020
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.
Data Stack
How to Propose a Data Stack
By Anders Schneiderman
|
September 3, 2020
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 ...
ETL/ELT
What is Data Transformation, Anyway?
By Peter Weinberg
|
August 24, 2020
There’s nothing more aggravating for a data analyst than sweating over a great analysis or dashboard only to have it go unused.
Best Practices
Why Data Analysts Should Adopt a Product Mindset
By Anders Schneiderman
|
August 18, 2020