Information on Office 365, SharePoint, Power BI, PowerApps, JavaScript, jQuery, and more.
August 14, 2021 Leave a comment
In this video, we take a simple Microsoft Form, copy each entry to SharePoint with Power Automate, and then visualize the data in Power BI. The main insight is to show only the most recent form submission by grouping within Power BI, creating a MaxDate column, and then filtering.
May 31, 2021 Leave a comment
In this video, we demonstrate how to create a Power Apps and Power Automate employee recognition solution that can post the recognition to a Teams channel, send a Teams chat, and/or send via email. We try to make it optional for submitters to include their information, finding it works for chats and email but not posts. We store the information in SharePoint and then use Power BI to visualize the values demonstrated and other data.
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.
