Leotrainings > BUSINESS INTELLIGENCE > Power BI > Power BI Training

Power BI Training

Power BI certification course lets you master the Power BI tool. We provide the best online training to help you learn Power BI Desktop, visualizations,
architecture, Service, reports, deriving business insights, Mobile Apps,. You will work on multiple real-life projects and assignments during this Power BI training online course.

Teacher
leo trainings
1,983 students enrolled

What you’ll learn in This Course?

  • Understand Data Extraction
  • Power BI Service Q & A and Data Insights
  • Embedded Power BI with API & Power BI Mobile
  • Understand Advance and Power BI Premium
  • Use Salesforce Data, Azure SQL Database, and SQL Server analysis tabular data
  • Deploy content packs to work with QuickBooks online and Adobe Analytics
  • Work on live projects to get hands-on experience.
  • An in-depth understanding of this BI tool and how it works in different scenarios
  • Three vital components: Power BI Service, Desktop and Mobile Apps
  • Visualize and analyze data and derive insights from Excel spreadsheets or local databases
  • Create compelling reports and visualizations, derive real-time insights, and deploy them on demand
  • Create, share, collaborate, and benefit from business information with purpose-built dashboards
  • Get the work done without being a Business Intelligence professional

Description:

About  Workday Power BI?

Power BI is a radically new tool in the hands of business enterprises who are overwhelmed with the amount of data at hand and until now did not have a cost-effective tool to extract insights from it. Upon the completion of this Power BI online course, as a trained professional, you can start using this BI tool, which is a set of tools and applications that let you extract data from multiple unrelated sources and convert it into a neatly managed and coherent set of information, visually appealing insights, interactive data, charts, graphs, and reports, etc. Further, you will get official training material issued by Microsoft for Analyzing Data with Power BI

  • Marketing, finance, sales, and other domain professionals who need extensive Business Intelligence
  • Statisticians aiming to implement their statistics skills to derive business insights
  • Individuals looking for jobs as Business Analysts, Business Development Managers, etc.
  • Graduates and Professionals looking to move to Workday Advanced Compensation
  • Functional Lead
  • Workday Administrators
  • Executives
  •  Generalists
  • Managers and Employees
  •  Project Managers
  •  IT Experts
  • Freshers Generalists.
  • IT Professionals.
  • Leads.
  • Managers and Employees.
  • Project Managers.

Requirements:

You do not need any prior knowledge to benefit from this Microsoft Power BI online training.

Total: 38 Courses View all

4
Salesforce
Salesforce Admin Training
₹1 ₹1

Salesforce Admin Training
The Salesforce admin online course implement, configure and manage Sales and Service Clouds. The salesforce cloud-based CRM tool is most popular co...
19 Lectures
Preview this course
Add to Wishlist
₹1 ₹1
5
SAP
SAP FICO
₹25,000

SAP FICO
1 Lectures
Preview this course
Add to Wishlist
₹25,000
6
SAP
SAP BW
₹25,000

SAP BW
1 Lectures
40
Preview this course
Add to Wishlist
₹25,000
Load more

Power BI Course Demo Video

1
Power BI Course Demo Video

Power BI Course Course Curriculum

1
INTRODUCTION TO POWER BI
1 hour

1 Introduction to Business Intelligence (BI)

2 Stages of business intelligence (BI)

3 Use cases of BI

4 Various BI tools

5 Overview of Data warehouse & concepts

6 Introduction to Power BI

7 Why Power BI

8 Power BI Components

9 Power BI pricing structure

10 Building blocks of Power BI

11 Architecture of Power BI

12 Power BI vs Tableau vs QlikView

13 Introduction of Power BI Desktop

14 Installation of Power BI Desktop

15 The key features of Power BI workflow

16 Process of creating reports in Power BI

2
DATA EXTRACTION
1 hour

1 Overview of Power BI desktop

2 Data sources in Power BI

3 Using files (excel, pdf, csv, etc.) as a data source

4 Using SaaS connectors

5 Extracting data from folders, and databases

6 Working with Azure SQL database and database sources

7 Connecting to Analysis Services

8 Other data sources (OData, web, SharePoint etc.)

9 Python & R script in Power BI

10 Introduction of power query editor

11 Advance editor

12 Query dependency editor

3
DATA VISUALIZATION WITH ANALYTICS
2.5

1 Deep dive into Power BI data visualization

2 Understanding Power View and Power Map

3 Data visualization techniques

4 Page layout & Formatting

5 Power BI Desktop visualization

6 Formatting and customizing visuals

7 Visualization interaction

8 Custom visualization in Power BI

9 Top-down and bottom-up analytics

10 Drill down

11 Drill through

12 Page navigations

13 Bookmarks

14 Selection pane to show/hide visuals

15 Comparing volume and value-based analytics

16 Combinations charts (dual axis charts)

17 Filter pane

18 Slicers

19 Use of Hierarchies in drill down analysis

20 Theme for corporate standards

21 Power BI template for design reusability

22 Mastering the best practices

23 Performance analyzer in Power BI for monitoring performance of report

24 Power BI Q&A (Natural Language Query visual)

25 Sync slicers

26 Tooltips & custom tooltips

27 Tables & matrix

28 Conditional formatting on visuals

29 Waterfall chart, KPI, Donut chart, Scatter chart

30 Geographical data visualization using Maps

4
DATA TRANSFORMATION – SHAPING & COMBINING DATA
1 hour

1 Shaping data using Power Query Editor

2 Formatting data

3 Transformation of data

4 Understanding of Data types

5 Data profiling for data quality check

6 Naming conventions & best practices to consider

7 Working with Parameters

8 Merge Query

9 Append Query

10 Group by of data (aggregation of data)

11 Applied steps (query settings)

12 Duplicate & Reference tables

13 Transpose of data

14 Fill

15 Pivot & Un-pivot of data

16 Custom columns

17 Conditional columns

18 Replace data from the tables

19 Split columns values

20 Move columns & sorting of data

21 Detect data type, count rows & reverse rows

22 Promote rows as column headers

23 Hierarchies in Power BI

24 M query

5
POWER BI SERVICE (Cloud), Q & A AND DATA INSIGHTS
2.5

1 Introduction to Power BI Service

2 Introduction of workspaces

3 Dashboard

4 Creating & Configuring Dashboards

5 Dashboard theme

6 Reports vs Dashboards

7 Building workspace Apps

8 Sharing reports & dashboards

9 Introduction to Power Q & A

10 Ask questions about your data using Natural Query Language

11 Getting answers in the form of charts, graphs, and data discovery methodologies

12 Configure custom questions for Q&A like FAQ

13 Ad-hoc analytics building

14 Power Q&A best practices

15 Quick Insights

16 Subscribe, Alerts, Usage statics, Related content

17 Design reports on Power BI Service

18 Collaboration using Power BI Service

19 Row Level Security (RLS)

20 Introduction of Paginated Reports

21 Introduction of Power BI Report Server

6
POWER BI SETTINGS, ADMINISTRATION & DIRECT CONNECTIVITY
1 hour

1 Getting to understand Power BI Desktop settings

2 Aggregating data from multiple data sources

3 Power BI Service settings

4 Power BI Admin Portal

5 Administration activities

6 Power BI usage analysis

7 Introduction of Office 365 admin activities

8 Introduction of Data Gateway

9 Installation & Configuration of data gateways

10 Scheduling auto data refresh

11 Managing groups, row-level security, datasets, reports, and dashboards

12 Real time data analysis using Direct Connectivity

13 Direct Query vs Import Mode

7
EMBEDDED POWER BI WITH API & POWER BI MOBILE
1 hour

1 Introduction to embedded Power BI

2 Create embedded code

3 Manage embedded code

4 Integration of Power BI in SharePoint

5 Introduction of Power BI API

6 Power BI Embedded playground

7 Introduction to Power BI Mobile

8 Creating mobile based reports & dashboards

9 Optimizing report for Power BI mobile app

10 Features of Power BI mobile app

11 Introduction of integrating Power BI & Excel

12 Power BI Analyze in Excel

8
POWER BI ADVANCE & POWER BI PREMIUM
1 hour

1 Introduction of Power BI Premium

2 Power BI Premium per user

3 Power BI Premium features

4 Introduction to Data Flow

5 Create Data Flow

6 Advantages of Data Flow

7 Create reports using Data Flow

8 Introduction to Power BI Deployment Pipelines

9 Create Deployment Pipelines

10 Benefits of Deployment Pipelines

11 Introduction of Sensitivity Labels

12 Introduction of Power BI Goals feature

13 Incremental data load in Power BI

14 Power BI best practice rules to improve performance

9
DATA MODELLING & DAX
1 hour

1 Introduction of relationships

2 Creating relationships

3 Cardinality

4 Cross filter direction

5 Use of inactive relationships

6 Introduction of DAX

7 Why DAX is used

8 DAX syntax

9 DAX functions

10 Context in DAX

11 Calculated columns using DAX

12 Measures using DAX

13 Calculated tables using DAX

14 Learning about table, information, logical, text, iterator,

15 Time intelligence functions (YTD, QTD, MTD)

16 Cumulative values, calculated tables, and ranking and rank over groups

17 Date and time functions

18 DAX advanced features

2

Be the first to add a review.

Please, login to leave a review
Enroll course
30-Day Money-Back Guarantee

Includes

50
Full lifetime access
Access on mobile and TV
Power BI Training
Category:
BUSINESS INTELLIGENCE, Power BI
Price:
Free
Get Course
X

    ENQUIRY NOW






    DEAL OF THE MONTH : GET 50% OFF ON SELF PACED COURSES & 15% OFF ON ALL COURSES

    Enroll Now!
    X