Home

Waaradhi Academy - Data Analaytics - Self Paced Learning Program

Begin a 60-day learning journey designed for everyone, whether you're a beginner or an experienced learner. Picture it like a step-by-step journey where you learn manageable lessons each day, supported by easy-to-follow instructions and hands-on activities. Here's the exciting part – as you progress, we'll keep adding fresh topics, ensuring there's always something new to explore. It's like a growing library of knowledge just for you. Learn at your own pace and look forward to continuous updates.

Ready for an educational adventure that evolves with you? Click on a concept which routes us to content page. Happy Learning - All the best!!

Day MS SQL Server Power BI MSBI Advanced Excel
# Concept Exercise Evaluation Concept Exercise Evaluation Concept Exercise Evaluation Concept Exercise Evaluation
1 SQL Server Introduction and Installation-Part1

SQL Server Introduction and Installation-Part2 		Power BI Introduction & Installation
2 DB Creation and Metadata-Part1

Recap of DB creation and Metadata-Part2 		ETL With Power BI Part-1
3 DDL Statement

DML and DQL Statements

Insert Statements

DDL - ALTER Commands 		ETL With Power BI Part-2
4 Column Constraints

Data Types 		Power BI Components
5 Primary Key

Primary Key Index - Identity Property 		Power Query Editor Features
6 SELECT with WHERE Clause - Part1

SELECT with WHERE Clause - Part2

WHERE Clause with Character Datatype and Distinct Keyword

WHERE Clause with Date Datatype and Wildcard Characters 		Power Pivot Data Modelling & Relationship
7 DML - UPDATE and DELETE Statements

Computed Columns With Update Statement 		Power Pivot Data Modelling(1-1, 1-many, many-1 & many-many)
8 Group By Clause | Aggregate Functions

Group By Clause | Aggregate Functions1 		Power Query Datatypes & Filters
9 Group By with Multiple Columns

Group By Clause with Multiple Columns- Aggregate Functions
Group By with Having Clause 		Power Query Column Formatting
10 SQL Functions - Part1

SQL Functions - Part2 		Power Query Row Formatting
11 Power Query Joins(Inner & Outer)
12 Power Query Joins- Merge Queries
13 Power Query Append Queries
14 Power Query-Append Queries(Transpose, pivot & unpivot)
15 Power Query Dependencies Managing Parameters
16 Power Pivot Introduction
17 Power Pivot Cardinalities(1:1, 1:M, M:1 & M:M)
18 Power Pivot Cardinalities with Cross Filter Direction Import
19 Power Pivot DAX Introduction
20 Power Pivot DAX Operators
21 Power Pivot - DAX - Logical Operators
22 Power Pivot - DAX - Logical Functions
23 Power Pivot - DAX - Text Functions
24 Power Pivot - DAX - Nested Text Functions
25 Power Pivot - DAX - Date Functions
26 Power Pivot - DAX - Mathematical and Statistical Functions
27 Power Pivot - DAX - Summarize and Rankx Functions
28 Power Pivot - DAX - Time Intelligence Functions
29 Power Pivot - DAX - Time Intelligence Functions (Total, Previous and Next functions)
30 Power Pivot - DAX - Filter Functions (CALCULATE and RELATED)
31 Power Pivot - DAX - Filter Functions (ALL and USERELATIONSHIP)
32 Power View - Introduction
33 Power View - Filters and Components
34 Power View - Filter Types
35 Power View - Drill Down - Next Level - Expand All
36 Power View - Types of Visualizations
37 Power View - Categorical Visualizations (Pie, DoNut Charts and TreeMap)
38 Power View - Tree Map | Bar Chart | Column Chart | Grouping | Binning
39 Power View - Grouping and Binning
40 Power View - KPI Visuals (Water Fall Chart, Funnel Chart, Gauge and KPI Visuals)
41 Power View - Map Visualizations - Map and Filled Map
42 Power View - Trend Visuals - Line Chart and Ribbon Chart
43 Power View - Tool tip customization and Edit Interactions
44 Power BI Service - Introduction
45 Power BI Service - User Account Setup
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60