MSBI (Microsoft Business Intelligence) is made up of tools used to convert business data into information which helps BI, Data Mining to provide the right solutions and quick decision making.

BI (Business Intelligence) helps in gaining a better understanding of market behaviour and commercial context. It helps an organization to analyze the behaviour, tastes and needs of customers, predict where your business was and where it is now and where it will be after some years. BI also helps in solving complex business queries.

MSBI (Microsoft Business Intelligence) is made up of tools used to convert business data into information which helps BI, Data Mining to provide the right solutions and quick decision making. This tool is related to database and is used for many purposes like generating reports, dumping data from one tool to another, etc. It is a suite of products and tools that you can use to monitor, analyze and plan your business using scorecards, dashboards, management reporting and analytics.

MSBI contains tools that are used to analyze the real-time task that arises in day to day activities for better decision making in the organization using tools like Visual Studio with SQL Server and so forth. It is classified into three models:

Microsoft Business Intelligence solutions help the organisation in:

  • Course Outline
  • Introduction (0.5 hr)
    1. Exploring SQL Server Data Tools
    2. Creating a Solution and Project
    3. Creating Your First Package
    4. Moving Data with the Import and Export Wizard
    5. Installing the Sample Databases
  • Control Flow (1 hr)
    1. Using Precedence Constraints
    2. Manipulating Files with the File System Task
    3. Coding Custom Script Tasks
    4. Using the Execute SQL Task
    5. Using the Execute Process Task
    6. Using the Expression Task
    7. Using the Send Mail Task
    8. Using the FTP Task
    9. Creating a Data Flow
  • Data Flow (2 hr)
    1. Extracting Data from Sources
    2. Loading Data to a Destination
    3. Changing Data Types with the Data Conversion Transform
    4. Creating and Replacing Columns with the Derived Column Transform
    5. Rolling Up Data with the Aggregate Transform
    6. Ordering Data with the Sort Transform
    7. Joining Data with the Lookup Transform
    8. Auditing Data with the Row Count Transform
    9. Combining Multiple Inputs with the Union All Transform
    10. Cleansing Data with the Script Component
    11. Separating Data with the Conditional Split Transform
    12. Altering Rows with the OLE DB Command Transform
    13. Handling Bad Data with the Fuzzy Lookup
    14. Removing Duplicates with the Fuzzy Grouping Transform
  • Making Packages Dynamic (0.5 hr)
    1. Making a Package Dynamic with Variables
    2. Making a Package Dynamic with Parameters
    3. Making a Connection Dynamic with Expressions
  • Common ETL Scenarios (1 hr)
    1. Loading Data Incrementally
    2. Using the CDC Components in SSIS
    3. Using Data Quality Services
    4. Using the DQS Cleansing Transform
  • Containers (0.5 hr)
    1. Using Sequence Containers to Organize a Package
    2. Using For Loop Containers to Repeat Control Flow Tasks
    3. Using the For Each Loop Container to Loop Through a Collection of Objects
  • Configuring Packages (0.5 hr)
    1. Easing Deployment with Configuration Tables
    2. Easing Deployment with Configuration Files
  • Troubleshooting SSIS (1 hr)
    1. Logging Package Data
    2. Using Event Handlers
    3. Troubleshooting Errors
    4. Using Data Viewers
    5. Using Breakpoint
    6. Using Checkpoint
    7. Using Transactions
  • Administering SSIS (1 hr)
    1. Creating and Configuring the SSIS Catalog
    2. Deploying Packages to the Package Catalog
    3. Configuring the Packages
    4. Securing SSIS Packages
    5. Running SSIS Packages
  • Introducing Reporting Services (0.5 hr)
    1. Reporting Platform
    2. Reporting Life Cycle
    3. Reporting Services Architecture
  • Installing Reporting Services (0.5 hr)
    1. Planning for Installation
    2. Performing/Configuring the Installation
  • Exploring Reporting Services (1 hr)
    1. Developing a Simple Report using Report Builder 3.0
    2. Managing a Report
    3. Viewing a Report
  • Designing Reports (1 hr)
    1. Getting Started with Report Designer
    2. Designing the Report Structure
    3. Enhancing the Report Appearance
  • Developing Expressions (1 hr)
    1. Adding Calculations to a Report
    2. Using Aggregate Functions
    3. Changing Report Item Properties by Using Expressions
    4. Working with Variables
  • Adding Interactivity (0.5 hr)
    1. Changing the Report Layout Interactively
    2. Working with Parameters
  • Visualizing Data (1 hr)
    1. Creating Charts
    2. Working with Gauges
  • Deploying Reports to a Server (1 hr)
    1. Reviewing Deployment Options
    2. Managing Content
    3. Configuring Data Source Properties
    4. Creating Report Snapshots
  • Accessing Reports Online (0.5 hr)
    1. Using Report Manager
    2. Exporting Reports
  • Creating Ad Hoc Reports (0.5 hr)
    1. Developing Reports with Report Builder
    2. Enhancing Reports
  • Working with Subscriptions (0.5 hr)
    1. Creating Standard Subscriptions
  • Introduction – Understanding a Dimensional Data warehouse (1 hr)
    1. Introduction to Analysis Services
    2. OLAP vs OLTP
    3. Measures/Fact table
    4. Dimension table
    5. Star and Snowflake Schema
  • Accessing Source Data (1 hr)
    1. Creating a business intelligence solution
    2. Creating a data source
    3. Creating data source view
    4. Modifying a data source view
  • Designing Dimension (1.5 hr)
    1. Dimension Fundamentals
    2. Using Dimension Wizard to Create a Standard Dimension
    3. Dimension Hierarchies
    4. Dimension Attribute Relationship
    5. Parent Child Dimension
    6. Creating a M:M Dimension, Fact Dimensions, Role-playing dimensions
  • Designing a cube (2 hr)
    1. Using the cube wizard to create a cube
    2. Measure Properties
    3. Aggregate Functions
    4. Deploying and Browsing the Cube
    5. Adding Measures and Dimensions to Existing Cubes
    6. Adding a Perspective
  • Interacting with a Cube (0.5 hr)
    1. Implementing Actions
    2. Creating standard action
    3. Creating drill through action
    4. Linking to Reporting Services Report”
  • Implementing Security (0.5 hr)
    1. Understanding Roles
    2. Securing Administrative Access
    3. Securing Data Access
  • Managing Partitions and Database Processing (1 hr)
    1. Working with Storage
    2. Dimension Storage Mode
    3. Partition Storage Mode
    4. Analysis Services Processing
    5. Processing a Dimension
    6. Processing a Cube
    7. Proactive Caching
    8. Working with Partitions
  • Introduction to MDX( 0.5 hr)
    1. Calculated Measures
    2. Named Sets
    3. KPIs
  • Customized course
  • Live Projects
  • Mock Test
  • Multiple Training Modes
  • Certified Trainer
  • Official Course
  • 24*7 Mentoring

     
    Required 'Candidate' login to applying this job. Click here to logout And try again
     
     

    Answers

     

    Account Activation

    Before you can login, you must activate your account with the code sent to your email address. If you did not receive this email, please check your junk/spam folder. Click here to resend the activation email. If you entered an incorrect email address, you will need to re-register with the correct email address.