Rebecca Culver's Articles

Rebecca Culver's avatar

posted by
4342 views

SQL Server 2016 Reporting Services to Offer Export to PowerPoint

In many environments, presentations are always offered in PowerPoint format. This is true even if the recipients will receive the deck via email, rather than viewing it in a meeting. For report writers and deck assemblers, th ...


Rebecca Culver's avatar

posted by
1298 views

Getting Visual with PowerView

Over the last few years, we have found ourselves working more frequently with charts in our reporting.  Why? First, we need to keep pace with media out in the world. The messages our audiences receive are increasingly vi ...


Rebecca Culver's avatar

posted by
1171 views

Project Online–Time Phased Reporting in Excel part III

Over the last few months, we’ve been exploring Time Phased reporting using Excel.  In our last post on this subject, Project Online Time Phased Reporting in Excel part II, we talked about using the Time table in Odata re ...


Rebecca Culver's avatar

posted by
1173 views

Project Online Reporting with Excel: Why Isn’t My Data Model Working?

Recently, we were working on a nice set of Project Online timesheet reports for a client.  The fields we needed were in these Odata tables: Tasks TimesheetLines TimesheetLineActualDataSet We knew we were going to need t ...


Set for Success: Good Portfolio Data thumbnail

Rebecca Culver's avatar

posted by
1071 views

Set for Success: Good Portfolio Data

It is Fall and a big time for Sports. A team effort is required at work, just as it is on the sports field. Our rule is: No Good Portfolio Data Unless Everybody Plays! All the pieces are in place: You have Project ...


Rebecca Culver's avatar

posted by
2381 views

Excel–Creating a Heatmap that Keeps its Formatting

We love using Excel with Project Online or Project Server to pull updated live data at any time. Often, our clients want to see this data with some sort of conditional formatting.  Maybe it’s a heatmap throughout a numbe ...


Rebecca Culver's avatar

posted by
1214 views

Hidden Files in Sharepoint Libraries

We’ve recently been assisting a client with a migration from Project Online to full blown Office 365. This project included rebranding the user experience, which led to a need to move the Project materials under a new site. W ...


Rebecca Culver's avatar

posted by
1199 views

Project Center Views–Group by Year, Quarter and Month

Project Center is a great tool for presenting a portfolio in a snapshot. Using the right filters and grouping, you can quickly show health across the portfolio, projects grouped by client, capitalized vs. non-capitalized proj ...


Rebecca Culver's avatar

posted by
767 views

BI for Project Server and Project Online: Using Color to Tell the Story

Being a visual person, I love the idea of charts, views and graphs. These tools make it easy to tell your story at a glance.  Are our projects in good health? Do we need more resources to accomplish our goals? Is our ris ...


Rebecca Culver's avatar

posted by
1405 views

Project Online–Time Phased Reporting in Excel, part II

Last week, we talked about using the Odata Timeset table to create time phased reports in Excel: Project Online - Time Phased Reporting in Excel - INTEGENT BLOG We noted the Timeset table provides Week number, Month number ...


Rebecca Culver's avatar

posted by
996 views

Project Online - Time Phased Reporting in Excel

Time Phased Reporting presents special challenges for Project Online users.  The good news is that a simple timesaving solution has been provided. There is an entity set (essentially a table) provided called TimeSet.&nb ...


Rebecca Culver's avatar

posted by
1104 views

How to Edit a Connection String in Excel PowerPivot

The functionality in Excel’s PowerPivot is wonderful. My favorite is the ability to add columns that contain functions, and I use this frequently for client reports. So, this is all great.  New functionality, happ ...