Course Description
This five-day Implementing Data Models and Reports with Microsoft SQL Server training teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining.
Course Outcomes
At the end of the course, learners will be able to:
- Use the Alteryx Designer interface to design data workflows.
- Connect to a plethora of data sources and write into numerous output sources.
- Clean and update your data and create useable datasets
- Use your effort to create repeatable workflows
- Filter, join, aggregate, blend and prep data.
- Apply expression logic to data without writing SQL
- Preparation for Alteryx Designer Core Exam
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Introduction to Business Intelligence and Data Modeling
- Implementing Reports with SQL Server Reporting Services
- Supporting Self Service Reporting
- Managing Report Execution and Delivery
- Creating Multidimensional Databases
- Working with Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX
- Customizing Cube Functionality
- Implementing a Tabular Data Model with Microsoft PowerPivot
- Introduction to DAX
- Implementing an Analysis Services Tabular Data Model
- Creating Data Visualizations with Power View
- Performing Predictive Analysis with Data Mining
Testimonials
“We just finished the course and I’d like to say that Basem was an excellent teacher. I will definitely recommend your company and him in the future”
- Renee Dansereau, Senior Analyst, AXA XL
“The course was comprehensive and interactive, and the trainer really understood the content. I have been able to implement much of what I learned into my daily work activities and have saved a lot of time.”
- Susan Medina, Senior Business Analyst, Advocate Health Care
“Our Informatica Axon and Enterprise Data Catalog training classes were all excellent for our needs. The trainer really knew a lot about data governance strategy, frameworks, stewardship and actual implementation. As a senior consultant, he had implemented many projects, this really helped in Q&A. Highly recommended.”
- Susan Charles, IT Director, SoFi Bank
