Data Analyst Mastery
Data Analyst Mastery
Get a High-Paying Data Analyst Job with Data Analyst Mastery
Data Analyst Mastery is an advanced-level course designed for those who want to take their data analysis skills to the next level. Perfect for learners aiming for senior roles or specialized data careers.
What You Will Learn in Data Analyst Mastery Course
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
