Data Analytics Courses in Chennai

• Get Started with Power BI
• Overview: Power BI concepts
• Sign up for Power BI

Data Preparation and Import:

• Data sources: Excel, databases, and files.
• Power Query Editor: cleaning, shaping, merging, and appending data.
• Understanding relationships: one-to-one, one-to-many, and many-to-many and creating and managing relationships between tables.
• Explore the Power BI portal.

• Overview: Visualizations
• Using visualizations
• Create a new report
• Create and arrange visualizations
• Format a visualization
• Creating interactive reports and dashboards.
• Choosing appropriate visualizations: charts, maps, and tables.
• Formatting and customizing visuals to improve aesthetics and readability.

Create a Report with Visualizations:

• Create chart visualizations
• Create a report using text, a map, and gauge visualizations.
• Use a slicer to filter visualizations
• Sort, copy, and paste visualizations
• From the collection, save and utilize a unique image.

• New DAX functions
• Date and time functions
• Time intelligence functions
• Filter functions
• Information functions
• Logical functions
• Math & Trig functions
• Parent and child functions
• Text functions

DAX Formulas and Advanced Analysis:

• Writing DAX formulas for calculated columns, measures, and calculated tables.
• Performing advanced calculations and aggregations using DAX functions.
• Utilizing features like drill-down, drill-through, and cross-filtering for interactive exploration.
• Creating hierarchies and implementing filtering options for deeper analysis.

• Python Syntax
• The print statement
• Comments
• Data Types

• Python Data Structures & Data Types
• String Operations in Python
• Using Dictionaries
• Working with Lists

• Simple Input & Output
• Simple Output Formatting
• File operations using Python

• Looping in Python
• Function Arguments, and Control Flow

• Functions
• Python Modules

• Numpy
• Pandas
• DataFrames

• Matplotlib

• Introduction
• Clauses
• Syntax/Semantic Check
• Order By
• Distinct
• Dual

• Arithmetic/Logical Operators
• Relational Operators

• Single Row Functions
• Pseudo Columns
• Level

• Control Statements

• Set Operators
• Joins

• Group Functions
• Analytical Functions

• Sub Query

• Index/Constraints
• DDL (Data Definition Language)

• TCL (Transaction Control Language)

• DML (Data Manipulation Language)

• View and Mview

• Data Dictionary
• GTT (Global Temporary Table)
• External Table

• Excel Syllabus
• Excel Tutorial

• Text to Columns
• Concatenate
• The Concatenate Function
• The Right Function with Concatenation
• Absolute Cell References

• Data Validation
• Conditional Formatting

• Pivot Tables
• Using Slicers
• Charts

• Data Analysis − Overview
• Data Analysis Process

• Remove Duplicates
• Extracting Data Values from Text
• Date Formats
• Sorting
• Filtering

• Lookup Functions
• Pivoting

• PivotTables, Power Query, and Power Pivot
• Cleaning and transforming raw data
• Removing duplicates, handling missing values, and formatting data for analysis

• Data Analysis Tool - Advanced filtering and sorting techniques
• Descriptive statistics: mean, median, mode, standard deviation, etc.
• Correlation analysis: calculating correlation coefficients
• Regression analysis: performing linear regression analysis to model relationships between variables

• Lookup and reference functions: INDEX-MATCH, VLOOKUP, HLOOKUP, etc.
• Logical functions: IF statements, nested IFs, AND, OR, etc.