Class / Schedule

-

Information Technology

Data Analysis, Integration and Business Intelligence (2 Days)

01-05-T931

Take the first steps to identify key concepts in business intelligence, including data analysis, integration and reporting.  This a huge topic that arches into a variety of business programs and concepts to assist in business decisions and database and application structures.  Understanding the overarching concepts can give you a head start when begin work on projects involving business intelligence.

Finding agile solutions in a technical world and delivering technology projects can be difficult, particularly understanding how different technological elements work together towards a solution.  This is the recommended ninth and final class of the Technical Solutions Delivery Certificate that provides an overview of technological understanding to help in the communication of projects and working relationships.
Class format includes lecture, hands-on exercises, and real world examples using SQL Server tools.
Performance Objectives:  Upon completion of this class, you should be able to:

  • Identify Business Intelligence in SQL Server involving integration, analysis and reporting
  • Work with SQL Server Data Tools and Management Studio
  • Understand Integration Services and Extract, Transform, Load (ETL) processes
  • Identify Analysis Services OLAP cubes and MDX SQL queries
  • Use Reporting Services to summarize, format and print data
  • Determine the right tool for the task at hand
  • Discuss front end tools (such as those in Excel) for Business Intelligence for end users

Competencies Covered in this course:  Overall review of technical structure

Intended Audience: This course is ideal for anyone, but especially communications professionals, who are involved in the conception.  This class is aimed at non IT professionals to gain an understanding with the IT world.

Recommended Prerequisite: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Jan 29 2020 8:00am-4:30pm
  • Jan 30 2020 8:00am-4:30pm
$575.00 Sun, 01/12/2020 - 16:00 Jillian Bates
2 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Apr 22 2020 8:00am-4:30pm
  • Apr 23 2020 8:00am-4:30pm
$575.00 Sun, 04/05/2020 - 17:00 Jillian Bates