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
“Tomi was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions, so the Informatica materials and lab books are super helpful.”
- Leroy Smith, ETL Developer, US Army
“Great Tableau Course. Lots of information packed into short period.”
- Matt, Data Analyst, Fortune Brands
“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
