Information on Office 365, SharePoint, Power BI, PowerApps, JavaScript, jQuery, and more.
February 13, 2021 Leave a comment
In this video, we look at a different way to visualize data from a lookup column in SharePoint. We join the columns in Power BI and then use both lists to create our visualizations.
January 31, 2021 Leave a comment
In this video, we explore how to use the FieldValuesAsText functionality in Power BI to get the data from within a SharePoint Lookup column. We also explore the 2.0 beta version of the SharePoint Online List data source as well as creating custom columns and filtering by Content Type.
May 25, 2020 Leave a comment
In this video, we create a Power BI visualization using a query from Microsoft SQL Server. Specifically, we join several tables from the Tracker.Net Learning Management System to visualize student and lesson information. We cover slicers, cards, pie charts, tables, and the Text Filter control. We also examine how to customize the drill-down interactions with the pie charts.
December 22, 2019 Leave a comment
In this video, we connect Power BI to an Excel spreadsheet and then use its power to visualize the data.
November 30, 2019 Leave a comment
My book Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More is on sale for $7 this week as part of the Apress Cyber Monday Sale. Enter code CYBERWEEK19 at checkout. Here is the direct link: https://www.apress.com/us/book/9781484253304.
September 11, 2019 Leave a comment
In this video, we create a help desk survey in Forms, copy each response to SharePoint using Flow, and then use the SharePoint list as Power BI data source for our visualizations.
September 11, 2019 Leave a comment
In this video, we explain the advantages of using Power BI to visualize SharePoint survey data and then create a powerful visualization that shows responses in the last week, month, and year.
August 31, 2019 Leave a comment
Please check my new YouTube channel at “https://www.youtube.com/channel/UCadnfEVO8PD48xbsE2GhxEg?view_as=subscriber. It has examples from my upcoming Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More book as well as other programming and application examples.
August 28, 2019 Leave a comment
We are exciting to announce this new book by Jeff Rhodes being published by Apress. Preorder now on Amazon and coming soon to other retailers.
Watch for upcoming posts and videos on Office 365 and related technologies.
