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

Focused View

ajay parmar

8:11:53

281 View

1. A Quick Demo- What are we covering.mp4

03:57

2.1 dataModel.zip

2. What is a Data Modelling - One to Many , Many to Many etc Relationships.mp4

40:23

3. Data Modelling Still on.mp4

27:26

4. Data Modelling.mp4

35:20

5. Introduction to BI Service - How to begin with it.mp4

26:12

6. How to Publish BI Reports.mp4

16:25

7. BI Service features - know your new Tool.mp4

08:00

8. How to share WorkSpaces.mp4

33:15

9. Sharing BI Reports.mp4

17:08

10. Admin and Viewer Roles.mp4

30:03

11. Exploring Other Sharing options - With specific people.mp4

24:23

12. Power-BI Service - Mobile View.mp4

17:30

13. PowerBI Service Row Level Security Set Up.mp4

12:29

14. Working with a Gateway.mp4

24:39

15.1 daxday 2.zip

15.2 daxday1.zip

15.3 daxday3.zip

15.4 SUMXCOUNTX.xlsx

15.5 TOYSHOP.xlsx

15. Introduction to DAX - Basic level.mp4

20:21

16. Work with Basic DAX functions - Count, Sum , CountA etc.mp4

18:47

17. More Basic Dax - CountRows, DistinctCount.mp4

12:42

18. Divide DAX - Improve the fundamentals.mp4

18:35

19. Filter Dax - Intermediate level.mp4

46:34

20. ITERATOR functions - Get idea.mp4

32:16

21. Remove Filters - ALL Dax.mp4

25:28

Description

PowerBI Complete training

What You'll 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 is this for?

Business Analysts , Excel Users and Data analysts and IT users

More details

Description
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.

Who this course is for:
Business Analysts , Excel Users and Data analysts and IT users

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

ajay parmar

Instructor's Courses

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.