Business Analyst
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.
₹4999.00 ₹9000.00 44% OFF
/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.
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.
Master Power BI
📌 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
📌 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
3 Subjects
THE001A - Power BI Essentials
94 Learning Materials
Introduction
Course Introduction
Introduction
Download Power BI
Installation
Navigating to User Interface
Course Data - Part 01
Data Extraction
Manual Entry Data
Load Excel File
Load CSV File
Load XML File
Load From PDF
Connecting to the Database
Connect Web Data
Connect WEB API
Data Transformation
Power Query Editor
Re-use the Data Model
Manage Parameters
Filtering Rows By Number Based Columns
Filtering Rows by Text Based Columns
Filtering Rows By Date Based Columns
Advanced Filtering with Logical Operations
Manage Queries
Manage Columns
Keep and Remove Rows
Handling Duplicates
Remove Blank Rows
Handling Error Values
Sorting Data
Split Column Values by Delimiter
Split Column By Other Features
Group By Count
Group By Sum
Group By Average
Group By Median
Group By Min and Max
Finding Duplicates Inside Group
Change Data Type
Manage Headers
Replace Values
Append Queries
Combine Files
Merge Queries
Merge - All Types
Transpose Rows to Columns
Reverse Rows
Count Rows
Rename Column
Fill Neighbour Values
Rearranging Columns
Convert to List
Text Formatting
Text Extraction
Statistics
Math Operations
Data Time Operations
Execute R Script
Execute Python Script
Add column from Example
Adding Custom Column
Adding Index Column
Adding column by Custom Function
Duplicating the Column
Adding Conditional Column
View Options
Query Dependency
Data Modeling
Training Institute Model
Model Relationship
Measures and Calculated Columns
DAX Table
Calculation Groups
Model Security
Q&A Setup
Data Visualization
Practice Data for Data Visualization
Bar and Column Charts
Line and Area Charts
Line and Stacked or Clustered Column Chart
Ribbon Chart
Waterfall Chart
Funnel Chart
Scatter Chart
Pie and Donut Chart
Treemap
Map and Filled Maps
Gauge Chart
Key Performance Indicator
Cards and Slicers
Table and Matrix
Visualization using Python Script
Visualization using R Script
Key Influencers
Decomposition Tree
Narrative
Prepare Report & Publish
Acknowledgement
Course Completion Certification Form
THE003 - Professional SQL Analyst
74 Learning Materials
Introduction to SQL
Download and Install PostgreSQL
Connect and Register SQL Server
Create a New Database
Course Data
Create Table and Columns
Data Retrieval and Querying
Retrieve Data
Source - Retrieve Data
Filter Data
Source - Filter Operations
Logical Operations on Filters
Source - Logical Operations
Wildcard Filters
Source - Wildcard Filters
Text Manipulation Functions
Source - Text Manipulation Functions
Numerical Operations
Source - Numerical Operations
Date Time Functions
Source - Date Time Functions
Aggregate, Group By and Having Clause
Source - Aggregate, Group By and Having Clause
Cartesian | Cross Joins
Source - Cartesian | Cross Joins
Inner Join
Source - Inner Join
LEFT Join
Query - LEFT Join
RIGHT Join
Query - RIGHT Join
Full Join | Full Outer Join
Query - Full Join
SELF Join
Source - SELF Join
Data Modification and Management
Create Table & Columns
Query - CREATE TABLE and COLUMNS
Insert Rows
Query - Insert Rows
READ Operation
Query - READ Operations
Update Values
Query - Update Values
DELETE Rows
Query - DELETE Rows
DELETE Columns
Query - DELETE Columns
Truncate and DROP Table
Query - Truncate and DROP Table
Advanced SQL Techniques
Sub Query
Query - Sub Query
Nested Query
Source - Nested Query
Common Table Expressions - CTE
Query - Common Table Expression
OVER - Window Function
Query - OVER
PARTITION BY - Window Function
Query - Partition By
Order By - Window Function
Query - Order By in Window Function
ROWS Frame - Window Function
Query - ROWS Frame
RANGE Frame - Window Function
Query - RANGE Frame
First Value - Window Function
Query - First Value
Last Value - Window Function
Query - Last Value
Nth Value - Window Function
Query - Nth Value
Ranking - Window Function
Query - Ranking
NTile - Window Function
Query - NTILE
Acknowledgement - Course Completion
Get Your Certificate
Advanced DAX Queries
298 Learning Materials
Introduction to DAX & DAX Studio
Pre-requisites
DAX Introduction
DAX Studio - Introduction
Course Data - AdventureWorks Sales - Microsoft
Connecting to Power BI Data Model
DAX Queries - Foundation
EVALUATE
Query - EVALUATE
ORDER BY
Query - ORDER BY
START AT
Query - START AT
ROW
Query - ROW
VAR - Introduction
Query - VAR Introduction
DEFINE VARIABLES
Query - DEFINE VARIABLES
DAX Operators
Arithmetic Operations
Query - Arithmetic Operators
Comparison Operators
Query - Comparison Operators
Text Concatenation Operator
Query - Text Concatenation Operator
Logical Operators
Query - Logical Operators
Table Manipulation Functions
Data for Table Manipulation
Distinct Function
Query - DISTINCT
Add Columns
Query - ADDCOLUMNS
Generate Series
Query - GENERATE SERIES
Creating Data Table
Query - DATATABLE
Cross Join or Cartesian Join
Query - CROSSJOIN
Generate - Combining Tables based on LEFT Table
Query - Generate
Generate All
Query - Generate All
Natural Inner Join
Query - Natural Inner Join
Natural Left Outer Join
Query - Natural Left Outer Join
Summarize
Query - Summarize
Rollup
Query - Rollup
Rollup Group
Query - Rollup Group
Summarize Columns
Query - Summarize Columns
Rollup Add Is SubTotal
Query - Rollup Add Is Subtotal
Add Missing Items
Query - Add Missing Items
Rollup Is SubTotal
Query - Rollup Is SubTotal
SET Operations - Except, Union & Intersect
Query - SET Operations - Except, Union & Intersect
Top N
Query - Top N
Aggregate Functions
Practice Data for Aggregate Functions
Count and CountX
Query - Count and CountX
CountA and CountAX
Query - CountA and CountAX
Counting Blank Values
Query - Counting Blank Values
Counting Rows
Query - Counting Rows
Counting Distinct Values
Query - Counting Distinct Values
Finding Minimum Values
Query - Finding Minimum Values
Finding Minimum Values with Expression
Query - Finding Minimum Values with Expression
Finding Maximum Values
Query - Finding Maximum Values
Sum Operations
Query - SUM Operations
Product Operations
Query - Product Operations
Average Function
Query - Average Function
Logical Function
Data For Logical Function
AND Operation
Query - AND Operation
OR Operation
Query - OR Operation
NOT Operation
Query - NOT Operation
IF Condition
Query - IF Condition
True and False
Query - True and False
IF.Eager Function
Query - IF.Eager Function
If Error
Query - If Error Function
COALESCE Function
Query - COALESCE Function
Switch with Exact Match
Query - Switch with Exact Match
Switch with Numerical Value Comparison
Query - Switch with Numerical Value Comparison
Information Function
Data For Information Functions
Analyze Column Statistics
Query - COLUMNSTATISTICS
Contains
Query - CONTAINS()
Contains ROW
Query - CONTAINSROW
Contains String
Query - CONTAINSSTRING() & CONTAINSSTRINGEXACT()
Filter and Slicer Simulation
Query - Filter and Slicer Simulation
Has One Filter
Query - HASONEFILTER
Has One Value
Query - HASONEVALUE
Check the Column has Applied Filters
Query - ISFILTERED
Check the Table Filtered by Other Tabular Column
Query - ISCROSSFILTERED
Text and Non-Text Values
Query - ISTEXT() and ISNONTEXT()
Number, Odd or Even
Query - ISNUMBER, ISODD, ISEVEN
Find Missing Values
Query - ISBLANK
Find Error Values
Query - ISERROR
Find out Logical Values
Query - ISLOGICAL
Find Empty Tables
Query - ISEMPTY
Find sub total rows
Query - ISSUBTOTAL
Find the scope of hierachy w.r.t rows
Query - ISINSCOPE
Math & Trig Functions
Data For Practice
Division and Modulus
Query - Divide and Modulus
Ceiling and Floor
Query - Ceiling and Floor
Rounding
Query - Rounding
Rounding Up and Down
Query - Rounding Up and Down
Truncate
Query - Truncate
Rounding to Even
Query - Rounding to Even
Power
Query - Power
Square Root
Query - SQRT
Exponential Growth
Query - Exponential Growth
Sign and Absolute Value
Query - Sign and Absolute Value
Factorial
Query - Factorial
GCD & LCM
Query - GCD & LCM
Logarithm
Query - Logarithm
Text Functions
Data For Practice - Text Functions
Concatenate and Combine Values
Query - Concatenate and Combine Values
ConcatenateX
Query - CONCATENATEX
Exact Comparison
Query - EXACT
Find and Search
Query - Find and Search
Fixed
Query - FIXED
Formatting Text
Query - FORMAT
VALUE
Query - VALUE
Left, Mid and Right Split
Query - LEFT, MID and RIGHT
Length of Text
Query - LENGTH
Trimming White Spaces on Prefix and Suffix
Query - TRIM
Replace and Substitute
Query - REPLACE and SUBSTITUTE
Upper and Lower Case Conversion
Query - UPPER and LOWER
Repeat Text
Query - REPT
Date & Time Functions
Practice Data for Date Time Functions
Date and Time
Query - DATE and TIME
Calendar
Query - Calendar
Calendar Auto
Query - Calendar Auto
Date Difference
Query - Date Difference
Date Value
Query - Date Value
Date Extraction
Query - Date Extraction
EDate and EOMonth
Query - EDate and EOMonth
Total Working Days
Query - NETWORKDAYS
Current Values
Query - Current Date and Time
Week Day
Query - Weekday
Time Intelligence Functions
Data For Practice - Time Intelligence
DateTable for Time Intelligence
Query - DateTable for Time Intelligence
Closing and Opening Balance of the Month
Query - Closing and Opening Balance of the Month
Closing and Opening Balance of the Quarter
Query - Closing and Opening Balance of Quarter
Closing and Opening Balance of the Year
Query - Closing and Opening Balance of the Year
Dates Between Two Given Dates
Query - Dates Between
Dates From a Given Date and A Period
Query - DATESINPERIOD
Shifting Dates Forward and Backward
Query - DATESADD
Start and End of Month
Query - Start and End of Month
Start and End of Quarter
Query - Start and End of the Quarter
Start and End of the Year
Query - Start and End of the Year
First and Last Date
Query - First and Last Date
Previous and Next
Query - Previous and Next
Same Period and Last Year
Query - Same Period Last Year
Parent & Child Functions
Practice Data
Path
Query - PATH
Path Length
Query - Path Length
Path Item and Path Reverse Item
Query - PATHITEM, PATHREVERSEITEM
Path Contains
Query - Path Contains
Relationship Functions
Data for Practice - Relationship Functions
Cross Filter
Query - Cross Filter
Cross Filter - OneWay Vs Both
Query - ONEWAY, BOTH
Related Column Values
Query - RELATED
Related Table Values
Query - RELATED TABLE
Use Relationship
Query - Use Relationship
Filter Functions
Data for Practice - Filter Functions
Calculate
Query - CALCULATE
Treat As
Query - TREATAS
Calculate Table
Query - CALCULATETABLE
All Values From the Column or Table
Query - ALL
All Values Ignoring Cross Filters
QUERY - ALLCROSSFILTERED
All Except
Query - ALLEXCEPT
All Selected
Query - ALLSELECTED
All but No Blank Rows
Query - ALLNOBLANKROWS
Earlier
Query - EARLIER / EARLIEST
Filter Rows
Query - FILTER
Keep and Remove Filters
Query - KEEPFILTERS, REMOVEFITLERS
Lookup Value
Query - LOOKUPVALUE
Window Functions
Data For Practice - Window Functions
Index
Query - INDEX | ORDERBY | PARTITIONBY
Offset
Query - OFFSET | ORDERBY | PARTITIONBY
Window
Query - WINDOW | ORDERBY | PARTITIONBY
Rank
Query - RANK
Acknowledgment Form
Acknowledgment Form
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
Real-Time Technical Support
Experience seamless technical support like never before with our dedicated Discord platform
Connect directly with trainer, fellow learners, and industry experts in real-time.
PLACEMENT TRAINING
Discover How IT WorkS
PORTFOLIO
We guide you through creating a strong portfolio by building real-world projects, enhancing your LinkedIn profile, and writing insightful blogs, enabling you to confidently showcase your data analysis and modeling skills to potential employers.
RESUME
We assist you in crafting a compelling Business Analyst-focused resume that highlights your technical expertise, relevant skills, and achievements, making you stand out to hiring managers in the business analyst field.
PARTNERED JOBS
We connect you with job opportunities through our industry partnerships, providing access to top companies seeking professionals skilled in Power BI & SQL, and help you get noticed in the competitive job market.
CODING ROUND
We help you prepare for SQL coding rounds by providing practice exercises and real-world SQL problems, ensuring you're ready to tackle any technical challenge with efficiency and accuracy.
TECHNICAL ROUND
We simulate technical face-to-face interviews, coaching you on how to demonstrate your Business Analyst knowledge, solve problems on the spot, and effectively communicate your skills to interviewers
HR ROUND
We prepare you for the final HR interview by coaching you on how to present yourself, discuss your career goals, and highlight how your SQL & Power BI expertise adds value to potential employers
/CourseBundles(54706)/3799380-Business_Analyst.png)
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?
Do I need prior experience?
Is this course available in English?
How can I get support if I have doubts?
Will I receive a certificate?
What tools will I learn in this course?
Can I access the course at my own pace?
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy