Greens Technologies is a leading provider of MSBI Training in Chennai. India's Top Rated MSBI Training Institute offers realtime practical MSBI (SSIS, SSAS, SSRS) Training with realtime project, job orientation and certification guidance. Our trainings are 100% job assured.
Microsoft Business Intelligence (MSBI) is a powerful suite of Data Integration, Data Reporting and Information Analysis/Mining components enriched with technology 'touch', beautiful UI and easier eye-catchy way of design and development. MSBI applications can be used efficiently by any business or enterprise for data discovery, data collaboration and usage management capabilities with the backdrop of SQL Server.
This impeccable MSBI (SQL BI) course is carefully designed for aspiring BI Developers, Consultants and Architects. This MSBI Training includes basic to advanced Business Intelligence, Data Warehouse (DWH) and Data Analytics (OLAP) concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). This MSBI Training course also includes Power Query & DAX for Data Modelling and MDX & DMX for Big Data Analysis and Reports along with Power BI Intergration and Azure Integration. Complete practical and realtime MSBI Training course with 24x7 LIVE server, Resume Guidance, ONE Real-time Project with Interview & Placement Assistance.
My training benefits
- My batch sizes are generally very small size 5-7 members OR 1 to 1 also, so students receive direct, hands-on training from us.
- 100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
- Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)
- Installation of Softwares in your desktop / laptop will be done.
- Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
- Continuous support is provided for any of your on-site problems. Placement assistance will be provided and you will be recommended to some of IT development firms.
For Corporate Training
- I will be more comfortable, if you could restrict the group not to exceed 20 persons.
- Training hours will be 40 Hrs/paper in view of 20 participants.
- Hardware for the required training should be provided by you, like Hall, Projector, and Furniture.
- I will be bringing my laptop for training purpose, which should be allowed in to your premises.
About Our Trainer
- As a Trainer, Yuvraj has over 8+ Years Working experience on SQL Server 2005, 2008 R2 and SQL Server 2012 Database Management and Business Intelligence competencies specifically into Marketing, Sales and Infrastructure domains. Holds MCP, MCDBA, MCITP and MCSA Certifications from Microsoft.
Currently working for a Leading MNC in Chennai as BI Consultant and Datawarehouse Archtect. Also involved in Database Consulting services on SQL Server 2014 with Azure for an Infrastructure Client based at Chennai, India.
Being proficient on SQL Server and related technologies in Health, Medicare and Sales-Retail Sector, I love sharing knowledge via Instructor Led LIVE Online / Classroom Trainings and offering training videos. Personally I enjoy answering doubts from the attendees and get involved in brain-storming sessions.
All Trainings are completely practical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases.
Courses Offered:
- SQL Server Training
- SQL DBA Training
- MSBI Training
- SQL BI and DWH [SSIS/SSRS/SSAS] Training
- DAX and Power View
- DQS and MDS with Powershell
Want a free career Advice or any career related queries? Reach him by
+91- 8939915572
Course Curriculum
Curriculum
SQL Server Development
- SQL Server database Overview
- What is DDL, DML
- Data Types
- What are Constraints (Identity, Unique, Check, NULL, Default)
- Operators
- Aggregates
- Where
- Group by
- Having
- Distinct, Top
- Date functions
- Temp tables
- Table Variables
- Usage of While loop & if conditions
- Case Statement
- Ranking Functions
- Scalar Functions
- Exception handling
- Transactions
- Joins
- Sub Queries
- Views
- CTE
- Cursor
- Stored Procedures
- User Defined Functions (String, Table value: inline Functions and multi value)
- Triggers
SSIS (SQL Server Integration Services)
- SSIS Introductions
- Control Flow
- Data Flow
- Precedence constraint & Expressions
- Sequence Container
- Annotation
- Data Flow Components
- Data viewer
- Copy
- OLEDB Source
- OLDB Destination
- Audit
- Character Map
- Conditional Split
- Row sampling
- Percentage sampling
- Multicast
- Data conversion / Type Cast
- Sort
- Merge
- Union all
- Aggregate
- Derived
- RowCount
- BreakPoints
- Merge join
- Flat File Destination
- Excel Destination
- OLEDB Command
- Cache transformation (target is cashed)
- Lookup
- SCD (type 1, type 2)
- Excel Source
- Flat File Source
- Control Flow Components
- Sequence Containers
- For loop
- For each loop
- Variables with default values
- Variables with dynamic values through Expressions
- Dynamic loading of Excel files into SQL target
- FTP Task
- Execute SQL Task – Basic
- Execute SQL task with parameter and with result
- Breakpoints
- Script task
- Bulk Insert Task ( sending FF – SQL)
- Execute package
- Execute process
- ERROR Output in DF
- File system Task
- Send Mail Task
- Logging
- Checkpoints (restart ability)
- Jobs (Scheduling)
- Deployment
- Configurations
Real-time Project related to Image and Capture Work stream with Banking Domain which implement real time Working Framework with ERROR Handling
SSRS (SQL Server Reporting Services)
- Introduction to SSRS
- Architecture of SSRS
- What is Report Server
- What is Report Manager
- Creating reports using BIDS
- What are Data sources
- What are Shared Data sources
- Types of Reports (Table and Matrix)
- FOTTER
- HEADERS AND EXPRESSIONS.
- Parameterized report
- Multi-valued Parameterized Reports
- Page break concept
- Drill Down report
- Report Wizard / Adhock Report /Ad-Hock Report / Wizards
- Cascading report — Parameter Dependency
- Drill through Report / hyperlink report / jump report / navigation report / go to report/ Action report
- Chart report and its properties & expressions
- Sub report
- List Report with Image
- Rectangle Report
- Indicators
- Gauge
- Deployment
- Report Subscription (Email and Windows File Share) and Scheduling
- Report Manager Operations
- Edit Report
- Move / Delete Report
- Linked Report
- Cashed / Execution Report
- Snap short and History comes under this report
SSAS (SQL Server Analysis Server)
- Introduction to SSAS
- Schemas
- Star Schema
- Snowflake Schema
- Data source
- Data source views
- Options in DSV
- Dimension
- Measures
- Cube Creation
- Build
- Deploy
- Process
- How to Brows the CUBE
- Types Of Relationships inside CUBE
- No relationship
- Regular Relationship
- Fact Relation
- Referenced Relationship
- Many to Many
- None
- Hierarchies
- What are KPI’s and How to Create KPI’s in SSAS
- What are Perspective and how to create
- What are Partitions
- What are Translations
- What are Actions
- What are Calculations
- Aggregations
- Storage design – ROLAP, MOLAP , HOLAP
- How to use Cube in Excel
- MDX in Report
