Quality education now comes with an affordable price tag.
Learnoa presents Instructor-Led self-paced comprehensive technology training programs.
We give you the same experience as of a LIVE INSTRUCTOR-LED TRAINING PROGRAM.
We give you the same quality as of a LIVE INSTRUCTOR-LED TRAINING PROGRAM.
You get the same experience and quality at a far lesser cost, with Learnoa!
As a bonus, we also arrange for doubt clearing sessions with instructors, on learner’s request.
Isn’t it wonderful?
Key Features
-
20 hours of video training
-
18 hours of hands-on practical experience
-
Self-paced Instructor-Led
-
Training by Industry expert
-
End-of-training Project
-
Notes / Interview questions / Practice material
-
Full Lifetime access
-
Accessible on Website and App
-
Certificate of Completion
-
Discussion forum for doubts clearing
Why to take this training?
Business Intelligence certainly is emerging as a fast growing function. Today, Indian Companies like Housing.com and Eveready Industries are using BI to enhance customer interface and analyse sales data. BI as a function is finding a strong footing in the sectors of e-commerce and retail, finance (banking, insurance etc.), and surprisingly in the industries of gaming, food, fashion, public transport and governance. As the dependence on data increases, almost any usage of data will require analytics and Business Intelligence to extract actionable insights in future.
Average Salary of Big Data Hadoop Developers is approximately $95,220 or approximately Rs. 66,65,400 per annum (Indeed.com salary data).
Training Details
The Microsoft Business Intelligence Online Training Program from Learnoa helps the learner to gain insights in multiple tools of Microsoft BI Suite, such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), etc.
- This training program first takes you through all the basic and advanced SQL concepts as well, to give a good start. These will include Data Types, Queries, Procedures, Functions, Transactions, Exception Handling, Triggers, to list a few.
- Then it takes you through SSIS which will include SQL Server Management Studio, Business Intelligence Development Studio (BIDS), Basic and advanced Control Flow, Data Flow, Debugging and Error Handling, SSIS Package deployment and Management, etc.
- After SSIS, comes SSRS which includes Creating Reports, Formatting, Grouping, Sorting, Matrix Reports and Charts, Managing and Programming Reporting Services, etc.
- The next comes SSAS which will include OLAP Modelling, SSAS in BIDS, Advanced SSAS, MDX, SSAS Administration, etc.
Table of Contents
SQL / TSQL Development
1. Basic database and design
2. What is DDL, DML
3. Data Types
4. What are Constraints & types
-
Unique
-
Check
-
NULL
-
Primary Key
-
Foreign Key
5. Default
-
Joins
-
Where
-
Group by & Having
-
Sub Queries
-
Usage of While loop & if conditions
-
Views
-
Stored Procedures
-
CTE
-
Exception handling
-
Transactions
-
Declaring & Using Variables and Table variables in SQL 12. Temp tables
-
Cursor
6. System functions & User Defined Functions (String, Table value: inline Functions and multi value, Cross Apply)
7. Triggers
SQL Server 2014 Integration Services
Introduction to SQL Server Integration Services
-
SSIS Package Architecture Overview ls
-
Source Control for SSIS Packages
SSIS for DBAs: Using SQL Server Management Studio
-
Importing and Exporting Data
-
Database Maintenance Plans
-
Creating Database Maintenance Plans using SSMS
Business Intelligence
Development Studio
-
Launching BIDS
-
The package designer
-
The Properties window
-
The SSIS menu
Introduction to Control Flow
-
Precedence Constraints
-
The File System Task
-
The Send Mail Task
Advanced Control Flow
-
Containers grouping and looping
-
The Web Service Task
-
The Analysis Services tasks
-
The Execute Package Task
Introduction to Data Flow
-
Data Flow Overview
-
The Derived Column Transformation
-
The Conditional Split Transformation
-
The Sort Transformation
Variables and Configurations
-
Variables Overview
-
Using variables in control flow
-
Using variables to pass information between packages
-
Configuration Overview
Slowly Changing Dimensions
-
Types of Slowly changing dimensions
-
Loading Slowly changing dimensions with SSIS
-
Handling inferred member in scd.
Change Data Capture
-
Enabling CDC on database
-
Implementing incremental Load with CDC
Pivoting & unpivoting in SSIS
Debugging, Error Handling and Logging
-
SSIS debugging overview
-
Breakpoints in SSIS
-
Control Flow: The OnError event
-
Configuring Package Logging
Advanced Data Flow
-
Revisiting data sources and
-
The Lookup Transformation
-
Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
-
The Merge and Merge Join
-
The Data Mining Query
-
The Data Mining Model Training Destination
-
The Slowly Changing Dimension
Extending SSIS through Custom Code
-
The SSIS script editor
-
Script in Data flow: The Script Component Introduction to SSIS component development
-
SSIS Package Deployment Configurations andl deployment
-
Deployment security
-
Executing packages – DTExec and DTExecUI
SSIS Package Management
-
Managing packages with SQLtServer Management Studio
-
Scheduling packages with SQL Server Agent
SQL Server 2014 Reporting Services
Introducing SQL Server Reporting Services
-
Reporting Services Architecture
-
Taking Reporting Services for a Spin
Creating Reports
-
Deconstructing Reporting Services
-
Creating Reports from Scratch
Calculations and Formatting
-
Using the Global Collections
-
Conditional Formatting
Grouping and Sorting
-
Calculating Totals and Percentages
-
Creating Drill-Down Reports
Report Parameters
-
Creating Drop-Down Parameters
-
Debugging Parameter Issues
Creating Matrix Reports and Charts
-
Creating a Basic Matrix Report
-
Exploring the Charting Possibilities
Managing Reporting Services
-
Deploying Reports and Data Sources
-
Exporting Reports and Printing
-
Using the Web-Based Report Manager
-
Studio-based Reporting Services Manager
Reporting Services Security
-
Two Parts to Reporting Services Security
-
Data Source Security
Programming Reporting Services
-
The Many Reporting Services APIs
-
Integrating Reporting Services into Applications using URL Access
Advanced Reporting Services
-
Programming Using the Reporting Services Web Service
Snapshots and Subscriptions
-
Caching and Snapshots
-
Creating Data-Driven Subscriptions
Ad-Hoc Reporting with Report Builder
-
Creating Report Model Projects
SQL Server 2014 Analysis Services
OLAP Modelling
-
Modelling source schemas-stars and snowflakes
-
Understanding dimensional modelling-Dimensions (Type 1, 2, or 3) or rapidly
-
Understanding fact (measures) and cube modelling
Using SSAS in BIDS
-
Understanding the development environment
-
Creating Data Sources and Data Source Views
-
Creating cubes – using the UDM and the Cube Build Wizard
Intermediate SSAS
-
Perspectives
-
Translations – cube metadata and currency localization
-
Actions – regular, drill-through and Reporting
Advanced SSAS
-
Modelling intermediate fact tables
-
Modelling M:Mi dimensions, Fact (degenerate) dimensions, Role-playing
-
Modelling changing dimensions – Dimension Intelligence w/ Wizard
-
Using the Add Business Intelligence Wizards – write-back, semi-additive
Cube Storage and Aggregation
-
Storage topics – basic aggregations, MOLAP
-
Advanced Storage Design – MOLAP, ROLAP, HOLAP
-
Partitions – relational and Analysis Services partitions
-
Customizing Aggregation Design - Processing Design
-
Rapidly changing dimensions / ROLAP dimensions
-
Welcome to the Real Time – Proactive Caching
Beginning MDX (All Basics)
-
Basic syntax
-
Using the MDX query editor in SQL Server Management Studio
-
Most-used Functions & Common tasks
-
New MDX functions
Intermediate MDX
-
Adding calculated members
-
Adding named sets
SSAS Administration
-
Best practices – health monitoring
-
Other Documentation methods
-
Disaster Recovery – backup / restore
Introduction to Data Mining
-
What and why?
-
Examples of using each of the 9
-
algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural)
-
Data mining dimensions
-
Processing mining models
Introduction to Reporting Clients
-
Excel 2003 Pivot Tables
-
SQL RS & Report Build
Who should take this training?
-
If you are passionate about data visualization, business intelligence, and data analytics then this program is for you. Also, it suits best for
-
- IT Professionals
-
- ETL Experts
-
- RDBMS Professionals
-
- Fresh Graduates
-
- Business Analysts
-
- Statisticians and Analysts
-
- Business Intelligence Manager
-
- Project Managers
-
- Data Scientists
What else you will get?
-
Along with the training content, you will also get everything which is applicable from the following on this program:
-
- Codes Snippets
-
- Sample Programs
-
- Informational PPTs
-
- Installation and Configuration Guidelines
-
- Class Notes
-
- Interview Questions
-
- How-Tos
-
- Useful links
-
- Case studies
-
- Real-life examples
Queries?
-
For any query, you can visit www.LearnOA.com and browse to Help page.
Prerequisites:
You will need to have a basic understanding of data. Knowing any of the programming language will enhance your training experience.
