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

Batch Date: Mar 1st @ 7:00PM

Faculty: Mr. Suresh Vadde

Duration : 30 Days

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

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

Syllabus:

POWER BI

Introduction:

1. Downloads
2. Install POWERBI DESKTOP
3. Connect to POWERBI DESKTOP

Source Connections:

1. GET data from SQLSERVER
2. Get data from SSAS
3. Get data from Excel AND multiple Excel sheets
4. Get data from Text files
5. Load data from multiple data sources

Working with Transformations:

1. Change datatype
2. Combine multiple tables
3. Enter data
4. Format dates
5. Joins
6. Pivot table
7. Reorder and remove columns
8. Rename columns
9. Rename tables
10. Split columns
11. Unpivot table

Working with Visualizations:

1. Area chart
2. Bar chart
3. Card
4. Column chart
5. Donut chart
6. Pie chart
7. Line chart
8. Table
9. Matrix
10. Ribbon chart
11. Scatter chart
12. Map
13. Tree ma
14. Waterfall chart
15. Format charts (All types)

POWER BI Filters:

1. Slicer
2. Basic filters
3. Advanced filters
4. Top N filters
5. Filters on Measures
6. Page level, Report level filters
7. Drill through filters

POWER BI Calculated Fields:

1. Calculated Columns
2. Calculated Measures
3. Calculated Tables
4. Conditional Columns
5. Custom Columns

Dashboards:

1. Register to Pro Service
2. Dashboard Introduction
3. Connect Desktop with BI Service or Pro
4. Publish Desktop Reports
5. Create Workspace
6. Create Dashboard

Working with Dashboards:

1. Dashboard Functionalities
2. Dashboard Settings
3. Pin report to Dashboard
4. Delete a Dashboard

Sharing Work:

1. Share a Dashboard
2. Share a Report
3. Share Workspace
4. Publish App

Subscriptions:

1. Subscriber Dashboard
2. Subscribe Report

DAX:

1. Aggregate functions
2. Date functions
3. Logical functions
4. Math functions
5. String functions
6. Trigonometric functions

Practice Scenarios:

1. Drill-up and Drill-down Reports
2. Sort chart in ascending and descending order
3. Show empty record in Reports

Interview Questions:

1. FAQ’S

PRE-REQUISITES:

1. SQLSERVER KNOWLEDGE
2. SSRS KNOWLEDGE