IvysDataAnalyticsCertificationProgramDetails(ModuleI+II+III)

BasedonIndustryCases,LiveExercises,&IndustryExecutedProjects

Module(I)AnalyticsEssentials81hrs
[Link](6Hrs) Populationmetrics:Mean,Median,Mode,StdDeviation,Variance,Covariance IntroductiontotypesofdistributionsNormal,Poisson,Binomial,Gamma HypothesisTestingtTest,FTestetc OrdinaryLeastSquaresmethodforregression

[Link]&ReportingonExcelusingVBA,Macros(45hrs) IntroductiontoMSExcel,BasicFunctionsandUsage Sorting,Filtering,AdvanceFiltering,Subtotal PivotTables DataEntryForms WhatifAnalysisDataTables,ScenarioManager&GoalSeek DifferentChartsGraphsWhichonetouseandwhen Vlookup,Hlookup,Match,Index Style&NumberFormatting,ConditionalFormatting Worksheet&WorkbookReference SmartPrintingOptions LogicalOperators&FunctionsIFandNestedIF DataValidation TextFunctions Relative&AbsoluteMacroRecording VBAProgramming MakingMacrodoAutomatedTasksforYou o RecordaMacro o AutomateaTaskusingMacro AnalysisUsingVBA o Objects VBACollectionObjects TheApplicationObject WorkbookandWindowObjects TheRangeObjects o Variable,DataTypes,andConstants TypesofVariables PromotingforUserInput Arrays InteractingwithUsers o VBASub,EventandFunctionProcedures CreateSubProcedures,EventProceduresandFunction Procedures

o o

WaystoExecutetheseProcedures HowtoExecuteFunctionProcedures ControlLogicandLoops ConditionalLogic ConditionalStatementsandtheIf/Then/ElseandSelect/Case CodeStructures Looping VBAUserFormsOverview IndustryProjectsusingVBA

[Link](15hrs) RelationalDatabaseFundamentals StepstoDesignEfficientRelationalDatabaseModels CaseStudiesonDesigningDatabaseModels CaseStudyImplementationonHandlingDatainMSAccess2007 Importing/ExportingLargeAmountofDatainto/fromMSAccess IntrotoSQLStatements WritingTransactionalSQLQueries,Merging,joining,sorting,indexing,etc. HandsonExercisesonManipulatingDataUsingSQLQueries CreatingDatabaseModelsUsingSQLStatements IndividualProjectsonHandlingSQLStatements

[Link](9Hrs) AnalyticalProblemSolvingSkills,CreativeThinking,RootCauseAnalysis,DecisionTree Analysis,FishBoneAnalysis,MindMapping,MintoPyramidsPrinciple,etc. TechniquestoHandleCaseBasedInterviews Group/IndividualExercises/CaseStudies [Link](3Hrs) [Link](3Hrs) WhatdoAnalyticsRecruitersLookforinaResume? AnalyticsResumeBestPractices AnalyticsIndustryKeywordstoIncludeinResume HowtoDescribeRelevantAnalyticsProjectsinResume? MythsaboutInterviewsandCommonMistakes ConvincingtheInterviewer CorrectPreparationforInterviewanditsAdvantages The4StepstoInterviewSuccess ComponentsofGoodInterview Howtofacecommoninterviewquestions

EffectiveStrategiestoGetYourResumeNoticed

[Link](Theseworkshophoursarenotcountedtowardsthetotal duration) IndustryNetworkingSessionswithAtLeastTwoIndustryGuestSpeakers MockInterviewSessionswithIndustryProfessionals AnalyticsCompanywiseInterviewQuestions(CollectedfromourAlumniandRecruiters) ComprehensiveAnalyticsInterviewQuestionBanks(SAS,VBA,Behavioral,etc)

IvysDataAnalyticsCertificationProgramDetails (ModuleII)IndustryApplicableCoreAnalyticswithCaseStudies(21Hrs)NEW
1. ImportanceofDataforManagementDecisions DataTypes 2. ClassifyingDatatoConveyMeaning DiagrammaticandGraphicRepresentation MeasuresofCentralTendencyandDispersion DataModeling RatiosandIndexNumbers Discussionwithcasesandexamples

TimeSeriesAnalysis MathematicalModelsforTimeSeries

MeasurementofSeasonal,CyclicalandIrregularVariations Discussionwithcasesandexamples

3.

ProbabilityConceptsandApplications BayesianTheory

ProbabilityDistributionsandMathematicalExpectation Discussionwithcasesandexamples

4. 5.

BasicsofSamplingandSamplingDistribution TheoryofEstimationandTestingofHypothesis Discussionwithcasesandexamples CorrelationandRegressionModels Forecasting Discussionwithcasesandexamples TheoryofAttributes Discussionwithcasesandexamples StatisticalDecisionAnalysis Discussionwithcasesandexamples

6. 7.

8.

9.

10. AnalysisofVariance Discussionwithcasesandexamples 11. MultivariateAnalysis Discussionwithcasesandexamples

Module(III)AdvancedAnalyticsusingSAS9(Base,AdvanceandStatsModeling) 62hrs
[Link] IntroductiontoSAS&DataProcessing,SASDatasteps SASFunctions Typesofvariables,VariableFormats SASproceduresincludingProcSQL SASMacros StatisticalModellingConceptsandPracticalAssignments o o o o o [Link] DedicatedPracticeSessionsonIndustryScenariosinSAS IndustryExecutedPredictiveModelingProjectsinSAS(5ProjectsfromRetail,Healthcare, Finance,Education,Aviationindustries) PleaseNote:Forminutedetailsonanyoftheabovemodules,pleasereachouttousthroughphone (+919748441111/+913340011221)oremail(info@[Link]). Regression ARIMA Clustering Logistic TimeSeriesAnalysis

HandlingDatainSASCaseStudiesI,II,andIII Assignments/Exercises