Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: June 6th @8:00AM

Faculty: Mr. Srihari (7+ Yrs of Exp,..)

Duration : 45 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

POWER BI

1. POWER BI Introduction

2. Data Connections

3. Power Query (Module - 1)

1. Basic Transformations
2. Text Transformations
3. Date Transformations
4. Conditional Column, Custom Column, Group by
5. Merge Query
6. Append Query

4. Power Pivot (Module - 2)

1. Text DAX functions
2. Date DAX functions
3. Logical DAX Functions
4. Aggregate DAX functions
5. Filter DAX functions
6. Parent child and Relation functions
7. Table manipulation function
8. Time Intelligent functions

5. Data Modeling

1. One to One
2. One to Many
3. Many to One
4. Many to Many
5. Single Direction
6. Both Direction

6. Data Visualization (Module - 3)

1. Barcharts
2. Linecharts
3. Piechart
4. Donutchart
5. Treechart
6. Funnelchart
7. waterfallchart
8. Table
9. Matrix
10. Slicer
11. Custom visuals

7. Filters Part - 1

1. Visual Level Filter
2. Page Level Filter
3. Report Level Filter
4. Drillthroug Filter

8. Filters Part - 2

1. Number Filters
2. Text Filters
3. Date Fliter

1. Book Marks
2. Edit Interaction
3. Selection
4. Syncslicer

9. Power BI Service (Module - 4)

10. Introduction

1. Workspace
2. Dataset
3. Dataflow
4. Gateways

1. Rowlevel Security

2. Schedule refresh

SQL SERVER

1. SQL Server Introduction

2. Data Types and Operastors

3. Functions

4. Constraints

5. Joins

6. Clauses

7. Subqueries

8. Rank Function and Set Operators

9. Views

10. Procedures