Basic to Advance Training on Power BI – Part2 (2022 updated)

Basic to Advance Training on Power BI – Part2 (2022 updated), available at $64.99, has an average rating of 4.35, with 21 lectures, based on 10 reviews, and has 147 subscribers.

You will learn about After completing the Part1, this is part2 and it educates you everything about BI Desktop and BI Service which is a cloud service. How to publish BI Desktop reports on BI Service and basic differences between desktop and Service. Data Modelling deep study. Every kind of relationship is discussed. One to one, one to many and many to many. Giving direction to a data using cardinalities. Both directions and single direction. Projects are used in examples How to create reports in Service without using Desktop How to create an account in BI Service with Introduction of BI Service BI Free and Licensed versions. Their advantages and disadvantages over one another. BI Service workspaces, By default plus user created workspaces. Difference between them. What is a gateway and what is it role along-with refresh schedule. How to access dashboards via mobile app stores. BI Service dashboards, datasets, reports – introduction to difference between each of them How to share and give access dashboards and workspaces with other users. How to set up row level security in your data to prevent users from viewing different reports. How to create Apps in BI Service This course is ideal for individuals who are Business Analysts , Excel Users and Data analysts and IT users It is particularly useful for Business Analysts , Excel Users and Data analysts and IT users.

Enroll now: Basic to Advance Training on Power BI – Part2 (2022 updated)

Summary

Title: Basic to Advance Training on Power BI – Part2 (2022 updated)

Price: $64.99

Average Rating: 4.35

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

After completing the Part1, this is part2 and it educates you everything about BI Desktop and BI Service which is a cloud service.
How to publish BI Desktop reports on BI Service and basic differences between desktop and Service.
Data Modelling deep study. Every kind of relationship is discussed. One to one, one to many and many to many.
Giving direction to a data using cardinalities. Both directions and single direction. Projects are used in examples
How to create reports in Service without using Desktop
How to create an account in BI Service with Introduction of BI Service
BI Free and Licensed versions. Their advantages and disadvantages over one another.
BI Service workspaces, By default plus user created workspaces. Difference between them.
What is a gateway and what is it role along-with refresh schedule.
How to access dashboards via mobile app stores.
BI Service dashboards, datasets, reports – introduction to difference between each of them
How to share and give access dashboards and workspaces with other users.
How to set up row level security in your data to prevent users from viewing different reports.
How to create Apps in BI Service

Who Should Attend

Business Analysts , Excel Users and Data analysts and IT users

Target Audiences

Business Analysts , Excel Users and Data analysts and IT users

This is a Part2 and it is in continuation to the Part1. Now ,in this final second part we are finishing the BI Desktop and primarily BI Service . Its account creation to using its services plus you’ll get the overview of DAX. (Basic of dax)
This course is updated for 2022 dear students and I have covered basics of DAX also.
What is a BI Service and what is the relationship between Desktop and Service when it comes to dashboards.
Create workspaces, reports, dashboards in power BI Service
How to provide admin or viewer rights to team members who can read or edit the reports and you don’t have to email.
How to link local excel files or files shared on server with BI service.
How to prevent or put data restrictions on users so they can not see other reports.
What is a difference between datasets, dashboards, Reports in BI service.
Learn how we have made a incredible dashboard – Sales Dashboard
Types of relationships – Data Modelling – One to One , One to Many, Many to Many
Types of Cardinality. – Single direction and both directions
What is a Dax and its role in PowerBI.
Discussing Basic DAX like SUM, COUNT, COUNTBLANK, DISTINCT COUNT .
Giving you a basic idea how DAX Formula works in power BI Window and how excel knowledge helps, if at all.
How to use Calculated field and what are measures – this term we use in DAX technology a lot.
BI Mobile apps – how to see reports via mobile – android phones and why it is called next level in bi.
Major differences between BI Service and BI Desktop working style.

Course Curriculum

Chapter 1: Introduction

Lecture 1: A Quick Demo- What are we covering?

Lecture 2: What is a Data Modelling – One to Many , Many to Many etc Relationships

Lecture 3: Data Modelling Still on

Lecture 4: Data Modelling

Lecture 5: Introduction to BI Service – How to begin with it

Lecture 6: How to Publish BI Reports

Lecture 7: BI Service features – know your new Tool

Lecture 8: How to share WorkSpaces

Lecture 9: Sharing BI Reports

Lecture 10: Admin and Viewer Roles

Lecture 11: Exploring Other Sharing options – With specific people

Lecture 12: Power-BI Service – Mobile View

Lecture 13: PowerBI Service Row Level Security Set Up

Lecture 14: Working with a Gateway

Lecture 15: Introduction to DAX – Basic level

Lecture 16: Work with Basic DAX functions – Count, Sum , CountA etc

Lecture 17: More Basic Dax – CountRows, DistinctCount

Lecture 18: Divide DAX – Improve the fundamentals

Lecture 19: Filter Dax – Intermediate level

Lecture 20: ITERATOR functions – Get idea

Lecture 21: Remove Filters – ALL Dax

Instructors

ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 2 votes
4 stars: 1 votes
5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu