Last night at approximately 9:28 PM EST the June 2016 release of Power BI Desktop dropped, which you can download here. The June update is pretty extensive and includes a bunch of new features and improvements. Here’s some of the biggest new features and some of my favorites.
Check out these 5 Power BI Tips
Continue reading June 2016 Release of Power BI Desktop is Here!
I’ve had this blog post in my mind to write for the past month or so and I’m finally just getting around to it while I’m waiting to board my flight back home.
Check out my first 5 Power BI Tips here
These are just five more Power BI tips and tricks that I think everyone should know in order to get the most out of Power BI and produce better, more useful, and more powerful Power BI reports for their users. So without further ado, here are five more Power BI tips in no particular order. Enjoy!
Download the latest version of the Power BI Architecture Diagram here!
I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram but as fast as Power BI is changing, v1 of the diagram was quickly obsolete. I always wanted to come back and add more to the diagram to make it more complete but now that SQL Server 2016 is generally available and enhancements have been made to Power BI to facilitate integration with Excel and SSRS, it made sense to do another diagram.
The reason I originally created this diagram was to use as a tool during conversations with my customers. But I’ve also used the diagram in other presentations and found it beneficial while teaching about how Power BI works. I wanted to make this resource available to others for their benefit. So here’s v2.
I’ve included a few new things to make the diagram up to date with the latest changes to Power BI, SQL Server Reporting Services, and Excel.
This document includes components to illustrate:
Feel free to download this content and use it in your presentations, discussions, and for your own learning. I hope you find it useful and if you do, share it with a friend.
Do you have any feedback on this diagram or anything you’d like to see me change? Leave a comment or let me know! Thanks!
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long list of new features and enhancements included with SQL Server Reporting Services 2016. The webinar has been recording and I’ve uploaded it to YouTube for your viewing pleasure.
If you’d like to download my PowerPoint slide deck, you can do that here.
And you can download my portal brand package here.
*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read about all the new enhancements and changes to Power BI Desktop right here.
So it appears that the May 2016 update to Power BI Desktop has dropped without any notification from the Power BI team on their blog or a notification within Power BI Deskop. So I figured I’d take a moment to point out of the new enhancements to Power BI Desktop.
New to Power BI Desktop? Get started here.
This one is awesome and has been a feature that we’ve all been waiting on for a while. Continue reading Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc
This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good friend, Mitch Pearson (blog | twitter) and I presented our session, Designing a Data Warehouse from the Ground Up. We had a great crowd and lots of great questions from the audience!
Watch Designing a Data Warehouse from the Ground Up Webinar Recording
With all the talk about designing a data warehouse and best practices, I thought I’d take a few moment to jot down some of my thoughts around best practices and things to consider when designing your data warehouse. Below you’ll find the first five of ten data warehouse design best practices that I believe are worth considering. This list isn’t meant to be the ten best “best practices” to follow and are in no particular order. Of course, each design scenario is different so you may find that some of the best practices listed here aren’t optimal in your specific situation.
Continue reading 10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )
This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The problem for this very large school district was that they were missing the street address information for some of the buildings and for other buildings they were missing the latitude and longitude.
New to Power BI? Start with these 5 tips!
The good news is that Power Query in Power BI is flexible enough for us to take advantage of the Bing Maps API so that we can lookup the missing pieces of information we need. In this blog post, I’m going to show you how you can use the Bing Maps API to look up an address based on a latitude and longitude or use a street address to find a latitude and longitude for the location. Continue reading Power BI and the Bing Maps API
Thank you to everyone that attended my webinar with the PASS Excel BI Virtual Chapter today! I’d also like to thank Thomas LeBlanc for having me to present. I had a great time presenting on the newest features of Power BI and what features you will see in the near future. Continue reading What’s New in Power BI Webinar Recording is Available
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power BI and time calculations! There were a bit of audio issues on my end but thankfully we were able to still have a great event with lots of great questions!
If you missed the webinar, have no fear! You can still watch the recording right here. Just jump ahead to minute 11 as I had some unfortunate connection issues!
If you have any additional questions or feedback, please leave a comment down below.
Download my PowerPoint slide deck here.
The PASS BI VC is a great group with tons of free, quality training events! I highly recommend you connect with this group so you can stay up to date on all their great events!
The PASS BI VC also has all their previous webinar recordings hosted on YouTube so definitely check that out!
If you’re new to Power BI, I suggest you start here.
Read more about Getting Started with R Visuals in Power BI
Read more about 10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)
Read more about 10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
I hope you enjoyed the webinar and that you maybe even learned a little something. If you have any questions, comments, or feedback, please leave it down below! Thanks for reading and watching!
Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web” as a preview feature. This is HUUUUGE news! This was probably the top requested feature and its finally here thanks to the hard work and dedication of the Microsoft Power BI team! Continue reading Power BI Publish to Web for Anonymous Access is Here
