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
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.
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.
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.
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.
If you are working with SQL and exploring different techniques and formulas, you probably will want to use Microsoft’s Adventure works sample databases. Sometimes, the installation can be tricky. There are four different methods for installing it that I have found to date. The information below will help you decide which works the best.
Adventure Works 2014 Sample Databases
Download from this site… https://msftdbprodsamples.codeplex.com/releases/view/125550
Dynamics CRM 2016 will be generally available in the fourth quarter of this year, delivering the “the most comprehensive upgrade ever” for the platform, Microsoft announced on Tuesday. See the announcement at http://news.microsoft.com/2015/09/08/microsoft-reinvents-productivity-with-upcoming-release-of-customer-engagement-solution/.
The new enhancements are designed to:
- increase productivity for organizations by providing a simple and seamless experience across their Dynamics CRM application
- easier integration with email (there will be a CRM app inside Outlook),
- easier integration with Excel and Dynamics CRM 2016 will offer an enhanced Excel experience including new Excel templates to automate tasks such as managing sales forecasts, for example.
- easier integration with OneDrive for Business for easier task management,
- an enhanced mobile experience for the worker on the go, and,
- enriched data and analytics,
Businesses will benefit from this new version of CRM.