Power BI Desktop Updates At October 31 2016

Amanda Cofsky, Program Manager at Microsoft, announced the new desktop release of Power BI on October 31.  You can read it at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/.

Here’s the complete list of October updates from Cofsky’s blog:

Report View

Analytics

Data Connectors

Query Editing Improvements

Other Improvements

The blog also contains simple instructions for using the DATE SLICER, REPORT GRIDLINES, DATA LABEL, and MAP FORMATTING OPTIONS.

Learn About Microsoft Dynamics NAV 2017

imageimage

Figure 1 – images from various sources

Microsoft has been on a role with releasing new software.  And, Dynamics NAV 2017 is looking very exciting for end users as well as developers. 

Lots of people have lots to say about it.  So, I put together a list of different blogs and articles that you might find as interesting as I did.  It can be a little light reading for the weekend.

1.  Waldo’s blog has some great details and some comments on the new opportunities.  See his information at http://www.waldo.be/2016/09/13/microsoft-dynamics-nav-2017-whats-new/

2. On the Community NAV blog, Tharanga Chandrasekara focuses on Microsoft’s release document on What’s New in NAV 2017.  It is a good read.  https://community.dynamics.com/nav/b/tharangacnavblog/archive/2016/09/17/what-is-new-in-microsoft-dynamics-nav-2017

3. If you are a developer, you may want to check out the info on the NAV TECH DAYS site at https://www.navtechdays.com/2016/sessions.  This covers things like “Building Extensions for NAV”, and Design Patterns in NAV 2017.

4.  To learn more about NAV 2017 Notifications, check out Roberto Stefanetti NAV Blog – https://robertostefanettinavblog.wordpress.com/category/nav-2017/

5.  If you are into Dynamics NAV technology and programming, you may want to check out the DIRECTIONS EMEA conference. It is being held Oct 12 to 14.  They are talking about the next best practices and the new features.  See the website. http://www.directionsemea.com/. “Join 1600 attendees who have already registered for THE BIGGEST NAV EVENT!”

Dynamics NAV 2017 is off to a rocking start!

"Introducing Microsoft Power BI" and Other Free Books at Microsoft Virtual Academy

image

Figure 1 – Some of the books available at Microsoft Virtual Academy

Last week, Microsoft announced that users of the Microsoft Virtual Academy had access to fee books.  There are a lot of books available.  Some of the key titles are:

Introducing Microsoft Power BI
Migrating SQL Server Databases to Azure
Windows 10 IT Pro Essentials Support Secrets

Planning and Preparing for Microsoft SharePoint Hybrid

Introducing Windows Server 2016 Technical Preview

Deploying Windows 10: Automating deployment by using System Center Configuration Manager

You can access the ebooks at https://mva.microsoft.com/ebooks.  You will need to make this a priority because they may only be available for a limited time.

Microsoft Office 2016 New Features Include Power BI And SQL Server Database Connector

image

Figure 1 – from technewstoday.com

Sandy Stachowiak posted a great article on 10 New Microsoft Office 2016 Features to Increase Productivity at http://www.makeuseof.com/tag/10-new-microsoft-office-2016-features-increase-productivity/.

You can read her blog in detail as she does a great job of highlighting new features.  The big features for Dynamics ERP users is the feature for NEW AND IMPROVED CONNECTION options.  Here is what she says.

Connectivity for Excel

You can import data from SAP HANA databases, SharePoint folders, and online services such as Salesforce Objects or Reports. Select Data > New Query and then make the appropriate selection from the drop-down box.

The connectors for IBM DB2 and SQL Server Database have been improved as well. For IBM DB2 you can now choose the Microsoft driver and for SQL Server Database you can include schema information as part of the navigation hierarchy.

Excel2016SQLServerNavigate

 

Connect Excel To Power BI with Publish

Power BI is a service that can transform your data into interactive reports. Using the business dashboard, you can monitor, analyze, and build models easily. Select File > Publish to upload workbooks or export workbook data directly to and from Power BI.

Excel2016PublishToPowerBI

Note that the service requires that you have a OneDrive for Business subscription.

You Can Use Power BI To Analyze the Top Movies from IMDb And Other Lessons

image

Graphic from https://www.youtube.com/watch?v=ByIUx-HmQbw&list=PL1N57mwBHtN2q1WbU5O29rrn_A0lkVv9p&index=3

 

I think learning should be fun! And, for me, Microsoft made a lesson on learning how to do queries in Microsoft Power BI a lot of fun by using the query on the IMDB database.  I love movies and I use the IMDb database often so I enjoyed the way the lesson categorizes movies.

Want to learn how to start using the Power BI tool?  Well, you can either start by going to the Learn page at the Power BI website at https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-0-0-what-is-power-bi/

Or, you you can go directly to the Power BI Desktop videos, and watch the short movies that also appear on YouTube.  The IMDb example is at https://www.youtube.com/watch?v=ByIUx-HmQbw.

For folks that work with Dynamics GP 2016, these short learning sequences are a great way to discover the ease of creating Power BI reports from a data source.

Enjoy!

Microsoft Power BI Updates in July 2016

 

image

Graphic from https://powerbi.microsoft.com

 

Microsoft announced the following updates for Power BI for July.  The announcement comes from Filip Karadzic,  Senior Program Manager, from the blog announcements page at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary/.

REPORT VIEW:
  • Predefined table styles
  • ShapeMap can use custom maps
DATA CONNECTIVITY:
  • New Data Connectors:
    • Amazon Redshift (Import + DirectQuery) (Preview)
    • Impala (Import) (Preview)
  • Improvements to existing data connectors:
    • Support for specifying a Command Timeout via the UX
    • CSV/Text – Support for Fixed-Width delimited files
    • SAP BW connector improvements:
QUERY EDITING IMPROVEMENTS:
  • Ability to use R scripts in Query Editor
  • Query Parameters – List Query output as “allowed values” for a parameter
  • Ability to overwrite existing user-defined functions

What is Microsoft’s Power BI and How Does It Work?

image

Graphics from https://powerbi.microsoft.com/en-us/

 

What is Microsoft Power BI

“What is Power BI?”   Microsoft defines it as

“Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.

Where Can I Get More Information on Microsoft Power BI?

Microsoft has created a web site for Power BI at https://powerbi.microsoft.com/.  You can find out everything you need to know about the product at this site.

You can also stay updated with all the new features by checking the Microsoft Power BI Blog at https://powerbi.microsoft.com/en-us/blog/.

 

Why Do I Need To Know About Power BI?

Power BI integration to Dynamics GP is a new feature in Dynamics GP 2016.  The big question that all GP users have is about the benefit of Power BI.  The benefit is that users can now connect data to the HOME page, and produce reports and dashboards similar to the way reports and dashboards can be built in SSRS reports.

 

Prerequisites for GP Users To Use Power BI

– You have access to Power BI and at least one report is available.

– You are able to log in to the Power BI site and view a report.

– You are creating your own Power BI reports\charts.

– You are using the GP 2016 desktop client.