Posts

Cloud Reporting for IntacctThis article explores the cloud reporting options you have for replacing FRx and Management Reporter.
Sometimes, it’s hard for me to believe that some companies might still be using FRx, as the product was retired by Microsoft – and replaced with Management Reporter (MR) – years ago. But MSDynamicsWorld.com recently hosted a webinar about replacing either, and hundreds of registrants attended. When I zoom out and think about process overhauls or technology replacements that I have been a part of, for the most part, they generally haven’t happened rapidly. Also, we’re all regularly in the trenches of our jobs, in this case producing reports or consolidating company financials for an understanding of company health, so taking the time to research, watch demos, have calls with sales folks, and test the power and viability of a new product can be tough. But as companies look to replace FRx and MR and at the same time prepare for a future move to a cloud ERP system, we’re seeing a lot of finance departments take the first leap by implementing a modern cloud reporting and budgeting solution, proving that a true business improvement momentum is building in the enterprise technology sector. This article will discuss the power of cloud reporting options not only to replace FRx and MR, but also as a strategic catalyst for a bigger picture cloud technology migration.
Read more

Have you ever started a new job in an industry you have no experience in? Learning the industry jargon can be overwhelming. I can personally attest to this because prior to working in the

Business Intelligence (BI) and Corporate Performance Management (CPM) worlds, I was in the food, public relations, and entertainment industries, and did not have much experience in BI or CPM. If you have recently been exposed to BI tools, such as report writers, budgeting and planning solutions, dashboards, data warehouses (DWs) and you feel like a deer in headlights, there is no need to panic. In this article, we will discuss ten acronyms in the BI/CPM realm that will help you understand and enhance your experience with BI and CPM processes.

Here are the top 8 business intelligence acronyms that may be resourceful when dealing with BI & CPM solutions

1. Extraction, Transformation, and Loading (ETL)

ETL represents three database functions that are combined into one tool to extract data from one data source. The ETL process is the practice of extracting data from data sources and transferring it into the DW. ETL isn’t necessarily three defined steps, but rather a broad process.

2. Data Warehouse (DW)

Informatica defines a DW as an acronym for data warehouse meaning, “technology that aggregates structured data from one or more sources so that it can be compared and analyzed for greater business intelligence.” The term “Data Warehouse” was coined by William H. Inmon, an American computer scientist. This is an analyst’s dream because all the metrics about the organization’s activities are gathered in one place. You can find out more about the details of a successful data warehouse here.

3. Relational Database Management System (RDBMS)

A RDBMS is a program that enables users to administer, create and update a relational database. Commercial RDBMS typically use the Structured Query Language (SQL) to access the database. A relational database is described as “a set of tables containing data fitted into predefined categories” by TechTarget.

4. Online Analytical Processing (OLAP)

OLAP, also known as “OLAP cube,” performs multidimensional analysis of data and offers the ability for complex calculations, advanced data modeling, and trend analysis.

5. Key Performance Indicator (KPI)

A KPI is a lot like a GPS navigation system as it allows the driver to be in complete control when making decisions about where to steer next. KPIs are navigational tools that your company will utilize to understand whether the business is on a successful route or whether it’s veering off. According to Klipfolio, a KPI is “a measureable value that demonstrates how effectively a company is achieving key business objectives.” You can learn more about KPIs and KPI strategies in detail in the following articles: 10 Steps to Successful KPI and Metric Design Using Dynamics GP, Part 1 and 10 Steps to Successful KPI and Metric Design Using Dynamics GP, Part 2. Keep in mind that there are vertical specific KPIs; therefore, do some research.

6. User Interface (UI)

In the IT world, UI is designed into a device within which a user can interact. This includes keyboards, display screens, a mouse, and a desktop. It can also include how a user interacts with the application or the website. Companies’ dependence on applications has led organizations to prioritize improving the user’s overall experience, also known as UX.

7. SQL Server

Microsoft SQL Server is a relational database management system that was developed by Microsoft.

  • SQL Management Studio (SSMS) – SSMS is an integrated environment used to administer a SQL Server Infrastructure. If you’re not familiar with a SQL Server, it is a relational database management software developed by Microsoft.
  • SQL Server Integration Services (SSIS) – SSIS is used to execute a wide range of data migration tasks.
  • SQL Server Reporting Services (SSRS) – SSRS is also part of the SQL Server services. It is a server-based report generating system that stores metadata and object definitions. You can learn more about the SQL Server on the Microsoft site.

8. Amazon Web Services (AWS)

AWS is a subsidiary of Amazon, and offers cloud computing platforms. AWS is also the competing platform against Microsoft Azure, formerly known as Windows Azure. Companies will be more exposed to AWS and Microsoft Azure as the cloud gets bigger. Cloud Computing platforms provide an easy way to access storage, servers, databases, and applications. It also provides quick access to flexible and low-cost resources.

If you are in the BI/CPM space, you may have seen the terms above used widely. For those who are new to the industry, I hope defining and laying out these terms give you a better understanding of the BI/CPM industry as well as the industry jargon. We’re happy to answer questions and generally review Solver’s web-powered, easy-to-use Excel and mobile BI tools with both real-time or data warehouse integrated analysis, budgeting and collaboration as a way to accelerate your company performance management experience.

Solver enables world-class decisions with a leading web-based CPM suite made up of budgeting, reporting, dashboards, and data warehousing, delivered through a web portal. Solver is reinventing CPM with its next generation solution. BI360 empowers business users with modern features including innovative use of Excel in the model design process. If you’re interested in learning more, our team is excited to hear about your organizational needs and goals.

This article will discuss the process of preparing for a successful financial reporting implementation.

Image taken from Shutterstock.

Image taken from Shutterstock.


In the modern business realm, you cannot avoid financial reporting. Whether it is a homegrown Excel process, a legacy software program, an independent software vendor (ISV), or a native enterprise resource planning (ERP) report writer, every company is doing it. Investing in your first modern reporting tool typically means automated financial statements, accessible collaboration, modern security, and self-service analytics. Don’t worry if it sounds like gibberish to you. In this article, we will discuss preparing for your first reporting implementation so you are able to select the best reporting tool to navigate your organization in managing and analyzing data.
Read more

In this article, we’ll explore what Business Intelligence solutions can do to help you achieve a best-of-breed Sage 100 experience that drives smarter organizational decision-making.

The modern business world moves at such a pace that it is imperative that our tools be accessible and flexible for our analytical processes.  Mobile applications are just one example of how independent software vendors (ISVs) are delivering Business Intelligence (BI) tools that speak to consumer needs for financial reporting, data management, and analytics for Sage 100 business intelligence users.  Today, you should be investing in BI technology that is nothing short of the flexibility you require, in terms of how you get to your transactional and operational information for more streamlined, smarter decision-making, regardless of where you are working.  Third party software vendors are bringing flexible BI solutions to market for an upgraded, modern end user experience.
Read more

This article will discuss the benefits of consolidating your many reporting tools.

reporting
How many of us use five or more report writers across our business systems? I know it sounds absurd, but most organizations do use that many reporting tools across their ERP system and other databases. When looking to invest in a reporting tool, how you integrate and present your data is very important. It is the backbone when it comes to making wise business decisions. In this article, I will focus on various options for consolidating multiple reporting tools to navigate your organization-specific issues in managing and analyzing your data.
Read more

This article will discuss the benefits and drawbacks of Sage Business Intelligence and Third Party Solutions.


shutterstock_forecastingbudgeting

Choosing the right Business Intelligence (BI) solution for your company is a lot like choosing what you need to eat for a healthier lifestyle. Is your company lacking nutrition? What does it need to help that problem and make better decisions? BI is an exciting realm to delve into because it does a number of things. It gives insight into consumer behavior, it improves efficiency, it increases productivity, and it turns data into actionable information. According to Gartner, the world’s leading Information Technology (IT) research company, BI is defined as “an umbrella term that include the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance.” The objective is to provide organizations the right knowledge in the hands of the right people at the right time to make informed decisions. BI increases the ability to identify trends and challenges, as well as fine-tune operations to meet business goals.
Read more

This article focuses on modern features and functionalities for financial reporting, so you have a better understanding of what to look for when seeking a tool to improve your experience with Sage 100.

Trend in Business Intelligence for H2 2015

Photo taken from Shutterstock.


In today’s data-driven world, your organization needs a powerful financial reporting tool to help you stay competitive in your industry.  In this article, I will explore the Business Intelligence (BI) options you have for software, specifically looking at feature and functions, so you can select the best reporting tool to navigate your organization-specific issues in managing and analyzing your data as a Sage 100 user.
Read more

This article discusses independent software vendor tools that will turbo-charge data management and analyses for Sage 500 users wanting to build a best-of-breed solution.

Some Sage 500 users will probably always wonder why they would want or need to deploy independent software vendor (ISV) tool(s) on top of their accounting system.  This confusion is perhaps an obstacle for ISVs and a concern for some Sage 500 users.  There are a couple of clarifications that seem to organically come out of the conversation.  First, no ISV can create a tool that can be a solution for every single organizational hurdle.  A great example would be how competitive mobile device brands, like Apple or Android, provide their own native mapping applications, but still allow you to download an app from another manufacturer, which is similar to modern flexible enterprise resource planning (ERP) systems, like Sage 500.  Because every organization using Sage 500 has particular objectives, specific budgeting requirements, and rules, the accounting system vary in how effective it is for each company.  ISV technologies enable organizations to customize their data management and analytics.
Read more

This article focuses on financial reporting options for non-profit organizations utilizing Microsoft Dynamics GP, zooming in on features and functionalities to expand your analytics.

Financial reporting has traditionally been the lead singer if Business Intelligence (BI) processes were in a band, and it is no different for non-profit organizations.  If you’re utilizing Microsoft Dynamics GP, you know that the accounting system is equipped with several native financial reporting functions.  However, plenty of organizations are moving to independent software vendor (ISV) offerings for their regular financial reporting tasks, but why?  Third party software solutions for financial report writing are designed in response to consumer demands, streamlining and expanding analytics for more robust insight into your data, trajectories, successes, and challenges.  This article will explore the benefits of an ISV financial report writer for non-profit organizations using Microsoft Dynamics GP.
Read more

Independent software vendor (ISV) tools expand and streamline data management and analytics for Intacct users building best-of-breed Business Intelligence (BI) solutions.

One question that sometimes comes up in conversations with Intacct customers is related to confusion as to why you might need to deploy ISV tool(s) on top of the accounting system.  This is a small hurdle for ISVs as the confusion seems to quickly dissipate for the Intacct community.  First of all, no software solution, even as great as Intacct has proven to be, can answer to every single business-related analytical hurdle for every company.  A perfect example would be Apple offering their own native Maps applications on their iPhones, but still allowing consumers to install the Google Maps app, just as any modern flexible enterprise resource planning (ERP) system, like Intacct, does.  Because every organization who utilizes Intacct has particular objectives, specific planning needs and rules, the accounting system will differ in how sufficient of a solution it is for each corporation.  ISVs provide businesses the capability to customize their data management and analytics.
Read more