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