Power BI Training in London

BY
Mindmajix Technologies

Mode

Online

Fees

₹ 8000 10000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course and certificate fees

Fees information
₹ 8,000  ₹10,000
certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Getting started with Microsoft Power BI

  • Understanding the Power BI Tools
  • Installing Power BI & Connecting to Data
  • The "Locale" used in the curriculum
  • Working with the query Editor
  • Working with the data model and creating a visualization

Introduction to Power BI Desktop

  • Overview of workflow  in power bi desktop
  • Introduction to different views of the data model
  • Taking a closer look at the query editor interface
  • Required Poer BI Settings

An Introduction to Query Editor

  • What is a query Editor?
  • About the attached data
  • Connecting Power BI Desktop to the data
  • Editing Rows
  • Understanding Append Queries
  • Editing Columns
  • Replacing Values
  • Formatting Data
  • Pivoting & Unpivoting Columns
  • Splitting Columns
  • Creating a new Group for the queries
  • \Intro Star Schema
  • Duplicating & Referencing Queries
  • Entering Data Manually
  • Merging Queries
  • Creating an Index Column
  • Duplicating Column and extracting info
  • Creating Conditional Columns
  • Performing Basic Mathematical Operations
  • Improving Performance and Loading Data into Data Model
  • Module Summary

Data & Relationship View

  • Query Editor & the data model. Why are they different?
  • Intro to relationships
  • Editing relationships
  • Concepts are cardinality
  • Cross Filter selection & Many to many relationship
  • Active properties
  • M-Language & DAX. How are they different?
  • DAX | Measures | Calculated Values
  • DAX will include complex functions like Calculate, SUM, SUMX, RELATED, ALLEXCEPT, CONCATENATE, LOOKUPVALUE, IF, SEARCH, DATEADD, DIVIDE, and many more.
  • Categorizing Data

Working in the Report View to Visualize the Results

  • Report view interface
  • Creating visuals
  • Add tooltips and interactions/markings
  • Data color
  • Hierarchies & Drill-down
  • Formatting charts & Sorting
  • Introduction to slicers
  • Treemaps & Tables
  • Types of filters
  • Multi-row cards
  • Combined visuals & waterfalls

Power Bi Service & Power BI Mobile

  • Why Power Bi Service?
  • Comparison Power BI Free & Premium
  • Logging into Power Bi Service
  • Interface overview
  • Importing data from Desktop to Service
  • Dataset menu
  • Working on reports
  • Dashboard overview
  • Workspace & Gateways
  • Installing Gateways - Personal & On-premise
  • Working alone or collaborating with colleagues
  • Collaborating in App Workspace
  • Sharing the results
  • Publishing the app
  • Content packs from online services
  • Power Bi Mobile Overview
  • Excluding dataset from sharing

Other Data Source

  • JSON Data
  • Importing data from the rest of the APIs
  • Setting up a SQL Server
  • Importing data from SQL Server

PowerApp

  • Overview
  • Basic Power App Concept
  • Canvas Apps | Navigation | Customisation
  • Contents (Galleries, Data Cards, Forms, Triggers, Functions & Formulas, Edit Forms, Text Boxes)

Practice Test & Interview Questions

Instructors

Ms Meenakshi
BI Developer
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books