Power BI Power Hour Reporting Webinar with Spencer Baucke

Live Stream – Power BI Power Hour: Build an Amazing Report from Start to Finish

During this webinar, Spencer Baucke will walk you through precisely how to create a compelling business intelligence report in Power BI in under 60 minutes. … Read More

Meet Zac Zinda, a Data Science Consultant at Tessellation

A Data Scientist’s Journey: From Evening Hobby to Full-Time Career

Welcome to our “Journey to Tessellation” series, in which we’re sharing the exciting, unconventional, and innovative career paths behind our entire team of consultants. Read on to discover how Zac Zinda, one of our newest consultants, switched career paths from teaching and the mortgage industry into data analytics. … Read More

Top 5 Power BI Basics

The Top 5 Basics Power BI Beginners Need to Know As someone just beginning their Power BI journey, I have been inundated with tips, tricks, and essentials from Power BI experts. There’s a lot to learn, and a lot to … Read More

Creating a Measures Table in Power BI

Creating a Measures Table in Power BI When navigating through your data model in Power BI Desktop, it’s easy to get lost, especially if you have a data model with several tables and a multitude of measures. In order to … Read More

Import v Direct Query: Here’s What You Need to Know

Import v Direct Query: Here’s What You Need to Know One of the first things any Power BI developer needs to know is whether to check that Import or Direct Query box while connecting to data in Power BI Desktop. … Read More

YTD Flags in Power Query

YTD Flags in Power Query Dates tables are an integral part of any comprehensive data model. Dates tables allow you to normalize a variety of different date fields and perform calculations and filtering on all of those different fields at … Read More

Toggling Views with Bookmarks in Power BI

Toggling Views with Bookmarks in Power BI Bookmarks are one of my favorite features in Power BI because they allow for a lot of great customization options for user experience. In this blog, I am going to show you how … Read More

Switching Metrics in Power BI

Switching Metrics in Power BI To avoid having multiple tabs with the same charts, but different metrics, you have to get a little creative in Power BI. This blog will walk you through how to enable this toggle functionality in … Read More

What-if Analysis in Power BI

https://www.tessellationtech.io/wp-content/uploads/2020/09/2020-09-29-17-48-11_Trim.mp4 What-if Analysis in Power BI Leveraging parameters in Power BI can take your scenario planning to the next level. In the example below, we are using mock model output of a linear regression model to perform a what-if analysis … Read More

Fact of Fact Analysis Using Power Query

Fact of Fact Analysis in Power Query Building a data model in Power BI can be extremely easy. When primary keys match foreign keys one to one and when tables are built with a star schema in mind, things go … Read More