Developing and Managing a Business Intelligence Semantic Model in SQL Server Analysis Services

Overview

Learn to create, manage, and troubleshoot BI Semantic Models using SQL Server "Denali" features, with PowerPivot as a starting point for enhanced business intelligence capabilities.

Syllabus

• Introduction to Business Intelligence Semantic Models (BISM)
Overview of Business Intelligence and its importance
Introduction to SQL Server Analysis Services (SSAS)
Understanding SQL Server "Denali" features
• PowerPivot as a Foundation
Introduction to PowerPivot for Excel
Importing and preparing data in PowerPivot
Basic DAX (Data Analysis Expressions) for calculations
• Creating BI Semantic Models
Differences between Tabular and Multidimensional models
Building a Tabular model using SQL Server Data Tools (SSDT)
Data modeling best practices
• Managing BI Semantic Models
Deploying models to SSAS
Configuring security and user access
Managing and optimizing processing and storage
• Enhancing BI Models with Advanced DAX
Advanced DAX functions and patterns
Time intelligence in DAX
Creating calculated columns and measures
• Troubleshooting and Optimizing BI Models
Identifying and solving common performance issues
Monitoring and tuning SQL Server and SSAS
Best practices for troubleshooting
• Integration with Other BI Tools
Using BI Semantic Models with Power BI
Creating reports and dashboards
Implementing connectivity with other tools
• Course Project
Students design a complete BI solution
Presenting and reviewing project outcomes
• Recap and Future Trends in BI
Recap of key concepts learned
Discussion on emerging trends in Business Intelligence and SSAS

Subjects

Conference Talks