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
“Our training was great! The trainer really knew a lot about the Informatica Platform from Data Integration, Data Quality and Data Governance perspective.”
- Patrick White, IoT Manager, Orbus Software
“Instructor was very passionate about Databricks and helped me to stay engaged. Great pace, great knowledge, and the trainer was fantastic overall :) ”
- Emma Darling, Platform Engineer, Barclays Bank
The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.
Every one of my employees had tons of positive stuff to say.
- Benjamin G, MXSG Analysis and Integration Chief, US Air Force
