Microsoft Power BI Training

BY
Edureka

Become an expert in business analytics and learn about Data Visualization and Data Analysis Expressions (DAX) with Power BI Desktop.

Mode

Online

Duration

21 Days

Fees

₹ 16199 17999

Important Dates

23 Nov, 2024

Course Commencement Date

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

Course overview

The Microsoft Power BI Training course is an introductory course in Power BI Desktop and how to use it with Power Pivot for Data Modelling. The course will introduce you to Power BI Q&A, as well as Data Visualisation and Data Analysis Expressions (DAX), with Power BI Desktop to explore, discover and visualise enterprise data with the employment of Natural Language.

The Microsoft Power BI Training Programme also covers topics such as Business Intelligence, Flow of Power BI, Matrixes and Tables, Power BI Q&A, Row-level Security, and many more. Upon completion of the training, you will become proficient in concepts like Data integration and visualization, exploring Power BI Q&A, using content packs, data gateways, and Power BI Report Server.  

Moreover, as a part of the course, you will receive 27 hours of live online instructor-led classes and 3 hours long 9 sessions of weekend classes. Furthermore, you will have lifetime access to all the online resources, 24x7 expert support. Upon completion of the course, you receive a "Business Analyst using Power BI" certification from Edureka.

The highlights

  • 21 days (weekdays) course
  • 7.5 weeks (weekend) course
  • Live instructor-led online sessions
  • Lifetime Access to the LMS
  • Case studies based
  • Round-the-clock expert technical support
  • Regular practical assignments
  • “Business Analyst using Power BI” certification from Edureka 

Program offerings

  • Certification from edureka
  • Instructor-led sessions
  • Lifetime access to lms
  • Regular assignments
  • 24x7 expert technical support
  • Real-life case studies

Course and certificate fees

Fees information
₹ 16,199  ₹17,999

The Microsoft Power BI Training programme fee has two ways of payment: 

lump sum and EMI. However, anyone who wishes to enrol for this programme can avail of a discount on the course fee, available for a limited period. 

HeadAmount
Original priceRs. 17,999
Discounted priceRs. 16,199

*EMI starts at Rs. 5,400 / month

certificate availability

Yes

certificate providing authority

Edureka

Who it is for

The Microsoft Power BI Training course by Edureka is ideal for professionals who are interested in data analytics, data visualization, and business intelligence. The course is best suited for:

  • Project Managers
  • Statisticians and Analysts
  • Business Analysts
  • Business Intelligence Managers
  • Data Scientists

Eligibility criteria

Prerequisites

There are no prerequisites for the Microsoft Power BI Training course by Edureka. However,  experience with Microsoft Excel and Python will be helpful for a smooth learning experience.

Certificate Qualifying Details

To get a certificate of completion, students have to complete a project. The project will test whether you can apply the concepts acquired during the programme.  Mail the project within 15 days of course completion for the evaluation process. Experts from Edureka will evaluate the project, give you a grade and award the certificate for the course. 

What you will learn

Data science knowledge R programming Knowledge of data visualization

After successful completion of the Microsoft Power BI Training course, you will get knowable to:

  • Learn about power view, power pivot, Power Map
  • Understand and employ content packs, Data Gateways, and Power BI Report Server
  • Employ and enforce custom visuals
  • Carry out Data binding and formatting
  • Probe Power Bi Q&A
  • Gain expertise in concepts like Data visualization and integration
  • Understand SSBI and DAX
  • Master Workspace collection and Power BI embedded

The syllabus

Introduction to Power BI

Topics
  • Introduction to Business Intelligence
  • Self-Service Business Intelligence (SSBI)
  • Introduction to Power BI
  • Traditional BI vs. Power BI
  • Power BI vs. Tableau vs. QlikView
  • Uses of Power BI
  • The Flow of Work in Power BI
  • Working with Power BI
  • Basic Components of Power BI
  • Comparison of Power BI Version
  • Introduction to Building Blocks of Power BI
  • Data model and importance of Data Modeling
Hands-on
  • Installation of Power BI

Power BI Desktop and Data Transformation

Topics
  • Data Sources in Power BI Desktop
  • Loading Data in Power BI Desktop
  • Views in Power BI Desktop
  • Query Editor In Power BI
  • Transform, Clean, Shape, and Model Data
  • Manage Data Relationship
  • Editing a Relationship
  • Cross Filter Direction
  • Saving Workfile
  • Measures
Hands-on
  • Data Cleaning using Power BI query editor
  • Creating Measures
  • Transform, Clean, Shape, and Model Data for further analysis

Data Analysis Expression (DAX)

Topics
  • Introduction to DAX
  • Importance of DAX
  • Data Types in DAX
  • DAX Calculation Types
  • Steps to Create Calculated Columns
  • Measures in DAX
  • DAX Syntax
  • DAX Functions
  • DAX Operators
  • DAX Tables and Filtering
Hands-on
  • Creating Calculated Columns and Measures
  • Performing Data Analysis using DAX

Data Visualization

Topics
  • Introduction to Visuals In Power BI
  • Visualization Charts in Power BI
  • Matrixes and Tables
  • Slicers and Map Visualizations
  • Gauges and Single Number Cards
  • Modifying Colors in Charts And Visuals
  • Shapes, Text Boxes, and Images
  • Custom Visuals
  • Page Layout and Formatting
  • Bookmarks and Selection Pane
  • KPI Visuals
  • Z-order
  • Grouping and Bining
Hands-on
  • Creating different visuals
  • Creating cards, measures, KPI, reference line, and slicers

Power BI Service

Topics
  • Introduction to Power BI Service
  • Creating a Dashboard
  • Quick Insights in Power BI
  • Configuring a Dashboard
  • Power BI Q&A
  • Ask Questions about your Data
  • Power BI Embedded
  • Bookmarks and buttons
Hands-on
  • Creating reports and dashboard
  • Publishing reports on Power BI Service
  • Using Power BI Service for operations on reports

Connectivity Modes

  • Data Sources Supported in Power BI
  • Exploring Live Connections to Data Sources
  • Connecting Directly to SQL Azure
  • Connecting Directly to SQL Server Analysis Services/My SQL
  • Import Power View and Power Pivot
  • Data Gateways
  • Direct Query vs. Import Connectivity modes
  • Connecting Power BI in Excel
Hands-on
  • Setting Up On-Premise Data Gateway
  • Connecting Power BI with SQL Server Database
  • Connecting Reports on Power BI Service with Local Data Files

Power BI Report Server

  • What is Power BI Report Server?
  • Key Features of Report Server
  • The architecture of the Report Server
  • Limitations of Report Server
  • Power BI Report Server vs. Power BI Service
  • Acquiring and Installing Power BI Report Server
  • What is a Web Portal?
  • Paginated Reports
  • Row Level Security
Hands-on
  • Setting Up Power BI Report Server
  • Using Power BI Report Server for Publishing Reports
  • Implementing Row Level Security

R & Python in Power BI

  • Brief concepts about R
  • R Programming Concepts
  • Create R Scripts for BI
  • Python Programming
  • Python Scripts in BI
  • Python integration with Power BI
Hands-on
  • Demonstrate connecting R and Python in Power BI
  • Using R and Python for data analysis

Advanced Analytics in Power BI

  • Use Parameters
  • Create a data flow
  • Introduction to Anomaly Detection
  • Introduction to Smart Narrative
  • Introduction to Sensitivity labels in Power BI
  • Deployment Pipeline
Hands-on
  • Connecting with Power BI service
  • Creating dataflow
  • Creating scorecard

In-Class Project

  • Power BI Service
  • Row Level Security
  • Visuals and Charts
  • Power BI Desktop
  • Handling Workspaces
Hands-on
  • Analyze store data
  • Draw conclusions from visuals created

Admission details

Candidates who want to enrol in the Microsoft Power BI Training programme should follow these steps:

  • Visit https://www.edureka.co/
  • Look for the “Microsoft Power BI Certification Training Course” webpage on the website.
  • Click on the “Enrol Now” button, which is on the bottom right. Fill your email and phone number.
  • Select any batch as per convenience. You can also skip batch selection or opt for a weekend batch. 
  • Once you have selected the batch, pay the requisite applicable fee.

Filling the form

Candidates interested in the Microsoft Power BI Training course by Edureka must provide their name and phone number. Choose a batch as per your preference after which you can make the payment. Submit the application form successfully.

How it helps

The Microsoft Power Bi Training course by Edureka will help you gain expertise in Power BI and carry out data analytics successfully. In the course, you will learn about Data Visualization and Data Analysis Expressions (DAX) with Power Map, Power View and Power BI Desktop. Moreover, the course will teach you to use Power BI with Power Pivot for effective Data Modelling.

Now, Microsoft is recognised as a pioneer in the Gartner Magic Quadrant for Business Intelligence Platforms and Analytics for 12 consecutive years. Therefore, as a certified Business Analyst using Power BI, you can find opportunities in companies like Dell, KPMG, Wipro, Hitachi, and many more. Best of all, you can expect a salary of up to 114,000 USD per annum. 

FAQs

What are the prerequisites for joining the Microsoft Power BI Training Course?

While there are no mandatory prerequisites to apply for the Microsoft Power BI Training Programme, experience with Microsoft Excel and Python will be helpful.

What are the benefits of enrolling into this course?

Microsoft is recognised as a pioneer in the Gartner Magic Quadrant for Business Intelligence Platforms and Analytics for 12 consecutive years. Therefore, a certified Business     Analyst using Power BI can find work opportunities in companies such as Dell, KPMG, Wipro, Hitachi, and more. You can expect a salary up to $114,000 per annum. 

Who can enrol in the training course?

The Microsoft Power BI Training by Edureka is ideal for professionals who are interested in data analytics, data visualization and business intelligence. It is best suited for Project Managers, Statisticians and Analysts, Business Analysts, Business Intelligence Managers, Data Scientists.

What is the admission process?

Candidates interested in the Microsoft Power BI Training course need to fill the contact details, choose a batch, make the fee payment and submit the application form.

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