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.
Interviews from PASS Summit 2018: Matthew Roche, Matt Masson, Adam Saxton & Patrick LeBlanc
I had a chance to catch up with two of the three Matts from the Power BI product team at…
Data Model Options for Power BI Solutions
At the heart of every a Business Intelligence reporting solution is a data model, to optimize queries and enable ad hoc report interactions. Data modeling technology has evolved quite a lot over the past 20 years or so. You have several choices and options depending on the simplicity or formality of your project, and factors like data size and security. In the past, choices were simpler. Power BI was the choice for smallish, “good enough” projects and when data quality, high volume and exactness were the priority, SSAS was the better choice. Now, using Power BI for modelling larger data sets is even advantageous with new features like hybrid models, aggregations and incremental data refresh.
I’ve been a quest to find the best medium to break these choices down into simple terms but it truly is a journey and not a destination.
Interviews with Microsoft Data Community Speakers and Leaders
What is the key to advancing your career in the Microsoft data platform? Here is some advice from some of the most successful people in the industry…
Every year we have some big community events that bring together community leaders from all over. These are international user group and community leaders who write books and speak at conferences. we had our local Oregon SQL Saturday “SQL Train” which is a chartered train – some coaches that one of our speaker’s chartered to bring all of our speakers and attendees up to the PASS summit after Oregon SQL Saturday, and then the big PASS summit (the big conference up in Seattle). I had a chance to sit down with a number of our speakers, community leaders and attendees and just ask questions about what brought them there, and advice that they would give people in the industry about how to get the most value out of that experience …and this is what they said:
How to Assign Pro Licenses to a Power BI Tenant
This is a question that comes up all the time. Power BI licensing is not complicated but a common challenge is that the person who sets up a new Power BI subscription and tenant within an organization is often not the same person who manages Office 365 or Azure service licensing for the organization. I’ve consulted on projects for several organizations where folks just didn’t know who to talk to or how to proceed after testing the water with Power BI. After setting up a new subscription, IT professionals and business data analysist often don’t know how to license Power BI for company use and share reports and datasets with others in the organization.
This post will show you how licenses are assigned to users and, more importantly, what to request from your support desk or administrators who may be unfamiliar with Power BI and Office 365 user licensing. Keep reading for background information about why this is important and necessary.
Web API Data Sources with Power Query and Scheduling Data Refresh in the Power BI Service
Using a Web API is a convenient way to expose and consume data over an Internet connection. Exercising some essential…
Mastering Power Query in a Day – Full-day training in Seattle
Following the Power BI World Tour, Seattle event on Oct 30, please join me for a full-day of deep learning. …
How to Configure the Power BI Gateway to use Dataset Connection Parameters
A service provider or vendor might want to publish multiple copies of a report that should connect to different database…
Pareto, Burn-down & Accumulating Trend Charts in Power BI
I’m managing an Agile team project using Microsoft Teams – the new project management platform integrated with Office 365. Teams…
Power BI for Grownups
The message from the Microsoft Business Applications Summit this week was very clear: Power BI is growing up. We have…