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
As a Data Platform Solution Architect for Microsoft, one of my jobs is to help teach my customers what our amazing tools can do and how those tools work. Interest in Power BI is blowing up and I’m seeing most of my customers express huge interest in this awesome tool. To help facilitate the conversation about how Power BI works and how it can help my customers, I put together this diagram.
Also, each text block in the black area to the right includes a link to the documentation on PowerBI.com for the specific component. So if I’m looking at the diagram and I want to gather more information on the Power BI Gateway – Enterprise, just click the text block or point #2. Continue reading Download the Power BI Architecture Diagram
There were so many updates to Power BI this month I thought I’d put all the links to the information on the updates in one place so we can get caught up quickly on everything that changed with the tool this month. Down below you’ll find my commentary on which updates I’m most excited about and links to the Power BI blog to get all the information on all the changes!
The big one here, in my opinion, is the ability to use custom visuals! Not only can you create your own visualizations to meet your organization’s needs, you can download other custom visualizations that have been shared in the Power BI Visuals Gallery. Some of these custom visuals are just awesome. The capabilities of this tool are off the charts (see what I did there?)!
One of the current issues in Power BI is the inability to specify a Date table. The Date table is what enables us to create some of the powerful DAX time calculations like Year To Date, Month To Date and more when the Date key is not a Date data type. Ginger Grant has blogged about this issue with a proposed work around, which you can read about here. Even though we can’t exactly specify which table is our Date table in Power BI, that doesn’t mean we can’t create some nifty time calculations with Continue reading Creating Time Calculations in Power BI
Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about that fact. As a feature included with Excel 2013 and 2016 (and an add-on for Excel 2010), Power Pivot allows user with a little technical expertise to integrate disparate data source together within a flexible data model. Once the data is loaded into Power Pivot, we easily have the ability to create powerful calculated measures, key performance indicators Continue reading Taking #PowerPivot to the Next Level
The Scatter Chart in Power BI and Excel is very useful chart for visualizing three different metrics in tandem. But with a little bit of work you can use a Scatter Chart to create a Calendar chart for visualizing your metrics across the days of an individual month.
To configure a Scatter Chart too mimic a Calendar type report, you need the following: Continue reading Power BI Tip: Use a Scatter Chart to Create a Calendar Report
Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve probably seen the link to download the tool on technet. Basically this tool is a fancy Excel workbook that allows you to easily clean up your Power Query code and insert it back into your Excel workbook or Power BI semantic model. It’s pretty nifty and easy to use so I figured I’d give you a quick run down on using it to clean up my Power Query code in my Fantasy Football & NFL stats Power BI model, which you can download here. Continue reading Cleaning Your #PowerBI Power Query Code