Implementing Data Models and Reports with Microsoft SQL Server 2014
Course Overview
Schedule Dates
Course Content
- Elements of an Enterprise BI Solution
- The Microsoft Enterprise BI Platform
- Planning an Enterprise BI Project
- Exploring a BI Solution
- Introduction to Multidimensional Analysis
- Creating Data Sources and Data Source Views
- Creating a Cube
- Overview of Cube Security
- Creating a Multidimensional Database
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
- Defining Dimensions
- Working with Measures
- Working with Measure Groups
- Configuring Measures and Measure Groups
- MDX Fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
- Using MDX
- Working with Key Performance Indicators
- Working with Actions
- Working with Perspectives
- Working with Translations
- Customizing a Cube
- Introduction to Analysis Services Tabular Data Models
- Creating a Tabular Data Model
- Using an Analysis Services Tabular Data Model in the Enterprise
- Implementing an Analysis Services Tabular Data Model
- DAX Fundamentals
- Enhancing a Tabular Data Model with DAX
- Using DAX to Enhance a Tabular Data Model
- Introduction to Reporting Services
- Creating a Report with Report Designer
- Grouping and Aggregating Data in a Report
- Publishing and Viewing a Report
- Creating a Report with Report Designer
- Showing Data Graphically
- Filtering Reports by Using Parameters
- Enhancing a Report
- Managing Report Security
- Managing Report Execution
- Subscriptions and Data Alerts
- Troubleshooting Reporting Services
- Introduction to SharePoint Server as a BI Platform
- Introduction to PerformancePoint Services
- PerformancePoint Data Sources and Time Intelligence
- Reports, Scorecards, and Dashboards
- Implementing a SharePoint Server BI Solution
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating a Data Mining Model
- Consuming Data Mining Data
- Using Data Mining to Support a Marketing Campaign
FAQs
Participants should have a basic understanding of SQL Server and relational database concepts. Familiarity with data warehousing and business intelligence principles is beneficial but not mandatory.
Yes, our course includes extensive hands-on labs and practical exercises to help you apply the concepts learned and gain real-world experience in implementing BI solutions and data models.
This course is ideal for database professionals, BI developers, and IT professionals who are responsible for creating and managing business intelligence solutions, implementing data warehouses, and performing ETL processes.
Yes, upon successfully completing the course, you will receive a certificate from CounselTrain, recognizing your expertise in implementing data models and reports with Microsoft SQL Server 2014.
Yes, CounselTrain offers both in-person and online options for this course. Our online platform provides flexibility for you to learn at your own pace while still receiving the same high-quality instruction.
To enroll, visit our course page on the CounselTrain website, select your preferred learning format, and complete the registration process. If you have any questions about enrollment, our support team is available to assist you.
Flexible Training Options to Meet Your Needs
We know the importance of flexibility in the success of learning and professional development. This is the reason CounselTrain provides a variety of delivery options for all IT training offered in the UAE to ensure access and convenience for each learner.
Select the method that best suits your needs.
