Course curriculum

  • 1

    Introductions

  • 2

    Visualizing Reports in Power BI

    • 11. Introduction to Power BI Reporting

    • 12. Visualizing reports 1 (Line Chart)

    • 13. Formatting Charts

    • 14. Creating an Additional Chart

    • 15. Top N Filters on Bar Chart

    • 16. Sorting a Visual

    • 17. Page Filters with Filters Pane and Slicers

    • 18. Edit Visual Interactions

    • 19. Using Visuals Background to enhance reports

      FREE PREVIEW
    • 20. Working with Shapes and Text Box

    • 21. Working with Report Themes

    • 22. Reusing a Report Page as Template

    • 23. Adding a Back button to navigate pages B

    • 24. Designing a Mobile View Report

      FREE PREVIEW
    • 25. Publishing report to Power BI Online Service

    • 26. Intro to Q and A

    • 27. Module 1 Outro

    • Assignment 1

    • Check your knowledge

  • 3

    Understanding Data Modeling in Power BI

    • 28. Intro to Data Modeling

    • 29. Why build a data model

    • 30. Steps 1 to 4 of building a Data Model

    • 31. Step 5 of Building a Power BI Data Model

    • 32. Prepare Data Model files in Power Query

    • 33. Building Fact and Dimension Tables with Power Query

    • 34. Resolving Table Relationship Issues

    • 35. Confirm Relationships in Model View

    • 36. Confirming Relationships

    • Data Modeling Assignment

  • 4

    Introduction to DAX

    • 37. Introduction to DAX

    • 38. Using CALENDARAUTO to generate Calendar Table

    • 39. Using FORMAT function to add Months Years and Qtrs to Calendar

    • 40. Connecting the Calendar table to the Fact Table

    • 41. Using the MONTH function to create custom sorting for month column

    • 42. Writing a simple SUM Aggregator Measure

    • 43. Understanding Filter Context 1

    • 44. Understanding Filter Context 2

    • 45. Introduction to CALCULATE function

    • 46. Creating an Empty Table to house all DAX Measures

    • 47. Time Intelligence (Previous Month Values)

    • 48. Calculating Variance

    • 49. Calculating Percentage Share by Removing Filters

    • 50. Calculate values for Same Period Last Year

    • 51. Calculating YTD Values

    • 52. Automatic Power BI Measures with Quick Measures

    • DAX Assignment

  • 5

    Visualizing Reports in Power BI 2

    • 53. Customize Theme

    • 54. Create a Report Page Template

    • 55. Compare Monthly Revenue against SPLY

    • 56. Create a Forecast Line Chart

    • 57. Using a Waterfall Chart to Visualize Variance

    • 58. Create a Matrix table Visual with Data Bars

    • 59. Create a Donut Chart

    • 60. Create a Clustered Bar Chart

    • 61. Create Bar Chart and Ribbon Chart

    • Visualization Assignment 2

  • 6

    Introduction to Data Preparation Techniques with Power Query

    • 62. Intro to Data Preparation

    • 63. Using the Append Method to combine Excel Worksheets

    • 64. Using Workbook Property method to combine Excel Worksheets

    • 65. Comparing Append and Workbook Property Consolidation Methods

    • 66. Consolidating Clean Excel Workbooks from a folder

    • 67. Consolidating unclean Excel Workbooks from a Folder

    • Check your knowledge

    • Rate the course