Data Anylytics course

• Counting, Probability,and Probability Distributions
• Sampling Distributions
• Estimation and Hypothesis Testing
• Scatter Diagram
• Anovaand Chisquare
• Anovaand 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
• DataTypes, Measure Of centraltendency,Measures of Dispersion
• Graphical Techniques, Skewness & Kurtosis,Box Plot
• DescriptiveStats
• Sampling Funnel,Sampling Variation,Central LimitTheorem,Confidence interval

• Excel tutorial
• Text to Columns
• Concatenate
• The Concatenate Function
• The Right Function with Concatenation
• 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
• Usingthe IF Function
• Changing the “Value if false ”Condition to Text
• Pivot Tables
• Creating a Pivot Table
• Specifying Pivot Table Data
• Changing a Pivot Tables Calculation
• Filtering and Sorting a PivotTable
• Creating a PivotChart
• Grouping Items
• Updating a PivotTable
• Formatting a PivotTable
• Using Slicers
• Charts
• Creating a SimpleChart
• Charting Non-Adjacent Cells
• Creating a Chart Using the Chart Wizard
• Modifying Charts
• Moving an Embedded Chart
• Sizing an Embedded Chart
• Changing the ChartType
• ChartTypes
• 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
• PieCharts
• Creating a PieChart
• Moving the PieChart to its OwnSheet
• Adding Data Labels
• Exploding a Slice of a PieChart
• Data Analysis−Overview
• types of Data Analysis
• Data Analysis Process
• Working with RangeNames
• Copying Name using Formula Autocomplete
• Range Name Syntax Rules
• Creating Range Names
• CreatingNamesforConstants
• Managing Names
• Scope of a Name
• Editing Names
• Applying Names
• Using Names in a Formula
• ViewingNamesinaWorkbook
• Copying Formula swith 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 aTable
• 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

• 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 SolveQueries
• The SET Operators
• Data Manipulation Statements
• Use of DDL Statements to Create and Manage Tables
• Other Schema Objects
• Control UserAccess
• Management of Schema Objects
• Manage Objects with Data Dictionary Views
• Manipulate Large DataSets
• Data Management in Different Time Zones
• Retrieve Data Using Sub-queries
• RegularExpressionSupport

• Start Page
• Show Me
• Connecting to Excel Files
• Connecting to Text Files
• Connect to Microsoft SQLServer
• Connecting to Microsoft Analysis Services
• Creating and Removing Hierarchies
• Bins
• Joining Tables
• Data Blending

• Parameters
• Grouping Example1
• Grouping Example2
• Edit Groups
• Set
• Combined Sets
• Creating a FirstReport
• Data Labels
• Create Folders
• Sorting Data
• Add Totals, SubTotals and Grand Totals to Report

• Area Chart
• Bar Chart
• Box Plot
• Bubble Chart
• Bump Chart
• Bullet Graph
• Circle Views
• Dual Combination Chart
• DualLines Chart
• Funnel Chart
• Traditional Funnel Charts
• Gantt Chart
• Grouped Baror Side by SideBars Chart
• Heatmap
• High light Table
• Histogram
• Cumulative Histogram
• Line Chart
• Lolli pop Chart
• Pare to Chart
• PieChart
• Scatter Plot
• Stacked Bar Chart
• Text Label
• Tree Map
• Word Cloud
• Water fall Chart

• Dual Axis Reports
• Blended Axis
• Individual Axis
• Add Reference Lines
• Reference Bands
• Reference Distributions
• Basic Maps
• Symbol Map
• Use Google Maps
• Map box Maps as a Background Map
• WMS Server Map as a Background Map

• Calculated Fields
• Basic Approach to Calculate Rank
• Advanced Approach to Calculate Ra
• Calculating Running Total
• Filters Introduction
• Quick Filters
• Filterson Dimensions
• Conditional Filters
• TopandBottom Filters
• Filterson Measures
• Context Filters
• Slicing Fliters
• DataSource Filters
• Extract Filters

• Create a Dashboard
• Format Dashboard Layout
• Createa Device Preview of a Dashboard
• Create Filters on Dashboard
• Dashboard Objects
• Create a Story

Module7: Server

• tableau online.
• Overview of Tableau Server.
• Publishing Tableau objects and scheduling / subscription.

Power BI

Module1: Introduction to Power BI

• The print statement
• Comments
• Python DataStructures & DataTypes
• String Operations in Python
• Simple Input & Output
• Simple Output Formatting
• Deep copy
• Shallow copy
• Operators in python

• What is multithreading?
• Difference between a Process and Thread
• Concurrent Programming and GIL
• Uses of Thread
• Starting a New Thread
• The Threading Module
• Thread Synchronization
• Locks
• Semaphore
• Deadlock of Threads
• Avoiding Deadlocks
• Daemon Threads
• Using Databases in Python
• Python MySQL Database Access
• Install the MySQLdb and other Packages
• Create Database Connection
• CREATE, INSERT, READ Operation
• DML and DDL Oepration with Databases
• Web Scraping in Python