Category Archives: BI

Effortlessly Create a SharePoint Dashboard

Last week, we had a customer ask about Power BI. We had a chat about what the Power BI need was, so that we would know how complex of a project it would be, and what it would entail. The main reason for Power BI, they said, was the need for dashboards for executives and managers to look at and

Read more

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
« Older Entries