OVERVIEW
Microsoft Power BI is one of the world’s most popular business intelligence and data analytics platforms. Power BI is a cloud-based application that is supplied via the Azure Cloud. On-premises capabilities are also available for individual users or when power users create complicated data mashups with in-house data sources. Power BI is unusual in that it allows users to accomplish data preparation, data discovery, and dashboard creation all in the same design tool.
Benefits of Power BI Training Course in Vellore
Immersive Learning: Our certified trainers provide hands-on classroom training. They will help you learn, practice, analyze, and gain insights into your learning while acquiring instantly practical data analysis abilities.
Practical Experimentation: We will provide you course handbook with step-by-step instructions; with guided hands-on activities, you will gain confidence and become more productive from the start.
Regular Assessments and Revisions: We know that every learner has a unique learning experience, we will give you proper guidance on diagnostic evaluations, module-end exams, and a final assessment at the end of the program are all part of the curriculum.
Power BI Training Course Syllabus
Introduction to Power BI
- What is Power BI?
- Why Power BI?
- Benefits of Power BI
- Building Blocks of Power BI
- Fundamental Concepts of Power BI
Power BI Desktop
- Software Installation Procedures and Guidelines
- Overview of Software
- Power BI Sign UP
- Introduction to Tools and Terminologies
- Refreshing Power BI Service Data
- What is a Dashboard?
- What is a Report?
- How to share Dashboard and Report?
Data Source Connection and Data Transforming
- Connecting to a Data Source
- Upload a local CSV File
- Connect to Excel Data
- What is a Query Editor?
- Import Data vs Direct Query
- Data Cleaning and Data Transformation
- Merging and Appending
Modelling using Power BI
- Modelling of Data
- Manage Data Relationship
- Cardinality, Cross Filtering
- Default Summarization and Sort By
- Creating Calculated Columns
- Creating Quick Measures and Measures
Analyzing Data with DAX Calculations in Power BI
- What is DAX?
- Why is DAX Important?
- DAX Syntax
- Data Types in DAX
- Functions in DAX
- Measures in DAX
- Operators in DAX
- Tables and Filtering in DAX
- Queries in DAX
- Parameter Naming in DAX
Data Visualization
- Creating Visualizations
- Colour Formatting
- Sort Order
- Scatter plot and Bubble Charts
- Tooltips
- Slicers
- Cross Filtering, Highlighting
- Report Level Filters
- Conditional Formatting, Tables, and Matrices
- KPI’s
- Cards and Gauges
- Map Visualizations
- Custom Visuals
- Grouping and Binning
- Selection Pane, Bookmarks & Buttons
- Z-Order
Reports and Dashboards
- Modify and Print a Report
- Add a filter to a page or report
- Set visualization interactions
- Print a report page
- Send a report to PowerPoint
- Create a Dashboard
- Create and manage dashboards
- Pin a report tile to a dashboard
- Pin a live report page to a dashboard
- Pin a tile from another dashboard
- Manage pinned elements in Excel
- Build a dashboard with Quick Insights
- Enable Cortana for Power BI
Publishing and Sharing Reports
- Introduction to Sharing Options
- How to Publish Report From Power BI Desktop?
- How to Publish Report to Web?
- How to Share Dashboards Using Power BI Service?
- What is Content Pack?
- How to Save as PDF?
- What is Row Level Security?
- How to Export Data from Visualization?