Menu

National Skills Development Program

Website menu

Home Courses Bundles Live Sessions About Contact

Courses

/ data-science

/ beginner

Master Power BI Desktop for data analysis

Name: Master Power BI Desktop for data analysis
Price: 6000 PKR
Availability: InStock

New

Master Power BI Desktop for data analysis: a self-paced PACI course with 75 lessons in 8 sections and a quiz after each section.

Created by PACI

Learners

0

Language

English

Course type

recorded

Level

beginner

Course promise

What you will learn

Cannect And Transform The Raw Source Data

Cannect And Transform The Raw Source Data Part 02

Design and build a relational model

Analyze the Data with calculated colummns and measures

Analyze the Data with calculated colummns and measures Part 02

Explore

Course content

8 sections · 75 lessons

Section 1. Cannect And Transform The Raw Source Data12 lessons

1. Introduction to the course

video

2. Excel vs. Power BI

video

Details

Course description

Master Power BI Desktop for data analysis is a self-paced recorded course from the Punjab Artificial Intelligence and Cybersecurity Initiative (PACI). It has 75 lessons in 8 sections (67 video lessons, 8 quizzes). What the course covers: - Cannect And Transform The Raw Source Data - Cannect And Transform The Raw Source Data Part 02 - Design and build a relational model - Analyze the Data with calculated colummns and measures - Analyze the Data with calculated colummns and measures Part 02 - Design custom interactive reports and dashboards - Design custom interactive reports and dashboards Part 02

Instructor

Meet your guide

P

PACI

Punjab Artificial Intelligence and Cybersecurity Initiative

PACI (Punjab Artificial Intelligence and Cybersecurity Initiative) publishes recorded courses in artificial intelligence, cybersecurity, web development and data skills.

More courses by PACI

WordPress Website Development

web-development • beginner

83 lessons

PKR 1,000 / month · 6-month course

The SQL Programming Essentials

data-science • beginner

53 lessons

PKR 1,000 / month · 6-month course

SOC Analyst Training

cybersecurity • beginner

90 lessons

PKR 1,000 / month · 6-month course

Design custom interactive reports and dashboards

3. How to install Power BI

video

4. Change default setting

video

5. Power BI workflow

video

6. Display of final dashboard

video

7. Back end vs front end

video

8. Types of data connectors

video

9. Introduction of Power Query

video

10. Query editing tools

video

11. Power query interface

video

Quiz

quiz

Section 2. Cannect And Transform The Raw Source Data Part 0212 lessons

12. Assignment with solution

video

13. Extracting data from web

video

14. Data profiling & colum quality

video

15. Numeric tools

video

16. Date and time tools

video

17. Change locale type

video

18. Index and conditional colums

video

19. Grouping & aggregating

video

20. Pivoting and un-pivoting

video

21. Merge queries

video

22. Append queries

video

Quiz

quiz

Section 3. Design and build a relational model10 lessons

23. Data modeling

video

24. Data normalization

video

25. Fact and dimension tables

video

26. Primary and foreign keys

video

27. Star and snowflake schema

video

28. Active and inactive relationship

video

29. Relationship Cardinality

video

30. Connecting Multiple fact tables

video

31. Filter context and flow

video

Quiz

quiz

Section 4. Analyze the Data with calculated colummns and measures11 lessons

32. Introduction of DAX

video

33. Calculate colums

video

34. DAX Measure

video

35. Quick measures

video

36. Filter context

video

37. DAX Syntax and operators

video

38. Basic Math and stats functions

video

39. Counting functions

video

40. Basic logical functions

video

41. Switch functions

video

Quiz

quiz

Section 5. Analyze the Data with calculated colummns and measures Part 029 lessons

42. Text functions

video

43. Basic date and time function

video

44. Related function

video

45. Calculate function

video

46. ALL function

video

47. Filter function

video

48. Iterator functio

video

49. Time intelligence

video

Quiz

quiz

Section 6. Design custom interactive reports and dashboards9 lessons

50. Visualizing data (3 Questions)

video

51. Dashboard design

video

52. Power BI interface

video

53. Adding report pages and Objects

video

54. Building and formatting charts

video

55. Line charts

video

56. KPI Card

video

57. Bar and donut chart

video

Quiz

quiz

Section 7. Design custom interactive reports and dashboards Part 0211 lessons

58. Adding bookmarks

video

59. Basic filter option

video

60. Table for Top N products

video

61. Top N text cards

video

62. Map visuals

video

63. Report slicers

video

64. Gauge charts

video

65. Report interaction

video

66. Donut Charts with visual filter

video

67. Adding bookmarks

video

Quiz

quiz

Final Exam1 lessons

Final Exam

quiz

Python Programming for All Levels

it-software • beginner

137 lessons

PKR 1,000 / month · 6-month course

Practical Malware Analysis for Beginners

cybersecurity • beginner

44 lessons

PKR 1,000 / month · 6-month course

Penetration Testing Web Hacking

cybersecurity • beginner

54 lessons

PKR 1,000 / month · 6-month course

Not yet

Share

Invite someone to this course

Ready when you are

Enroll to unlock lessons, track progress, and continue learning from your student dashboard.

Master Power BI Desktop for data analysis

What you will learn

Related topics

Course content

Course description

Meet your guide

PACI

More courses by PACI

WordPress Website Development

The SQL Programming Essentials

SOC Analyst Training

Python Programming for All Levels

Practical Malware Analysis for Beginners

Penetration Testing Web Hacking

Invite someone to this course

Ready when you are