Introduction to Data Analytics
- Overview of Data Analytics and its applications
- Opportunities and Careers paths in Data Analytics
- Roles and responsibilities of a Data Analyst
MS–Excel (Basic to Advance)
- Interface
- Row and Columns
- Keyboard shortcuts for easy navigation
- Data Entry(Fill series)
- Find and Select
- Clear Options
- Ctrl+Enter
- Formatting options(Font,Alignment,Clipboard(copy, paste special))
- Fundamentals of Excel
- Logical and Advanced Functions
- Visualization
- Data Summarization and Connecting to Data
- VBA and Macros
Referencing, Named ranges,Uses,Arithemetic Functions
- Mathematical calculations with Cell referencing(Absolute,Relative,Mixed)
- Functions with Name Range
- Arithmetic
- functions(SUM,SUMIF,SUMIFS,COUNT,COUNTA,COUNTIFS,AVERAGE,AVERAGEIFS,MAX,MAXIFS,MIN,MINIFS)
Logical functions
- Logical functions:IF,AND,OR,NESTED IFS,NOT,IFERROR
- Usage of Mathematical and Logical functions nested together
VLookup, Hlookup, Nested VLookup, Index, Match
- LOOKUP
- VLOOKUP
- NESTED VLOOKUP
- HLOOKUP
- INDEX
- INDEX WITH MATCH FUNCTION
Advanced functions
- Combination of Arithmatic
- Logical
- Lookup functions
- Data Validation(with Dependent drop down)
Date and Text Functions
- Date Functions:DATE,DAY,MONTH,YEAR,YEARFRAC,DATEDIFF,EOMONTH Text
- Functions:TEXT,UPPER,LOWER,PROPER,LEFT,RIGHT,SEARCH,FIND,MID,TTC, Flash Fill
Data cleaning, Data type identification, Remove Duplicates, Formatting and Filtering
- Number Formatting(with shortcuts)
- CTRL+T(Converting into an Excel Table)
- Formatting Table
- Remove Duplicate
- SORT
- Advanced Sort
- FILTER
- Advanced Filter
Data Visualization: Conditional Formatting, Charts
- Conditional formatting(icon sets/Highlighted colour sets/Data bars/custom formatting)
- Charts:Bar,Column,Lines,Scatter,Combo,Gantt,Waterfall,pie
- Fundamentals of Data Visualization
- Introduction to Power BI
- Data Visualization using Power BI
- Power BI basics
- DAX
- Data Visualization with Analytics
- Dashboard
Data Summarization: Pivot Report and Charts
- Pivot Reports:Insert,Interface,Crosstable Reports;Filter,Pivot Charts,
- Slicers:Add,Connect to multiple reports and charts
Calculated field, Calculated item
Data Summarization: Dashboard Creation, Tips and Tricks
- Dashboard:Types,Getting reports and charts together, Use of Slicers.
- Design and placement: Formatting of Tables,Charts,Sheets,Proper use of Colours and Shapes
Connecting to Data: Power Query, Pivot, Power Pivot within Excel
- Power Query: Interface, Tabs
- Connecting to data from other excel files, text files, other sources
- Data Cleaning
- Transforming
- Loading Data into Excel Query
Power BI
Power BI Introduction and Installation
- Understanding Power BI Background
- Installation of Power BI and check list for installation
Data Type and Load
- Loading data from multiple sources
- Data type and the type of default chart on drag drop.
Power BI Visualization
- Understanding Column Chart
- Understanding Line Chart
- Conditional formating
Power Query Editor
- Loading data from folder
- Understanding Power Query in detail
- Promote header, Split to limiter, Add columns, append, merge queries etc
Modelling with Power BI
- Loading multiple data from different format
- Understanding modelling (How to create relationship)
- Connection type, Data cardinality, Filter direction
- Making dashboard using new loaded data
Power Query Editor Filter Data
- Power Query Custom Column & Conditional Column
- Manage Parameter
- Introduction to Filter and types of filter
- Trend analysis, Future forecast
Customize the data in Power BI
- Understanding Tool tip with information
- Use and understanding of Drill Down
- Visual interaction and customisation of visual interaction
- Drill through function and usage
- Button triggers
- Bookmark and different use and implementation
- Navigation buttons
Dax Expressions
- Introduction to DAX
- Table Dax, Calculated column, DAX measure and difference
- Calculated Column
- Related, Lookup value, switch, Datedif,Rankx,Date functions
- Dax Measure and Quick Measure
Tableau
Introduction to Tableau
- Tableau File Extensions
- Data Types, Dimensions, Measures, Aggregation concept
- Tableau Desktop Installation
- Data Source Overview
- Live Vs Extract
Basic Charts & Formatting
- Overview of worksheet sections
- Bar Chart, Stacked Bar Chart
- Text Table, Highlight Table
- Formatting: Remove grid lines, hiding the axes, conversion of numbers to thousands, millions, Shading, Row divider, Column divider
Filters
- Types of Filters
- Extract, Data Source, Context, Dimension, Measure, Quick Filters
- Order of operation of filters
Calculations
- Examples of Basic Calculations: Aggregate functions
- Table Calculations
Data Combining Techniques
- Combining
- Joins, Relationships, Blending & Union
Charts
- Different type of charts
- Combined Axis
Parameters
- What are Parameters ? Purpose and examples
Analytics & Dashboard
- Overview of Dashboard: Tiled Vs Floating
- Dashboard creation with formatting
MySQL
Introduction to Mysql
- Introduction to Databases
- Introduction to RDBMS
- Different types of RDBMS
- Software Installation(MySQL Workbench)
SQL Commands and Data Types
- Types of SQL Commands (DDL,DML,DQL,DCL,TCL) and their applications
- Data Types in SQL (Numeric, Char, Datetime)
DQL & Operators
- SELECT
- LIMIT
- DISTINCT
- WHERE AND
- OR
- IN
- NOT IN
- BETWEEN
- EXIST
- ISNULL
- IS NOT NULL
- ORDER BY
Group Operations & Aggregate Functions
- Group By
- Having Clause
- COUNT
- SUM
- AVG
- MIN
- MAX
- COUNT String Functions
- Date & Time Function
Joins
- Inner
- Left
- Right
- Cross
- Self Joins
- Full outer join
DDL
- Create
- Drop
- Alter
- Rename
- Truncate
DML
- Insert
- Update & Delete
Advanced-Data Visualization
- Slicers and Filters in Power BI
- Interactive Visualizations in Power BI
- Creating Paginated Reports
- Creating Dashboards in Power BI
Data Modelling & DAX
- Introduction and Techniques to Data Modelling
- Creating Measures in DAX
- DAX Functions
Publishing Your Dashboards
- Introduction to Power BI Service
- Collaboration using Power BI
- Creating Dashboards using Power BI Cloud/Service
- Publishing Your Dashboard
Publishing Your Dashboards
- Data Cleaning Techniques
- Data Transformation Techniques
- Introduction to Power Query
- Data Types and Filters in Power Query
- Inbuilt Column and Row Transformations
- Creating a Query in Power Query
- Combining Two Data Sets
Data Analysis using Python Libraries
- Introduction to Python
- Introduction to NumPy and Pandas
- Indexing and Slicing NumPy arrays
- Data Handling with NumPy
- Visualization using Matplotlib
- Data Manipulation using Pandas
- Indexing and Filtering Pandas data frames and series
- Modifying Pandas data frames and Series
Data Analytics using Tableau
- Fundamentals of Tableau
- Data Visualization using Tableau
- Essential Design Principles for Visualization with Tableau
- Connecting to Various Data Source and Preparing Data
- Working with Metadata
- Tableau Filters
- Data Structuring
- Creating Charts and Graphs
- Creating Dashboards and Interactive Reports in Tableau
- Calculations
- Visual Analytics
- Dashboard
