Category Archives: BI

Quick Chart: SharePoint/Microsoft List Data

In SharePoint online, the Quick Chart web part can show you dynamic data from a list!   As long as you have a SharePoint list (aka Microsoft list) on your site that has at least one number or currency column, you can use it in the web part settings, to display as a chart.  In this post, I’ll detail the steps

Read more

Charts in Power Apps

There are several different ways that you can accomplish building charts in PowerApps, ranging from the high-end Power BI, all the way to something simple like a series of rectangles with variable widths.  In this post and associated video, I’ll go over your current options, what you’ll need in order to accomplish them, and what’s possible.  For Power BI, I’m

Read more

New Modern Web Parts – Full List

In Office 365, you may notice that there are more new things rolling out right now.  This post is all about the new page editing experience and new web parts.  Here’s what I’ll cover: How to use the new page editing interface How to use each of the new web parts How to set your new page as the homepage

Read more

Adventures in Power BI and DAX

This one is going to be a bit different than a lot of what I usually write, but I learned something new today, and wanted to share some of the steps with you.  I worked in Power BI in Office 365 today, and learned a little DAX, which stands for Data Analysis Expressions. Here’s the challenge.  I have a list

Read more

Getting PerformancePoint up and running

Thought I’d kick the tires on PerformancePoint in SharePoint 2013 today, and share with you the steps I had to take to make it usable. In Central Administration, in the list of service applications, click on the PerformancePoint Service application. (assuming you already installed this service app) Click PerformancePoint Service Application Settings – type your unattended service account, in my

Read more

Report Viewer: Create a Hyperlink to SharePoint

If you’re not aware yet, the upcoming version of SharePoint (2013) does not include a design view in SharePoint Designer anymore, which means no more no-code data view web parts. SSRS reports are a great replacement for the data view web part in many cases.  In this post, I’ll show you how to create a conditionally formatted list of tasks

Read more

Display User Data Fields for a SharePoint List

You have all of this data in SharePoint, and you have all of this information about the site users, such as their department names, phone numbers, and much more. Instead of asking for site users to fill out all of their pertinent information every time they fill out a list item, form or survey in SharePoint, wouldn’t it be nice

Read more
« Older Entries