Data Analytics Detailed Program
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
Excel: Basic to Advanced
• MICROSOFT EXCEL WINDOW
• THE WORKBOOK
• CREATING AND SAVING WORKBOOK
• OPENING AND CLOSING WORKBOOK
• CORRECTING THE CONTENT OF A CELL
• CHANGING COLUMN WIDTH
• INSERTING ROWS AND COLUMN
• INSERTING WORKSHEET
• DELETING ROWS AND COLUMN
• DELETING WORKSHEET
• HIDING AND UNHINDING
• ROWS AND COLUMN
• MERGING A CELL AND COLUMN
• TYPING, BACKSPACE AND DELETE
• BOLD AND ITALICIZE, UNDERLINE
• COPY AND PASTE
• UNDERSTANDING CELL REFRENCING
• FREEZING AND UNFREEZING PANE
• RENAMING WORKSHEET
• MERGING A CELL AND COLUMN
• TYPING, BACKSPACE AND DELETE
• BOLD AND ITALICIZE, UNDERLINE
• COPY AND PASTE
• UNDERSTANDING CELL REFRENCING
• FREEZING AND UNFREEZING PANE
Excel: Formulas
• CONDITIONAL FORMATTING
• ADDITION
• SUBTRACTION
• MULTIPLICATION
• DIVISION
• SUM
• PRODUCT
• COUNT
• COUNTA
• COUNT BLANK
• CONCATENATE
• MAX
• MIX
• MEDIAN
• POWER
• SQRT
• SORT
• MODE
• RANGE
• COUNT IF
• IF
• IFS
• NESTED IF
• DROPDOWN
• ABSOLUTE CELL REFERENCE
• RELATIVE CELL REFERENCE
• MIXED CELL REFERENCE
• V LOOK UP
• IFERROR / IF NA V LOOK UP
• H LOOK UP
• X LOOK UP
• MATCH & INDEX
• AGGREGATE
• TODAY
• Trebuchet MS
• NOW
• END OF MONTH (EO MONTH)
• E DATE
• WORK DAYS
• SUM IF
• SUMIFS
• AVERAGE IFS
• QUARTILE
• PERCENTILE
• PERCENTAGE
• STANDARD DEVIATION
• VARIANCE
• LEN
• RIGHT
• LEFT
• SEQUENCE
• TRIMPROPER
• LOWER
• UPPER
• CLEANING DATA WITH TEXT FUNCTIONS
• REMOVING UNWANTED CHARACTERS FROM TEXT
• EXTRACTING DATA VALUES FROM TEXT
• FORMATTING DATA WITH TEXT FUNCTIONS
• DATE FORMATS
• 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
• PIVOT TABLES
• CREATING A PIVOT TABLE
• SPECIFYING PIVOT TABLE DATA
• CHANGING A PIVOT TABLES CALCULATION
• FILTERING AND SORTING A PIVOT TABL
• CREATING A PIVOT CHART
• GROUPING ITEMS
• UPDATING A PIVOT TABLE
• FORMATTING A PIVOT TABLE
• USING SLICERS
• CHARTS
• CREATING 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 AREAS
• FORMATTINGDATA MAKERS
• PIE CHARTS
• CREATING A PIE CHART
• MOVING THE PIE CHART TO ITS OWN SHEET
• ADDING DATA LABELS
• EXPLODING A SLICE OF A PIE CHART CHART
• DASHBOARD
• DATA MANIPULATION
• IMPORTING DATA FROM OTHER SOURCE
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
• Power Query
• How To Merge in Power Query
• How To Append in Power Query
• How To Pivot and Unpivot in Power Query
• Relationship
• Cross Filter Direction
• Dax
• Three Ways to Use Dax
• Sum
• Sumx
• Count
• Countrows
• Counta
• Calculate Function
• If
• Nested If
• Related And Lookup Valu
• Year, Month and Day Function
• Visualization
• How To Use Kpi (Key Performance Indicator)
• How To Use The Three Different Map Visuals
• How To Use Guage Visuals
SAVE Publishing Workbooks and Workspace
• Share Data with Colleagues and Others
• Publish a report to the web
• Manage published reports
• Share a dashboard
Data base : SQL
• Introduction To SQL
• How To Download SQL
• SQL Installation
• How To Download and Install NoSQL
• Basic SQL Data Type
• How To Create Table
• How To Preview Table
• How To Delete Table
• Primary Key
• How To Alter a Table
• How To Delete a Table
• How To Insert Information into A Table
• How To Preview the Data in A Table
• How To Insert Information into A Table Part 2 15. How To Insert Information into A Table Part 3
• How To Insert Information into A Table Part 4
• How To Update the Table?
• How To Delete a Row
• How To Filter a Table Using Select Statement?
• How To Filter a Table Using Select Statement
• Foreign Key
