FMTFMT

Jeff Fenn, Author at FMT

Search Archive
New Features in Microsoft Business Intelligence with SQL 2016 and Power BI
Microsoft Power BI recently had its one-year anniversary, and with the release of SQL 2016, the future of Business Intelligence just took a giant leap forward. Microsoft is starting to achieve its goal of putting the power of data in the hands of every business and person on the planet. In this blog, we’ll preview some of the new features of SQL 2016 Reporting Services and some of the most recent updates in Power BI that you’ll see during the Microsoft BI session at nVerge In the Cloud.  We’ll also look at how you can jump in and get started with these tools and how they work together to provide you access and insights into your data. SQL 2016 Reporting Services SQL Reporting Services (SRS) is still the go to on-premise solution for deploying and managing reports. Some of the great new features include the ability to: Develop paginated reports […]
Decrypting Microsoft Dynamics GP eConnect Stored Procedures
On a recent project, I had to decrypt an eConnect stored procedure – something you typically never have to do when using eConnect. eConnect provides both Pre and Post procedures for modifying business logic before passing a transaction through eConnect to Microsoft Dynamics GP (I advise against modifying any Dynamics GP stored procedures as it may cause problems down the road with upgrades). In my case, I was working on an integration using SmartConnect to insert a payables transaction into Dynamics GP. (If you haven’t used SmartConnect before, it’s a terrific tool for creating quick integrations to GP from other sources including flat files, SQL, CRM etc.; but that’s a blog for another day.) It was a pretty straightforward integration using eConnect and leveraging the taPMTransactionInsert procedure. However, I was running into issues because of an error caused by code written by a previous consulting firm in the post procedure […]
Power View Data Visualizations - SQL 2012 Reporting Services
Power View, a feature of SQL Server 2012 Reporting Services, allows you to create reports and dashboards using a number of different data visualizations. With the ability to drag and drop data, and being able to easily switch between visualizations, Power View quickly becomes a powerful BI tool to illustrate, summarize, display and analyze your data. The following table is a list of data visualizations that come out of the box with Power View:   Click image to enlarge TABLE You can easily drag and drop fields onto a table. Columns can be easily reordered and all columns are automatically sortable. You can even include images files.   Click image to enlarge MATRIX Tables can be easily be converted into a matrix, with row and column groups. By default the matrix will have totals and subtotals for each of the groups. Additional columns can be easily added by dragging a […]
Should I Upgrade to SQL 2012?
Microsoft recently released the latest version of SQL Server (“Denali”) 2012. With every new SQL Server release, hundreds of new features and improvements are added, and this is a major one! Enhancements can be found throughout the product, across all components including the Database Engine, Analysis Service, SSIS, Reporting and Master Data Services. Like previous releases, SQL 2012 brings along faster performance, great availability, improved data exploration, more consistent data, and optimized productivity. So what does all this mean? And more importantly, should you upgrade? The new release of SQL Server comes with many new and cool features. So many that it is outside the scope of this article to go through them all, but here are a few highlights: Always On: A new feature that improves database mirroring allowing you to fail over multiple databases instead of individually.  SQL Server Data Tools: SQL Server Management Studio now runs in […]
©
2021
 FMT Consultants, LLC.
|
Privacy Policy
X
FMT

Contact Us

X
FMT

Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram