In the words of mighty Julius Caesar, “Divide and conquer”, and data is no different. We can break down any complex problem into buckets and forge a path to purposefully resolve it....
In the words of mighty Julius Caesar, “Divide and conquer”, and data is no different. We can break down any complex problem into buckets and forge a path to purposefully resolve it....
Topics: Data, Power BI, Data Visualization
After working in Business Intelligence for several years I have come to the conclusion that there are some visuals that are foundational to data exploration and decision making. One...
Topics: Business Analysis, Data, Power BI, Visualization, lattice chart, small-multiple charts, grid chart, clustered bar chart, trellis chart, panel chart
Welcome back to Data Science Wednesday! On this week's episode, Decisive Data's Lead Data Scientist Tessa Jones goes over what really is diagnostic...
Topics: Blog, Data, Power BI, Tableau, Data Science Wednesday
Welcome back! On this weeks episode of Data Science Wednesaday, Decisive Data's Lead Data Scientist Tessa Jones takes us through a basic understanding of...
Topics: Power BI, Tableau, Visualization, Data Science Wednesday
In this blog post we are going to look at using what I call a Reporting Options table in Power BI, SSAS Tabular, or Power Pivot. A Reporting Options table gives users a simple way to...
Topics: Power BI, Reporting Options Table
This post describes how to change a Power BI data source from a CSV or Excel data source to a SQL Server Database connection.
This is not very intuitive because Power BI does not yet...
Topics: Power BI
This article summarizes four common Power BI Data Infrastructure options as of July 2016.
Imported Data
All data will be stored in the Power BI cloud in a SQL Server...
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
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
It’s rare to come across a report or data set that does not slice by time. While it’s necessary for virtually all reports, analysts often underestimate the difficulty of creating time...
PowerPivot is an incredible, under-appreciated tool for data analysis. But using such a robust program can be intimidating at first. This article will cover some basic DAX functions to...