Power Platform World Tour Vancouver Presentations
These are copies of my presentation decks from the sessions today at the Power Platform World Tour event in Vancouver,…
Power BI Project Good and Best Practices
The purpose of this article is to outline a set of guidelines and recommended practices for managing Microsoft Power BI projects. This guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects.
Again, this guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Topics included in this guide:
- Solution Architecture
- Managing Power BI Desktop Files
- Datasets and Reports
- Version Control & Lifecycle Management
- Workspace and App Management
- Data Model and Power Query Design Guidelines
- Dimensional Design
- Query Optimization
- Managing Dataset Size with Parameters
- Implicit and Explicit Measures
- If Users Need Excel, Give them Excel
- Certified & Shared Datasets
- Enterprise Scale Options
Power BI Product Suggestion: Show Measure Dependencies
I was just working on a client project where we have several complex measures that reference other measures. Sometimes it…
Power BI Licensing
Power BI licensing options are a mystery to many. It’s not that it is complicated; in fact, on the contrary,…
Power Platform Virtual Conference
I am happy to join several world-class speakers on July 23 & 24 for the Power Platform Virtual Conference. I will be speaking about how to create “no-code” Power BI custom visuals along with Mike Carlo from PowerBI.tips.
Drillthrough Navigation Between Power BI and SSRS Paginated Reports
Report navigation is, in my opinion, the essence of true data exploration and discovery. It lets business users see and understand important information in different forms; in summary and in detail, within context. SSRS and Power BI are truly a dynamic duo for reporting and data discovery. I wanted to post a follow up to these two articles because they are apparently very popular topics. Posted two days apart on my blog, they received 2,744 and 3,356 views. Woo!
Drillthrough from Paginated Report to Power BI
— report recipealso see: Drillthrough from Power BI to an SSRS Paginated Report In the recipe titled “Drillthrough from Power…
Drillthrough from Power BI to an SSRS Paginated Report
Navigating from a Power BI report to an SSRS Paginated report with filters and parameters.
This recipe primarily involves Power BI report design techniques. I’m not going to get into the details of Power BI report design but will cover the basics with a partially-completed report to get you started. If you are less-experienced with Power BI you can use this as an example for future report projects.
Power BI Performance Analysis
How can you find the cause of slow performance issues in Power BI? This post demonstrates some of the advanced…
Advanced DAX Training from Marco Russo in Portland: June 2019
It’s very rare to have the opportunity to learn DAX from the world’s leading expert but we will have that…
Getting Started with Power BI Report Design level 101 – What Every New User Should Know
Let’s step through a few very simple things that every Power BI new user needs to know. Power BI is…
Data Geeks and Data Jocks Meetup in Vancouver, Washington
Our little “Data Geeks” Meetup group in Vancouver, Washington is growing with a line-up of heavy-hitters and bigger crowds. This…
Azure Everyday Roundup
Short (2-4 minute) video posts to help you learn about the Microsoft Azure analytics and data platform. In November of…
Power BI at Enterprise Scale
Last night I was scheduled to present this topic at the Power BI User Group in Portland except the meeting…
It’s about solving business problems & meeting people… Allen White interview
I’ve been remiss about blogging for a little while and have some great stuff to share, starting with this interview with Allen White at the PASS Summit conference in November. Allen is a 15-year PASS veteran and one of the most consistent SQL Server experts in the industry. He’s a powerhouse of knowledge, experience and wisdom. He’s a long-time SQL Server and Microsoft Data Platform MVP and owner of DataPerf Professionals Consulting, mentor, coach, trainer, co-founder and leader of the Ohio North SQL Server user group. He’s served on the PASS Board of Directors as the Program Director.