If you need to brush up on your Power BI skills, check out the Microsoft Power BI YouTube channel. See the link below. There are some new videos out there that have been uploading in the last two months.
Figure 1 & 2 from the site https://logs.msdn.microsoft.com
Check it out! Tons of Free Microsoft eBooks. The list of all books and the download selection is located at the link below.
Note from Eric:
It’s that time of year again, and today I am kicking off my annual FREE MICROSOFT EBOOK GIVEAWAY extravaganza! And this time, I’m posting MORE FREE EBOOKS in this post than I ever have in any of my previous giveaways! Based on this, you will notice something different about this year’s post… In previous years, I included images of the eBook covers next to each item; however, I would also get feedback from people on the amount of time to load all of the images. So, this year I decided to streamline the list to make it easier to get to the eBooks you want. You will now find a simple list, organized by category, with the download links in the Format column so you can choose which format you want to download.
- How many can you download?
- ANSWER: As many as you want! This is a FREE eBook giveaway, so please download as many as interest you.
- Wow, there are a LOT listed here. Is there a way to download all of them at once?
- ANSWER: Yes, please see the note below on how to do this.
- Can I share a link to your post to let others know about this giveaway?
- ANSWER: Yes, please do share the good news with anyone you feel could benefit from this.
- I know you said they are “Free,” but what’s the catch?
- ANSWER: There is no catch. They really are FREE. This consider it a, “Thank you,” for being a reader of my blog and a customer or partner of Microsoft.
- Ok, so if they are free and you’re encouraging us to share this with others, can I post a link to your post here on sites like Reddit, FatWallet, and other deal share sites to let them know, or is that asking too much?
- ANSWER: Please do. In fact, I would encourage you to share a link to this post on any deal site you feel their users could benefit from the FREE eBooks and resources included below. Again, I WANT to give away MILLIONS of FREE eBooks!
- Are these “time-bombed” versions of the eBooks that stop working after a certain amount of time or reads?
- ANSWER: No, these are the full resources for you to use.
Posted in Azure, BI, Dynamics 365, DYNAMICS CRM, Dynamics GP, Excel, Microsoft, Office 365, OneNote, Outlook, Power BI, Reporting, SQL 2014, SQL 2016, SQL Server, Warehouse, Windows
- Tagged Free Books
Figure 1 – Explanation of Power BI from https://powerbi.microsoft.com
On June 12, Amanda Cofsky, Program Manager for Power BI, provided an overview of the new reporting features available as of June. The link to download Power BI is…. http://powerbi.microsoft.com/desktop?WT.mc_id=Blog_Desktop_Update.
Here’s the complete list of June updates from Cofsky’s blog posting.
- Data bars for new table & matrix (preview)
- Markers on line, area, & combo charts
- Accessible reports
- Consume Power BI reports with keyboard navigation and screen reader support
- Create accessible reports
- Visuals font family setting
- Horizontal Image Slicer
- Combo chart formatting updates
- Force zeros to align between the two axes
- Shade area of the line
- Bing maps improvements
- Map themes
- Improved geo hierarchy experience
- High density line sampling
- Custom Data Connectors support
- Power BI service Live Connect to On Premises and Push streaming datasets
- Impala connector is now generally available
- Amazon Redshift connector is now generally available
- SAP BW connector – DirectQuery support (beta)
- IBM Netezza connector (beta)
- “Add Column from Examples” enhancements
You can watch a video of the new features by clicking on https://youtu.be/YlNVE5dgcSI (Power BI Desktop Update – June 2017). Remember that YouTube links can change from time to time so this link may change over time.
Posted in Cloud, Dynamics 365, Dynamics AX, Dynamics GP, Dynamics NAV, Microsoft, Power BI, Reporting, What's New, Working
- Tagged Features, Power BI, Reporting, What's New
The above notice says it all… Dashboards are now part of Power BI Pro.
Figure 1 – Visual of Sales Dashboard created in Power BI – from Maggie Sparkman’s article “Create reports optimized for the Power BI phone apps”
Maggie Sparkman published a great article on creating desktop reports in Power BI that will translate to the mobile apps on the phones.
Her article appears at https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-phone-report/?mobileclient=ios.
In her article, she provides clear, step-by-step instructions on creating the visual. The article is well worth the read if you are into Power BI.
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:
Query Editing Improvements
The blog also contains simple instructions for using the DATE SLICER, REPORT GRIDLINES, DATA LABEL, and MAP FORMATTING OPTIONS.
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!
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.
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.
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.
Note that the service requires that you have a OneDrive for Business subscription.