Why Power BI
Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator. Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modelling capabilities including data preparation, data discovery and interactive dashboards.
About Power BI Course
Microsoft Power BI Training introduces you to Power BI Desktop and how it is used with Power Pivot for Data Modelling. This course enables you to learn about Data Analysis Expressions (DAX) and Data Visualization with Power BI Desktop, Power View and Power Map. This course will also introduce you to Power BI Q&A, which enables you to discover, explore and visualize enterprise data using Natural Language.
Topics Covered in this Training
Introduction to visuals in Power BI
Charts in Power BI
Matrixes and tables
Gauges and Single Number Cards
Modifying colors in charts and visuals
Shapes, text boxes, and images
What Are Custom Visuals?
Page layout and formatting
Self Service Business Intelligence
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
Overview of Power BI Desktop
Data Sources in Power BI Desktop
Connecting to a data Sources
Query Editor in Power BI
Clean and Transform your data with Query Editor
Combining Data – Merging and Appending
Cleaning irregularly formatted data
Views in Power BI Desktop
Manage Data Relationship
Cross Filter Direction
Create calculated tables and measures
Optimizing Data Models
Essential concepts in DAX
Why is DAX important?
Data Types in DAX
Measures in DAX
DAX tables and filtering
DAX Parameter Naming
Introduction to using Excel data in Power BI
Exploring live connections to data with Power BI
Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
Introduction to Power BI Development API
Import Power View and Power Pivot to Power BI
Power BI Publisher for Excel
Introducing Power BI Mobile
All other topics...