Course Description
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.
The 20762C: Developing SQL 2016 Databases certification is a validation of your skills and knowledge in building and implementing databases across organizations using SQL Server 2016. It covers designing, implementing, and maintaining SQL Server 2016 native applications and database systems, ensuring robust data retrieval, manipulation, and storage. Whether it’s data warehousing, data management, or mastering SQL language for relational databases, this certification enhances your marketplace credibility. Industries use this certification to evaluate potential employees’ proficiency and thus ensure efficient management of their SQL databases, leading to optimal data processing, business continuity, and decision-making solutions. This certification essentially bridges the gap between an organization’s data management needs and tangible database solutions.
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Module 1: Introduction to Business Intelligence and Data Modeling
- Module 2: Creating Multidimensional Databases
- Module 3: Working with Cubes and Dimensions
- Module 4: Working with Measures and Measure Groups
- Module 5: Introduction to MDX
- Module 6: Customizing Cube Functionality
- Module 7: Implementing a Tabular Data Model by Using Analysis Services
- Module 8: Introduction to Data Analysis Expression (DAX)
- Module 9: Performing Predictive Analysis with Data Mining
Testimonials
“ExistBI, Thank you again for the great Microsoft Power BI, PowerApps and Power Automate courses, our team was very happy”
- Kerry Urofsky, Systems Manager, Service, Avantik
“The Informatica Cloud Data Integration for Developers training class was excellent, the teacher was very knowledgeable and the materials were very useful”
- James Martin, Data Engineer, RoyOMartin
“Last week’s Informatica PowerCenter Bootcamp training was really good. It was very practical, and we had the opportunity to try out what was being taught. The trainer was incredibly kind and professional, and since there were only two of us, he was able to give us his full attention. I would definitely recommend this training to anyone.”
- Dilane Azangue, Data Integration Consultant, PTA IT Consulting
