Loading Events

« All Events

  • This event has passed.

20768: Developing SQL Data Models

February 19 @ 8:00 am - February 21 @ 5:00 pm

|Recurring Event (See all)

One event on March 21, 2018 at 8:00am

One event on April 16, 2018 at 8:00am

One event on May 30, 2018 at 8:00am

One event on June 27, 2018 at 8:00am

Live Online Instructor Led

About this course

The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

Audience profile

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.
Primary responsibilities will  include:
• Implementing multidimensional databases by using SQL Server Analysis Services
• Creating tabular semantic data models for analysis by using SQL Server Analysis Services

At course completion

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis

Details

Start:
February 19 @ 8:00 am
End:
February 21 @ 5:00 pm
Event Categories:
, ,

Organizer

Tony Scott
Phone:
6019145026
Email:
tony@systemsit-ms.com
Website:
www.systemsit-ms.com

Venue

Systems IT
1855 Lakeland Drive, Suite R-101
Jackson, MS 39216 United States
+ Google Map
Phone:
6019144500
Website:
www.systemsit-ms.com