Posts

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will lay out the effects of a data warehouse solution for your Acumatica experience, so that you can have a head start in shopping for the best data storage and Business Intelligence (BI)  tool.

Data is an essential ingredient in the recipe for corporate success.  Because of this importance, data warehouses are then relevant by association.  When I first heard of data warehousing, I had a lot of questions, so perhaps you feel the same.  What does data warehouse management look like?  Are they a tangible product?  How do you implement one?  Why should I go with a data warehouse at all?  You might have these kind of questions – or other ones altogether, as an Acumatica customer.  In this article, I’ll go about answering these questions and more, so you can evaluate how a data warehouse can help you with Acumatica data management analysis processes.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

In this article, we’ll discuss the effect data warehousing can have for the Sage X3 user experience, so that you and your team can figure out what is today’s best solution for your company.

Data is driving business decision-making, which perhaps doesn’t seem like a shocking statement.  However, as data grows in amount and in significance, data warehouses are relatedly an important aspect of business today.  If you’re like me, you are wondering the who, what, when, where, why, and how of data warehousing.  Who manages a data warehouse?  What do they look like?  When is a good time to invest in a data warehouse?  Where do you house one?  Why should we go with a data warehouse over other Business Intelligence (BI) data stores?  How do we set up a data warehouse?  As a Sage X3 customer, you might have one or more of these questions.  This article will aim to answer your questions, so you can understand the product category and can begin to assess your data warehousing needs with Sage X3.

Who?  Let’s start by discussing who implements and automates a data warehouse.  Commercial data warehouse solutions usually come “out of the box” ready, meaning a simple installation process, then replication of your Sage X3 and other source data.  A consultant who specializes in extracting, transferring, and loading (ETL) will deploy your data warehouse, automating the ETL of data from your sources, like Sage X3.  After that, a consultant who focuses on expediting, optimizing, and streamlining reporting, budgeting, and/or dashboard tasks will work with you on querying data from your warehouse.  After setup and training, the business end user can manage a data warehouse, eliminating IT middlemen.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

In this article, I will go about demystifying the purpose and functionality of data warehousing for Microsoft Dynamics AX customers, so that you can hit the ground running in your search for the best Business Intelligence data storage source for your organization.

Data continues to rule the business world, driving more informed decision-making for better business practices.  Hence, the rise of data warehouses.  You’ve definitely heard of them, but do you know the ins and outs of the prominent data sources?  For Microsoft Dynamics AX users, you might have questions – several even – but don’t know where to start, don’t feel like you have the time to learn about the software, etc.  That’s where this article comes in, answering the most common questions Dynamics AX users might have, so you can understand the product category in order to figure out your own data warehousing goals.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will go about explaining the impact of data warehousing for Sage 300, so that you and your team can get a head start figuring out the best modern solution for your company.

Since data is such an important topic in the world of business, it makes sense that data warehouses are going to be prominent by association.  However, questions of who, what, when, where, why, and how rapidly start to pile up for most of us because firstly, what do data warehouses even look like?  Are they tangible, physical items where you can store files, like an external hard drive?  Who maintains them?   When should we be investing in a data warehouse?  Where are they hosted?  Why do we need one?  And how do we get started with our data warehouse?  For Sage 300 customers, maybe these questions have crossed your mind – and perhaps there are other confusing elements that you would like addressed before understanding whether or not you even need a data warehouse.  In this article, I will answer some of the main questions Sage 300 customers might have, so you can comprehend the key features and functionalities in order to pinpoint your team’s data warehousing needs.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

This article will answer your questions about data warehouses for Microsoft Dynamics AX, so you can make a decision about what your best options are for your organization.

Because data is a buzzword in the business world, it follows that data warehouses are going to be relevant by proxy.  But the who, what, when, where, why, and how questions quickly surface for a lot of us because first of all, what are we picturing here?  Is it an actual physical storage space, like an external hard drive?  Who manages it?  When should we be considering an investment in such a device?  Where is it staged?  Why would we need one?  And how do we deploy a data warehouse?  For Dynamics AX customers, these might be questions you have – and there might be other outlying confusions and curiosities that need answered before any action can be taken.  This article will explore the details of data warehousing for Microsoft Dynamics AX customers, including the key features, so you can understand your team’s specific data warehousing needs now or in the future.
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.

Data integrations can be confusing, and they make a difference when picking the right BI tool.  This article will discuss the difference between live reporting for Microsoft Dynamics versus data warehouse or OLAP cube integrations.

Data, data, data.  These days, companies are swimming in it.  Transactional and operational information is a required aspect of conducting business these days – for many reasons, but perhaps, especially when it comes to making important decisions about the future of the company.  Business Intelligence (BI) involves analysis of enterprise data for understanding of trends and trajectories, successes and failures, as well as related planning or forecasting for the fiscal year.

Whether a company is using an OLAP cube or some sort of data warehouse, important company facts and figures, such as transactions, personnel information, and inventory, are used in Enterprise Resource Planning (ERP) systems and BI tools like financial report writers, budgeting solutions, and dashboards.  When selecting which BI tool to use, an important question arises pretty early in the selection process: is it more advantageous to integrate live to and from ERP systems like Microsoft Dynamics, Sage, Acumatica, or SAP Business One, or to integrate to a BI data storage option?
Read more

The information you are reading is more than 2 years old and may be outdated. Read new blogs.
Data-Warehouse-vs-OLAP-Cube