BUSINESS INTELLIGENCE SOLUTIONS WITH SQL SERVER 2012

This course will teach students how to create meaningful Business Reports using Microsoft Excel, SQL Server Queries and databases from BIG DATA.

Course Outline:

• Business Intellighence

• Defining Business Intelligence Structures

• Analyzing Cube Content

• Delivering

Materials

• Virtual Workstation to practice at home

• Windows Server 2012 with SQL Server 2012 Virtual Machines

• PRO SQL Server 2012 BI Solutions (Randal Root & Caryn Mason)

• Sample Databases and Exercises

Who should participate?

• Business and marketing professionals

• Data Analysts who deal with large amounts of data

• Operation Managers

• Business Owners

Feb

08

Day

WORD LEVEL I - FOUNDATION

Learn: Paragraph Spacing, Margins, Columns, etc.

Feb

16

Eve

QUICKBOOKS LEVEL I

Learn to: Enter/Pay Bills, Payroll, Bank Reconciliation, Customer Payments, etc.

Feb

22

Eve

INCOME TAX LEVEL I - PERSONAL

Learn: Child Care, Rent, Tuition, RRSP/HBP, Moving, etc.

Feb

15

Day

WORD LEVEL II - INTERMEDIATE

Learn: Tables, Header/Footer, Mail Merge, Etc.