Ducat offers a Power BI Training. Power BI is a cloud-based 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 information technology staff or database administrators.Make informed decisions quickly. Connect, model, and then explore your data with visual reports that you can collaborate, publish, and share. Power BI integrates with other tools, including Microsoft Excel, so you can get up to speed quickly and work seamlessly with your existing solutions.

Power BI overview

  • Dataset
  • Reports
  • Dashboard
  • Workspace
  • Tiles
  • Q&A Question box

Power BI versus Excel Reporting

  • Diff
  • When we use which reports.

Cloud vs On-Prem Reporting

  • Cloud
  • On Premises
  • Compare

Introduction to the M language

  • Evaluation model
  • Operator
  • Type Conversion
  • Expression ,value and let expression

Power BI Desktop

  • Introduction
  • Download & install

Connect To data

  • Excel
  • csv
  • Sql server
  • Web
  • MS Access
  • Other

Shape & Combine data

  • Add Custom column
  • Add new column
  • Change Type
  • Replace Values
  • Split column
  • Group by
  • Un Pivot
  • Rename
  • Remove
  • Applied steps
  • Remove Error

Combine Data

  • Remove Top Row
  • Remove Bottom row
  • Remove Blank row
  • Merge Query
  • Append Query

Data View in Desktop

  • Data view Grid
  • Modelling Ribbon
  • Formula bar
  • Search
  • Fields List

Relationship

  • Relationship view
  • Add/ Edit relationship

Introduction to the DAX language

  • DAX
  • DAX Important
  • Syntax
  • Create
  • Context

DAX function

  • Date and Time Functions (DAX)
  • Time Intelligence Functions (DAX)
  • Filter Functions (DAX)
  • Information Functions (DAX)
  • Logical Functions (DAX)
  • Math and Trig Functions (DAX)
  • Other Functions (DAX)
  • Parent and Child Functions (DAX)
  • Statistical Functions (DAX)
  • Text Functions (DAX)

Categorization

  • Introduction

Building a Report

  • Report View
  • Report canvas
  • Visual configuration

Custom Visuals

  • Type
  • Download & Add Visual Gallery

Power Bi Web

  • Create Reports in Power BI Website
  • Get Data from Website
  • Building Dashboards
  • Sharing
  • Power Q&A
  • Power BI Mobile App
  • Scheduling

Power BI Gateway

  • On-premises date gateway
  • Personal
  • Analysis Services Connector (depreciated)

Embed Power BI

  • Publish on Web
  • REST API
  • Power BI Embedded

Power BI Q&A Natural Language

  • How it work
  • Visualization
  • Question sample
  • Advantage
COMMENCING NEW BATCHES
ENQUIRY FORM
FOLLOW US ON
SUBSCRIBE TO OUR NEWSLETTER

WE ACCEPT ONLINE PAYMENTS
PAY ONLINE