Posts

Image taken from Shutterstock

This article will explore the benefits of a data warehouse for Healthcare organizations using Sage 100.

All organizations rely on data to identify and meet goals, with plans for growth and development budgeted.  Data warehousing is a powerful option to structure and enrich business intelligence (BI) and corporate performance management (CPM) analytics.  A data warehouse (DW), by definition, is a multi-dimensional database that can house a significant amount of information, deriving from an assortment of sources within an organization, used to make good management decisions.  Your information in DWs can be used in reporting, routine budgeting and forecasting, and dashboards – or big picture performance data questions.  A DW organizes by subject, focusing interactions through topics, like financials, patients, services, or clinics.  If you’re a Healthcare organization using Sage 100, this article will highlight the impact of a DW for your team.
Read more

This article will focus on Microsoft Excel Reporting for Banks and how it has evolved over time.

Origins:  I met Harold as my new boss in 1989 when I became Controller for a small subsidiary of a bank.  At the time, I was a Lotus 1-2-3 disciple.  I was great at writing macros and spitting out reports.  The one thing I hated about Lotus, however, was its poor printing capabilities.
Harold introduced me to Microsoft Excel and its ability to set and preview the print area made me convert overnight.  Harold said he loved the ability to type numbers into Excel every month, so he could get a good feel for the financials.
Read more

This article will discuss modern, dynamic reporting for media organizations that use Microsoft Dynamics GP, including what to look for in a software solution.

Financial reporting is absolutely unavoidable in the modern business world.  We’re all doing it, whether it is a homegrown Excel process, a legacy program, the native Microsoft Dynamics GP report writer, or an independent software vendor (ISV) solution.  And the media industry is no different.  In terms of process improvement, upgrading your reporting writing processes with a new solution means automated financial statements, modern security, accessible collaboration, and self-service analytics.  This article will explore what you should be looking for in a report writer to meet today’s analytical objectives, zooming in on what a reporting tool should offer you as a media organization using Microsoft Dynamics GP.
Read more

This article focuses on using dashboards in monthly financial presentations for stronger decision-making.

Image taken from Shutterstock.

Image taken from Shutterstock.


Graphics are everywhere. They are literally everywhere we go, filling our kitchen pantries and even the clothes we wear. Red Crow Marketing Inc. mentions that “digital marketing experts estimate that most Americans are exposed to around 4,000 to 10,000 advertisements each day.” If we’re drawn to visuals, doesn’t it make sense to apply visuals to your financial reports and presentations? Think about receiving multiple pages of spreadsheets full of data. Is this how you best extract your financial analysis at the end of every month? This is where a dashboard comes in handy. Dashboards are defined as charts, graphs, and scorecards that convey data trends, successes, and problem areas with key performance indicators (KPIs), whether you are looking at a store, region, product, and a corporate department in particular, or the entire organization. A dashboard presents key data from various financial and operational sources on a single page, and uses graphs and tables to summarize a large amount of data. In this article, Solver Controller Gina Louie will talk about her experiences in presenting month-end financial presentations to the management team.
Read more

This article will focus on key benefits of a data warehouse (DW) when associated with your cloud- and on-premise data sources.

Image taken from Shutterstock.

Image taken from Shutterstock.


Have you watched a Tasty food video on Buzzfeed? The videos always start with a default still of the finished dish, then gives the viewers a tutorial of the ingredients and measurements that go into the recipe. In the same way, a data warehouse (DW), a platform where all of your important data sits, can be seen as the final meal and the ingredients can be interpreted as the different data sources that make up the recipe, in this case, the analysis. Just as ingredients come from different origins, data sources come from different places. This article focuses on the benefits of data warehousing while being on-premise and the cloud.
Read more

Image taken from Shutterstock.

This article will highlight the top 5 corporate performance management trends for 2017, zooming in on features and functionalities and looking at the bigger picture roadmap for the marketplace.

It’s that time of the year again – the beginning of the year, specifically – where we move from organizing ourselves and goalsetting to the work of achieving our objectives.  There appears to be a collective understanding that 2016 was a rough year, at least in pop culture, no doubt a result of social media and specifically, the meme-driven culture.  Regardless of your perspective on how the business world fared in 2016, a new year brings with it a chance to do better, to improve processes and outcomes of teamwork.  And in that vein, this article will zoom in on the trends you can expect to see emerge for Business Intelligence (BI) and Corporate Performance Management (CPM).
Read more