2016 – 2017
Florida Department of Education
Curriculum Framework 

Program Title:	Business Intelligence Professional
Career Cluster:	Information Technology

CCC	
CIP Number	0552130101	
Program Type	College Credit Certificate (CCC)	
Standard Length	20 credit hours	
CTSO	Phi Beta Lambda, BPA 	
SOC Codes (all applicable) 	15-1199 – Computer Occupations, All Others	
CTE Program Resources 	http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml	

Purpose

This certificate program is part of the Business Intelligence Specialist AS degree program (1552130100).

A College Credit Certificate consists of a program of instruction of less than sixty (60) credits of college-level courses, which is part of an AS or AAS degree program and prepares students for entry into employment (Rule 6A-14.030, F.A.C.).

This program offers a sequence of courses that provides coherent and rigorous content aligned with challenging academic standards and relevant technical knowledge and skills needed to prepare for further education and careers in the Information Technology career cluster; provides technical skill proficiency, and includes competency-based applied learning that contributes to the academic knowledge, higher-order reasoning and problem-solving skills, work attitudes, general employability skills, technical skills, and occupation-specific skills, and knowledge of all aspects of the Information Technology career cluster.

The content includes but is not limited to instruction in documenting specifications for business reports; locating, acquiring and modeling data for analysis and output; building and generating reports; and business intelligence techniques. 

Additional Information relevant to this Career and Technical Education (CTE) program is provided at the end of this document.

Standards

After successfully completing this program, the student will be able to perform the following:

01.0	Document specifications for and generate standard or custom reports, that summarize business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
02.0	Define and differentiate among data constraints, filters, exception threshold, and data organization factors important in the creation of a report.
03.0	Locate, acquire, and model the data for analysis and output.
04.0	Compare and contrast the various forms for report presentation.
05.0	Describe the advantages and disadvantages for various report delivery mechanisms.
06.0	Reassess current business intelligence or trend data in support of altered information needs.
07.0	

2016 – 2017
Florida Department of Education
Student Performance Standards

Program Title:	Business Intelligence Professional
CIP Number:		0552130101
Program Length:	20 credit hours
SOC Code(s):		15-1199

This certificate program is part of the Business Intelligence Specialist AS or AAS degree program (1552130100).  At the completion of this program, the student will be able to:	
01.0	Document specifications for and generate standard or custom reports, that summarize business, financial, or economic data for review by executives, managers, clients, and other stakeholders. – The student will be able to:	
01.01	Compare attributes and benefits of available data sources.	
01.01.1	RDMS.	
01.01.2	OLAP Cubes.	
01.01.3	Spreadsheet.	
01.01.4	XML.	
01.01.5	CSV.	
01.01.6	Web service.	
01.02	Define report data elements/requirements (metadata).	
01.02.1	Dimensions.	
01.02.2	Type I (As is – current).	
01.02.3	Type II (Historical – slowly changing).	
01.02.4	Facts.	
01.02.5	Base.	
01.02.6	Summaries.	
01.02.7	Calculated fields.	
01.02.8	Periodicity.	
01.02.9	Relationships/JOINs.	
01.03	Describe how data is to be used and retained (disposition).	
01.03.1	Data mining.	
01.03.2	Filtering.	
01.03.3	Exception threshold alerts.	
01.03.4	Aggregating.	
01.03.5	Snapshot.	
01.03.6	Dynamic.	
01.03.7	Historical/archive/disposal.	
01.04	Determine the form of analysis.	
01.04.1	Comparative analysis.	
01.04.2	Impact analysis.	
01.04.3	Correlational (affinity) analysis.	
01.04.4	Trending/Forecasting.	
02.0	Define and differentiate among data constraints, filters, exception threshold, and data organization factors important in the creation of a report. – The student will be able to:	
02.01	Distinguish between data constraints and filters and their appropriate use.	
02.02	Describe how each of the following data constraints relates to the creation and/or delivery of a report.	
02.02.1	Size of recordset (scope & performance).	
02.02.2	Time/period (end points and span).	
02.02.3	Range (e.g., # of records).	
02.02.4	Data element (e.g., type, size).	
02.02.5	Localization (programming & display language).	
02.03	Describe how each of the following types of filters may be used to refine or enhance a report.	
02.03.1	Dimensions (Type I and Type II).	
02.03.2	Facts (e.g., base, summaries, calculated fields).	
02.04	Illustrate how the use of an exception threshold contributes to the operational effectiveness of a report.	
02.04.1	Display or action dependent on threshold.	
02.04.2	Triggers alert or advance warning of approaching static threshold.	
02.04.3	Highlights results exceeding dynamic threshold.	
02.05	Compare and contrast the following forms of data organization in terms of representation and analysis of data results.	
02.05.1	GROUP BY.	
02.05.2	ORDER BY (SORT).	
02.05.3	Concatenation/substring.	
02.05.4	KRAN.	
03.0	Locate, acquire, and model the data for analysis and output. – The student will be able to:	
03.01	Identify the types of data that might be used to create business intelligence reports in support of the organization’s business and financial strategic goals.	
03.01.1	Inventory repositories.	
03.01.2	Sales data.	
03.01.3	Customer data.	
03.01.4	Employee/staffing data.	
03.01.5	Financial data.	
03.02	Describe the risks and potential areas of concern related to the use of external data.	
03.02.1	Integrity/validity of data.	
03.02.2	Legality of data availability.	
03.02.3	Privacy issues of data acquired.	
03.02.4	Confidentiality of acquisition.	
03.03	Describe potential issues, concerns, and obstacles associated with the use of data sources.	
03.03.1	Data form.	
03.03.2	Data integrity.	
03.03.3	Normalization.	
03.04	Describe the role and implications of standardization relative to internal and external data sources.	
03.04.1	Describe the need for data typing and transformation.	
03.04.2	Describe the methods by which transformation may be accomplished.	
04.0	Compare and contrast the various forms for report presentation. – The student will be able to:	
04.01	Describe the attributes of a report suitable for creation using a report generator.	
04.02	Describe the attributes of a report suitable for presentation in spreadsheet form.	
04.03	Describe the attributes of a report suitable for presentation in database form.	
04.04	Describe the attributes of a report suitable for presentation in OLAP Cube or hypercube form.	
04.05	Describe the attributes of a report suitable for presentation in HTML/Flash.	
04.06	Describe the attributes of a report suitable for presentation in graph form.	
04.07	Describe the attributes of a report suitable for presentation via a dashboard interface.	
05.0	Describe the advantages and disadvantages for various report delivery mechanisms. – The student will be able to:	
05.01	Email.	
05.02	Web-based.	
05.03	Mobile device.	
05.04	Intranet.	
05.05	Print/PDF.	
05.06	Oral presentation.	
06.0	Reassess current business intelligence or trend data in support of altered information needs. – The student will be able to:	
06.01	Identify and relate report design constraints and their relationship to data.	
06.02	Evaluate current technology in terms of compatibility and capacity for meeting new or evolving information needs.	
06.03	Re-construct report based on alternative parameters.	
06.04	Adapt and validate report based on new requirements.	

Additional Information

Laboratory Activities

Laboratory investigations that include scientific inquiry, research, measurement, problem solving, emerging technologies, tools and equipment, as well as, experimental, quality, and safety procedures are an integral part of this career and technical program/course. Laboratory investigations benefit all students by developing an understanding of the complexity and ambiguity of empirical work, as well as the skills required to manage, operate, calibrate and troubleshoot equipment/tools used to make observations. Students understand measurement error; and have the skills to aggregate, interpret, and present the resulting data. Equipment and supplies should be provided to enhance hands-on experiences for students.

Career and Technical Student Organization (CTSO)

Phi Beta Lambda and Business Professionals of America (BPA) are the intercurricular career and technical student organizations providing leadership training and reinforcing specific career and technical skills.  Career and Technical Student Organizations provide activities for students as an integral part of the instruction offered.  

Accommodations

Federal and state legislation requires the provision of accommodations for students with disabilities to meet individual needs and ensure equal access. Postsecondary students with disabilities must self-identify, present documentation, request accommodations if needed, and develop a plan with their counselor and/or instructors. Accommodations received in postsecondary education may differ from those received in secondary education. Accommodations change the way the student is instructed. Students with disabilities may need accommodations in such areas as instructional methods and materials, assignments and assessments, time demands and schedules, learning environment, assistive technology and special communication systems. Documentation of the accommodations requested and provided should be maintained in a confidential file.

Additional Resources

For additional information regarding articulation agreements, Bright Futures Scholarships, Fine Arts/Practical Arts Credit and Equivalent Mathematics and Equally Rigorous Science Courses please refer to:
http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml