This post will show you how to show items with no data from tabular model using an Excel Pivot Table. The reason for this post stems from the below picture.
As you can see in a...
This post will show you how to show items with no data from tabular model using an Excel Pivot Table. The reason for this post stems from the below picture.
As you can see in a...
Topics: Blog, Data, DAX, Excel, Excel and PowerPivot, PowerPivot
Ever been tasked with analyzing data from a table, but you have little-to-no understanding of the "origin" and/or "meaning" of its various columns?
Topics: Blog, Data, Excel, Excel and PowerPivot, Functions, Large data set, SQL
The following post describes how to quickly extract useful information from a small data set using DAX, Tabular, and Power BI.
To get the most from your data it pays to quickly move...
Topics: Blog, Data, Excel, Excel and PowerPivot, Power BI, PowerPivot, SSAS, Tabular
One of the coolest things about Business Intelligence is finding new ways to get and analyze data. That’s why one of my favorite features in the PowerBI suite is the ability to extract...
Topics: Blog, Business Analysis, Data, Excel, Excel and PowerPivot, Power Query, PowerPivot
Tabular Cubes are quickly becoming one of the most popular ways to develop data models to support Business Intelligence. They can be developed quickly; building a full model with a...
Topics: Blog, Cubes, DAX, Excel, Excel and PowerPivot, Functions, Power BI, PowerPivot
PowerPivot is a remarkable tool that allows regular users to create relational data models and calculations within an Excel workbook. It’s a relatively simple program to use, but it...
Topics: Blog, Business Analysis, Data, DAX, Excel and PowerPivot, Functions, Power BI, PowerPivot