EXCEL POWER BI TOOLS
• An Overview of Power BI Tools.
• Introduction of Power query.
• Introduction of Power view.
• Introduction of Power pivot
• Introduction of Power map.
• Creating KPI
• Interview Tips.
• PDF File & Videos.
POWER QUERY
• Installing Power Query.
• Creating Power Query.
• Options of Loading Data.
• Creating Data Transforms.
• Editing Queries.
• Getting the initial data.
• Initial transforms to prepare the data.
• Splitting Columns, Merging Columns.
• Creating Custom Columns.
• Indexing Rows.
• Grouping and pivoting data
POWER PIVOT
Importing SQL Server tables
• Importing Access and Excel data
• Using Filter into rows/columns
• Using Data and diagram view
• Hiding from client view
• Create Relationships
• Creating Pivot Table from Power Pivot.
• Adding to data models.
• Using function in pivot table
• Creating hierarchies
POWER VIEW
Enabling Power View, and quick an overview.
• Creating Power View from Tables.
• Using Filter Slicer, Views and Tiles.
• Insert image and text boxes.
• Creating Charts.
• Formatting Charts.
• Using Different Types of Charts.
POWER MAP
Enabling Power Map, and quick an overview.
• Creating Power Map from Tables.
• Editing Power Map.
• Using Map Layout option.
• Using multiple Map

Course duration & fees.

Learn MS Access and VBA

1 Months (Sat to Sun – 2 Hours Class 9:00 AM to 8:00 PM) online classes.

 Fees: – 2500 INR/

 Class Videos, Notes, PDF Books

EXCEL POWER BI TOOLS