EL ENG X404.8 - Business Intelligence With SQL Server
Business intelligence (BI) is revealed by combining operational information from various sources into a data mart and then providing insightful queries and reports to decision makers. BI has become an essential tool for strategic management, finance, customer service, marketing, sales and other business activities. Learn to analyze and develop a BI system, including programming examples using Microsoft SQL Server. You also learn to design insightful inquiries and reports, and gain an understanding of BI applications, data mart features, data mining algorithms and BI industry trends.
Course Outline
Course Objectives
- Understand business intelligence concepts and processes.
- Use SQL server relational databases to design and populate data marts.
- Create specific data mart applications based on business and marketing needs and goals.
What You Learn
- BI applications
- Data mart features in Microsoft SQL Server
- BI features in Microsoft Power BI
- Operational systems
- ETL (extract, transform and load)
- Relational databases with star schema
- How to create a data cube
- Aggregation and slowly changing dimensions
- Data mining algorithms including Association, Decision trees, Naïve Bayes, Neural Network, Regression, Sequence Clustering and Time Series.
- BI industry, tools and trends
How You Learn
- In-class presentations by instructor and BI industry professionals
- In-class exams
- Team programming assignments
- Analysis and design papers
Is This Course Right for You?
If you want to learn how to perform analytics in a business environment, then you should enroll.