Eligibility: IT Professionals / Exposure to Information Technology
Diploma In Data Analytics
About Profound Data Analytics Course
Data Analytics analyses historical data to provide actionable insights for immediate decision-making. It deals with descriptive analysis, summarizing past events and explaining why they occurred. It typically addresses welldefined and tactical problems related to operational efficiency and immediate decision-making.
Data analysts should be proficient in data manipulation using tools like SQL for database querying and data extraction and tools like Excel for data cleaning and transformation.
Duration: 2.5 Months
- Perform basic spreadsheet tasks
- viewing, entering & editing data
- moving, copying data
- Cleaning & wranggling data
- Conditional Formatting
- Functions
- CONCATINATE, LEN, TRIM
- COUNTA, AGGREGATEIFS
- SUMIF, COUNTIF
- Fundamentals of analyzing
- filter and sort data
- Pivot Tables
- HLOOKUP, VLOOKUP
- What-if analysis
- Charts
- Descriptive Statistics
- Annova, Regression
- Mini Project on Excel
- Create DB, Drop DB
- Create Table, Drop Table, Alter Table
- Data Types
- Constraints, Not Null, Unique
- Primary Key, Foreign Key
- Create Index
- Dates
- Views
- Built in functions
- Summarizing results using group functions
- Joins
- Retrieving Data with Sub Queries
- Manipulating Data
- Mini Project on SQL Queries
- Introduction to Python Programming
- Installation & working
- Basic Operators, Data types, Variables
- Control Statements
- Conditional Looping
- Functions
- Collections in Python
- Object Oriented Programming
- Modules and Packages
- String
- File Handling
- Exception Handling
- Multi-threading
- Regular Expressions
- Mini Project on Core Python
- Numpy
- Introduction, installation
- 1D & 2D arrays
- Array indexing – slicing & advance
- Operations – Arithmetic, Logical
- Math, String, Statistical
- Set, Broadcasting
- Pandas
- Introduction, installation
- Series – Creation, indexing
- Slicing, attributes & functions
- Dataframes – Creation
- Merging dataframes,
- Concatenate dataframes
- Binary operations
- Data input and output
- Matplotlib
- Introduction, installation
- Data Visualization
- Plots – single line, multiple line
- Grid axes
- Labels, color line markers
- Seaborn
- Distribution Plots
- Category Plots
- Matrix Plots
- Grids, Regression Plots
- Introduction to Plotly, Altair, ggPlot
- Introduction to Plotly, Altair and ggplot
- Introduction Microsoft Power BI Desktop
- Connecting & Shaping Data
- Creating a Data Model
- Calculated Fields with DAX
- Visualizing Data with Reports
- Artificial Intelligence & Microsoft Power BI
- Power BI Optimization Tools
- Mock test on mnc pattern
- Coding test
- Technical interview
- Group discussion
- Presentations
Batch Schedule
Download BrochureEnquiry
Why choose Profound Edutech for Full Stack Web Developer Training?
- Updated course curriculum.
- Expert faculty members
- 100% placement assistance
- Focus on developing practical expertise
- Live exposure to the latest technology, and state-of-the-art learning infrastructure.
Why Full Stack Web Developer Course at Profound is Different than other Classes in Pune ?
- Strong focus on Placement and proven track record of placed students with MNCs in the field of Web Development.
- This Course contents have been designed by understanding the need of Industry and level of Fresher / student. Which makes Duration and Contents of course intensive than any other Classes.
- One on One attention by Trainers fulfilling need of every student.
- Well equipped Class rooms available for Concept Sessions, Project discussions, Presentations, Brain storming giving feel of Corporate Environment
- Ample Lab facility available free of charge for exploring world of web development.
- Extensive practical hands-on on every Topic guided by a Lab Trainer which helps in removing coding fear of a student.
- Design and Development of deadline oriented Real time projects under guidance of Experts provides feel of how to survive in competitive world.
- Exhaustive tests on each concept, on-line MCQ tests practice raises student's confidence in facing Recruitment exams held by Companies.
- Along with Technical competence, emphasis given for preparing Fresher on Interview skills and other Soft skills.
- Sincere efforts to build Technical competency in Fresher to make him Employable in Industry.