This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far:
[+]Just ten years ago, even the most advanced analytics professionals only had to manage a handful of data sources. But data volume, velocity, and variety are now increasing exponentially. In 2016,....
[+]When defining your data warehouse strategy—or moving from on-premise to cloud—you’ve got lots of options. But your data warehouse is only as good as the strategy you use to put it in place. Bottom....
[+]Healthy competition can bring out the best in organizations. Just look at companies like Coke and Pepsi or General Motors and Ford, all of which were obsessed with outdoing the other while the....
[+]Sign up now for a demo or a free trail of the Panoply.io platform.
Learn more about platform features
When it comes to NoSQL databases, MongoDB and Cassandra may seem similar but are quite different. Both have similar use cases, but are not intended for transactional data (i.e., accounting....
[+]Being Data Driven Data Technology
Humans are visually-motivated. When we see a movie, we’re drawn to the most beautiful and exotic settings, the most striking and recognizable actors, the biggest explosions. What we don’t spend a....
[+]Both business and tech analysts agree that a capacity for advanced analytics is becoming mission-critical to the basic viability for all companies. While some believe that we are only three to....
[+]Being Data Driven Customer Stories
Meet Justin Mulvaney, he’s the data analyst at Spacious, a company based in New York City. We recently sat down with Justin to talk about his background, how he serves the data needs of a....
[+]Build vs. Buy—tale as old as time, song as old as…"I need that analysis yesterday!"
[+]We’re making a new resource available to Panoply customers and users. We call it our Community, and one click over there and you’ll see it is a forum.To break down the elements of using Panoply -....
[+]One of the biggest news items that came out of AWS re:invent 2017 was the announcement of Aurora Serverless. At first when we saw the news, we’re all 👏.
[+]Data Industry and Trends Being Data Driven
International Women's Day is a day when women are recognized for their achievements without regard to divisions, whether national, ethnic, linguistic, cultural, economic or political.
As we....
[+]ETL. It should be fairly straightforward, right? We extract data, transform it as needed, and load it into the target application. But like the recipe for the perfect Bloody Mary or the ideal....
[+]Nearly everyone in the IT world has heard the quote from Facebook’s Mark Zuckerberg about the need for speed and performance in technology—“Move fast, break things.” While that might apply to....
[+]As an analyst who deals with data from many data sources daily, you might find yourself as the go-to source for information about business intelligence in your office. While it’s cute when your....
[+]To be an outstanding data engineer you must constantly keep up to date with the latest developments and tools for building data infrastructure, learn about the real world examples from top....
[+]This series of posts analyzes how specific NoSQL databases stack up against one of the most popular NoSQL databases, MongoDB. We've covered the following comparisons so far:
[+]As we speak the future of cloud computing is being decided. Amazon and Google, as well as Microsoft and a few others, offer multiple cloud solutions for practically everything. Despite the....
[+]Your company sits on an immense treasure trove of data, but tapping this data and accessing its value is a challenge. As your company grew or new software solutions became available, your business....
[+]Like most data teams, Kimberly Clark’s EMEA Omnichannel team has results, insights and findings to deliver to dozens of stakeholders. The team also has data scattered across databases, cloud....
[+]Being Data Driven Data Technology
Amazon Redshift is a very powerful data warehouse, optimized for analyzing massive amounts of data in a blink of a second, when configured right.
[+]Three days, over ten thousand attendees, forty hours of content and at least five things happening at once. Welcome to SaaStr Annual! We've been scouring the official schedule for the coolest....
[+]As a member of the marketing team you already know that data is power. However, it’s not always easy to get, and even when you can get the data you need, it’s not always easy to understand,....
[+]For the last couple of decades ETL (extract, transform, load) has been the traditional approach for data warehousing and analytics. The ELT (extract, load, transform) approach changes the old....
[+]Data analytics is a requirement for virtually every business today. However building an analytical data warehouse requires vast computing power to maintain performance and quick retrieval of....
[+]Data Industry and Trends Data Technology
2017 has come to an end, and as you're gearing up for a successful 2018, you might find a cheat sheet of essential ETL tools and data storage comparisions handy. This list provides commentary to....
[+]The data industry continues to impress with new tools being released every month. While we all love choices, the current data stack landscape can be overwhelming. We’re here to help separate the....
[+]Pressed by the end-of-year holiday rush, we all feel the pain of trying to do more. To help you get some time back, we've made our data warehouse even smarter—which means faster and more....
[+]Being Data Driven Data Technology
Data analytics allows organizations to gain insight into their business operations and find new ways to increase their revenue. However, the data sources used to provide these insights are often....
[+]Data Industry and Trends Product
Panoply, Stitch and Chartio today announced the availability of the world’s first Automatic Cloud Data Stack. The combined offering enables data analysts and business users to connect to disparate....
[+]Good Business Intelligence (BI), allows your organization to query data obtained from trusted sources and use the answers to gain a competitive edge in your industry. The first step to achieving....
[+]MySQL has become an inexpensive option for organizations around the globe that need a relational database. However, as the variety and volume of data has increased in recent years, non-relational....
[+]Being Data Driven Data Technology
Data warehouses and data lakes are two different types of data storage repositories. Data warehouses integrate data from various sources and structures them for business reporting. Data lakes....
[+]Following the steady growth trajectory of customer onboarding, with a select-user rollout in late 2016 and a quiet launch in February 2017 that has ballooned to over 100 active customers to date,....
[+]The future of any successful enterprise will hinge on its ability to harness and use massive amounts of data currently available, to improve productivity, decrease costs, and increase profits. How....
[+]There are some big things happening around big data. I’ve had the chance to work with various types of cloud, data center, and virtualization systems through the years. One of the biggest trends....
[+]PostgreSQL and MariaDB are open source databases, which boast of vast community support and development, as well as enterprise versions. While PostgreSQL has withstood time and continued....
[+]Being Data Driven Data Technology
Business Intelligence (BI) has, by tradition, been a long and drawn out process. In the early days of computers, BI tools such as SAP/Crystal Reports and IBM/Cognos came along to speed things up.....
[+]As your organization moves its data into the cloud, you face the challenge of balancing productivity and efficiency gains with tremendous compliance and security concerns. While securing your....
[+]TL;DR -- whether you were there or not, these interesting tweets provide food for thought until #Data18.
[+]Managing big data is a never-ending challenge. Extract, transform, and load (ETL) processes serve as the traditional foundation for enterprise data warehousing. However, with the emerging....
[+]The Tableau Conference brings together the best and the brightest in data analytics from across the country under one roof in Las Vegas, Nevada. Tableau is a leader in BI reporting tools with....
[+]Being Data Driven Data Technology
Is it easy to connect to a data warehouse? Selecting the right tool can help make this connection attainable. Tableau Desktop makes this connection easy, from opening the software to connecting to....
[+]Data Industry and Trends Being Data Driven
In the past, designing a data warehouse has taken too long to complete. Executing numerous semi-automated steps results in a data warehouse that was limited and inflexible. This limitation caused....
[+]I gotta hand it to Oracle and Larry Ellison, the guy knows how to put on a show! They also know how to do business. When they announced their quarter highlights on September 14th, Larry reported....
[+]Data Industry and Trends Being Data Driven
If you ask a group of big data analysts what are some of the top professional challenges they face, you can easily imagine which challenges are consistently shortlisted. One is the amount of time....
[+]There are many risks involved with data security. Storing data in the cloud might seem like a safe bet, and for most users it is. But risks will always exist. Below we have identified some serious....
[+]The traditional approach for handling data warehousing as an analytical task has been
Data Industry and Trends Being Data Driven
As more organizations begin their journey to the cloud, they need to plan how they will apply the best practices of data management to ensure that cloud-based, data-driven use cases are successful....
[+]There’s no question that the cloud offers many potential benefits. Major companies everywhere are lining up to reap the benefits by moving their back-office systems to cloud-based data warehouse....
[+]Are you considering a career as a BI Architect? You have made an excellent choice. Business Intelligence Architects are some of the leading minds in business and information management.
They use....
[+]Data Industry and Trends Being Data Driven
Long before there was big data, there were computing solutions designed to store, organize, and analyze data. But just like the job of a big data architect, it's both bigger and different than ....
[+]Designing a database schema is the first step in building a foundation in data management. Ineffective schema design can creates databases that are heavy consumers of memory and other resources,....
[+]Data Industry and Trends Being Data Driven
Organizations looking to leverage big data impose a larger and different set of job requirements on their data architects versus organizations in traditional environments.
[+]Although there are several data warehousing systems on the market, Amazon Redshift and Google BigQuery are the industry behemoths. There is a “prevailing consensus that Amazon is leading the pack.....
[+]Putting it bluntly
[+]When it comes to NoSQL databases, MongoDB is definitely in the lead as the world's fastest-growing database. But the days when a single database was enough are behind us;
[+]Whether your database needs to run on a mobile device or scale to a humongous size, this post has you covered with CouchDB vs. MongoDB. One of these databases can run on your phone while the other....
[+]Data Industry and Trends Being Data Driven
A data engineer conceives, builds and maintains the data infrastructure that holds your enterprise’s advanced analytics capacities together.
[+]The battle of the NoSQL databases continues. We first analyzed Cassandra vs MongoDB. This time we will dig in Redis vs MongoDB.
[+]In today’s fast-paced competitive market, there are critical advantages to utilizing infrastructure-as-a-service, especially for businesses concerned about fast-tracking their analytics....
[+]Let's talk about data. The sheer volume of the data collected today is enormous. When I try to even imagine the amounts ... it's staggering.
[+]Across industries, a rapidly rising demand for data scientists and engineers by far outstripps supply. In fact, the shortage of skilled IT professionals is one of the main factors that is slowing....
[+]Big Data can be a seductive master. How can you maximize time-to-insight without going over to the Dark Side?
[+]Data Industry and Trends Being Data Driven
The demand for skilled Data Engineers (or Big Data Engineers) is projected to rapidly grow. No wonder that’s the case: no matter what your company does, to succeed in today’s competitive....
[+]Setting up a Redshift cluster that hangs on some number of query executions is always a hassle. When users run queries in Amazon Redshift, the queries are routed to query queues. Usually the....
[+]Yesterday at AWS San Francisco Summit, Amazon announced a powerful new feature - Redshift Spectrum. Spectrum offers a set of new capabilities that allow Redshift users to seamlessly query....
[+]Data Industry and Trends Data Technology
Data warehouse technologies are advancing towards interactive, real-time, and analytical solutions. In particular, cloud-based data warehouse technologies have reached new heights with the help of....
[+]For many organizations, their ability to collect data has long surpassed their ability to organize it quickly enough for analysis. As companies of all sizes are increasingly pressured to leverage....
[+]On Feb 28th, Amazon Web Services (AWS), went down for approximately 4 hours. The outage occurred in Amazon’s US-East-1 facility in Virginia, their biggest region, and disrupted business continuity....
[+]As a data engineer, I enjoy my work, but when it comes to integrating and managing data there are quite a few tasks that are downright tedious. From data remodeling to juggling a hodgepodge of....
[+]Data Industry and Trends Being Data Driven
I loved this line from an article I recently stumbled upon: “Choosing between the different types of data warehouse platforms can be simplified once you know which deployment option best meets....
[+]We all know that in the database technology world, it comes down to two main database types – SQL (relational) and NoSQL (non-relational). The differences between them are rooted in the way they....
[+]Today’s considered data management best practices, advocate building resilient architectures that span multiple data centers, regions or even continents.
[+]One of the main goals of this blog is to help developers and data architects, just like us, with their Amazon Redshift operations, including Redshift security. Starting from a full comparison with....
[+]Data analyst? You must be familiar with both Tableau and AWS Redshift. And you must know, or at least you should believe me that integrating the Redshift columnar-based database speed with the....
[+]The basic free Google Analytics (GA) functionality is great for small and medium websites and mobile applications, but as your online business expands, you will start looking to get more of this....
[+]Amazon re:Invent is a great place to gather feedback from industry professionals, and especially gauge cloud-industry trends. This past year, we used the opportunity to collect and analyze....
Extract, Transform, and Load (ETL) is a data warehousing process that uses batch processing to help business users analyze and report on data relevant to their business focus. The ETL process....
[+]A smart, proactive PostgreSQL connection pooler, we are proud to announce our PGproxy offers the advantages of query routing and rewriting, making it optimal for data engineers who need to query....
[+]Data Industry and Trends Data Technology
If you’re looking for a solution for processing huge chuncks of data, then there are lots of options these days. Depending on your use case and the type of operations you want to perform on data,....
[+]If you recognize your data as an asset, than augmenting it simply means growing your business assets. With data augmentation, you can run manipulations on existing data, use multiple sources from....
[+]Attendance at this year’s AWS re:Invent conference almost doubled, from 18,000 people last year to 32,000 people last week. The large, international cloud computing event attracted professionals....
[+]We’re sure you’re already beginning to build your re:Invent schedule for 2016. As the largest cloud conference in the world approaches, it’s time to make sure that you’re maximizing your time and....
[+]Preparing data for Business Intelligence (BI) can be a very tedious and time consuming process. You want the data to turn into the best reports for analysis. But, the raw data needs lots of....
[+]The cloud, unlike the Force, is not a mystical energy that surrounds us and binds us.
[+]We often come across new products aiming to help us with our lives or improve our productivity. It’s in our best interests to find the best products that will minimize tedious work to none, but....
[+]Data Industry and Trends Being Data Driven
This is the third and final part in the 101 series covering big data concepts, terminology and technology
[+]Data and music have much in common given that both tell stories with points and notes, yet each on its own lacks the coherence and context that distinguishes music from noise. Paradoxically, in....
[+]The byproduct of the ever increasing integration of the internet in our daily lives is massive growth of data transitioning between applications and servers every minute. In order to make these....
[+]One of the most critical issue in data warehouse management is avoiding duplications. When you are periodically loading data into your data warehouse you will want to skip the rows that have been....
[+]Being Data Driven Data Technology
Microsoft Research just released SandDance, a free web-based data visualization tool.
[+]The premise that to build a perfect data warehouse you must have perfect business understanding is simply irrelevant. We must look to technology to empower us to keep pace with our rapidly....
[+]This is the second part in a 101 series covering Big Data concepts, terminology and technology.
[+]As a species we’ve invented some pretty nifty things. It’s practically consensus that the wheel, the printing press and the internet top the list but we don’t need to look that far back to find....
[+]
