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

Batch Date: Oct 25th @6:00PM

Faculty: Real Time Expert

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
(Power BI Desktop, Power BI App Service, Power BI Gateways
& Power BI Mobile View)

Introduction:

Topics:

1. Introduction of Power BI and Power BI Products.
2. Installing Power BI desktop and sign-in to Power BI app service from Desktop

Power BI Desktop

Topics:

1. Detailed overview of Power BI Desktop panels (TOP, LEFT, RIGHT PANELS)
2. How to connect different database like excel, text, SQL server database etc.….

ETL (Extracting, Transforming, Loading)

• How to load and edit the files into Power BI
• Choose & Remove columns
• Keep & Remove rows
• Remove duplicates & Error rows
• Sorting (Ascending & Descending)
• Splitting column
• Group by
• Data type change
• First row as headers
• Replace values
• Merge
• Append
• Pivot & Un pivot, Queries

Analytics: (Data Modeling)

• Reports, Data and Relationships (Modeling)
• Detailed view of Fields
• Table properties & Relationships
• What are Measures?
• What are columns?
• What are Parameters?
• Bookmarks
• Sync Slicers
• Industry needs DAX Functions (Basics)
• Table Joints
• RLS (Row Level Security)

Reports

1. What is reports windows from Left side vertical panel and explore the options of reports window
i. Top ribbon with report options (New page, visuals, Text box, image, shapes and page view, etc )
ii. Right side panel (Fields options) → Rename, hide/Unhide, delete, Hierarchy and filters (Visualizations) → around 25+ styles with formatting options

2. Different report styles and apply formatting options
i. Table, Matrix, Card, Multi row card,
ii. Bar charts, Line charts
iii. Dual style charts (Line and bar)
iv. Pie charts, Donut charts, Tree maps and geographical maps (Globe and Filled Map)
v. Scatter plot, Funnel, Gauge, KPI and Slickers.

3. How to create drilldown and drill through charts?

4. How to publish the reports into Power BI App service?

Power BI App Service

Topics:

• Complete overview of App service
• What is Dashboard and how to create our own Dashboard?
• What is Report and Dataset?
• Types of gateways and what are those?
• Refresh the data from on-premises to Cloud App service

Power BI Gateways

Topics:

• How to connect gateways
• Scheduled refresh the data from on-premises to Cloud App service

Topics:

1. How to connect to Mobile and how to check reports