Course Introduction

The purpose of this training course to share knowledge on Microsoft SQL Server Business Intelligence concepts. In this video tutorial three components of Microsoft Business Intelligence (MSBI) are discussed which are SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Quick Start Power BI Service:

  • Get Power BI Tools
  • Introduction to Tools and Terminology
  • Dashboard in Minutes
  • Refreshing Power BI Service Data
  • Interacting with your Dashboards
  • Sharing Dashboards and Reports
  • Recap and What's Next

Getting and Transforming Data with Power BI Desktop:

  • Introduction to Power BI Desktop
  • Getting Data: Excel vs Power BI Desktop & Service
  • Data Structure for Q&A
  • DirectQuery vs Import Data
  • Recap and What's Next

 Modeling with Power BI:

  • Introduction to Modeling
  • Setup and Manage Relationships
  • Cardinality and Cross Filtering
  • Default Summarization & Sort by
  • Creating Calculated Columns
  • Creating Measures
  • Recap and What's Next0


Power BI Service Visualisation Tools:
  • Introduction
  • Standalone Tiles
  • Data Driven Alerts
  • Quick and Related Insights
  • Custom Q&A questions

Refreshing Datasets:

  • Understanding Data Refresh
  • Personal Gateway (Power BI Pro and 64-bit Windows)
  • Replacing a Dataset
  • Troubleshooting Refreshing2

Power BI and Excel Together:

  • Options for Publishing from Excel
  • Pin Excel Elements to Power BI
  • Connect to Data using Power BI Publisher/Analyze in Excel
  • Excel 2016 Publish: Upload and Export to Power BI
  • Sharing Published Excel Dashboards

Leave A Message

There are no any courses offered by this institute...!