Success life Mantra

  • +91 452 4911 236
  • delight@successlifemantra.com
  • Anna Nagar, Madurai-20.
Facebook Instagram Youtube

Success Life Mantra

Menu

Data Analyst Professional

Data Analyst Professional

From Job Seeker to Data Analyst : Your Complete BI Journey

This course covers the fundamentals of Data Warehousing & BI, hands-on SQL for professionals, Power BI, and Excel tailored for data analysis. Ideal for beginners and aspiring analytics.

Become a Job Ready Data Analyst for Just ₹35000 ₹11,999/- (Inclusive of Tax)

🎉 1 + 1 OFFER !

👥 Special Offer: When you buy this course, your friend gets access too – completely free!

Less Than ₹6000 Per Person

Enroll Now

What You Will Learn in Data Analyst Professional Course

Module 1 : Decision Support Systems

  • OLTP Systems and Reports
  • Need for information
  • How to extract information?
  • What is Data Warehouse?

Module 2 : ETL and BI Tools

  • High level flow
  • Top ETL tools
  • Top BI tools
  • Top multidimensional databases

Module 3 : BI Solution

  • BI Solution Architecture
  • Data Profiling
  • Staging Database
  • Data Quality Check
  • Operational Data Store
  • ODS vs Data Warehouse
  • Data Mart
  • Meta Data Database

Module 4 : Creating EDW

  • Bill Inmon Approach
  • Ralph Kimball Approach

Module 5 : Dimensional Modeling

  • Normalized model
  • Dimensional Model
  • Normalized vs Dimensional Model
  • Facts and Measures
  • Dimensions

Module 1 : Introduction to RDBMS

  • What is Database?
  • How data is stored in RDBMS?
  • One-to-many Relationship
  • Many-to-many Relationship

Module 2 : Database Modeling

  • What is Entity-Relationship Diagram?
  • What is Normalization?
  • What is Functional Dependency?
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Module 3 : Microsoft SQL Server

  • Versions of SQL Server
  • Components of SQL Server
  • Editions of MS SQL Server
  • Installing MS SQL Server
  • Installing SSMS
  • SQL Server Management Studio

Module 4 : T-SQL

  • SQL Server Data Types
  • Types of Database Objects
  • Types of SQL commands

Module 5 : DDL commands

  • Creating and Removing databases
  • Creating and Removing tables
  • Altering Tables

Module 6 : DML Commands and simple SELECT

  • Inserting rows
  • Simple Select statement
  • Updating rows
  • Deleting rows

Module 7 : Creating constraints

  • Default constraint
  • Unique constraint
  • Check constraint
  • Primary Key constraint
  • Foreign Key constraint

Module 8 : SELECT Statement

  • Filtering Columns
  • Filtering Rows
  • Comparison Operators
  • Arithmetic Operators
  • Logical Operators
  • DISTINCT Clause
  • Working with NULLs
  • IN Operator
  • BETWEEN Operator
  • LIKE Operator

Module 9 : Grouping Rows

  • Aggregate Functions
  • GROUP BY Clause
  • HAVING Clause
  • ORDER BY Clause

Module 10 : Fetching Top Rows

  • TOP Clause
  • TOP Clause with TIES

Module 11 : Auto-generate Primary Key Values

  • Identity property
  • How TRUNCATE and DELETE differ?

Module 12 : DML with WHERE Clause

  • Create new table from existing table
  • Adding new columns
  • Updating specific rows
  • Deleting specific rows

Module 13 : Built-in Functions

  • Numeric Functions
  • Date Functions
  • String Functions
  • NULL Functions
  • Data Conversion Functions
  • '@@Functions

Module 14 : Joining Tables

  • Inner Join
  • Outer Join
  • Cross Join
  • Self Join

Module 15 : SET Operators

  • Union
  • Intersect
  • Except

Module 16 : Subqueries

  • Self-contained subquery
  • Correlated subquery
  • IN or EXISTS?

Module 17 : Views & Indexes

  • Working with Views
  • What is Index?
  • Clustered Index
  • Non Clustered Index

Module 1 : Consuming and Transforming Data

  • Connection Types and loading from different types of files
  • Create Global Sales db
  • Load data from Global Sales db and files
  • Convert Global Sales normalized model from database and files to dimensional model Retail Store DW (GlobalSalesDW)
  • Connection Types and loading from different types of files
  • Create Global Sales db
  • Load data from Global Sales db and files
  • Convert Global Sales normalized model from database and files to dimensional model Retail Store DW (GlobalSalesDW)
  • Data Types
  • Query steps and M Query
  • Removing columns - 2 fns
  • Modifying Steps
  • Splitting Queries
  • Query Folding
  • Commenting Steps
  • Renaming Queries
  • Merging Queries (Order and Order Detail)
  • Disable Query
  • Query Referencing and Copying
  • Grouping Queries
  • Adding New Columns (Except Invoke Function)
  • Cleansing Data
  • Creating Tables

Module 2 : Modeling Data

  • Navigating Power BI Desktop
  • Handling Columns
  • Creating Hierarchy

Module 1 : Understanding Relationships

  • Load Pubs data
  • Why Relationship is Needed
  • Managing Relationships
  • Create and Edit Relationships
  • Cross Filter Direction
  • Bidirectional Relationship

Module 2 : Types of Cardinality

  • 1:*
  • *:1
  • *:*
  • 1:1

Module 3 : Introduction to DAX

  • Syntax and Usage
  • Data Types
  • String Functions
  • BLANK VALUES
  • DAX Operators
  • Numeric Functions
  • Date and Time Functions
  • Format

Module 4 : Navigational Functions

  • RELATED
  • RELATEDTABLE

Module 5 : Table Functions

  • Filter
  • ALL
  • ALLNOBLANKROW
  • ALLEXCEPT
  • CalculateTable
  • VALUES
  • DISTINCT

Module 6 : Using Variables

  • Table Variables
  • SCOPE of Variables

Module 7 : IF and SWITCH Statements

Module 8 : Implicit and Explicit measures

  • Resolving Total Issue and Formatting Measures
  • Difference Between Columns and Measures

Module 9 : Aggregate Functions

  • Aggregate and Iterator functions
  • COUNT functions

Module 10 : Evaluation Contexts

  • Row Context
  • Filter Context

Module 11 : CALCULATE function

  • Removing Already Applied Filters
  • Including Additional Filters
  • Change Existing Filters

Module 12 : Time Intelligence Functions

  • YTD, QTD and MTD Functions
  • DATEADD and PARALLELPERIOD
  • SAMEPERIODLASTYEAR
  • PREVIOUSMONTH
  • NEXTDAY
  • SELECTEDVALUE

Module 13 : Relationship Functions

  • USERELATIONSHIP
  • CROSSFILTER

Module 14 : Calculated Columns

  • USERELATIONSHIP
  • CROSSFILTER

Module 15 : Measures

Module 16 : Visualizing Data

  • Page Layout and Formatting
  • Card visual
  • All the default visuals
  • Grouping and Binning
  • Custom Visuals
  • AI Visuals

Module 1 : Report Life Cycle

Module 2 : Workspace

  • High level flow
  • Top ETL tools
  • Top BI tools
  • Top multidimensional databases

Module 3 : Licenses

Module 4 : Report and Symantec Models

Module 5 : Creating Dashboard, using Q&A

Module 6 : Publish Power BI Apps

Module 7 : Row Level Security

Domain Training

Virtual Internship

Real Time Project

ATS Friendly Resume

Leveraging LinkedIn

Cracking Interviews

Become a Job Ready Data Analyst for Just ₹35000 ₹11,999/- (Inclusive of Tax)

What You Will Learn in Data Warehouse & Business Intelligence Course

Saepe quo labore aenean dictumst expedita commodi auctor, nisl, lorem iusto feugiat nemo reiciendis laboris.

Decision Support Systems

ETL and BI Tools

BI Solution

Creating EDW

Dimensional Modeling

Types of Dimensions

Types of Measures

Types of Fact Tables

Bridge Tables

Dimensional Schemas

Slowly Changing Dimensions

Business Intelligence

Course Mentor

Founder, Success Life Mantra

Enabled 1000s of job seekers to get their first job

Consulting, Managing, Architecting, Development and S&M Projects

Head of Business Intelligence Academy & Head of MSBI COE in Top IT MNCs

Hello, I am Janarthanan, the founder at Success Life Mantra. I help Fresh graduates, Job seekers and college students to become job ready freshers to get them job in their dream company with best pay in the industry.

For around 30 years, teaching is my passion, sometimes it was my profession and most of the times I did it purely for my own satisfaction.

As an IT professional, I worked on and gave training on various technologies like Oracle, Power Builder, Sybase SQL Anywhere, MS SQL Server, SSIS, SSRS, SSAS, QlikView and Power BI. As a Business Intelligence architect, I gave training to become data analyst for most of my students.

And I have performed various roles like developer, team leader, project manager, architect, vice president and various leadership roles in top IT MNCs. I look forward to sharing my knowledge & experience with you.

Testimonials

Hear from Our Successful Students

Saepe quo labore aenean dictumst expedita commodi auctor, nisl, lorem iusto feugiat nemo reiciendis laboris.

“ I have enrolled for the data analyst course here and it is the best institute for this course. The trainer, Janarthanan is an expert who has used the algorithms he teaches in real-world projects so you can be sure to learn the right way of doing this.”

Bala Murugan

STUDENT

“I am highly satisfied after learning my Data Analytics Couse in Success Life Mantra. Topics are covered step by step Especially the trainer is good & friendly and we can ask any doubts at any point of time. Thanks to Sucess Life Mantra that I have got an offer letter for a Data Analyst role.”

Aparna

STUDENT

“The Power BI Training gave me the confidence to apply for data analyst roles. The hands-on projects made all the difference!”

Santhosh Kumar

STUDENT

1
2
3 (2)
4
5
Become a Job Ready Data Analyst for Just ₹35000 ₹11,999/- (Inclusive of Tax)

SPIN TO WIN!

  • Try your lucky to get discount coupon
  • 1 spin per email
  • No cheating
Try Your Luck