Course Overview
![sql-analysis-2019-300×200 sql analysis 2019 300x200 2](https://ezdasolutions.com/wp-content/uploads/2022/10/sql-analysis-2019-300x200-2.jpg)
Course objectives
This course provides a full introduction to the use of both of these engines in an enterprise environment. The third major component of the course is a form of Machine Learning called Data Mining. Data Mining is the analysis of large data set to reveal hidden patterns and trends. This course will teach you how to create a Data Mining solution, how to compare and validate different data mining options (models) for a given data set, and how to use your chosen model in a consumer-friendly client.
Modules
Module 1: Introduction to Business Intelligence and Data Modeling
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Business Intelligence
- 1.4 The Microsoft Business Intelligence Platform
- 1.5 Exploring a Data Warehouse
- 1.6 Exploring a Data Model
Module 2: Multidimensional Databases
- 2.1 Module 2 Introduction
- 2.2 Introduction to Multidimensional Analysis
- 2.3 Overview of Cube Security
- 2.4 Creating and Configuring a Cube
- 2.5 Data Sources
- 2.6 Data Source Views
- 2.7 Adding a Dimension to a Cube
Module 3: Cubes and Dimensions
- 3.1 Module 3 Introduction
- 3.2 Dimensions
- 3.3 Attribute Hierarchies and Relationships
- 3.4 Sorting and Grouping Attributes
- 3.5 Slowly Changing Dimensions
Module 4: Measures and Measure Groups
- 4.1 Module 4 Introduction
- 4.2 Measures
- 4.3 Measure Groups and Relationships
- 4.4 Measure Group Storage
Module 5: Introduction to MDX
- 5.1 Module 5 Introduction
- 5.2 MDX Fundamentals
- 5.3 Adding Calculations to a Cube
- 5.4 Querying a cube using MDX
Module 6: Customizing Cube Functionality
- 6.1 Module 6 Introduction
- 6.2 Key Performance Indicators
- 6.3 Actions
- 6.4 Perspectives
- 6.5 Translations
Module 7: Tabular Data Models
- 7.1 Module 7 Introduction
- 7.2 Introduction to Tabular Data Models
- 7.3 Creating a Tabular Data Model
- 7.4 Configure Relationships and Attributes
- 7.5 Configuring Data Model for an Enterprise BI Solution
Module 8: Data Analysis Expressions (DAX)
- 8.1 Module 8 Introduction
- 8.2 DAX Fundamentals
- 8.3 Calculated Columns
- 8.4 Relationships
- 8.5 Measures
- 8.6 Time Intelligence
- 8.7 KPI
- 8.8 Parent – Child Hierarchies
Module 9: Data Mining
- 9.1 Module 9 Introduction
- 9.2 Overview of Data Mining
- 9.3 Custom Data Mining Solutions
- 9.4 Validating a Data Mining Model
- 9.5 Consuming a Data Mining Model
- 9.6 Course Wrap Up
Modes of Learning
- Flashcards: Remember the “read and guess” games we used to play back then? Here’s to enhance what you learned. How does it work? A statement will be written on a flashcard, and you’ll need to guess the answer. Then flip it over to see if you answered it correctly. The cards continue, each with a random statement from the course that you took previously.
- Scatter: “Make Everything Disappear.” Turn the screen white and vanish it all but this time testing your knowledge and your time being monitored. Find the best match and click your way toward success. This brain teaser might give you a hard time! But education combined with games adds an element of fun to it.
- Learn: Here’s another. Read and choose the right answer. A game designed on a Multiple-Choice pattern. This kind of exercise boosts your confidence. When one option seems to be correct, you choose the other only for it to be the right option. The right option will welcome another statement, but don’t sweat! You are still learning.
- Speller: This fun-packed game is unique in its own way. Hear the term carefully and type it out on your screen. You think you are a pro at learning spellings of tricky terms. Test yourself out with this game. Could you hear it properly? If you could, were you able to write it?
We have found our students doing absolutely great by showcasing their certificates. Grab that certificate of yours before someone else does and get that recognition you deserve.
You best learn when you see it. Our easy-to-understand video content is in place for you. Watch the studying content and grasp all the concepts easily. With so many lectures and 3000+ hours of video content, find what suits your needs. These educational videos are designed to sharpen your experience with your training content. Our easy-to-understand video content is in place for you. Watch the studying content and grasp all the concepts easily.
In contrast to other e-learning services, our labs will let you exercise what you analyze in a real environment with a lot to choose from. This layout mirrors the traditional study room format which ensures you will recognize exactly the way to set up, manage and troubleshoot any environment.
Being a successful IT professional involves more than knowing key terms and concepts. You need to be able to “apply” your knowledge to real-world situations. At EZDA we quote, “Learn it to pertain to it.” So, why spend money buying the equipment when we got you all covered?