Course details
This course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining.
Course Outline
- Lesson 1: Introduction to Business Intelligence and Data Modeling
- Lesson 2: Implementing Reports with Reporting Services
- Lesson 3: Supporting Self-Service Reporting
- Lesson 4: Managing a Reporting Infrastructure
- Lesson 5: Creating Multidimensional Databases
- Lesson 6: Working with Cubes and Dimensions
- Lesson 7: Working with Measures and Measure Groups
- Lesson 8: Introduction to MDX
- Lesson 9: Customizing Cube Functionality
- Lesson 10: Implementing a Tabular Data Model by Using Microsoft PowerPivot
- Lesson 11: Introduction to Data Analysis Expression (DAX)
- Lesson 12: Implementing an Analysis Services Tabular Data Model
- Lesson 13: Creating Data Visualizations With Power View
- Lesson 14: Performing Predictive Analysis with Data Mining
Prerequisites
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
- 10774A: Writing Queries with Microsoft SQL Server Transact-SQL
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 courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Global CoursesSGD 20
SGD 191Duration: 2 Hours - SQL – Master SQL Database Queries Course DriveSGD 32
SGD 218Duration: Upto 1 Hour
