Visualizing eSignature Data in Power BI

In this video, we take our previous example of DocuSign eSignature data and visualize it in Power BI. We show how to build a link to the form attachment(s), turn them into clickable web URLs, create slicers, edit interactions to filter rather than highlight, create a “Days Open” column, publish to the Power BI service, edit the data connection to allow scheduled refreshes, and more.

Subscribe to My Channel

 

My Book: Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate

Advertisement

Forms – Power Automate – SharePoint and then Showing the Most Current Submission in Power BI

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.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Creating an Employee Recognition App in Power Apps, Power Automate, Power BI, Teams, and SharePoint

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.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Joining SharePoint Lists in Power BI

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.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Working with SharePoint Lookup Columns in Power BI

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.

Subscribe to My Channel

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Creating a Power BI Visualization from SQL Server Data

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.

Subscribe to My Channel

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Connecting to Excel from Power BI

In this video, we connect Power BI to an Excel spreadsheet and then use its power to visualize the data.

Subscribe to My Channel


My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Creating Business Applications with Office 365 eBook on Sale for $7 this week

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.

Creating a Survey in Forms, Copying the Responses to SharePoint with Flow, & Visualizing in Power BI

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.

Subscribe to My Channel

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Visualizing a SharePoint Survey with Power BI

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.

Subscribe to My Channel

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More