Data Analyst Professional & Mastery Bundle
Data Analyst Professional & Mastery Bundle
From Beginner to Expert : Your Complete Data Analyst Guide
Data Analyst Professional & Data Analyst Mastery is a complete, end-to-end program that takes you from beginner to expert. It’s the perfect all-in-one course for becoming a high-performing data analyst.
What You Will Learn in Data Analyst Professional & Mastery Bundle Course
Data Analyst Professional :
Data Warehouse and Business Intelligence - 5 Modules
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
SQL Professional - 17 Modules
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
Power BI Desktop - 2 Modules
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
DAX - 16 Modules
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
Power BI Service - 7 Modules
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
Get Ready To Work From Day One - 3 Modules
Domain Training
Virtual Internship
Real Time Project
Preparation For Interviews - 3 Modules
ATS Friendly Resume
Leveraging LinkedIn
Cracking Interviews
Data Analyst Mastery :
Data Warehouse and Business Intelligence Mastery - 8 Modules
Module 1 : Types of Dimensions
- Dimension Table
- Surrogate Keys
- Hierarchy
- Conformed Dimensions
- Role Playing Dimensions
- Junk Dimensions
- Degenerate Dimensions
Module 2 : Types of Measures
- Fact Table
- Types of Facts/Measures
- Additive Facts
- Non Additive Facts
- Semi Additive Facts
Module 3 : Types of Fact Tables
- Transactional
- Periodic Snapshot
- History or Accumulating
- Factless Fact
Module 4 : Bridge Tables
- Many-To-Many Relationships
- M2M between Fact and Dimension
- M2M between Dimensions
Module 5 : Dimensional Schemas
- Star Schema
- Snow Flake Schema
- Fact Constellation
Module 6 : Slowly Changing Dimensions
- What is SCD
- SCD Types
Module 7 : ETL
- What is ETL?
- Full and Incremental Extraction
- Transformation Types
- Historical and Incremental Load
Module 8 : Business Intelligence
- BI Reports
- Drill Down Reports
- Drill Through Reports
- Bar/Column Charts
- Line Chart
- Combo Chart
- Gauges
- Scatter plot Chart
- Map Chart
- Pie Chart and Tree Maps
- Table and Matrix Charts
- Scorecard
- Dashboard
SQL Mastery - 9 Modules
Module 1 : Variables
- Local Variables
- Global Variables
Module 2 : Window Functions
- Using Order by clause
- Using Partition by clause
- Aggregate Functions
- Framing
Module 3 : Transactions
- Analytical Functions
- DCL Statement
- TCL Statement
Module 4 : Controlling Flow
- Conditional logic
- CASE Statement
- While Statement
Module 5 : Tables
- Common Table Expressions
- Temp Tables
- Derived Tables
- Recursive Queries
Module 6 : User Defined Functions
- Scalar Functions
- Inline Table Valued Functions
- Multi statement Table valued function
Module 7 : APPLY operator
- CROSS APPLY
- OUTER APPLY
Module 8 : Stored Procedures
- Creating Stored Procedures
- Working with Parameters
Module 9 : Querying Metadata
- Metadata Functions
- System Views
Advanced Power Query - 5 Modules
Consuming and Transforming Data :
Module 1 : Understanding Power Query/ M Query
Module 2 : Loading Target Data
Module 3 : Adding new columns
Module 4 : Query parameters
Module 5 : Privacy Levels
Advanced DAX - 4 Modules
Module 1 : Calculated Columns
- Circular dependency error
Module 2 : Calculated Tables
- Table Functions
- SET Functions
- JOIN Functions
- Table creation function
Module 3 : Measures
- Navigational Functions
- RankX and ConcatenateX functions
- ALLSELECTED function
- Time Intelligence Functions
- Hierarchy Functions
- Filtering Disconnected Tables
- Fixing Granularity Issue
- Quick Measures
- What-If Parameters
Module 4 : Visualizing Data
- KPI and Guage Visuals
- Custom Visuals
- AI Visuals
- Edit Interactions
- Categories that have no data
- Bookmarks
- Selection Pane
- Drill Through
- Tooltip
- Report Themes
- Creating templates
Power BI Service - 7 Modules
Scheduling Symantec Models :
Module 1 : Data Gateway
Module 2 : DSN Creation & Connecting to Symantec Model Data Sources
- High level flow
- Top ETL tools
- Top BI tools
- Top multidimensional databases
Module 3 : Scheduling Data Refresh
Module 4 : Alerts and Subscriptions
Module 5 : Sharing Reports, Dashboards and Workspaces
Module 6 : Dynamic Row Level Security
Get Ready To Work From Day One - 3 Modules
Domain Training
Virtual Internship
Real Time Project
Preparation For Interviews - 3 Modules
ATS Friendly Resume
Leveraging LinkedIn
Cracking Interviews
Qlik Sense
- Qlik Sense
Tableau
- Tableau
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
