a

Power BI Training

Microsoft Power BI is a business intelligence software to analyze your data and extract business insights from it through building interactive dashboards. This Power BI Training course will enable you to get the most out of Power BI, helping you to resolve business problems and improve operations. 

This course will help you learn Power BI architecture, Desktop, Service, Mobile Apps, Visualizations, Reports, deriving business insights. Work on real-world projects.

5 Days

Understanding of How data works and what it can do for an organization.

Introduction

  • Introducing MS PowerBI
  • What is MS MS PowerBI
  • Exploring BI
  • Introducing MS PowerBI Products
  • MS PowerBI/MS Data Platform
  • What is MS PowerBI Service
  • What is the MS PowerBI Service Architecture
  • What is MS PowerBI Mobile
  • What is MS PowerBI Desktop
  • MS PowerBI Editions and Pricing
  • MS PowerBI for Buss Users
  • MS PowerBI: Data Analysts
  • MS PowerBI: Pros
  • MS PowerBI: Developers

The MS PowerBI Service

  • Introducing Self-service BI
  • What is Organizational BI
  • Signing Up for MS PowerBI
  • What is the MS PowerBI Portal
  • What is MS PowerBI Content Items
  • Data Sets – Reports – Dashboards
  • Connecting to Data – Content-Packs
  • Importing Local Files – Live Connections
  • Storing results of calculations – future use
  • Building data objects from the keyboard, clipboard, or external data files

Visualizing Data

  • What are Reports
  • Exploring MS PowerBI-Visualizations
  • Column/Bar/Line/Combo/TreeMap/Scatter/Shape/Table/
  • /Matrix/Map/Guage/Slicer/card
  • Custom-Visualizations
  • Exploring Reports
  • Get Quick-Insights
  • Excel-Reports
  • Create/Modify and Sharing – Dashboards
  • Exploring Natural-queries
  • Integrating with Cortana-Digital-Assistant

MS PowerBI Mobile

  • Introducing Native-Applications
  • Introducing the iOS/Android and windows-Applications
  • Viewing Content/Dashboards and Reports on mobile
  • Sharing/Collaboration

Data Modeling Fundamentals

  • What are Data Models
  • What is Schemas
  • Introducing Relationships
  • What is Data-Connectivity
  • What is MS PowerBI Desktop
  • What is Design-Environment
  • What is Navigation
  • Importing Data from Excel Files/Text Files/Data Feeds,
  • SSAS and Web
  • Importing From R

Transforming Data

  • What is the Query-Editor
  • What is Data-Preview
  • Shaping/Cleansing Data
  • Applying Transformations
  • Loading Transformed Data
  • Using Advanced Features
  • Combining Datasets
  • Using functions
  • Generating Date Tables
  • Master Calendar

Refining the Model

  • What are Tables and Columns
  • What is the Column-Data-Types
  • What is Column-Operations
  • Working with Tables/Columns
  • Managing Schema/Data Changes
  • Managing Data-Refresh
  • Relating Tables
  • Relationship Rules and Limitations
  • Auto-detecting Relation-ships
  • Creating Relation-ships Manually
  • Working with Relation-ships

Executing Calculations

  • What is Data-Analysis-Expressions
  • What is Calculated-Columns
  • What are Measures
  • What is DAX-Syntax
  • What are DAX Functions
  • Advanced DAX
  • Building Basic & Advanced Calculated-Columns
  • Executing Implicit and Explicit Measures
  • Executing Role-Playing Relationships
  • Executing Parent-Child Relationships
  • Executing Many-to-Many Relationships

Enabling Team BI

  • What are Workspaces/Groups
  • Working with Group/Workspaces
  • Packaging/Publishing Content
  • What is Organisational Content-Packs
  • What is the ContentPack Life-cycle
  • Centralizing Data Management
  • What is the Enterprise-Gateway

Organizational BI

  • Executing: Classic BI Solutions
  • What is MS BISM
  • What is Setup Requirements
  • Connection of Users: Analysis Services
  • Executing: Real-time BI Solutions

Advanced Analytics in MS PowerBI with R

  • IntegratingR: MS PowerBI
  • R Powered custom visuals in MS PowerBI
  • Control MS PowerBI visuals with R code
  • Use R scripts in Data Preparation
  • Machine learning / Predictive modeling in MS PowerBI
  • with R variables and script
  • Text Analytics