Facebook Twitter LinkedIn YouTube E-mail RSS

Power BI Update – Pin Excel Visuals Directly To Power BI

Share

Microsoft has added another new feature that will be a big plus to all companies who put a lot of emphasis on reporting done through Excel. They have now given users of Power BI the wonderful ability to pin Excel visuals directly to Power BI. As with most things within Power BI, the process is as simple as it gets.

For example, I spent literally 3 minutes to get from a blank Excel document to having a new tile on my Power BI Dashboard, all using Microsoft’s example data outlined in their AdventureWorks suite. It really works as simple as Create, Pin and Confirm:

powerbivisuals_1

While the process is simple, there are always details to note that can prove critical if not considered. Microsoft’s answer is to create the Pin Manager. The Pin Manager is used to track your visuals that are being used in Dashboards and also gives you the ability to manually update them:

powerbivisuals_2

 

 

 

 

 

 

 

 

 

 

 

 

Presently it appears that the update cannot be scheduled or automated so the use of this feature should be selective until it becomes available.

The question therefore is why would you use the visuals you have created in Excel instead of using the embedded visuals in Power BI? The majority of significant visuals are present in both and Power BI can be scheduled to update automatically?

I believe there is a twofold answer. The first is that while Power BI is wonderful for visualizing cubes and creating models in, some datasets and spreadsheet data can be considered either too small or not compatible for a pivot model. In these scenarios the ability to Pin directly from Excel may be a better option.

The second answer is as simple as the tool itself. Despite all these new tools coming out, some people and companies simply prefer Excel, proven again by the fact that it is still the most used office software in the world.

Written By: George Bryant, GNet Group

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Webinar Release: Rise of the Machine (Learning)

Share

Webinar: Rise of the Machine (Learning) – Azure ML Brings Predictive Analytics to the Masses

Machine Learning no longer requires expensive infrastructures and knowledge of specialized statistical coding languages. Microsoft Azure ML lowers the barriers of entry for predictive analytics using Machine Learning.  In this newly released webinar recorded by Greg Beaumont, he will review the similarities and differences of Machine Learning compared to traditional Predictive Analytics, Data Mining, Data Science, and Artificial Intelligence.

Greg will demonstrate how a BI solution using only Excel with Power Pivot can connect to an Azure ML Model in the cloud for predictions and new types of analysis. Learn how Azure ML can be used to add value to Apps. Also, review ways to turn your Azure ML Model into a source of revenue using Azure Marketplace.

Machine Learning is now quietly rising all around us as it integrates with technology, improves processes and workflows, and transforms how data drives business. Empower your organization with new competitive advantages using Azure ML.

CLICK HERE TO VIEW WEBINAR

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Nihilent Technologies Delivers New Generation Abstraction Platform

Share

GNet Group, a subsidiary of Nihilent Technologies, is proud to announce the recent launch of its next-generation semantic intelligence engine for data mining of key data from large numbers of legal documents. This Abstraction Platform is the result of a partnership between Nihilent Technologies and Brightleaf Solutions, Inc and adds an important dimension of using unstructured data to GNet Group’s existing BI capabilities.

“This joint effort has yielded new thinking about an old problem: how do you get meaningful data from unstructured, English language legal documents and ensure the results are accurate and reliable. Today’s delivery of v1.0 of our new abstraction platform is the result of that.” Stated Samir Bhatia, CEO of Brightleaf Solutions.

Abhay Ghate, Chief Technology Officer for Nihilent Technologies said “We have a lot of experience with language parsing and using it to build structured databases. Brightleaf showed us how to apply that to legal documents which use precise language and are often lengthy and complex. It’s quite different than extracting data from written forms or other textural documents such as corporate reports, books, or news stories.”

Bhatia continued “Brightleaf’s new semantic intelligence engine is rule-based so we can modify and tune it for specific document types, thus gaining the quality and consistency that only comes with automation. Combining this technology with an extensive people-based quality control process yields results that meet the most stringent quality requirements.”

Looking to the future, Nihilent and GNet Group continue to innovate to bridge the gap between our client’s business requirements and the latest technologies.

Resource Links

Read full Press Release

Brightleaf’s Automated Contract Abstraction Solution

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

We’ve done it again! GNet Group has been named 100 Best Companies to Work For

Share

For the 2nd year in a row, GNet Group has been named Minnesota Business Magazine’s 100 Best Companies to Work For. The 2015 “100 Best” were selected by an independent research firm employing an anonymous online questionnaire filled out by the employees of each company — to determine which companies in Minnesota excel in the areas of work environment, employee benefits, and overall employee happiness, making them the 100 Best Companies to Work For.

Minnesota Business Magazine's 2015 100 Best Companies to Work For

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Predict Breast Cancer Biopsies for Malignancy Using Azure Machine Learning

Share

The video embedded above, which demos the use of Azure ML with Excel 2013 to predict malignancy of breast cancer biopsies, contains references to the following links: Read more…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments