BI Archives - FMT
[Video] What exactly is BI and Enterprise Reporting Budgeting?
There has been a lot of noise around BI. The advent of PowerBI and Azure Machine Learning coupled with the latest news around Management Reporter and Forecaster have added complexity to the ecosystem. A complexity that stands in the way of you and the tools you need to grow your business. The first half of this video will focus on clarifying the categories and identifying the latest business intelligence trends for Dynamics customers. The second half will introduce a product, Solver BI360, that addresses the data integration, reporting, budgeting and dashboarding component of BI.
How to Install and Configure BI Features on SharePoint 2016 and SQL Server 2016
Contents Setting Up Your Demo Infrastructure How to Install and Configure PowerPivot for SharePoint 2016 How to Install and Configure Advanced PowerPivot Features How to Install and Configure SSRS in SharePoint-Integrated Mode How to Install and Configure PerformancePoint Services The SQL Server 2016 BI stack for SharePoint 2016 adds many important enhancements. With the performance optimizations in SQL Server Analysis Services (SSAS), PowerPivot data models now load faster and client queries now return quicker, resulting in an overall more responsive BI experience. Additionally, enhancements to SharePoint-integrated Reporting Services (SSRS) include improvements with SQL Server 2016, such as new chart types, HTML5 rendering of reports, cross-browser printing, export to Microsoft PowerPoint, and an updated version of Report Builder. Deploying the new BI features to SharePoint 2016 requires careful preparation, as many considerations have changed, due to the new architecture. Excel Services no longer ships with SharePoint 2016, making it a […]
Comparing Corporate Performance Management and Business Intelligence
The difference between Business intelligence (BI) and Corporate Performance Management (CPM) can often become muddled and confusing for businesses looking to choose the right solution for their reporting. While both are very closely intertwined, understanding the differences and similarities between the two is important to choosing the correct option for your business. In this blog, we will help to clear up the confusion between BI and CPM by addressing the similarities and differences between these two systems. BI Business Intelligence describes the technology used to gather and analyze data relevant to an enterprise in order to improve business decision making. This includes ad-hoc queries, OLAP (on-line analytical processing), scorecards and searches. BI can also be used for many types of visualizations such as dashboards, scorecards, and KPIs. While BI is graphically-oriented, it goes beyond just displaying data. BI can also allow users to drill down into a chart or report […]
Tracking Changes in On-Premise CRM 2011 Audit View using SQL
Have you ever found yourself needing to track the changes you make to records in CRM, but feeling uncertain how to do so? If you are using the On-Premise version of CRM 2011, you can leverage the Audit view in SQL Management Studio to easily track your changes. For example, let’s say you needed to track the changes for customers in CRM 2011 On-Premise to show one instance where the data had changed. CRM 2011 on premise Audit view contains all the attributes of a transaction in a string. Changes to a transaction are separated by “,” and the previous values of a transaction are separated by “~”. Unfortunately, using the string alone we can’t query individual attributes to track changes. In order to more easily accomplish this, we would split the values to be able to join to other views or tables. In the following example, we will be […]
FMT Consultants Announces nVerge 2014 - a One-Day Technology Conference Focusing on Microsoft Dynamics GP, Dynamics CRM, Dynamics Marketing, SharePoint, Office 365 and IT Environments
nVerge 2014 takes place on September 25th in San Diego, CA and offers a combination of keynotes, breakout sessions, learning labs, ongoing exhibition with software developers and IT service providers, networking sessions and a post-conference cocktail reception. San Diego, CA, July 29, 2014 - FMT Consultants, a leading San Diego and Los Angeles-based provider of technology solutions, announces nVerge 2014. nVerge 2014 is a one-day technology conference focusing on the latest feature updates and trends for Microsoft Dynamics GP, Dynamics CRM, Microsoft SharePoint, Microsoft Office 365, Business Intelligence, Corporate Performance Management (CPM) solutions, third party software applications for the Microsoft Dynamics product line, hardware solutions and IT services. The one-day conference offers a combination of keynote and breakout sessions, presentations by premiere San Diego businesses, ongoing learning labs, exhibition with IT service providers and independent software vendors, networking sessions, breakfast, lunch featuring a special presentation by Dale Carnegie of San […]
Business Intelligence Semantic Model – Creating Your First Tabular Model Project – Part 2 of 2
This blog continues from where I left off in Part 1 – “Creating Your First Tabular Model”. As covered in part 1 you'll need to meet the following requirements in order to create your first new tabular model project: Have an instance of SQL Server 2012 running in Tabular mode. Have SQL Server Data Tools (SSDT) – installed as part of SQL Server 2012. Microsoft provides different sample databases – the one I use in this blog is AdventureWorksDW2012 and can be found at http://msftdbprodsamples.codeplex.com/releases/view/55330. In part 1 of the blog series we created and deployed our tabular model using SQL Server Data Tools, and we created a simple report using Power View within Excel. It’s a simple report. A very simple report. As promised in the last blog, I’m going to show you how to enhance it with some created measures, and you’ll learn how to make […]