Category: BI Industry

Azure Data Factory, Azure Databricks, BI Industry, BI Projects, Business Analytics, Microsoft BI Platform

How Lakehouse Architecture is Revolutionizing Business Intelligence

Paul Turley

The Lakehouse is the evolution of the earlier cloud data platform in many pieces that came with “some assembly required”. All of the components are modern, mature and capable but complicated and require specialized skills. Imagine that the new version is easier to assemble with instructions that are only a few pages with stick figures, and it comes with an Allen wrench.

We’re seeing consulting customers putting Lakehouse and BI solutions on-line in just a few weeks. Then they iterate to scale-up their modern data warehouse/BI platform as they train their Center of Excellence champions and Data Governance organizations as they progress.

BI Industry, BI Projects, Business Analytics, DevOps & CI/CD, Microsoft BI Platform

DevOps & CI/CD for Power BI: Real-World Example

Paul Turley

In a recent blog post, Paul discussed that DevOps, and specifically CI/CD, principles are essential for modern software development, and Power BI is no exception. Power BI CI/CD for enterprise class projects can be achieved using Azure DevOps, with steps including source control, automated testing, and build and release pipelines.  

Azure Data Factory, Azure Databricks, BI Industry, Business Analytics, Dimensional Modeling, Microsoft BI Platform, Power BI, Power Query, Self-service BI, SQL Server, Tabular Models

Getting Data Into Shape for Reporting with Power BI

Paul Turley

Even for small, informal BI projects, shaping the data into a dimensional model alleviates complexity, speeds up slow calculations and reduces the data model storage size. I conclude this post by reviewing seven data architectures and the data shaping methods with different degrees of scale.

BI Industry, BI Projects

Power BI Data Modeling Sessions

Paul Turley

This is going to be a very busy week for presentations Iam presenting with five sessions scheduled on the topic…

BI Industry, BI Projects, Microsoft BI Platform, Power Query, Self-service BI

Doing Power BI the Right Way

Paul Turley

This is an introduction to a series of posts and pages that will provide a comprehensive set of best practices for successful Power BI solutions. In previous posts. Let’s start with a simplified flowchart and condensed decision tree. This first whiteboard drawing is the first half of the Power BI design process, ending with the data model, before measures, visualization and solution delivery. There is a lot more but I think this is a good starting point. Let’s start the conversation here and then I will enhance this post with a more complete list of topics.

BI Industry, BI Projects, Power BI, Self-service BI

How to Assign Pro Licenses to a Power BI Tenant

Paul Turley

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.

BI Industry, Business Analytics, Power BI, Power Query, Self-service BI, SolidQ

Mastering Power Query in a Day – Full-day training in Seattle

Paul Turley

Following the Power BI World Tour, Seattle event on Oct 30, please join me for a full-day of deep learning. …

BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, Power Query, SQL Server, T-SQL

SQL, M or Dax? – part 2

Paul Turley

This is a post about a post about a post. Thanks to those of you who are entering comments in the original May 12 post titled SQL, M or DAX? This is a popular topic. And thanks to Adam Saxton for mentioning this post in his Guy in A Cube Weekly Roundup.

BI Industry, BI Projects, Power BI

Power BI Global Hackathon Contest Results

Paul Turley

The results of last month’s Power BI Global Hackathon are in! The Hackathon was facilitated by our our PUG here…

BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, Power BI, Self-service BI, SQL Saturday

Keeping Up with Power BI – A Never Ending Story

Paul Turley

This first week of the new year has been a lot of housecleaning for me (literally and figuratively…  my office…

BI Industry, Business Analytics, Microsoft BI Platform, PASS, Power BI, PowerShell, Self-service BI

Spontaneous Interviews at PASS Summit 2017

Paul Turley

Conversations with Julie Koesmarno, Olivier Matrat, Aaron Nelson, Seth Bauer and Robert Bruckner captured in video interviews below… Continuing my…

BI Industry, PASS, SQL Server

Interview with Pinal Dave at PASS Summit 2017

Paul Turley

While attending PASS Summit 2017 in Seattle, I had a chance to catch-up of several friends and industry experts, and…

%d bloggers like this: