Hanna Kim
Data Warehousing for Manufacturing Companies Using Sage 100

This article will zoom in on the impact of a data warehouse solution for manufacturing companies using Sage 100.

DW for Sage 300

Photo taken from Shutterstock.

Corporations use data to set and meet goals in order to stay on budget. A data warehouse is a powerful tool to organize and strengthen Business Intelligence (BI) analyses. A data warehouse (DW) is a multi-dimensional database that can store a large amount of data, collected from an array of sources within a company and utilized to guide management decisions. The information in data warehouses can be used for things such as scheduled budgeting, reporting, and dashboards or higher level performance data questions. They structure around the subject, so they focus the interaction through organizing by topic such as customer, product, or sales. As a manufacturing company using Sage 100, you may want to know the impact a data warehouse solution has for your company.

Continue reading

Hanna Kim
Excel-based Budgeting Tools versus Web-based Budgeting Tools (Budgeting Series)

This article focuses on the difference between Excel-based and Web-based budgeting tools.

Choosing the right budgeting tool is extremely important for a growing company. Many financial companies use homegrown Microsoft Excel models extensively in their budgeting, but there are some limitations that are inherent in the application. I admit Excel is a great tool for modeling and analysis, but it is not the best tool to use for budgeting. Software companies are developing commercial budgeting tools that are Excel-based and Web-based to stay familiar with the features and functionalities that most professionals are accustomed to. In this article, we will explore the advantages and the drawbacks of both Excel-based and Web-based budgeting tools that organizations experience. This article is the third installment of our series on budgeting: Excel-based Budgeting Tools Versus Web-based Budgeting Tools.

Continue reading

Hanna Kim
Live ERP Budgeting, What Is It?

This article will touch on the basics of budgeting with your ERP system.

ERPBudgetingBI360

The process of investing in a new Enterprise Resource Planning (ERP) software can be a daunting task. Where do you start? Do you find reviews online and hope they are in line with your company’s needs and goals? Let me break it down for you. We’ll explore the basics of ERP from software pricing to ERP utilization with third party budgeting solutions.

Continue reading

Hanna Kim
Budget Consolidation in Multi-Entity Organizations (Budgeting Series)

This article focuses on consolidating finances from multi-entity companies.

Photo taken from Shutterstock.

Photo taken from Shutterstock.

Nobody likes growing pains, but every company wants to grow. Growing pains are symptoms that an organization needs to make a transition. It is the nature of business. There is a way to alleviate these pains through automated consolidation of your company’s budget. Budget consolidation, just like financial consolidations, is growing in significance because of reasons such as globalization and the popularity of acquisitions and mergers. Nowadays, it is not uncommon for a mid-sized organization to own many legal entities in different locations. Although a business’ budget consolidation requirements may not be that complicated, creating a set of consolidated accounts can be time consuming and prone to many errors if done in Microsoft Excel spreadsheets. There are many financial consolidation tools and solutions that can also automate the consolidation of your budgets and they can replace or improve existing processes and systems. This article is the second installment of our series on budgeting: Budget Consolidation in Multi-Entity Organizations.

Continue reading

Hanna Kim
Professional Services Dashboards with Dynamics AX

This article discusses dashboard solutions for Professional Services organizations hoping to expand their Microsoft Dynamics AX analytics.

ProServ Dashboards Dyn AX

We’re all collecting data – stacks and stacks of data. How do we use this data to make it worthwhile? It often comes down to dashboards and data visualizations including charts and graphs. According to Gartner’s survey on financial Executive International CFO Technology, dashboards and scorecards are top priorities in terms of software that executives are seeking. Companies are bombarded with useful information every day, but they often find it challenging to consolidate the information into digestible bits that can be utilized and implemented. Because business is constantly changing and moving quickly, analytics that are accessible and easily digestible is essential.  With dashboards, you have access to graphs, charts, and scorecards that illustrate trajectories, victories, and challenges through key performance indicators (KPIs) and your information to effectively keep a project or the entire company on track.

Continue reading

Matthew Felzke
Top BI and Corporate Performance Management Trends for 2016

This article will discuss the year ahead of us, specifically in terms of what 2016 holds for Business Intelligence and Corporate Performance Management for modern businesses.

Another year has come and gone, seemingly faster than ever – and we’re already into the second month of 2016.  At the end of 2015 or in early January, some people were writing about Business Intelligence (BI) and Corporate Performance Management (CPM) trends they predicted we would see manifest this year.  However, much like my current approach to New Year’s resolutions, I felt it was important to let the dust settle, work through the workload hangover of the holidays, and have the New Year function as a soft opening.  This way, we can approach 2016 with a rolling start that doesn’t set us up for failure.  This article will discuss some key trends and trajectories that data management and analytics will take in 2016.

Continue reading

Matthew Felzke
Business Intelligence Trends for the Second Half of 2015 and Beyond

This article will discuss what is trending in terms of Business Intelligence, specifically what you should know about for the rest of 2015 and beyond, so you can continue to make strong, data-driven decisions.

July 1 has come and gone, and we’re flying at full speed in the second half of 2015.  Conferences, summits, business deals, partnerships, and other organizational happenings fill up our days, months, and years, but we have to stay focused on so many things directly related to the success of our company.  One of those things has to be how we access, manage, and analyze our data for stronger, more informed decision-making.  In this article, I’ll discuss what you need to focus on in terms of Business Intelligence (BI) trends for software solutions and how we conduct our analytical processes.

Continue reading

Matthew Felzke
Top BI and Performance Management Trends for 2015

This article will discuss what to expect, what is up and coming, and what will rule in the business world, with a specific focus on the Business Intelligence processes our finance and executive teams will continue to be charged with improving in 2015.

I don’t know if you feel like this, but the new year came and went so quickly, and here we are in the second half of January.  We’re not only back in the swing of things, but business is racing as usual.  Sometimes, it seems as if we can get lost in the hustle of catching up from the holidays, preparing for the next big event, and/or traveling to visit a customer or partner.  But improving processes and staying competitive and connected to the industry, including trends and trajectories for the business world, is still on your to-do list.  This article will zoom in on the top trends for business and specifically performance management, so your company can be in front of developments and evolutions for financial reporting, budgeting, data visualizing, and data warehousing processes.

Continue reading

Matthew Felzke
Data Warehouse Software for Microsoft SQL Server

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.

Continue reading

Matthew Felzke
Financial Consolidations for Microsoft Dynamics and Other ERPs

A financial consolidations tool is essential for any parent company that manages subsidiaries and wants unified reports to analyze overall company health.  This article will explore the key features and functions of today’s financial consolidation software.

There are plenty of Enterprise Resource Planning (ERP) system users that are managing multiple companies or subsidiaries under a parent company.  Making sense of data from different entities, divisions, and sometimes, with different currencies can be a logistical nightmare without a professional financial consolidation and reporting tool.  As data becomes a bigger and bigger part of corporate decision-making, CEOs and CFOs of corporations that own multiple companies are looking for a Business Intelligence (BI) solution that includes a robust and business user friendly consolidation module.  For professionals in this boat, it can be frustrating, but specifically for the typical ERP users, there are not too many choices that combine power and ease of use.

Continue reading