Location:
Tucson Police Department
1310 W. Miracle Mile
Tucson, AZ 85705
Room: Rillito Meeting Room
12:30 – 1:00 pm | Check-In
1:00 – 1:10 pm | Welcome & Announcements
1:10- 1:45 pm | Building Web Intelligence Dashboards – Part 1 – Roxanne Pittman, InfoSol Inc
In this session we will create a Webi Dashboard use the 80/20 rule to focus attention on the top performers and also incorporate Trend charts with shared elements.
1:45- 2:20 pm | Using Excel Files In Web Intelligence – Michael Ward, CTTS
This presentation will provide the user with a variety of ways Excel files can be used in reporting. It will include using Excel as a data provider, using Excel for a bridge file when encountering incompatible format types, as a dynamic filer file, and other uses. IT will include an in-depth look at how to properly import an Excel files, where to store the Excel file, and how to update an Excel file without breaking the Webi Document. It will include some nice tips and techniques when using Excel files. It will open your eyes to the real power of an Excel file.
2:20- 2:35 pm | Leveraging formulas in WebI – Ozlem Kacira, Pima Community College
We will show how complex formulas have been implemented in the reports to compare different snapshot data rather than using nested or subqueries. Also we will show how to add scrolling html marquee to make more attractive dashboards.
2:35- 2:50 pm | Break & Networking
Enjoy some delicious snacks and drinks.
2:50- 3:25 pm | Building Web Intelligence Dashboards – Part 2 – Roxanne Pittman, InfoSol Inc
This session will demonstrate how to add conditional formatting to a chart and use a dual slider to view data more precisely. We will also show how to display key data points on chart – showing beginning, low, high and ending points for quick analysis.
3:25- 4:00 pm | IDT Overview – Michael Ward, CTTS
A high level look at building universes with the new IDT. Learn about creating connections, building the data foundation layer, adding a business layer, and applying security profiles. Also learn about creating LOV’s and combining those with Parameters. Defining Context, adding aggregate awareness, and sharing project will also be covered.
4:00 – 4:15 pm | Raffle & Prizes