Scribd
Upload
110 views

Data Analytics Syllabus

Uploaded by

favcadiz
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
110 views

Data Analytics Syllabus

Uploaded by

favcadiz
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 30

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

You might also like