Basket
{{item.CourseTitle}}
Price: {{item.ItemPriceExVatFormatted}} {{item.Currency}}
Aron Mesterbasic
Microsoft Upgrading to MCSA: SQL Server 2016 Business Intelligence Development training and certification use Readynez's unique Lecture | Lab | Review technique, which will immerse you in topics like: - Working with measures and measure groups - Performing predictive analysis with data mining
Your course package is designed to provide maximum learning and convenience. This is included in the price of your course:
Your expert instructor will get you ready for the following exam and certifications, which are included in your course package and covered by the Certification guarantee.
It is recommended you have at least 2 years’ experience of working with relational databases, including:
- Designing a normalised database
- Creating tables and relationships
- Some exposure to basic programming constructs (such as looping and branching)
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
Using our engaging learning methodology including a variety of tools, we’ll cover the entire curriculum.
Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite
Lessons
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Lab: Exploring a Data Warehouse
After are completing this module, you will be editable to:
- Describe the concept of business intelligence
- Describe the Microsoft business intelligence platform
Module 2: Creating Multidimensional Databases
This module describes the steps required to create a multidimensional database with analysis services
Lessons
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
Lab: Creating a multidimensional database
After are completing this module, you will be editable to:
- Use multidimensional analysis
- Create data sources and data source views
- Create a cube
- Describe cube security
Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions into a cube
Lessons
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
Lab: Working with Cubes and Dimensions
After are completing this module, you will be editable to:
- Configure dimensions
- Define attribute hierarchies.
- Sort and group attributes
Module 4: Working with Measures and Measure Groups
This module describes how to implement Measures and measure groups in a cube
Lessons
- Working with Measures
- Working with measure groups
Lab: Configuring Measures and Measure Groups
After are completing this module, you will be editable to:
- Work with Measures
- Work with measure groups
Module 5: Introduction to MDXT
This module describes the MDX syntax and how to use MDX
Lessons
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Lab: Using MDX
After are completing this module, you will be editable to:
- Describe the fundamentals of MDX
- Add calculations to a cube
- Query a cube using MDX
Module 6: Customising Cube Functionality
This module describes how to customise a cube
Lessons
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
Lab: Customising a Cube
After are completing this module, you will be editable to:
- Implement key performance indicators
- Implement actions
- Implement perspectives
- Implement translations
Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in PowerPivot
Lessons
- Introduction to tabular data models
- Creating a tabular data model
- Using an Analysis Services tabular model in an enterprise BI solution
Lab: Working with an Analysis Services tabular data model
After are completing this module, you will be editable to:
- Describe tabular data models
- Create a tabular data model
- Be printable to use an Analysis Services tabular data model into an enterprise BI solution
Module 8: Introduction to Data Analysis Expression (DAX)
This module describes how to use DAX to create Measures and Calculated columns in a tabular data model
Lessons
- DAX fundamentals
- Using DAX to create Calculated Columns and Measures in a tabular data model
Lab: Creating Calculated Columns and Measures by using DAX
After are completing this module, you will be editable to:
- Describe the fundamentals of DAX
- Use DAX to create Calculated Columns and Measures in a tabular data model
Module 9: Performing Predictive Analysis with Data Mining
This module describes how to use data mining for predictive analysis
Lessons
- Overview of data mining
- Using the data mining add-in for Excel
- Creating a custom data mining solution
- Validating a data mining model
- Connecting to and consuming a data mining model
Lab: Perform Predictive Analysis with Data Mining
After are completing this module, you will be editable to:
- Describe data mining
- Use the data mining add-in for Excel
- Create a custom data mining solution
- Validate a data mining solution
- Connect to and consume a data mining solution
The Virtual Classroom is an online room, where you will join your instructor and fellow classmates in real time. Everything happens live and you can interact freely, discuss, ask questions, and watch your instructor present on a whiteboard, discuss the courseware and slides, work with labs, and review.
Yes, you can sit exams from all the major Vendors like Microsoft, Cisco etc from the comfort of your home or office.
With Readynez you do any course form the comfort of your home or office. Readynez provides support and best practices for your at-home classroom and you can enjoy learning with minimal impact on your day-to-day life. Plus you'll save the cost and the environmental burden of travelling.
Well, learning is limitless, when you are motivated, but you need the right path to achieve what you want. Readynez consultants have many years of experience customizing learner paths and we can design one for you too. We are always available with help and guidance, and you can reach us on the chat or write us at info@readynez.com.