Hi, I'm Elle.

I share design and development tips and tricks, lessons learned, and best practices – most of which were probably learned the hard way. Comments are welcomed.


Leave a comment

BI Dashboards: Get It Right From the Start

Questions courtesy of my project manager, Dean Call. Follow him on Twitter (@dacall) for more Knowledge Management insight. 

Business Intelligence dashboards are typically designed with simplicity in mind. After all, the only thing dashboards really do is highlight key information that allows business leaders make critical real-time decisions at a glance. Sounds pretty simple, right? Wrong!

Like many organizations with disparate silos of information, it’s very easy to get lost down a rabbit hole when designing and developing a dashboard solution. The key to staying on track is getting the right information you need from the start.

STEP ONE: Ask leaders, “What questions should the dashboard answer?”

And don’t expect your development team to know the answer. This is a question for leadership – and it is the very first question leaders should start with. Why? Because if your dashboard doesn’t help you make decisions, then it’s just data. And it doesn’t matter how pretty your charts and graphs are, without context or historical trending, the data won’t tell you a damn thing.

It’s like having a gas gauge in your car that only tells you how many gallons of gas you have. Unless you know the capacity of your tank and can quickly do the math, this information only becomes helpful when you can quickly relate it to how empty or full your tank is.

STEP TWO: Evaluate the Current State

This question, though, is just a start. After you figure out what questions the dashboard is supposed to answer, it’s time to ask many more questions. But don’t get ahead of yourself – take it step by step. Asking questions in the following order will ensure you have the right information you need to move forward successfully.

  • What pieces are we currently measuring and why?
    • What is the as-is?
    • What/how did we improve it?
    • Where does it fit?

STEP THREE: Focus on the Data

  • What data do you need to answer the first question?
    • Who owns the data?
    • Once you have the data, what is the process that will make it actionable?
      • Does it require validation?
      • Does it require manipulation (math, perhaps)?
      • Does it change?
        • If so, how often?
    • What is the best way to display this information?
    • Does it answer the first question?
      • If yes, move to the next question asked in Step One
      • If not, repeat Step Three until the answer is yes

As you can see, the first steps of implementing business intelligence dashboards has little to do with the technology used. However, it’s still important to get your development team on board at this stage.

From the start, encourage your tech team to approach this project with a business focus. Remind them that even though technology is facilitating the answers, it doesn’t define the answers. Heck, you may even want to remind your client too.

So what do you think?

  • From your experience, what are other important questions to ask?
  • What have you learned from being in similar situations?
  • What advice can you offer?


Leave a comment

Breaking Down the Baldrige Criteria

Currently, I’m working on a project to develop an Integrated Management System (IMS) for the Army’s Combined Arms Support Command (CASCOM) at Fort Lee, Virginia.

This project involves creating dashboards for the Two-Star Commanding General. CASCOM has decided to use the Baldrige Criteria as a guiding principle for the development of these dashboards. These dashboards will display the overall health index for the organization, organized by the seven Baldrige Criteria categories.

This presentation is a breakdown of the program’s background, purpose, and categories. I created this presentation to brief my team on the high-level program requirements.

Continue Reading →


Leave a comment

SharePoint Saturday 2013 – Richmond, VA

SP Sat

SharePoint Saturday Richmond 2013

This year, SharePoint Saturday Richmond was held Saturday, March 23 at the Richmond Convention Center in Downtown Richmond, VA. Over 25 speakers spoke about topics ranging from SharePoint branding best practices to building SharePoint 2013 farms and apps on Windows Azure to communicating the business value of SharePoint to executives.

Overall it was a diverse mix of informative sessions geared toward designers, developers, administrators, and end users. This event was free thanks to sponsors such as TCSC, Avepoint, Kodak, K2, and was made possible thanks to the Richmond SharePoint User Group.

I decided to volunteer again this year to work the registration table. Nothing too exciting – handing out name badges, signing people in – but nonetheless, a job that still needs to be done. For me, I enjoy volunteering at SharePoint Saturday because I feel it’s a way to give back to those who give so much in the SharePoint community.

The best part of volunteering this year was attending the speakers dinner the night before the event. It was a great opportunity to connect with the speakers in a casual, relaxed environment without the hustle and bustle of sessions the day of. In addition, it was entertaining to hear the horror stories of past clients and projects – the kind of stories the speakers would like to tell you during the sessions but know they shouldn’t. You know, the good stuff. But not so much the important stuff.

The important stuff is connecting with other professionals in the industry, building relationships, and having one-on-one interaction that opens the door for connecting again in the future.

metro

Metro Tabs by Kevin Guyer

For example, I attended Kevin Guyer’s session, “The Cheapskate’s Guide to Extending SP2010′s Functionality.” I left that session eager to use an already existing solution that he improved called Metro Tabs (an Easy Tabs alternative that looks like Windows 8).

Kevin wasn’t sure if there would be much interest in Metro Tabs, so he told us he’d post a link on his blog sometime in the near future with a link. After the session, I introduced myself and asked him a couple related questions, then started following him on Twitter. So what, right?

Well, it wasn’t until a couple of days later he posted a link to the final version of Metro Tabs on Twitter. Anxiously awaiting to test, I downloaded the necessary files and began adding web parts, hoping to see Metro Tabs in action. Unfortunately, it didn’t work as expected so I reached out to Kevin on Twitter. In less than a day, he messaged me back with the fix. Impressive! And they work great!

From this, I’ve learned there is so much to learn and so many people to learn from. And, when you’re at events like SharePoint Saturday, it’s all about sharing knowledge and building your professional network. These connections can be very valuable when you’re in a fast-paced, constantly-changing industry such as information technology.

What do you think?

  • If you attended SharePoint Saturday Richmond (or any SharePoint Saturday), what did you enjoy most?
  • Did you learn anything new and exciting?
  • Do you have any plans to go to future SharePoint events?


Leave a comment

Tech Resource: Safari Books Online

Receiving my monthly statement for my Safari Books Online subscription inspired me to share one of the best resources I’ve found for tech stuff so far…

safari

Read Safari Books Online using multiple devices.

If you’re a professional in the information technology industry, you probably already have an arsenal of tech books that keep piling and piling up. Then the software version changes, and the books become extinct. Not to mention, it’s a costly extinction.

So what is the best way to build your tech library and still have money in your pocket? I suggest giving Safari Books Online a whirl.

At first I shrugged off my coworker’s recommendation to sign up for a subscription but it turns out he was right. With Safari Books Online, you can find just about any tech book from just about any publisher – all for one low monthly price. And, this includes video tutorials, code samples, books, and certification prep guides.

Depending on your need to read, there are different membership options – and a free trial period.

Option 1 – Safari Bookshelf - Allows you to check out 10 books a month. While these books are in your bookshelf, you can read them online via browser or mobile device. If you’re like me and you work in a building that gets absolutely no cell service, there is a caveat: The number of books you can save locally to read offline is limited to three. While it’s not necessarily a bad thing, this plan does require me to be selective when choosing books.

Option 2 – Safari Library – Costs a little more per month but lets you have unlimited access to all books, including Rough Cuts (books in development but not published yet). If you like to stay ahead of the game, having access to Rough Cuts may give you the leverage you’re looking for.

Pretty smart, eh? And, it’s cheap too. Visit the Safari Books Online website to check the latest subscription prices. Regardless of which option you pick, you’ll surely learn something.

What do you think?

  • What are your favorite tech resources?


Leave a comment

Handy Tool: SharePoint 2010 CSS Reference Charts

Branding SharePoint sites to not look like SharePoint sites can be, well, let’s just say tedious. The following links are a couple valuable resources that I have found to help with referencing CSS objects in SharePoint.

Know of any others? Share them in the comments section below.


2 Comments

Create Custom Footer using SharePoint 2010 Master Page

Creating a SharePoint 2010 master page for a custom footer is very easy to do. Follow these simple steps to make a custom footer for your site.

For this exercise, we will be using a Publishing site. The difference between a Publishing site and a team site is the added layer of checking in/out files before publishing or previewing a live version. If you are not using a Publishing site, please disregard the related steps below.

  1. Copy Master Page
    1. Open site using SharePoint Designer 2010
    2. Click Master Pages in the left navigation pane
    3. Right click v4.master and select Copy, then paste
  2. Rename the New Master Page
    1. From the Ribbon, click Rename
    2. Type “Customfooter.master” (or any other name you choose)
  3. Edit the CSS Inline
    1. From the Ribbon, click Check Out
    2. Then, click Edit File
    3. Select Split View
    4. In code, find: <SharePoint:DeveloperDashboard runat=”server”/>.
    5. Add the following code just below the code listed above:
      <div class=”s4-notdlg” style=”clear: both; background-color: #FEAD30; padding: 10px;”> © Copyright XXXX 2013, All Rights Reserved </div>Image
    6. Click Save. If prompted, click Yes to overwrite existing site definition.
  4. Apply Default Master Page
    1. Click Master Pages from left navigation pane
    2. Select the row for Customfooter.master (or whatever you named your new file), BUT NOT the title itself.
    3. From the Ribbon, click Set to Default.
    4. Then, click Check In.
  5. View Your Changes
    1. Click Save
    2. Open site in browser, or click Preview in Browser

This information is shared courtesy of a fellow colleague, Larry Cureton. Follow him on Twitter (@llcureton) for more SharePoint related insight.

Follow

Get every new post delivered to your Inbox.