Transcription
About IntellipaatIntellipaat is an e-learning and professional certification company forsoftware developers, IT administrators, and other professionals,headquartered in Bangalore, India. The training is offered in threemajor modes: Online instructor Led Trainings, Self-paced e-learningtrainings, and Corporate Trainings.6, 22,205 Learnerswww.intellipaat.com150 Corporate Clients250 Courses Copyright IntelliPaat. All rights reserved.
About The CourseIntellipaat Business Intelligence architect master program willprovide you in-depth knowledge on business intelligence and datawarehousing. You will master how to design and develop enterpriseclass Data warehouse and building reporting solution, SQL anddoing performance tuning in Data warehouses. This program isspecially designed by industry experts and you will get 8 courseswith 32 industry based projectExercise and projectworkInstructor Led Training150 Hrs of highlyinteractive instructor ledtraining178 Hrs of Self-Pacedsessions with LifetimeaccessLifetime access andfree upgrade to latestversionSupportLifetime 24*7technical supportand query resolutionLifetime Access300 Hrs of real-timeprojects after everymoduleSelf-Paced TrainingJob AssistanceGet CertifiedFlexi SchedulingJob assistancethrough 80 corporate tie-upsGet global industryrecognizedcertificationsAttend multiplebatches for lifetime &stay updated.Learning PathPower BIInformaticaOracle PL SQLMSBITableau 10 Desktopwww.intellipaat.com Copyright IntelliPaat. All rights reserved.
Why take this Course?Today there is an urgent need for business intelligence professionalswho are well-versed with the front-end and back-end of BI. Due tothis the Intellipaat master program in BI architecture has beencreated to help you gain complete proficiency in the ETL steps andalso the BI reporting techniques. Taking this training will put you in adifferent league and help you grab top jobs.IndexInstructor LedSelf-Paced Courses1. Tableau Desktop 101. Data warehouse &2. Oracle PL SQL3. Microsoft BusinessIntelligenceErwin2. MicroStrategy3. QlikView4. Power BI5. Informaticawww.intellipaat.com Copyright IntelliPaat. All rights reserved.
Tableau Desktop 10Learning ObjectiveThis will help you master building interactive tableau dashboards and learn datavisualization. This Tableau course will prepare you for Tableau Desktop QualifiedAssociate Certification exam. In this Tableau certification training you will alsolearn Tableau desktop and public integration with R & Big data. It is best suitedfor software developers, BI professionals, system and IT administrators.Topics Introduction to Data Visualization Working with Mappingand Power of Tableau Working with Calculations & Architecture of Tableau Working with Metadata & Data Working with ParametersBlending Charts and Graphs Creation of sets Dashboards and Stories Working with Filters Integration of Tableau with R and Organizing Data and m Copyright IntelliPaat. All rights reserved.
Oracle PL SQLLearning ObjectiveThis course provides you with the complete skills needed to create, implementand manage robust database applications using the Oracle database tools.Some of the topics covered are – understanding of the Basic ProceduralLanguage/Structured Query Language, subprogram, section and syntax query,DML, advanced DML and scripting. Entire training is in line with the Oracle PLSQL certification.Topics Introduction to Oracle SQL Database Transactions Using DDL Statements to Create and Creating Other Schema ObjectsManage Tables Writing Cursor and Conditional Retrieving Data Using the SQLStatementSELECT Statement Introduction to Explicit Cursor Restricting and Sorting Data Advance concepts of explicit General functions Using Single-Row Functions to Exception HandlingCustomize Output Writing Subprogram, ProcedureCursor Large Object Functionsand passing parameters OLAP Functions Creating PL/SQL Package Using Conversion Functions and Advance Package Concepts andConditional Expressionsfunctions Displaying Data from Multiple Tables Introduction and writing Triggers Using Subqueries to Solve Queries Compound Triggers Using the Set Operators Working with Dynamic SQL Manipulating Data using SQL Advance level- Scriptingwww.intellipaat.com Copyright IntelliPaat. All rights reserved.
Microsoft Business IntelligenceLearning ObjectiveThis course provides you all the skills needed to work with the MicrosoftBusiness Intelligence stack. You will get proficiency in SQL Server, Analysis,Integration, and Reporting. This training will provide you enough knowledgeabout Data Warehousing, ETL Solutions, Connecting Managers, Transformationsand other operations.Topics What is BI? Structures and Processes ETL Overview Type of Database Relationship Working with Connection Managers SSAS Cube Advance Data Transformations Cube: Operations & Limitations Slowly Changing Dimensions Cube and In-memory Analytics Overview of Fuzzy Look-up Data Source ViewTransformation and Lookup and DimensionsTerm Extraction Measures & Features of CubeConcepts of Logging & Working with MDXConfiguration Functions of MDX Introduction to SSRS DAX language Matrix and Tablix Overview BI Semantic Model Parameters and Expression Plan and deploy SSAS Reports and Charts creation Analyzing Big Data with Microsoft Dashboard Building Reports and Authenticity Getting started with SSAS www.intellipaat.comR Copyright IntelliPaat. All rights reserved.
Power BILearning ObjectivePower BI is a radically new tool in the hands of business enterprises who areoverwhelmed with the amount of data at hand and until now did not have acost-effective tool to extract insights from it. Enter Power BI which is a set oftools and applications that let you extract data from multiple unrelated sourcesand convert it into neatly managed and coherent set of information, visuallyappealing insights, interactive data, charts, graphs and reports.Topics Introduction to Power BI Extracting Data Power Query for Data Transformation Power Pivot for Data Modeling and Data Analysis Expression – DAX Queries Data Visualization with Analytics Power Q & A Power BI Desktop & Administrationwww.intellipaat.com Copyright IntelliPaat. All rights reserved.
InformaticaLearning ObjectiveThis training course lets learners grasp advanced skills like InformaticaInstallation, Configuration and Administration using PowerCenter. You will beable to test and monitor critical data processing using automated, scalable andauditable approach. Get trained in Workflow Informatica, data warehousing,Repository Management and other processes.Topics Data Warehousing and Cleansing High Availability & Failover, working withutilitiesConceptsFlat file processing (advance Informatica Installation and Configuration Active, passive, expression transformation Sorter, Sequence Generator, Filter, Joiner Dynamic targetingtransformation Java & XML transformations, active look up Ranking, Union, Router Transformation Unconnected Stored Procedure usage Syntax for Rank and Dense Rank Incremental Data Loading and Aggregation Source Qualifier Transformation and Constraint based loadingMappings XML Transformation and active look upSlowly Changing Dimension & advanced Profiling in PowerCenter, Workflow Creation transformations)& DeletionSCD Mapplet and loading to multiple designer Performance Tuning in Informatica Repository Manager & Workflow Tables Parameters, Variables, Error handling &Recoverywww.intellipaat.comLinkedIn Connection & Connection withSourcesInformatica Database Connection & Relational Database Push down optimization, Partitioning, &Cache management Copyright IntelliPaat. All rights reserved.
Self-Paced CoursesThis course will help you master Business Intelligenceconcepts like data warehousing (DW) Architecture, DataData warehouse& ErwinIntegration, Data Modeling, Erwin, fundamentals of ETL Extract, transform, load. You will gain thorough proficiencyin multidimensional modeling, RDBMS tools, SQL parsing,comparison of data warehouse and database, Cube andErwin implementation.This course is meant for an in-depth understanding of theMicroStrategy platform, its architecture, the significance ofMicroStrategyBusiness Intelligence, etc. You will gain expertise to domultidimensional data modeling involving hierarchies,levels, measures and schemas. This also includes theDesktopTutorials, Server ApplicationsandDerivedMetrics.This course lets you master the Qlikview software in orderQlikViewto derive business intelligence and for discovering visualinsights. In this course, you will learn the skills needed fordata interpretation, modeling, designing, and deploying.Get hands-on experience in Qlikview applications.www.intellipaat.com Copyright IntelliPaat. All rights reserved.
Project WorksCourseTableau 10DesktopOracle PL SQLIndustry/DomainProjectSalesTableau Interactive DashboardsCrimeSegmenting types of crimes and their frequencyHealthcareVisual mapping between Vaccination rate and Measles outbreakRetailAnalysing market performanceGeneralPerforming DML Operations on databaseBanking and FinanceStreamlining banking data with PL SQLTelecommunicationsTelecom company wants to learn more about customersAviationAn Airline company wants to optimize routes & seatsGeneralConfiguration and loggingSalesSSAS cube using BI Data Tools 2012SalesBuilding DashboardsRetailAnalysing retail sales dataManufacturingWorking with data warehouse and generating reportsEcommerceEcommerce company wants to improve salesShippingTop down and bottom up analysis to identify shipping cost leakageHealthcareValue & Volume based analysis on hospital records to analyse chargesvs. patients inflowAutomobileUnderstanding customer buying habits in automobile industryMedia and entertainmentMedia company wants to understand customer's behaviourSalesGeneral Manager Insight - DashboardBanking and FinanceCustomer & Relationship ApplicationGeneralCRDWFMCGCreating a sales data martGeneralCustomer social media data integrationMSBIPower BIInformatica 6 Additional projects as part of self-paced courseswww.intellipaat.com Copyright IntelliPaat. All rights reserved.
Job Assistance ProgramIntellipaat is offering job assistance to all the learners who have completed the training. Youshould get a minimum of 60% marks in the qualifying exam to avail job assistance.Intellipaat has exclusive tie-ups with over 80 MNCs for placements.Successfully finish the trainingGet your resume updatedStart receiving interview callsIntellipaat Alumni Working in Top CompaniesRamyasri MandepudiRecruiter at Goodwill technologies Pvt. Ltd.Thank you Intellipaat for the wonderful Informatica training. I am completelysatisfied with the training and was able to grab my dream job thanks to thiswonderful training.Ayush GuptaCo-Founder at YellowSquashThe Intellipaat MSBI training was outstanding. The wide variety and rich qualityof the training material, the videos, ppts and pdfs that accompanied thetraining were really good and helped me master this technologyYogesh TaggarGroup Manager at WNS Global Services Pvt. Ltd.Thanks a lot Intellipaat team. Your help was very useful to me. Without yoursupport I would not have been able to master the subject but you made theentire learning experience abbsolutely effortless. Great workMore Customer Reviewswww.intellipaat.com Copyright IntelliPaat. All rights reserved.
Our Clients 80 CorporatesFrequently Asked QuestionsQ 1. What is the criterion for availing the Intellipaat job assistance program?Ans. All Intellipaat learners who have successfully completed the training post April 2017 aredirectly eligible for the Intellipaat job assistance program.Q 2. Which are the companies that I can get placed in?Ans. We have exclusive tie-ups with MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma,Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, and more. So you have theopportunity to get placed in these top global companies.Q 3. Do I need to have prior industry experience for getting an interview call?Ans. There is no need to have any prior industry experience for getting an interview call. In fact,the successful completion of the Intellipaat certification training is equivalent to six months ofindustry experience. This is definitely an added advantage when you are attending an interview.Q 4. If I don’t get a job in the first attempt, can I get another chance?Ans. Definitely, yes. Your resume will be in our database and we will circulate it to our MNCpartners until you get a job. So there is no upper limit to the number of job interviews you canattend.Q 5. Does Intellipaat guarantee a job through its job assistance program?Ans. Intellipaat does not guarantee any job through the job assistance program. However, wewill definitely offer you full assistance by circulating your resume among our affiliate partners.www.intellipaat.com Copyright IntelliPaat. All rights reserved.
MicroStrategy platform, its architecture, the significance of Business Intelligence, etc. You will gain expertise to do multidimensional data modeling involving hierarchies, levels, measures and schemas. This also includes the Desktop Tutorials, Server Applications and Derived Metrics. MicroStrategy This course lets you master the Qlikview software in order to derive business intelligence and .
