Posts

This article will focus on financial reporting tools for organizations using Dynamics 365 for Finance and Operations, Enterprise Edition, so you can invest in the right solution for your team.
This past November, Microsoft unveiled Microsoft Dynamics 365. Combining the Dynamics customer relationship management (CRM) and enterprise resource planning (ERP) offerings in one unified cloud-hosted solution, there are two versions of Microsoft Dynamics 365. The lower end version of the product is called the Business Edition and is based on Dynamics NAV as a framework. The Enterprise Edition is the higher end version, which is based on Dynamics AX and created for larger corporations in the top of the marketplace. Both are hosted by Microsoft and deployed in the Azure cloud. In this article, we will explore what you should look for in a financial reporting tool for your organization to use with Dynamics 365, Enterprise Edition.
Read more

This article is about data warehouses (DWs) for organizations utilizing Acumatica so you can optimize your reporting capabilities by making the best software investment.
 

Image taken from Shutterstock.

Image taken from Shutterstock.


Have you ever set foot in a factory or a warehouse before? It’s usually a large space that is used as storage for goods. For companies, there has never been a better moment to increase productivity and lower costs. In a warehouse or factory, there is production support, opportunity to expand, packing and processing, saving time and money, and minimizing business risks. The benefits apply to data warehouses (DWs) as well. If you are starting to feel like you are wasting time and energy that can be used toward something else rather than analyzing and managing data with Microsoft Excel, DWs can help by removing tedious manual work and any errors. In this article, we will focus on Cloud DWs so you can make the most out of your Acumatica experience.
Read more

Power BI P&LThis article will discuss the power of combining the forces of cloud corporate performance management (CPM) and Microsoft Power BI for a true best-of-breed solution with Dynamics ERPs.
It’s hard to deny the popularity and buzz of Microsoft’s Power BI. It is the current shining star of enterprise technology, and with the brand power of Microsoft, it has made its way into a lot of companies’ portfolio of systems. It makes sense too: not only does the executive team want data visualizations, but cross-departmentally, information workers of every type can access insight easily and quickly about the health of the organization or the progress of a project. However, dashboards, like charts, graphs, and scorecards, are just one form of reporting and can be limiting for certain teams.
Read more

This article is an interview with Solver CIO Hadrian Knotz about the role of IT in managing cloud and on-premises technologies.
In this changing enterprise technology climate, I knew I wanted to sit down with an IT subject matter expert to learn how companies are managing applications and systems that reside either on-premises or in the cloud. The best person for the conversation is Hadrian Knotz, who is the CIO at Solver, Inc. and is, generally speaking, a gentleman and a scholar. Read on to learn about the challenges facing IT teams who are supporting the technology needs of organizations, big and small – and how these professionals are providing solutions. 
Felzke: Solver has recently launched BI360 Cloud, a cloud deployment Corporate Performance Management (CPM) suite offering, after years of success with the on-premises version of BI360. How have you seen technology management change since when you joined Solver and started leading that team?
Read more

This article is an interview with Solver’s Chief Technology Officer (CTO) Mike Applegate about technology development and enterprise technology management in the Corporate Performance Management (CPM) realm.
 
mike_applegate
 
As many of you know, Solver launched BI360 to the cloud in June, so I decided to sit down with CTO Mike Applegate to discuss life after the cloud launch. Mike leads the product strategy and development team. With Mike’s knowledge and experience, this interview is a must-read for those interested in developing applications that are on-premises or cloud-hosted.
Read more

This article focuses on data warehouses (DWs) for organizations utilizing Dynamics 365 for Finance and Operations, Business Edition so you can make the best software investment by optimizing your reporting capabilities.
 
dwCloudHow do you know if your company needs a data warehouse (DW)? The signs are clear. If you are beginning to feel like you are wasting energy and time due to manual processes as well as analyzing and managing data with a program such as Microsoft Excel, DWs can help immensely by eliminating errors and tedious manual work. If you’re in the Business Intelligence (BI) and Corporate Performance Management (CPM) world, you probably know that Microsoft launched a true cloud version of Microsoft Dynamics, Microsoft Dynamics 365, last November. This enterprise resource planning (ERP) system lets companies combine CRM tools, ERP, and Microsoft Office capabilities into the next generation of business applications. There are two different versions of Microsoft Dynamics 365. The Business Edition is the lower end version built off of the Dynamics NAV product, and the Enterprise Edition is the higher end version based on Dynamics AX. Both editions are created for and deployed in the Azure cloud, which is hosted and managed by Microsoft. This article will cover DWs for your organization using Dynamics 365, Business Edition. Read more

This article explores financial planning and analysis in the cloud for your CPM strategies.

shutterstock_149667980

Image from Shutterstock.


In the budgeting and forecasting realm, Financial Planning and Analysis (FP&A) is becoming more and more relevant. Most mid-sized and large companies have dedicated professionals in FP&A roles due to the constant evolution of finance and the reach across the enterprise. If you are not familiar with FP&A, this article will cover the benefits of cloud for your finances and hopefully, answers any questions you may have regarding to FP&A and the cloud. 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 Excel Budgeting on Cloud for Banks.
 
loan
Nothing is easier than Excel – When it comes to budgeting for a bank, it all starts with the balance sheet.  The main component of a bank’s revenue comes from the interest earned from loans and paid on deposits.  To budget interest, you will need to figure out what the existing loan and deposit balances will look like over the next several months.
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