Posts

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

This article covers data warehousing, both generally and more specifically for Professional Services organizations who are looking to expand their Acumatica analytics.

In the business culture of today, maybe particularly for Professional Services companies, data is king.  Since data drives decision-making, and Professional Services teams are working smartly to stay on track and on budget with clients, projects, vendors, and so forth, data warehousing can be really effective to support Business Intelligence (BI) analytical tasks.  When I first learned about a data warehouse as a solution, I had questions, so you might as well.  In this article, I’ll go about providing the answers you need about data warehousing with Acumatica for your Professional Services organization.
Read more

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

This article will discuss data warehouses, both in general and specifically for non-profit organizations, who are seeking to expand their Intacct analytical processes.

In the world of business today, data is everywhere, perhaps especially for non-profit organizations.  Because data informs decision-making, and non-profits are working hard to stay on budget and/or on track with donors, grants, members, and so on, data warehouses can be really impactful to Business Intelligence (BI) processes.  I know I had questions about data warehousing when I first heard of the product category, so you might, too.  This article will aim to provide you the answers to general and specific questions about data warehouses for managing and analyzing your non-profit data with Intacct.
Read more

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

In this article, data warehouses will be the focus, so you know what to look for in a BI data storage solution for the benefit of your Intacct experience.

Everywhere you look in the business world, data.  Because of data’s significant role in corporate decision-making, data warehouses have become a heavy-hitting tool for companies today.  In my first interaction with the concept of data warehousing, I had some questions, from basic to logistical, so I’m assuming you feel the same.  How do you manage a data warehouse?  Can I hold the product in my hands?  How does deployment happen?  And why a data warehouse in the first place?  If you have these questions or more Intacct-specific curiosities regarding data warehouses, this article will hopefully provide you with the answers you seek, so you can envision how a data warehouse solution can assist you in Intacct data management and analysis tasks.
Read more

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.

If you’re like most companies, you rely on multiple data sources, each with different reporting tools to manage company information and analysis processes, but you need to bring together all of that data for richer analytics.  This article will discuss data warehouses as the solution.

Almost all companies of any size are relying on multiple data sources for company information, such as an Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), Payroll, and vertical industry systems, perhaps as well as data sitting in manual spreadsheets.  Even if you have a great accounting system report designer or pre-built online analytical processing (OLAP) cubes as one of your data sources, one of the biggest ways for management to make sound business decisions requires the ability to utilize financial reports and/or dashboards to look across all of your company information.  Unfortunately, each of the data sources or systems typically have their own unique BI tools.  And that’s where a data warehouse comes into the equation, likely solving this prevalent business problem.  This article will discuss the benefits of a data warehouse (DW) as a solution to data management with a Microsoft SQL Server.
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