Data Analytics Course Syllabus

• Business Statistics
• Introduction to Statistical Analysis
•  Counting, Probability, and Probability Distributions
•  Sampling Distributions
•  Estimation and Hypothesis Testing
•  Scatter Diagram
•  Anova and Chisquare
•  Imputation Techniques
•  Data Cleaning
•  Correlation and Regression
• Introduction to Data Analytics
•  Data Analytics Overview
•  Importance of Data Analytics
•  Types of Data Analytics
•  Descriptive Analytics
•  Diagnostic Analytics
•  Predictive Analytics
•  Prescriptive Analytics
•  Benefits of Data Analytics
•  Data Visualization for Decision Making
•  Data Types, Measure Of central tendency, Measures of Dispersion
•  Graphical Techniques, Skewness & Kurtosis, Box Plot
•  Descriptive Stats
•  Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval

• Excel: Basics to Advanced

•  Excel tutorial
•  Text to Columns
•  Concatenate
•  The Concatenate Function
•  The Right Function with Concatenation
•  Absolute Cell References
•  Data Validation
•  Time and Date Calculations
•  Conditional Formatting
•  Exploring Styles and Clearing Formatting
•  Using Conditional Formatting to Hide Cells
•  Using the IF Function
•  Changing the “Value if false” Condition to Text
•  Pivot Tables
•  Creating a Pivot Table
•  Specifying PivotTable Data
•  Changing a PivotTables Calculation
•  Filtering and Sorting a PivotTable
•  Creating a PivotChart
•  Grouping Items
•  Updating a PivotTable
•  Formatting a PivotTable
•  Using Slicers
•  Charts
•  Creating a Simple Chart
•  Charting Non-Adjacent Cells
•  Creating a Chart Using the Chart Wizard
•  Modifying Charts
•  Moving an Embedded Chart
•  Sizing an Embedded Chart
•  Changing the Chart Type
•  Chart Types
•  Changing the Way Data is Displayed
•  Moving the Legend
•  Formatting Charts
•  Adding Chart Items
•  Formatting All Text
•  Formatting and Aligning Numbers
•  Formatting the Plot Area
•  Formatting Data Markers
•  Pie Charts
•  Creating a Pie Chart
•  Moving the Pie Chart to its Own Sheet
•  Adding Data Labels
•  Exploding a Slice of a Pie Chart
•  Data Analysis − Overview
•  types of Data Analysis
•  Data Analysis Process
•  Working with Range Names
•  Copying Name using Formula Autocomplete
•  Range Name Syntax Rules
•  Creating Range Names
•  Creating Names for Constants
•  Managing Names
•  Scope of a Name
•  Editing Names
•  Applying Names
•  Using Names in a Formula
•  Viewing Names in a Workbook
•  Copying Formulas with Names
•  Difference between Tables and Ranges
•  Create Table
•  Table Name
•  Managing Names in a Table
•  Table Headers replacing Column Letters
•  Propagation of a Formula in a Table
•  Resize Table
•  Remove Duplicates
•  Convert to Range
•  Table Style Options
•  Table Styles
•  Cleaning Data with Text Functions
•  Removing Unwanted Characters from Text
•  Extracting Data Values from Text
•  Formatting Data with Text Functions
•  Date Formats
•  Conditional Formatting
•  Sorting
•  Filtering
•  Lookup Functions
•  Pivoting

• SQL

•  Introduction to Oracle Database
•  Retrieve Data using the SQL SELECT Statement
•  Learn to Restrict and Sort Data
•  Usage of Single-Row Functions to Customize Output
•  Invoke Conversion Functions and Conditional Expressions
•  Aggregate Data Using the Group Functions
•  Display Data from Multiple Tables Using Joins
•  Use Sub-Queries to Solve Queries
•  The SET Operators
•  Data Manipulation Statements
•  Use of DDL Statements to Create and Manage Tables
•  Other Schema Objects
•  Control User Access
•  Management of Schema Objects
•  Manage Objects with Data Dictionary Views

contact us for full syllabus 

Email:info@digitaldataacademy.com