YTD Flags in Power Query

YTD Flags in Power Query What are YTD Flags in Power Query? Dates tables are an integral part of creating data models in Power BI. Dates tables allow you to normalize a variety of different date fields and perform calculations … Read More

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

Import v Direct Query: Here’s What You Need to Know When connecting to data in Power BI, you need to choose whether you want to use Import or Direct Query mode for connecting to your data. Using the Import method, … Read More

Optimizing Power BI Reports

Optimizing Power BI Reports Why is it Important to Optimize Power BI Reports? When developing reports in Power BI Desktop (or any software for that matter), good performance in terms of load time is important for gaining trust with stakeholders … Read More

Report Page Tooltips in Power BI

Report Page Tooltips in Power BI Fitting all the details you want displayed about a certain data point in your report can be a struggle. Often, it’s getting to that next level of your data’s granularity that is the tricky … Read More

Tableau Parameter Buttons

How to Create Custom Buttons in Tableau

Buttons are ubiquitous and self-explanatory to use, and yet it feels like our options for creating and implementing them in Tableau can be quite limited. Not anymore! This guide will walk you through the steps needed to create beautiful and functional buttons in Tableau for a variety of needs. … Read More

The CALCULATE() Function in Power BI

The CALCULATE() Function in Power BI For readers familiar with Power BI, you already know that the CALCULATE function is one of the most important DAX functions in the platform. This function is commonly used, extremely useful, and opens up … Read More

How to Create YTD Calculations in Power BI​

How to Create YTD Calculations in Power BI Recently, Tessellation put out a blog covering how to create Year to Date (YTD) calculations in Tableau, which you can find here. Regardless of what industry or company you work in, comparing … Read More

How to Create YTD Calculations in Tableau

How to Create YTD Calculations in Tableau One of the most commonly requested items in Tableau dashboarding is to show your metrics as Year to Date (YTD), Prior Year to Date (PYTD), and Year over Year change (YoY). Although seemingly … Read More

3 Reasons Why You Should Change Careers into Data Analytics in 2021

At this point in your career, I’m guessing you are probably curious about the world of data analytics. Perhaps you feel stuck in your current job during the pandemic and want to know how feasible a career switch into data analytics is. … Read More

Dynamic Rows and Columns in Tableau

Dynamic Rows & Columns in Tableau Recently Luke Stanke and myself held a webinar discussing some cool ways to enhance P&L statements and other financial reporting. This blog post contains detailed instructions on how to use some of the techniques … Read More