Introduction to Data Analytics
• Data Analytics Overview
• Importance of Data Analytics
• Types of Data Analytics
• Benefits of Data Analytics
• Data Analytics Processes
• Difference Between Data Analytics and Data
Science
Excel: Basic to Advanced
• MICROSOFT EXCEL WINDOW
• THE WORKBOOK
• CREATING AND SAVING WORKBOOK
• CORRECTING THE CONTENT OF A CELL
• CHANGING COLUMN AND ROW WIDTH
• INSERTING ROWS AND COLUMN
• INSERTING WORKSHEET
• DELETING ROWS AND COLUMN
• DELETING WORKSHEET
• HIDING AND UNHIDING ROWS, COLUMNS AND
WORKSHEET
• MERGING A CELL
• COPY AND PASTE
• FREEZING AND UNFREEZING PANE
• LOCKING AND UNLOCKING A WORKSHEET
• RENAMING WORKSHEET
• TYPING, BACKSPACE AND DELETE
• UNDERSTANDING CELL REFRENCING
• FREEZING AND UNFREEZING PANE
Excel: Formulas
AGGREGATE FUNCTIONS
• ADDITION
• SUBTRACTION
• MULTIPLICATION
• DIVISION
• SUM
• PRODUCT
• COUNT
• COUNTA
• COUNTBLANK
• MAX
• MIN
• MEDIAN
• SQRT
• MODE
LOGICAL FUNCTIONS
• IF
• NESTED IF
• IFS
• AND
• OR
• IFERROR/IFNA
• SWITCH
• ABSOLUTE CELL REFERENCE
• RELATIVE CELL REFERENCE
• MIXED CELL REFERENCE
•
STATISTICAL FUNCTIONS
• COUNTIF
• COUNTIFS
• SUMIF
• SUMIFS
• AVERAGE
• AVERAGEIF
• AVERAGEIFS
• QUARTILE
• PERCENTILE
• STANDARD DEVIATION
• VARIANCE
• SEQUENCE
LOOKUP FUNCTIONS
• CONDITIONAL FORMATTING
• SORT
• FILTER (DATE FILTER, NUMBER FILTER,
TEXT FILTER)
• VLOOKUP
• HLOOKUP
• XLOOKUP
• INDEX AND MATCH
• FORMULATEXT
• UNIQUE
DATE FUNCTIONS
• TODAY
• NOW
• EDATE
• EOMONTHS
• DATE
• DAY
• MONTHS
• WORKDAY
• WEEKDAY
TEXT FUNCTIONS
• CONCAT
• TEXT
• LEN
• MID
• RIGHT
• LEFT
• TRIM
• LOWER
• UPPER
• PROPER
• TEXT BEFORE
• TEXT AFTER
• TEXTJOIN
• TEXTSPLIT
• SUBSTITUTE
• TEXT TO COLUMN
• FLASH FILL
DATA VISUALIZATION WITH EXCEL
• CREATE AND NAME TABLE
• TABLE HEADERS REPLACING COLUMN LETTERS
• PROPAGATION OF A FORMULA IN A TABLE
• RESIZE TABLE
• REMOVE DUPLICATES
• CONVERT TO RANGE
• TABLE STYLE OPTIONS
• SHAPES
• DASHBOARD TEMPLATE
• CREATING A PIVOT TABLE
• SPECIFYING PIVOT TABLE DATA
• CHANGING A PIVOT TABLES CALCULATION
• FILTERING AND SORTING A PIVOT TABLE
• CREATING A PIVOT CHART
• GROUPING ITEMS
• UPDATING A PIVOT TABLE
• FORMATTING A PIVOT TABLE
• USING SLICERS
• CHARTS
• STATTIC DASHBOARD
• INTERACTIVE DASHBOARD
Data Visualization: Powerbi
• Introduction To Power Bi
• Installation Of Power Bi
• How To Get Data from Excel
• How To Get Data from Pdf
• How To Get Data from Folder
• How To Get Data from A Website
• How To Get Data from Txt/Csv File
DATA CLEANING WITH POWERQUERY
• Power Query
• How To Pivot and Unpivot in Power Query
• How To Merge in Power Query
• How To Append in Power Query
• Splitting Data
• Changing Data Types
• Groupby
• Keeping and Removing of Rows and Columns
• Transpose
• Formatting text in PowerQuery
• Dealing with number column
• Dealing with Date and time column
• Add Column
• Invoke Functions
Data Modelling
• Relationship
• Cross Filter Direction
• Cardinality
Dax
• Three Ways to Use Dax
Measures
• Sum
• Sumx
• Count
• Distinct Count
• Countrows
• Counta
• CountaX
• Min
• MinX
• Max
• Maxx
• Calculate Function
Calculated Column
• If
• Nested If
• Switch
• Related And Lookup Value
Date Table
• Calendar_auto
• Date
• Today
• Year
• Month
• Quarter
• Day
Visualization
• Shapes
• Page Formatting
• Charts
• Creating a Dashboard
SAVE Publishing Workbooks and Workspace
• Share Data with Colleagues and Others
• Publish a report to the web
• Manage published reports
• Share a dashboard
• Exporting to PDF
• Connecting to SQL
Data base : SQL
• Introduction To SQL
• How To Download MySQL
• SQL Installation
• How To Download and Install MySQL
• Basic SQL Data Type
• How To Create Table
• How To Preview Table
• How To Delete Table
• How To Insert Information into A Table
• Constraints
• How To Alter a Table
• How To Delete a Table
• How To Preview the Data in A Table
• How To Update the Table
• Importing Data
• How To Delete a Row
• Filtering a table
• Foreign Key
Aggregate Functions
• Sum
• Count
• AVG
• Distinct Count
•
Data Cleaning Functions
• DateDiff
• Substring
• CharIndex
CTE
Join and Union
SubQuery and Nested Query
