Course details
This workshop teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform.
- Lesson 1: Planning a BI Solution
- Lesson 2: Planning SQL Server Business Intelligence Infrastructure
- Lesson 3: Designing a Data Warehouse
- Lesson 4: Designing an ETL Solution
- Lesson 5: Designing Analytical Data Models
- Lesson 6: Planning a BI Delivery Solution
- Lesson 7: Designing a Reporting Services Solution
- Lesson 8: Designing a Microsoft Excel-Based Reporting Solution
- Lesson 9: Planning a SharePoint Server BI Solution
- Lesson 10: Monitoring and Optimizing a BI Solution
- Lesson 11: Operating a BI Solution
Prerequisites
Before attending this course, students must have:
- A basic understanding of dimensional modeling (star schema) for data warehouses.
- The ability to create Integration Services packages that include control flows and data flows.
- The ability to create a basic multidimensional cube with Analysis Services.
- The ability to create a basic tabular model with PowerPivot and Analysis Services.
- The ability to create Reporting Services reports with Report Designer.
- The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services.
- Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel.
Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Programming Complete Bundle Apex LearningAED 83
AED 771Duration: Upto 8 Hours - SQL Developer Diploma Lead AcademyAED 92
AED 1,432Duration: Upto 5 Hours