Hanna Kim
Best Report Writers for Sage 100

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.

Screen Shot 2016-05-27 at 8.31.02 AM

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.

Continue reading

Hanna Kim
Not-for-Profit Financial Reporting and Roll-ups with Dynamics GP

This article focuses on financial reporting and roll-up solutions for not-for-profit organizations utilizing Microsoft Dynamics GP.

NFP Fin Cons GP

Financial reporting and consolidations can mean different things to different people. Many larger Microsoft Dynamics GP not-for-profit customers are managing the finances of a parent organization with multiple locations rolling up to it. First things first, let’s define financial roll-ups or ‘consolidations’ as it is typically called in the corporate world. It can simply mean that an organization is combining data from multiple locations either as part of the planning process or for reporting purposes. It can also mean a lot more than just combining data. Financial consolidation is the process of aggregating transactional data from several departments and from multiple business entities within a company for the parent company. In these cases, simply combining data can be complex for multiple reasons. For instance, legal entities can have different charts of accounts or fiscal years. They may also be partially owned. This article will explore the elements and functionalities of financial consolidation for your non-profit organization using Microsoft Dynamics GP.

Continue reading

Hanna Kim
How Do You Know If You Need a New BI/Analytics System?

This article will help organizations identify signs that they need a new Business Intelligence system.

Trend in Business Intelligence for H2 2015

Today, plenty of large organizations, as well as small and medium-sized companies, are stuck using old or manual Business Intelligence (BI) tools that are in desperate need of a replacement. BI translates to technology-driven processes for analyzing data and presenting information that will help companies improve the decision making processes at all levels of management. Well, how do you know if you need a new BI/Analytics system? You should begin by constructing the right set of questions. What tool(s) does your organization have to have right now? What are your BI goals, and what is your schedule for building the BI toolbox to meet analytical goals? Also, outdated BI systems show several warning signs such as wasting time, harming decision-making, and keeping organizations from taking advantage of their data.

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

Hanna Kim
Power BI: What Is It and Why Should I Care?

This article focuses on Power BI and the influence it has on your organization’s data.

Power BI

Do you ever feel like you’re inundated with information that doesn’t matter to you? If you’re nodding your head, then Microsoft Power BI might be an option for you. Power BI is a data visualization tool that helps users stay up to date with information that matters to them and complements their current third party and ERP reporting tools by bringing their data to life through visualization. Microsoft defines Power BI as “a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.” The services and features enable you to find and visualize data in a compelling way, share discoveries, and collaborate in intuitive new ways.

Continue reading

Hanna Kim
Manufacturing and Distribution Data Warehousing with Dynamics NAV

This article will explore the impact of a data warehouse solution for manufacturing and distribution companies using Microsoft Dynamics NAV.

Data-Warehouse-for-NAV

When it comes to making decisions within a company, data rules all. Organizations use data to set and meet goals in order to stay on budget. Data warehousing is a powerful solution to organize and strengthen Business Intelligence (BI) analyses. A data warehouse is a multi-dimensional database that can store a large amount of data, accumulated from a wide range of sources within a company and used to guide management decisions. They are not live, real-time integrations; therefore, the information in data warehouses can be used for 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, sales, or product. As a manufacturing or distribution NAV user, you may want to know the impact a data warehouse solution has for your company. In this article, I’ll go about explaining this solution for these two industries using NAV for managing data and analytics.

Continue reading

Hanna Kim
BI and CPM Systems for Beginners

This article will discuss how Business Intelligence and Corporate Performance Management systems differ – and how they overlap.

Many find the word ‘Business Intelligence’ (BI) often ambiguous and confusing. It can simply mean that you know something about the business, but Gartner, the world’s leading IT research company, defines BI 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 the right knowledge to the right people at the right time to make informed decisions.

Continue reading

Hanna Kim
An Introduction to the Business Intelligence World

This article is an introduction: I’ll tell you a little bit about myself and my entry into the Business Intelligence realm, as well as my plans to blog about management solutions.

My name is Hanna Kim, and I’m an Angeleno. If you live in Los Angeles, you will notice that the city is not full of natives, but it is rather a melting pot of people with interesting stories, and I absolutely admire that about this city. As a story lover, I love traveling. I enjoy learning about different cultures and history, but the most fascinating part of traveling is finding layers about myself that I never knew about. It is always a humbling experience.

Continue reading

Karen Barak
Get your BI360 Guru on at Focus 2016!

Your company has put tens or hundreds of thousands of dollars into acquiring a budgeting and planning software system that will streamline your staff’s workload. Chances are, that even after training, you or your team has only been using a small percentage of the features or functions available in the solution.

Now, you or your team might wish to rediscover the full range of attributes, or you might even be seeking solutions to more complicated business process matters. Those answers and more can be found at Focus 2016, August 22-25, 2016, located at the Hilton La Jolla Torrey Pines, San Diego, CA.

For four days in August, dozens of BI360 product experts, hundreds of technology professionals and BI360 users will gather to impart their wisdom to help you and others like you become BI360 gurus in their own right.

Continue reading

Matthew Felzke
Building a Best-of-Breed Business Intelligence Solution for Sage 500

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.

Continue reading