About Course
This course provides comprehensive training on Power BI Desktop for data analysis. Learn how to connect, transform, model data, and create interactive reports and dashboards using Power BI. Gain the skills to efficiently analyze data and communicate insights using powerful visualizations.
Master Power BI Desktop and build data analysis skills for actionable insights.
Requirements
- ✓Basic understanding of data and analytics.
- ✓Familiarity with Excel (recommended but not required).
- ✓A computer with Power BI Desktop installed.
- ✓Willingness to learn advanced data visualization techniques.
Course Curriculum
Section 1. Connect and Transform the Raw Source Data
1. Introduction to the Course
2. Excel vs Power BI
3. How to install Power BI
4. Change default settings
5. Power BI workflow
6. Display of final dashboard
7. Back end vs front end
8. Types of data connectors
9. Introduction to Power Query
10. Query editing tools
11. Power query interface
Assessment Exercise- 01
Section 2. Connect and Transform the Raw Source Data Part 02
12. Assignment with solution
13. Extracting data from web
14. Data profiling column quality
15. Numeric tools
16. Date and time tools
17. Change locale type
18. Index and conditional columns
19. Grouping aggregating
20. Pivoting and unpivoting
21. Merge queries
22. Append queries
Assessment Exercise- 02
Section 3. Design and Build a Relational Model
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 relationships
29. Relationship Cardinality
30. Connecting multiple fact tables
31. Filter context and flow
Assessment Exercise- 03
Section 4. Analyze the Data with Calculated Columns and Measures
32. Introduction to DAX
33. Calculate columns
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
Assessment Exercise- 04
Section 5. Analyze the Data with Calculated Columns and Measures Part 02
42. Text functions
43. Basic date and time function
44. Related function
45. Calculate function
46. ALL function
47. Filter function
48. Iterator function
49. Time intelligence
Assessment Exercise- 05
Section 6. Design Custom Interactive Reports and Dashboards
50. Visualizing data (3 Questions)
51. Dashboard design framework
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
Assessment Exercise- 06
Section 7. Design Custom Interactive Reports and Dashboards Part 02
58. Basic filter option
59. Table for Top N products
60. Top N text cards
61. Map visuals
62. Report slicers
63. Gauge charts
64. Report interaction
65. Donut charts with visual filter
66. Adding bookmarks
Assessment Exercise- 07
Section 8. Final Exam
Final Exam
What You Will Learn
- ✓Master the Power BI workflow and interface.
- ✓Learn to connect and transform raw source data.
- ✓Understand data modeling techniques and relationships.
- ✓Create powerful calculated columns and measures with DAX.
- ✓Design interactive reports and dashboards with Power BI.
- ✓Learn advanced visualization techniques and dashboard design.
- ✓Gain the skills to perform data profiling and cleaning.