Posts

This article will focus on your options for modern financial budgeting solutions for your Intacct ERP solution.

Image taken from Shutterstock.

Image taken from Shutterstock.


Budgeting is a vital and important process, regardless of whether you are planning your personal finances or managing your organization’s budgets and forecasts. We have been seeing more and more budgeting tools hosted on the cloud and even though it seems pretty straightforward, most companies are still used to hosting their corporate performance management (CPM) tools on premises. Choosing the right budgeting solution for your industry that integrates smoothly with your Intacct enterprise resource planning (ERP) system can be challenging, but you have powerful options, and it will give you more knowledge about budgeting solutions for your company. In this article, we will explore Cloud-based budgeting and some of those solutions for your Intacct ERP system.
Read more

This article will discuss your options for modern financial reporting solutions with Intacct.
Financial reporting is the cornerstone of corporate performance management (CPM), as the process does the work of summing up the financial health of your company. Today’s business world relies on financial reporting in a major, indispensable way. As it is a requisite aspect of running a business, automation of reporting processes and streamlining the content only makes sense. As you seek to understand the data that you pull from cloud and on-premise technologies, reporting is becoming more crucial, even just as a way to consolidate information. This article will zoom in on second generation cloud reporting tools and how the right one can benefit your data management and analysis tasks from your Intacct ERP system.
Read more

This article will focus on financial reporting software options for Acumatica users.
 

reportingFinancial reporting is arguably the meat and potatoes of corporate performance management (CPM) as your company goes about the work of summarizing the financial well-being of your organization. In the modern business world, there is no way we can avoid financial reporting. It is mandatory, whether we like it or not, so why not automate the reporting process and streamline the report content? As we make sense of all the data that we can collect from our cloud and on-premise technology, reporting is only becoming more important.​ In this article, we will discuss the second generation of cloud reporting tools and how that will benefit your organization in managing and analyzing data from your Acumatica ERP system.

Read more

This article will focus on Cloud-Based analytics for Banks in the Era of Data Hackers.
 

Image taken from Pixabay.

Image taken from Pixabay.


Getting to know all about you – A $1 Billion Credit Union recently approached me wanting to know my methodology to Corporate Performance Management (CPM) before they wanted to see a product demonstration.  Their ultimate goal is to have me perform a Data Analytics Assessment to see how good their current CPM process is before recommending any improvements. 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 focus on the Enterprise Budgeting on Cloud for Banks.
dashboard benchmarkingThe Cloud is coming!  Are you prepared?  I read a story once about a land that was going through a drought, famine, and warfare.  After a momentous battle, a leader told one of his lieutenants, “Go up now, look toward the sea.” So the lieutenant went up and looked and said, “There is nothing.”  And the leader said, “Go back” seven times. Read more

Image taken from Shutterstock


This article will zoom in on the newest major public cloud provider, Microsoft Azure, and what you need to know about their cloud services.
In the enterprise technology realm, all you hear about these days is cloud, cloud, cloud.  And the forecast continues to be cloudy with 100% chance of more cloud.  Cloud technology has taken its time in terms of becoming a refined, trusted, and widely adopted culture-redefining presence in the world of business, but with Microsoft entering this arena, you know it’s just getting good.  Microsoft Azure joins the ranks of Google Cloud and Amazon Web Services in offering what modern businesses are seeking: public cloud services.  Cloud service providers, like Microsoft, Google, and Amazon are providing virtual machines, data management, web apps, and more, so that your business can be conducted from anywhere with an internet connection, all while being managed by the cloud vendor.  This article will explore Microsoft Azure, specifically looking at their cloud services – and what that functionality means for those that are looking at Cloud business intelligence (BI) and corporate performance management (CPM) solutions.
Read more

This article will focus on the Top Cloud-based Reporting Tools for Banks.
 
Top Cloud-based Reporting Tools for Banks
Why was Dick Tracy’s watch so cool?  Dick Tracy was the main character of a comic strip that started in 1931.  He was a police detective that used forensic science, advanced gadgetry, and wits to catch the bad guys.  This series was the beginning of today’s police procedural mystery stories—although the Dick Tracy stories often ended in gunfights just the same. His stories typically follow a criminal committing a crime and Tracy’s relentless pursuit of the criminal.
Read more

This article will focus on the Best Excel Reporting and Budgeting Tools on Cloud for Banks

bankincomestatementExcel: How do I love thee? Let me count the ways. (Sonnet 43) – The reason why we all love Microsoft Excel so much is that you can create almost any report you can imagine.  Take for example this Business Process Management (BPM) report.  BPM is a systematic approach to making an organization’s workflow more effective, more efficient and more capable of adapting to an ever-changing environment.
Read more

award-best-work-la-2019

This article focuses on the future of Dynamics GP Users and their Reporting and Budgeting tools.

Photo taken from Shutterstock.

Photo taken from Shutterstock.

Why are many companies still keeping their Dynamics GP ERP system on-premise when there is a cloud option available? Some may not know the options to migrate to the cloud. Others may feel safer using a more traditional platform. Microsoft just changed the whole game for Microsoft Dynamics Enterprise Resource Planning (ERP) users. A true cloud version of Microsoft Dynamics, Microsoft Dynamics 365, officially released this November 1st. Dynamics 365 lets companies combine CRM, ERP and Microsoft Office capabilities into the next generation of business applications in the cloud. This Azure-hosted Dynamics service seems to be the true future for many Dynamics GP customers. Therefore, if your company is slowly making its way to the cloud, and on premise tools are most likely developed less progressively, eventually moving to Dynamics 365 or other CRM/ERP tools seems a pretty interesting alternative. This article focuses on the steps your company will need to take when your ERP is moving to the cloud.
Read more