Lab 12
Executive Dashboard - OMIS 675
Use Charts to summarize your server status’, your ticket status, Add quotes feed from Yahoo Finance – follow your 5 favorite companies. Add your own business news widget. Due 4/9
- Use Charts to summarize your server status.
- Before you get started, create a folder on the C drive of your web server called TempImageFiles.
- Create a new web form called Dashboard (make sure to select your master page)
- Insert a 4 x 3 Table into the MainContent area of your page.
- Create the following labels to define the sections
- Expand the Data toolbox, drag a Chart control to the cell below your Server Status label
- .
- Set Chart Type to Column
- Create a new Data Source
- Configure the new data source, use a custom SQL statement.
- Your goal for this chart is to display the number of servers that have a ‘DOWN’ status for each of your applications. I used the following SELECT Statement.
SELECT COUNT (STATUS) as 'DOWN', APP_ID as 'APPLICATION'
FROM Servers
Where STATUS = 'DOWN'
Group by APP_ID
- Your test query should look something like this. Keep in mind that for this to work you’ll need servers that have a down status. Shouldn’t be too hard to make this happen using your System Tracker. PS. Remember the server status is case sensitive.
- Set your X and Y Value Members as shown
- In your chart’s properties, ensure the Palette is set to None. Type RED into the PaletteCustomColors field.
- Save, and visit your site on the web. Should look something like this:
- Now create a new chart that shows the same information for servers that have a ‘WARNING’ Status. Use yellow for the series color. Create this in the next cell
- Use Charts to summarize your INCIDENT status.
- Using what you learned above, create a Pie chart that connects to your incident table and displays your OPEN and CLOSED tickets.
- Should look something like above.
- Yes, you’ll have to tinker with the custom query.
- Grading note: I will be changing the status of your tickets, and servers – so please ensure all your labs are working enough to accommodate that
- Add a news/quotes/stock ticker feed from Yahoo Finance
- Google ‘Yahoo finance widget’
- Follow the instructions to add your 5 favorite companies, and to embed the widget in the lower left cell of your table. Hint: put your cursor in the cell, then go to source and paste the code in.
- Incorporate a business news widget
- Search the web for ‘business news widget’. Find something you like and embed the code.
- Hopefully your site is looking something like this now.