The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a modern SQL Server platform such as SQL Server 2017 or Azure SQL Database. If you’re assessing a single SQL Server with only a few databases, reading the exported results (which can be in .JSON or .CSV format) may not be that difficult. But if you’re assessing dozens of environments including hundreds of databases, we need a better way to understand the results. Continue reading Making Sense of Data Migration Assistant Assessments with Power BI
The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube channel that you can go back and watch anytime, which is pretty amazing!
Obviously I haven’t watched all 75 different videos, but I did watch a few so I’ve included some of the things I learned, announcements on new features, links to some of the especially interesting sessions, and my notes from a couple of those sessions below. Continue reading Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics
Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power BI Report Server includes the ability to host Power BI reports, along with traditional SQL Server Reporting Services content, within the boundaries of your organization’s firewall.
I put together the following video that Continue reading Setting up the Power BI Report Server Preview
Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power BI. Between Power BI Premium and Power BI Report Server, my head has been spinning trying to stay educated on all the new changes and enhancements. With all these announcements, it was definitely time to update my Power BI architecture diagram to reflect the addition of Power BI Premium and Power BI Report Server.
I’ve made a few changes in v3 of the Power BI architecture diagram. Continue reading Power BI Architecture Diagram v3 is Now Available!
Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the business intelligence stack. I met with Jacksonville University students and faculty and also had the pleasure of speaking with members of local businesses that are interested in leveraging Microsoft technologies. It was a wonderful experience and I had a great time!
If you’d like to download my slide deck from the discussion and presentation today, you can find that here.
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers. The other reason is that the customer I’m speaking with have lots of questions about Power BI. So consider this one of my efforts at scaling myself.
If you enjoy this “Power BI tips and tricks” type posts, check out my first five Power BI tips and then my second five Power BI tips. You’ll probably enjoy those if you found this post helpful. So without further ado, I present to you more Power BI tips that I truly hope you’ll find helpful.
For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison Power BI User Group. I’m always really excited when someone invites me back a second time to speak because that means that the first time wasn’t completely awful! We had a great time last evening discussing Continue reading Introduction to Power BI Desktop – Session Materials Available