An Academy For Data Science Training And Opportunities

Transforming youAn Academy for Data Science Training and OpportunitiesBecome aDataScientist

Transforming you

About usDV Analytics a leading data science training andconsulting firm, led by industry experts. We are aiming totrain and prepare resources to acquire the most in-demanddata science job opportunities in India and abroad“We not just train, we program you for 100% success”Our Features1Training: Classroom/Online/Corporate/Crash Courses2Projects: Realtime industry based projects3Proficiency: Classroom video access4Resume: Resume preparation and project support5Support: Mock-interviews, communication andpresentation skill development6Job Referrals: 100% placement supportQuick facts50 1200 Batched DeliveredStudents trained8.5 Lacs pa35 MNCsAverage salaryReferrals85% Students Placed10 Dedicated IndustryExperts and Faculties

Become aData ScientistYou’ll master in DBMS and Reporting,Data Exploration, Data Visualization,Predictive/Descriptive Analytics,Machine Learning , DeepLearning and AI TechniquesEligibility:Minimum Graduate DegreeBothTechnical and Non-Technical

Step-1 Journey to DBMSand Reporting SkillStart yourjourney withDV Analyticsto become aDataScientist

Learning PathStep-3 Learn Predictive Modeling that leads actionsusing Machine Learning, Deep Learning and AIStep-2 Learn Data Analysis, InsightsGeneration and Presentation SkillStep-1 Learn DBMSand Reporting SkillIn this program you learn how to readdata from multiple source files. Designcomplex data model using joins andrelationship concept along withmanipulation techniques and automationprocessAnalytics Type:Managing data to create a summaryview of analysis and reporting of what ishappening?In this program you learn how to designassociative data model. Designing of KPIMetrics and prepare drill down and storytelling dashboard using advanced datavisualization applicationsAnalytics Type:Descriptive and Diagnostic analyticsDescribe the insights based on the pastinformation what is happening? Andexamine the cause of past results aswhy did it happen?In this program you learn Statistics and itsbusiness applications in terms predictingthe future outcomes from the historypattern of the data and creating an actionto achieve the optimization techniqueusing Machine Learning, Deep Learningand Artificial IntelligenceAnalytics Type:Predictive and Prescriptive analyticsWhat will happen? When and why ? Whatshould we do?

Our training program?Step-3 Learn Predictive Modeling that leads actionsusing Machine Learning, Deep Learning and AIStep-2 Learn Data Analysis, InsightsGeneration and Presentation SkillStep-1 Learn DBMSand Reporting Skill

What companies are looking at?

What companies are looking at?

What companies are looking at?

Our Training ProgramDBMS and Reporting SkillData Extraction andProcessingData Wrangling andExplorationProgramming Language Excel Base and AdvancedExcel VBAAccess (RDBMS)SQL ServerSAS Base and AdvancedR ProgrammingPython ProgrammingBigdata Hadoop Framework, SPARK Bigdata Eco-systemSpark SQL programmingData Visualization SkillStatisticsMachine Learning Tableau Base and AdvancedPower BI Base and AdvancedQlikview Base and AdvancedQliksense Base and AdvancedData Mining SkillDeep LearningData VisualizationBigdata Processing Framework Statistics (Theory)/Business Analytics ApplicationsPredictive Modeling in SAS/R/PythonMachine Learning in SAS/R/PythonDeep Learning in R/Python/TensorFlow/KerasArtificial Intelligence in R/Python

ProgramOur Training ModulesModule-1Module-2Module-3Module-4DBMS Reporting Data Visualization DataMiningDBMS Reporting Data Visualization DataMiningDBMS Reporting Data Visualization Data MiningDBMS Reporting DataVisualizationDBMSDBMS Programming SkillsExcel Base and AdvancedExcel Base and AdvancedExcel Base and AdvancedExcel Base and AdvancedExcel VBAExcel VBAExcel VBAExcel VBAMS AccessMS AccessMS AccessMS AccessSQL ServerSQL ServerSQL ServerSQL ServerSAS Base and AdvancedSAS Base and AdvancedSAS Base and AdvancedSAS Base and AdvancedR ProgrammingPython ProgrammingR ProgrammingR ProgrammingPython ProgrammingPython ProgrammingBigdata and Hadoop FrameworkBigdata and Hadoop FrameworkSpark/Scala ProgrammingSpark/Scala ProgrammingData Visualization SkillsDVTableau Base and AdvancedTableau Base and AdvancedTableau Base and AdvancedAny One from Power BI / Qlikview / QliksenseAny One from Power BI / Qlikview / QliksensePower BI Base and AdvancedQlikview Base and AdvancedPower BI Base and AdvancedQliksense Base and AdvancedDMQlikview Base and AdvancedQliksense Base and AdvancedData Mining SkillsStatistics and Business AnalyticsStatistics and Business AnalyticsStatistics and Business AnalyticsPredictive Modeling SAS/R/PythonPredictive Modeling SAS/PythonPredictive Modeling SAS/RMachine Learning SAS/R/PythonMachine Learning SAS/PythonMachine Learning SAS/RDeep Learning R/Python/Tensorflow/KerasDeep Learning Python/Tensorflow/KerasArtificial Intelligence R/PythonTableau Base and Advanced

ontents

Data Extraction andProcessingData Wrangling andExplorationProgramming LanguageDBMSandStatisticsMachine LearningDeep LearningData VisualizationBigdata Processing FrameworkProgrammingSkillsUsing Excel, VBA, Access,SQL, SAS, R, Python, Hadoop,Spark/Scala

Excel DBMS Reporting andVisualizationExcel is one of the finest reporting tool in the analytics world. Everyanalyst is must start with Excel as their first analytics tool to progressfurtherSession-1 Excel introduction to excel navigation processExcel data reading by identifying dimension and measure fieldsExcel data connection to flat files to database connectionCSession-2 Excel summary analysis using basic and advanced pivotExcel summary analysis using advanced pivot 110 optionsExcel slicer dashboardExcel power pivotSession-3 Excel data manipulation using formula and functionsExcel expressions using arithmetic expressions and if then logicExcel Functions Lookup reference functions Character functions Numeric functions Datetime functionsSession-4 Excel automated dashboard using advanced charts and VBAautomationLive projects from Realtime industry experienceEXEL

Excel VBAV isualasicA pplicationVisual Basic for Applications. It's a programming language thatenables you to control just about everything in Excel. You'll learnhow to create Macros that can be run from things like a button on aspreadsheet.Session-1 Excel navigation through developer tabRecord the first macro using manual processGet through excel vba .notationDo the first macro programmingVba programming variablesSession-2 VBA conditional logic using If then Else ifConditional and logical operatorsProgramming Loops and ArraysString FunctionsSession-3 Subs and FunctionsVBA code for data importing and connection to dbAdvanced VBA queries for sheet navigation and filtersSession-4 Excel VBA user formsExcel VBA Charts, Embedded Charts, Charts and User Forms etc

MS Access (RDBMS)CGet the first step into Relational Database Management SystemKnowing access we can get an understanding of query writing,joining and relationship data model designing. It is good to haveaccess knowledge before entering in SQL,SAS,R and PythonSession-1 What is DatabaseWhat is table and data types in designing columnsConcept of RDBMSData Importing and Exporting in AccessSession-2 Access Queries (select, maketable, append, update, delete,crosstab, union and union all)Session-3 Joining tables ( Inner Join, Left Join, Right Join, Left Null, RightNull, Full join, Un-Matched Join)Relationship (one to many, many

Jan 01, 2020 · SAS Programming SAS (Statistical Analysis System). SAS is a business application software which is used for DBMS and reporting, visualization and data mining purpose. To begin with sas we must start with sas data manipulation using sas programming Session-1 SAS Jargons and navigation though SAS PC ad SAS EG windows