Havens Consulting
Video by: Reid Havens
One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.
Video by: Reid Havens
Learn about an important feature in the Power BI query editor, referencing other queries. Using this feature will help reduce query dependencies and allow for easier updates if the data source changes for the report.
Video by: Reid Havens
An important but overlooked feature of Power BI report building is the ability to name objects in the selection pane. It both helps to organize the report objects for development, and aids in the creation of bookmarks.
Video by: Reid Havens
Failing to deliver a well-designed Power BI Report is a very common reporting pitfall. What good is quality data if it is not presented in a way that is meaningful or easily understood? This video discusses visual cues, and how certain chart types can convey data more accurately than others. Plus we'll cover a tool called the visuals reference, provided by the folks over at SQLBI.com, that can help in choosing the right visualization to use.
SQLBI Visuals Reference Link:
https://www.sqlbi.com/ref/power-bi-visuals-reference/
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
