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
I enjoyed the class a lot! I had problems with queries, so it was super helpful when Mahesh copies them into the chat. All explanations were thorough and be able to do it was awesome.
- Lisa Kruta, Environmental Coordinator, US Air Force
“The SAP BOE310 Business Intelligence Platform: Administration and Security training was well presented and the trainer was very patient with us, now signed up to the BOE320 Administering Servers training”
- Yocelyn Robles, Platform Engineer, Franchise Tax Board
“ExistBI has provided multiple Microsoft Power BI training to our HR, Product and Sales teams. We’ve now engaged them to assist with complex Financial reports”
- Jena Bomboy, HR Director, The Giant Company
