Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 | info@databear.com

Power BI solutions

Data Preparation Part 2 – Pivot vs Unpivot Columns

Power BI Cleaning and Transforming Data Pivot and unpivot columns in Power BI is very useful functionality for structuring data that cannot be used for reporting as-is.  The first blog post on data preparation covered the basics of cleaning and transforming your datasets. This blog post, will go into more advanced cleaning and transformation steps […]

Data Preparation Part 2 – Pivot vs Unpivot Columns Read More »

Power BI: Pivot and Unpivot Columns

Power BI: Pivot and Unpivot Columns

Pivot and Unpivot walkthrough in Power BI Power Query in Power BI provides very effective functionality to pivot and unpivot columns. For the pivot functionality you turn rows to columns and for the unpivot functionality the inverse is true where columns are transformed into rows. Power BI Pivot We will be working with the following

Power BI: Pivot and Unpivot Columns Read More »

Power BI: The Ferrari that never left the garage…

So far I’ve given you a very small glimpse of this marvelous thing called Power BI, and the old (IT dependent) vs. the new (Self-service BI) approaches. Let’s quickly paint a scenario: You wake up one morning and you have a beautiful red Ferrari parked in your garage (Oh yeah!!)… but you decide to walk

Power BI: The Ferrari that never left the garage… Read More »