Business Analyst (Tamil)
Become a Professional Business Analyst by mastering Advanced SQL, Power BI, and Advanced DAX Queries to build a highly competitive and sought-after career profile.
₹3124.00
/CourseBundles(54706)/3804086-Business_Analyst_Image.png)
Become the Business Analyst
Master the skills to become a Business Analyst with our comprehensive course! Learn data analysis, visualization, and problem-solving to drive business decisions effectively.
Data Extraction
Learn to gather raw data from various sources efficiently.
Data Transformation
Clean, process, and structure data for analysis
Data Modeling
Build structured data models for insightful decision-making.
.jpg)
Data Visualization
Present data effectively using charts and dashboards.
How it works?
Enroll, learn at your own pace with step-by-step lessons, and get expert support anytime via text, screen share, or voice chat. Apply your skills to real-world projects and advance your Business Analyst career!
Master the basics to advanced techniques, gaining the skills to build Power BI dashboards and write complex SQL and DAX queries in Tamil.
Study at your own pace, anytime and anywhere, with lifetime access to recorded lessons and resources
Get your queries resolved anytime through text, screen share, or voice chat, plus enjoy weekly Live Q&A sessions on our Technical Support Channel for seamless learning!
With our dedicated Career99 placement guidance, we support and refer committed students to secure their dream jobs.
Essential Tech Stack for Business Intelligence
Unlock the power of data with the must-have tools for every Business Analyst. Learn to analyze, visualize, and present insights using industry-standard platforms.
Exce for Professional
📌 The backbone of data organization, calculation, and business reporting.📌 Helps clean, structure, analyze, and transform raw data efficiently.
📌 Essential for creating dashboards, MIS reports, and making data-driven decisions.
Advanced SQL
📌 The backbone of data extraction and manipulation.
📌 Helps retrieve, clean, and transform data from databases efficiently.
📌Essential for creating reports and making data-driven decisions.
Power BI Essentials
📌 A powerful visualization tool for interactive dashboards and reports.
📌 Helps analyze and present insights from complex datasets.
📌 Connects seamlessly with multiple data sources for real-time reporting.
Advanced DAX Queries
📌 Optimizes and enhances DAX queries for better Power BI performance.
📌 Helps in advanced calculations and data modeling.
📌 Essential for troubleshooting and improving report efficiency.
Course Curriculum
4 Subjects
THE001A - Power BI Essentials
97 Learning Materials
Introduction
Join Technical and Career Support
External Link
Course Introduction
Video
00:06:53
Introduction
PDF
Download Power BI
Video
00:01:48
Installation
Video
00:06:38
Navigating to User Interface
Video
00:06:02
Course Data - Part 01
ZIP
Data Extraction
Manual Entry Data
Video
00:06:25
Load Excel File
Video
00:02:30
Load CSV File
Video
00:04:37
Load XML File
Video
00:02:10
Load From PDF
Video
00:01:21
Connecting to the Database
Video
00:05:28
Connect Web Data
Video
00:02:20
Connect WEB API
Video
00:09:02
Data Transformation
Power Query Editor
Video
00:09:05
Re-use the Data Model
Video
00:05:24
Manage Parameters
Video
00:03:56
Filtering Rows By Number Based Columns
Video
00:05:53
Filtering Rows by Text Based Columns
Video
00:04:19
Filtering Rows By Date Based Columns
Video
00:06:43
Advanced Filtering with Logical Operations
Video
00:06:58
Manage Queries
Video
00:07:55
Manage Columns
Video
00:02:20
Keep and Remove Rows
Video
00:04:46
Handling Duplicates
Video
00:03:15
Remove Blank Rows
Video
00:00:20
Handling Error Values
Video
00:03:03
Sorting Data
Video
00:02:25
Split Column Values by Delimiter
Video
00:06:31
Split Column By Other Features
Video
00:05:09
Group By Count
Video
00:04:31
Group By Sum
Video
00:02:39
Group By Average
Video
00:00:53
Group By Median
Video
00:00:49
Group By Min and Max
Video
00:01:41
Finding Duplicates Inside Group
Video
00:02:23
Change Data Type
Video
00:03:22
Manage Headers
Video
00:01:12
Replace Values
Video
00:02:30
Append Queries
Video
00:05:22
Combine Files
Video
00:03:03
Merge Queries
Video
00:07:16
Merge - All Types
Video
00:10:15
Transpose Rows to Columns
Video
00:01:08
Reverse Rows
Video
00:00:43
Count Rows
Video
00:01:14
Rename Column
Video
00:00:33
Fill Neighbour Values
Video
00:01:10
Rearranging Columns
Video
00:01:04
Convert to List
Video
00:01:12
Text Formatting
Video
00:03:19
Text Extraction
Video
00:04:28
Statistics
Video
00:03:57
Math Operations
Video
00:04:38
Data Time Operations
Video
00:04:08
Execute R Script
Video
00:02:21
Execute Python Script
Video
00:02:28
Add column from Example
Video
00:02:29
Adding Custom Column
Video
00:01:58
Adding Index Column
Video
00:01:25
Adding column by Custom Function
Video
00:05:01
Duplicating the Column
Video
00:00:11
Adding Conditional Column
Video
00:02:35
View Options
Video
00:03:31
Query Dependency
Video
00:04:28
Data Modeling
Training Institute Model
ZIP
Model Relationship
Video
00:11:35
Measures and Calculated Columns
Video
00:08:44
DAX Table
Video
00:09:11
Calculation Groups
Video
00:07:24
Model Security
Video
00:04:02
Q&A Setup
Video
00:08:05
Data Visualization
Practice Data for Data Visualization
ZIP
Bar and Column Charts
Video
00:13:41
Line and Area Charts
Video
00:07:23
Line and Stacked or Clustered Column Chart
Video
00:02:56
Ribbon Chart
Video
00:01:38
Waterfall Chart
Video
00:03:28
Funnel Chart
Video
00:02:30
Scatter Chart
Video
00:05:25
Pie and Donut Chart
Video
00:06:16
Treemap
Video
00:02:47
Map and Filled Maps
Video
00:04:38
Gauge Chart
Video
00:04:07
Key Performance Indicator
Video
00:01:28
Cards and Slicers
Video
00:08:27
Table and Matrix
Video
00:03:57
Visualization using Python Script
Video
00:03:41
Visualization using R Script
Video
00:02:01
Key Influencers
Video
00:03:03
Decomposition Tree
Video
00:05:54
Narrative
Video
00:02:33
Prepare Report & Publish
Video
00:37:16
Acknowledgement
Course Completion Certification Form
External Link
Join My Youtube Channel
External Link
Follow Me on Instagram
External Link
THE003 - Professional SQL Analyst
77 Learning Materials
Introduction to SQL
Join Technical and Career Support
External Link
Download and Install PostgreSQL
Video
00:03:33
Connect and Register SQL Server
Video
00:02:50
Create a New Database
Video
00:00:00
Course Data
ZIP
Create Table and Columns
Video
00:24:23
Data Retrieval and Querying
Retrieve Data
Video
00:00:00
Source - Retrieve Data
ZIP
Filter Data
Video
00:16:28
Source - Filter Operations
ZIP
Logical Operations on Filters
Video
00:08:52
Source - Logical Operations
ZIP
Wildcard Filters
Video
00:11:04
Source - Wildcard Filters
ZIP
Text Manipulation Functions
Video
00:38:50
Source - Text Manipulation Functions
ZIP
Numerical Operations
Video
00:21:39
Source - Numerical Operations
ZIP
Date Time Functions
Video
00:29:43
Source - Date Time Functions
ZIP
Aggregate, Group By and Having Clause
Video
00:25:30
Source - Aggregate, Group By and Having Clause
ZIP
Cartesian | Cross Joins
Video
00:08:47
Source - Cartesian | Cross Joins
ZIP
Inner Join
Video
00:07:34
Source - Inner Join
ZIP
LEFT Join
Video
00:06:32
Query - LEFT Join
ZIP
RIGHT Join
Video
00:03:05
Query - RIGHT Join
ZIP
Full Join | Full Outer Join
Video
00:02:39
Query - Full Join
ZIP
SELF Join
Video
00:07:11
Source - SELF Join
ZIP
Data Modification and Management
Create Table & Columns
Video
00:05:28
Query - CREATE TABLE and COLUMNS
ZIP
Insert Rows
Video
00:07:11
Query - Insert Rows
ZIP
READ Operation
Video
00:02:32
Query - READ Operations
ZIP
Update Values
Video
00:04:58
Query - Update Values
ZIP
DELETE Rows
Video
00:01:00
Query - DELETE Rows
ZIP
DELETE Columns
Video
00:01:14
Query - DELETE Columns
ZIP
Truncate and DROP Table
Video
00:01:36
Query - Truncate and DROP Table
ZIP
Advanced SQL Techniques
Sub Query
Video
00:15:34
Query - Sub Query
ZIP
Nested Query
Video
00:09:21
Source - Nested Query
ZIP
Common Table Expressions - CTE
Video
00:11:10
Query - Common Table Expression
ZIP
OVER - Window Function
Video
00:02:36
Query - OVER
ZIP
PARTITION BY - Window Function
Video
00:03:57
Query - Partition By
ZIP
Order By - Window Function
Video
00:03:16
Query - Order By in Window Function
ZIP
ROWS Frame - Window Function
Video
00:03:55
Query - ROWS Frame
ZIP
RANGE Frame - Window Function
Video
00:05:10
Query - RANGE Frame
ZIP
First Value - Window Function
Video
00:06:13
Query - First Value
ZIP
Last Value - Window Function
Video
00:05:48
Query - Last Value
ZIP
Nth Value - Window Function
Video
00:04:00
Query - Nth Value
ZIP
Ranking - Window Function
Video
00:04:54
Query - Ranking
ZIP
NTile - Window Function
Video
00:02:18
Query - NTILE
ZIP
Acknowledgement - Course Completion
Get Your Certificate
External Link
Join My Youtube Channel
External Link
Follow Me on Instagram
External Link
Advanced DAX Queries
301 Learning Materials
Introduction to DAX & DAX Studio
Join Technical and Career Support
External Link
Pre-requisites
Video
00:02:07
DAX Introduction
Video
00:03:30
DAX Studio - Introduction
Video
00:03:41
Course Data - AdventureWorks Sales - Microsoft
ZIP
Connecting to Power BI Data Model
Video
00:02:58
DAX Queries - Foundation
EVALUATE
Video
00:10:50
Query - EVALUATE
ZIP
ORDER BY
Video
00:05:17
Query - ORDER BY
ZIP
START AT
Video
00:08:13
Query - START AT
ZIP
ROW
Video
00:03:52
Query - ROW
ZIP
VAR - Introduction
Video
00:08:25
Query - VAR Introduction
ZIP
DEFINE VARIABLES
Video
00:07:22
Query - DEFINE VARIABLES
ZIP
DAX Operators
Arithmetic Operations
Video
00:12:40
Query - Arithmetic Operators
ZIP
Comparison Operators
Video
00:08:29
Query - Comparison Operators
ZIP
Text Concatenation Operator
Video
00:03:18
Query - Text Concatenation Operator
ZIP
Logical Operators
Video
00:23:30
Query - Logical Operators
ZIP
Table Manipulation Functions
Data for Table Manipulation
ZIP
Distinct Function
Video
00:02:34
Query - DISTINCT
ZIP
Add Columns
Video
00:11:44
Query - ADDCOLUMNS
ZIP
Generate Series
Video
00:02:06
Query - GENERATE SERIES
ZIP
Creating Data Table
Video
00:09:17
Query - DATATABLE
ZIP
Cross Join or Cartesian Join
Video
00:04:22
Query - CROSSJOIN
ZIP
Generate - Combining Tables based on LEFT Table
Video
00:08:07
Query - Generate
ZIP
Generate All
Video
00:02:17
Query - Generate All
ZIP
Natural Inner Join
Video
00:03:26
Query - Natural Inner Join
ZIP
Natural Left Outer Join
Video
00:02:38
Query - Natural Left Outer Join
ZIP
Summarize
Video
00:04:43
Query - Summarize
ZIP
Rollup
Video
00:04:59
Query - Rollup
ZIP
Rollup Group
Video
00:03:31
Query - Rollup Group
ZIP
Summarize Columns
Video
00:03:45
Query - Summarize Columns
ZIP
Rollup Add Is SubTotal
Video
00:04:06
Query - Rollup Add Is Subtotal
ZIP
Add Missing Items
Video
00:03:59
Query - Add Missing Items
ZIP
Rollup Is SubTotal
Video
00:05:46
Query - Rollup Is SubTotal
ZIP
SET Operations - Except, Union & Intersect
Video
00:14:08
Query - SET Operations - Except, Union & Intersect
ZIP
Top N
Video
00:07:48
Query - Top N
ZIP
Aggregate Functions
Practice Data for Aggregate Functions
ZIP
Count and CountX
Video
00:04:44
Query - Count and CountX
ZIP
CountA and CountAX
Video
00:03:07
Query - CountA and CountAX
ZIP
Counting Blank Values
Video
00:01:31
Query - Counting Blank Values
ZIP
Counting Rows
Video
00:01:02
Query - Counting Rows
ZIP
Counting Distinct Values
Video
00:02:44
Query - Counting Distinct Values
ZIP
Finding Minimum Values
Video
00:05:09
Query - Finding Minimum Values
ZIP
Finding Minimum Values with Expression
Video
00:01:32
Query - Finding Minimum Values with Expression
ZIP
Finding Maximum Values
Video
00:03:07
Query - Finding Maximum Values
ZIP
Sum Operations
Video
00:02:25
Query - SUM Operations
ZIP
Product Operations
Video
00:02:41
Query - Product Operations
ZIP
Average Function
Video
00:04:15
Query - Average Function
ZIP
Logical Function
Data For Logical Function
ZIP
AND Operation
Video
00:03:07
Query - AND Operation
ZIP
OR Operation
Video
00:02:16
Query - OR Operation
ZIP
NOT Operation
Video
00:01:24
Query - NOT Operation
ZIP
IF Condition
Video
00:04:53
Query - IF Condition
ZIP
True and False
Video
00:02:33
Query - True and False
ZIP
IF.Eager Function
Video
00:08:48
Query - IF.Eager Function
ZIP
If Error
Video
00:03:07
Query - If Error Function
ZIP
COALESCE Function
Video
00:04:51
Query - COALESCE Function
ZIP
Switch with Exact Match
Video
00:03:18
Query - Switch with Exact Match
ZIP
Switch with Numerical Value Comparison
Video
00:05:44
Query - Switch with Numerical Value Comparison
ZIP
Information Function
Data For Information Functions
ZIP
Analyze Column Statistics
Video
00:03:50
Query - COLUMNSTATISTICS
ZIP
Contains
Video
00:06:54
Query - CONTAINS()
ZIP
Contains ROW
Video
00:01:41
Query - CONTAINSROW
ZIP
Contains String
Video
00:06:00
Query - CONTAINSSTRING() & CONTAINSSTRINGEXACT()
ZIP
Filter and Slicer Simulation
Video
00:11:47
Query - Filter and Slicer Simulation
ZIP
Has One Filter
Video
00:09:07
Query - HASONEFILTER
ZIP
Has One Value
Video
00:01:27
Query - HASONEVALUE
ZIP
Check the Column has Applied Filters
Video
00:04:00
Query - ISFILTERED
ZIP
Check the Table Filtered by Other Tabular Column
Video
00:04:06
Query - ISCROSSFILTERED
ZIP
Text and Non-Text Values
Video
00:02:13
Query - ISTEXT() and ISNONTEXT()
ZIP
Number, Odd or Even
Video
00:03:10
Query - ISNUMBER, ISODD, ISEVEN
ZIP
Find Missing Values
Video
00:02:29
Query - ISBLANK
ZIP
Find Error Values
Video
00:02:13
Query - ISERROR
ZIP
Find out Logical Values
Video
00:01:29
Query - ISLOGICAL
ZIP
Find Empty Tables
Video
00:01:10
Query - ISEMPTY
ZIP
Find sub total rows
Video
00:03:09
Query - ISSUBTOTAL
ZIP
Find the scope of hierachy w.r.t rows
Video
00:03:50
Query - ISINSCOPE
ZIP
Math & Trig Functions
Data For Practice
ZIP
Division and Modulus
Video
00:03:15
Query - Divide and Modulus
ZIP
Ceiling and Floor
Video
00:02:43
Query - Ceiling and Floor
ZIP
Rounding
Video
00:03:21
Query - Rounding
ZIP
Rounding Up and Down
Video
00:01:59
Query - Rounding Up and Down
ZIP
Truncate
Video
00:01:13
Query - Truncate
ZIP
Rounding to Even
Video
00:01:02
Query - Rounding to Even
ZIP
Power
Video
00:01:28
Query - Power
ZIP
Square Root
Video
00:00:32
Query - SQRT
ZIP
Exponential Growth
Video
00:00:43
Query - Exponential Growth
ZIP
Sign and Absolute Value
Video
00:01:13
Query - Sign and Absolute Value
ZIP
Factorial
Video
00:01:16
Query - Factorial
ZIP
GCD & LCM
Video
00:01:57
Query - GCD & LCM
ZIP
Logarithm
Video
00:01:12
Query - Logarithm
ZIP
Text Functions
Data For Practice - Text Functions
ZIP
Concatenate and Combine Values
Video
00:08:24
Query - Concatenate and Combine Values
ZIP
ConcatenateX
Video
00:02:19
Query - CONCATENATEX
ZIP
Exact Comparison
Video
00:02:44
Query - EXACT
ZIP
Find and Search
Video
00:03:47
Query - Find and Search
ZIP
Fixed
Video
00:02:42
Query - FIXED
ZIP
Formatting Text
Video
00:06:37
Query - FORMAT
ZIP
VALUE
Video
00:02:36
Query - VALUE
ZIP
Left, Mid and Right Split
Video
00:03:11
Query - LEFT, MID and RIGHT
ZIP
Length of Text
Video
00:00:51
Query - LENGTH
ZIP
Trimming White Spaces on Prefix and Suffix
Video
00:03:04
Query - TRIM
ZIP
Replace and Substitute
Video
00:03:53
Query - REPLACE and SUBSTITUTE
ZIP
Upper and Lower Case Conversion
Video
00:01:14
Query - UPPER and LOWER
ZIP
Repeat Text
Video
00:01:08
Query - REPT
ZIP
Date & Time Functions
Practice Data for Date Time Functions
ZIP
Date and Time
Video
00:02:19
Query - DATE and TIME
ZIP
Calendar
Video
00:02:25
Query - Calendar
ZIP
Calendar Auto
Video
00:03:52
Query - Calendar Auto
ZIP
Date Difference
Video
00:03:03
Query - Date Difference
ZIP
Date Value
Video
00:01:17
Query - Date Value
ZIP
Date Extraction
Video
00:02:25
Query - Date Extraction
ZIP
EDate and EOMonth
Video
00:02:22
Query - EDate and EOMonth
ZIP
Total Working Days
Video
00:04:15
Query - NETWORKDAYS
ZIP
Current Values
Video
00:01:41
Query - Current Date and Time
ZIP
Week Day
Video
00:02:07
Query - Weekday
ZIP
Time Intelligence Functions
Data For Practice - Time Intelligence
ZIP
DateTable for Time Intelligence
Video
00:06:01
Query - DateTable for Time Intelligence
ZIP
Closing and Opening Balance of the Month
Video
00:07:02
Query - Closing and Opening Balance of the Month
ZIP
Closing and Opening Balance of the Quarter
Video
00:02:31
Query - Closing and Opening Balance of Quarter
ZIP
Closing and Opening Balance of the Year
Video
00:05:00
Query - Closing and Opening Balance of the Year
ZIP
Dates Between Two Given Dates
Video
00:01:47
Query - Dates Between
ZIP
Dates From a Given Date and A Period
Video
00:02:10
Query - DATESINPERIOD
ZIP
Shifting Dates Forward and Backward
Video
00:09:13
Query - DATESADD
ZIP
Start and End of Month
Video
00:03:37
Query - Start and End of Month
ZIP
Start and End of Quarter
Video
00:02:38
Query - Start and End of the Quarter
ZIP
Start and End of the Year
Video
00:02:35
Query - Start and End of the Year
ZIP
First and Last Date
Video
00:01:10
Query - First and Last Date
ZIP
Previous and Next
Video
00:06:03
Query - Previous and Next
ZIP
Same Period and Last Year
Video
00:02:06
Query - Same Period Last Year
ZIP
Parent & Child Functions
Practice Data
ZIP
Path
Video
00:02:15
Query - PATH
ZIP
Path Length
Video
00:01:25
Query - Path Length
ZIP
Path Item and Path Reverse Item
Video
00:03:27
Query - PATHITEM, PATHREVERSEITEM
ZIP
Path Contains
Video
00:01:26
Query - Path Contains
ZIP
Relationship Functions
Data for Practice - Relationship Functions
ZIP
Cross Filter
Video
00:07:41
Query - Cross Filter
ZIP
Cross Filter - OneWay Vs Both
Video
00:05:22
Query - ONEWAY, BOTH
ZIP
Related Column Values
Video
00:01:40
Query - RELATED
ZIP
Related Table Values
Video
00:04:36
Query - RELATED TABLE
ZIP
Use Relationship
Video
00:06:17
Query - Use Relationship
ZIP
Filter Functions
Data for Practice - Filter Functions
ZIP
Calculate
Video
00:03:50
Query - CALCULATE
ZIP
Treat As
Video
00:02:33
Query - TREATAS
ZIP
Calculate Table
Video
00:01:48
Query - CALCULATETABLE
ZIP
All Values From the Column or Table
Video
00:11:58
Query - ALL
ZIP
All Values Ignoring Cross Filters
Video
00:07:42
QUERY - ALLCROSSFILTERED
ZIP
All Except
Video
00:06:57
Query - ALLEXCEPT
ZIP
All Selected
Video
00:10:35
Query - ALLSELECTED
ZIP
All but No Blank Rows
Video
00:03:43
Query - ALLNOBLANKROWS
ZIP
Earlier
Video
00:07:57
Query - EARLIER / EARLIEST
ZIP
Filter Rows
Video
00:02:08
Query - FILTER
ZIP
Keep and Remove Filters
Video
00:07:14
Query - KEEPFILTERS, REMOVEFITLERS
ZIP
Lookup Value
Video
00:01:57
Query - LOOKUPVALUE
ZIP
Window Functions
Data For Practice - Window Functions
ZIP
Index
Video
00:08:52
Query - INDEX | ORDERBY | PARTITIONBY
ZIP
Offset
Video
00:05:12
Query - OFFSET | ORDERBY | PARTITIONBY
ZIP
Window
Video
00:06:17
Query - WINDOW | ORDERBY | PARTITIONBY
ZIP
Rank
Video
00:03:08
Query - RANK
ZIP
Acknowledgment Form
Couse Completion Certificate
External Link
Join My Youtube Channel - Learn Realworld DAX
External Link
Follow me on Instagram
External Link
Microsoft Excel for Professionals
92 Learning Materials
Getting Started
Course Introduction
Video
00:01:27
New Workbook
Video
00:08:34
Excel Interface
Video
00:05:30
Data Management
Practice Data for Data Management
ZIP
Basic Data Entry Operation
Video
00:15:15
Clipboard Operations
Video
00:18:28
Custom Fonts
Video
00:07:59
Custom Borders
Video
00:09:00
Custom Colors
Video
00:04:29
Text Alignments
Video
00:03:08
Text Indentation
Video
00:02:41
Text Orientation
Video
00:02:39
Make Text Visible inside Cell
Video
00:05:32
Merging Cells
Video
00:09:09
Data Types
Video
00:14:35
Insert Operations
Video
00:04:04
Delete Operation
Video
00:04:51
Format Cell Size
Video
00:05:56
Content Visibility
Video
00:06:29
Organize Sheets
Video
00:08:33
Hyper Link
Video
00:06:05
Math Formula and Functions
Data for Math Formula and Functions
ZIP
Basic Math Operations
Video
00:11:00
Input and Calculation Styles
Video
00:02:19
Generate Numbers
Video
00:08:06
Rounding Functions
Video
00:15:08
Absolute Value and Sign
Video
00:01:45
Basic Aggregate Functions
Video
00:07:36
Data Extraction Functions
Practice data for Data Extraction
ZIP
Basic Text Extraction Functions
Video
00:00:00
Text Extraction Before and After Delimeter
Video
00:00:00
Splitting Text Data
Video
00:00:00
Text Position and Size
Video
00:00:00
Data Transformation Functions
Practice Data
ZIP
Text Concatenation
Video
00:07:21
Modifying Text Cases
Video
00:01:48
Replace and Substitute Functions
Video
00:06:19
Trim Function
Video
00:03:07
Date and Time Functions
Practice Data
ZIP
Date and Time Creation
Video
00:06:17
Date and Time Conversion
Video
00:01:55
Date and Time Extaction
Video
00:05:32
Date Difference and Intervals
Video
00:06:40
Date Addition and Adjustments
Video
00:04:04
Lookup and Reference Functions
Practice Data
ZIP
Core Lookup Functions
Video
00:23:05
Match and Index
Video
00:13:50
Comparison and Conditionals
Practice Data
ZIP
Comparison Operators
Video
00:05:49
Comparison Functions
Video
00:09:00
Logical Tests
Video
00:12:12
Handling Multiple Conditions - Sequential
Video
00:15:26
Handling Multiple Conditions - Parallel
Video
00:24:23
Tables
Practice Data
ZIP
Table Design
Video
00:14:53
Sort and Filters
Video
00:21:01
Slicers
Video
00:11:11
Conditional Formatting
Practice Data
ZIP
Highlight Cell By Rules
Video
00:08:12
Ranking Rules
Video
00:04:21
Selection Based Rules
Video
00:04:18
Manage Rules
Video
00:07:32
Data Analysis with Pivot Tables
Practice Data
ZIP
Creating a Pivot Table
Video
00:10:07
Pivot Table Design
Video
00:06:08
Timeline Control
Video
00:04:32
Refresh and Change Data Source
Video
00:03:18
Pivot Table Actions
Video
00:02:23
Show & Hide Pivot Table Components
Video
00:01:38
Data Visualization with Pivot Charts
Practice Data
ZIP
Chart Elements
Video
00:15:51
Chart Layouts
Video
00:01:56
Chart Style
Video
00:01:47
Presenting Categories Comparison
Video
00:09:19
Presenting Categories Composition
Video
00:04:20
Presenting Data Trend
Video
00:07:58
Data Review
Practice Data
ZIP
Proofing
Video
00:04:54
Optimize Performance
Video
00:01:19
Accessibility
Video
00:03:27
Translate Contents
Video
00:02:19
Comments & Notes
Video
00:05:52
Data Protection
Video
00:15:07
Page Layout
Practice Data
ZIP
Page Margins
Video
00:02:50
Page Orientation and Size
Video
00:04:51
Print Area
Video
00:02:21
Apply Page Breaks
Video
00:01:53
Page Background
Video
00:01:05
Setting Title on Each Page
Video
00:01:36
Scale to Fit
Video
00:02:22
Sheet Options
Video
00:02:30
Industry-Recognized Certificate!
Boost your career with a certification that validates your expertise in Business Analysis, Power BI, and SQL.
Upon course completion, you'll receive a verifiable certificate to showcase your skills and enhance your job opportunities
Frequently asked questions
Got questions? We’ve got answers! Find everything you need to know about the course structure, support, certification, and learning experience below. If you need more help, feel free to reach out anytime!
Who is this course for?
This course is ideal for aspiring Business Analysts, working professionals, and anyone looking to build expertise in Power BI, SQL, and data analysis.
Do I need prior experience?
No prior experience is required! We start from the basics and gradually move to advanced concepts.
Is this course available in English?
No! The entire course, including video lessons and support, is provided in Tamil for easy understanding.
How can I get support if I have doubts?
You can ask questions anytime through our Technical Support Channel via LinkedIn Chat Support.
Will I receive a certificate?
Yes! Upon course completion, you'll receive a certificate to showcase your skills.
What tools will I learn in this course?
You'll master Microsoft Excel, Power BI, SQL, Advanced DAX Queries, and Essential Business Analyst techniques used in real-world projects.
Can I access the course at my own pace?
Absolutely! You get lifetime access to the course, so you can learn at your convenience.
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy