DataMarts NIC Next Generation Reporting Strategy

1
DataMarts _at_NICNext Generation Reporting Strategy

• June 2007

2
Todays Topics

• NICs Reporting Strategy
• Information Centers
• Summer 2007 Reporting Pilot
• Demonstration

3
Current GenerationReporting Strategy

• Custom Envision
• Excel and Access
• Query Builder
• Custom Uniquery Paragraphs
• Some DataMart
• Student and Applicant data
• Census weekly snapshots

4
Next Generation Reporting Strategy

• Formalization of Information Centers
• Excel pivot tables
• Web delivered reports
• Less reliance on Access
• DataMarts
• Beyond Student and Applicant data
• Automated snapshots

5
Current GenerationReporting Strategy
Report Viewer
Report Consumers
Power Users
Query Builder
Transactional Server
6
Next GenerationReporting Strategy
Report Viewer
Report Consumers
IC Coordination Group
Report Builder
Data Modelers
Visual Studio
DataMart Server
7
Next GenerationReporting Strategy
Report Viewer
Report Consumers
IC Coordination Group
Report Builder
Data Modelers
Visual Studio
DataMart Server
8
IC Coordination Group
Information Specialist (as defined by official
job description responsibilities)
9
IC Coordination Group

• Roles include report authoring, training,
  establishing standards, defining report request
  methodology
• Group will meet regularly to discuss roles and
  other items that may arise

10
Next GenerationReporting Strategy
Report Viewer
Report Consumers
IC Coordination Group
Report Builder
Data Modelers
Visual Studio
DataMart Server
11
What is a Report Model?

• A report model is a description of an underlying
  database that is used for building reports. It is
  an additional layer of information that maps
  database tables and views into concepts that are
  meaningful to report authors.

12
Why Use Report Models?
13
Mapping Information
14
What does that mean?
15
What is Report Builder?

• Report Builder is a tool that creates reports.
  Report Builders user-friendly model lets report
  authors build reports without needing a deep
  technical understanding of the underlying data
  sources.

16
Report Builder
17
Next GenerationReporting Strategy
Report Viewer
Report Consumers
IC Coordination Group
Report Builder
Data Modelers
Visual Studio
DataMart Server
18
What is a Report Server?

• A complete set of tools that you can use to
  create, manage, and view reports.
• Hosts reports in a variety of formats. Output
  formats include HTML, PDF, TIFF, Excel, CSV, and
  more.

19
Report Server

• ? Open the web page http//nicblade05.nic.edu/Re
  ports

20
Report Viewer

• ? Web Delivered Reports

21
Report Viewer

• ? Excel delivered reports

22
Report Viewer

• ? Excel delivered reports (pivot table)

23
Summer 2007 Reporting PilotExpectations

• Training on 7/24 and 7/25
• Optional Tuesday afternoon working sessions after
  July training
• Participate in re-cap of pilot
• Determine regularly scheduled IC Coordination
  Group meetings

24
Break6/13 SurveyDemonstration