Microsoft 70-466: Implementing Data Models & Reports
This comprehensive course covers the Microsoft 70-466 certification, focusing on implementing data models and reports with SQL Server 2012. Designed for professionals aiming to enhance their data management and reporting skills, this course dives deep into business intelligence and data modeling, SQL Server Reporting Services, self-service reporting, and more. You’ll gain hands-on experience with multidimensional databases, cubes, dimensions, MDX, DAX, and tabular data models, ensuring you’re well-prepared for the certification exam.
Throughout the course, you’ll explore practical applications and real-world scenarios, learning to manage report execution, delivery, and create data visualizations with Power View. Whether you’re new to SQL Server or looking to upgrade your skills, this course provides the essential tools and knowledge needed to succeed in the field of data analysis and business intelligence.
What Will I Learn?
- Understand the fundamentals of business intelligence and data modeling.
- Learn to implement and manage SQL Server Reporting Services.
- Support and execute self-service reporting strategies.
- Create and manage multidimensional databases, cubes, and dimensions.
- Develop proficiency in MDX and DAX for data manipulation and calculations.
- Customize cube functionality to suit specific business needs.
- Implement and deploy tabular data models for advanced data analysis.
- Create compelling data visualisations using Power View.
- Perform predictive analysis and data mining for strategic insights.
Material Includes
- 47 On-demand Videos
- Closed Captions
- 17 Topics
- 42 Prep Questions
- Certificate of Completion
Audience
- Database administrators and developers.
- Business intelligence analysts and developers.
- Data analysts and scientists.
- IT professionals interested in data reporting and visualization.
- Beginners looking to start a career in data analysis with SQL Server.
