Self-Paced Online

Master Power BI Desktop for data analysis

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

AI & Data Science
English language
Beginner

What you’ll 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
Design custom interactive reports and dashboards

About this course

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

Course content

8 modules · 75 lessons

01Section 1. Cannect And Transform The Raw Source Data12 lessons

1. Introduction to the course
2. Excel vs. Power BI
3. How to install Power BI
4. Change default setting
5. Power BI workflow
6. Display of final dashboard
7. Back end vs front end
8. Types of data connectors
9. Introduction of Power Query
10. Query editing tools
11. Power query interface
Quiz

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

12. Assignment with solution
13. Extracting data from web
14. Data profiling & colum quality
15. Numeric tools
16. Date and time tools
17. Change locale type
18. Index and conditional colums
19. Grouping & aggregating
20. Pivoting and un-pivoting
21. Merge queries
22. Append queries
Quiz

03Section 3. Design and build a relational model10 lessons

23. Data modeling
24. Data normalization
25. Fact and dimension tables
26. Primary and foreign keys
27. Star and snowflake schema
28. Active and inactive relationship
29. Relationship Cardinality
30. Connecting Multiple fact tables
31. Filter context and flow
Quiz

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

32. Introduction of DAX
33. Calculate colums
34. DAX Measure
35. Quick measures
36. Filter context
37. DAX Syntax and operators
38. Basic Math and stats functions
39. Counting functions
40. Basic logical functions
41. Switch functions
Quiz

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

42. Text functions
43. Basic date and time function
44. Related function
45. Calculate function
46. ALL function
47. Filter function
48. Iterator functio
49. Time intelligence
Quiz

06Section 6. Design custom interactive reports and dashboards9 lessons

50. Visualizing data (3 Questions)
51. Dashboard design
52. Power BI interface
53. Adding report pages and Objects
54. Building and formatting charts
55. Line charts
56. KPI Card
57. Bar and donut chart
Quiz

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

58. Adding bookmarks
59. Basic filter option
60. Table for Top N products
61. Top N text cards
62. Map visuals
63. Report slicers
64. Gauge charts
65. Report interaction
66. Donut Charts with visual filter
67. Adding bookmarks
Quiz

08Final Exam1 lessons

Final Exam

Your instructor

PACI

Punjab Artificial Intelligence and Cybersecurity Initiative

No reviews yet20 courses on NSDP

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

View full profile

24-hour refund policy

Start learning with confidence.

1
Pay and start
Pay the course fee and open your first lessons on the NSDP Portal.
2
Ask within 24 hours
Not satisfied? Ask for a refund within 24 hours of payment.
3
Get your fee back
Our team confirms your request and refunds the course fee.

The same policy applies to self-paced courses (within 24 hours of payment) and to live Zoom and on-campus classes (within 24 hours of the first class). To ask, contact the NSDP helpline 0304 111 0869, WhatsApp 03484350668 or email support.department@nsdp.pk with your CNIC and PSID / challan number, or type “refund” in the NSDP Rehnuma chat. Requests after 24 hours aren’t eligible. See the cancellation & refund policy.

Student reviews

No reviews yet. Students can share their experience once they have completed at least half of the course.

Record your course on NSDPInstructors wantedCreate a self-paced course once, reach learners across Pakistan and abroad, and earn on every enrolment.Become an instructor

Students also explore

Self-Paced OnlineAdmissions open

AI & Data Science · English · Beginner

Pandas Bootcamp for Data Analysis

Pandas Bootcamp for Data Analysis: a self-paced PACI course with 140 lessons in 16 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month

Self-Paced OnlineAdmissions open

AI & Data Science · English · Beginner

The SQL Programming Essentials

The SQL Programming Essentials: a self-paced PACI course with 53 lessons in 9 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month

Self-Paced OnlineAdmissions open

Machine Learning · English · Beginner

Machine Learning Classification Bootcamp

Machine Learning Classification Bootcamp: a self-paced PACI course with 88 lessons in 11 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month

Self-Paced OnlineAdmissions open

Machine Learning · English · Beginner

Machine Learning Regression Masterclass

Machine Learning Regression Masterclass: a self-paced PACI course with 81 lessons in 11 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month