Best Power BI training in Chennai
MODULE 1: INTRODUCTION TO POWER BI
• Business Intelligence
• Self Service Business Intelligence (SSBI)
• SSBI Tools
• Power BI vs Tableau vs QlikView
• What is Power BI
• Why Power BI?
• Key Benefits of Power BI
• Flow of Power BI
• Components of Power BI
• Architecture of Power BI
• Building Blocks of Power BI
MODULE 2: POWER BI DESKTOP
• Overview of Power BI Desktop
• Data Sources in Power BI Desktop
• Connecting to a data Sources
• Query Editor in Power BI
• Query Ribbon
• Clean and transform your data with Query Editor
• Combining Data – Merging and Appending
• Cleaning irregularly formatted data
• Views in Power BI Desktop
• Modelling Data
• Manage Data Relationship
• Automatic Relationship Updates
• Template Appstc.com 936 145 3182 Level Up STC
• Cross Filter Direction
• Create calculated tables and measures
• Optimizing Data Models
• PBIDS Files
MODULE 3: DATA VISUALIZATION
• Introduction to visuals in Power BI
• Charts in Power BI
• Matrixes and tables
• Slicers
• Map Visualizations
• Gauges and Single Number Cards
• Create scatter, waterfall, and funnel charts
• Modifying colours in charts and visuals
• Shapes, text boxes, and images
• What Are Custom Visuals?
• Page layout and formatting
• KPI Visuals
• Z-Order
• Explore time-based data
• AppSource
MODULE 4: DATA ANALYSIS EXPRESSIONS (DAX)
• Essential concepts in DAX
• Why is DAX important?
• DAX Syntax
• Data Types in DAX
• Ranking and rank over groups
• Filter and evaluation context
• Context interactions
• Calculation Types
• DAX Functions
• Measures in DAX
• DAX Operators
• DAX tables and filtering
• DAX queries
• Create simple and compound measures
• Schema relations
• Star schema design
• DAX Parameter Naming
MODULE 5: QUERYING DATA
• Opening the Query Editor
• Adding Conditional
• Columns Relationships
• Viewing Data Relationships
• Creating Relationships
• The Query Editor Applying Queries
• Naming Applied
• Changes Undoing
• Applied Steps
• Sorting Rows
• Adding an Index Column
• Filtering Rows
MODULE 6: SLICERS
• Adding and Using Slicers
• Formatting Slicers
• Searching Slicers
• Cascading Slicers
• Horizontal Slicers
MODULE 7: POWER BI ONLINE SERVICES
• Introduction to Power BI Online Services
• Sharing and Collaborating in Power BI
• Creating Dashboards in Power BI Online
• Power BI Online Data Refresh and Scheduling