Power BI Certification Training Course

Get certified and job-ready with IIHT Surat’s Power BI certification training course in Surat. Our course covers all aspects of Power BI, from data modeling and report creation to DAX and advanced visualization techniques.

Power BI is a business intelligence tool and is meant for analyzing and visualizing raw data which in turn is used to present actionable information. By combining business analytics, data visualization, and best practices, the Power Bi course helps organizations make data-driven decisions.

Power BI builds interactive dashboards and business intelligence reports by converting data from different sources. The different sources can be graphs, maps, charts and the list goes on. Power BI is widely popular because of its interactive features and exceptional Excel integration.

Curriculum:

• Module 1 Excel
• Sorting a Table filtering a Table
• Filtering a Range
• Filtering data for selected view (AutoFilter)
• Using advanced filter options
• Sort by color Sorting in a Pivot Table
• Filtering in a Pivot Table
• Filtering Using the Report Filter Area
• Summarizing Data with subtotals
• Pivot Tables
• Using advanced options of Pivot tables
• Consolidating data from multiple sheets and files
• Import and export data in Excel
• Creating a Data Table
• Introduction to Scenario Manager
• Using Goal Seek / Solver
• Creating Dashboard in Excel
• Module 2 Introduction
• Downloads
• Install POWERBI DESKTOP
• Connect to POWERBI DESKTOP
• Module 3 Source Connections
• GET data from SQLSERVER
• Get data from MySQL
• Get data from Excel AND multiple Excel sheets
• Get data from Text files / JSON or CSV Files
• koad data from multiple data sources
• Module 4 Working with Trans1ormations
• Change datatype
• Combine multiple tables
• Enter data
• Format dates
• Joins
• Pivot table
• Reorder and remove columns
• Rename columns
• Rename tables
• Split columns
• Unpivot table
• Module 5 Working with VisualiEations
• Area chart
• Bar chart
• Card
• Column chart
• Pie chart
• kine chart
• Table
• Matrix
• Scatter chart
• Map
• Format charts (All types)
• Custom Widget
• Module 6 POWER BI Filters
• Slicer
• Basic filters
• Advanced filters
• Top N filters
• Filters on Measures
• Module 7 POWER BI Calculated Fields
• Calculated Columns
• Calculated Measures
• Calculated Tables
• Conditional Columns
• Module 8 Dashboards
• Register to Pro Service
• Dashboard Introduction
• Connect Desktop with BI Service or Pro
• Publish Desktop Reports
• Create Workspace
• Create Dashboard (Power BI)
• Create Dashboard in Tableau (Introduction)
• and more.