Course curriculum

    1. Welcome to the course

    2. 1. Introduction

    3. Download Course Files

    4. 2. About the course

    5. 3. Downloading Power BI Desktop

      FREE PREVIEW

    6. 4. Understanding the Power BI User Interface

      FREE PREVIEW

    7. 5. Understanding the Data

    8. 6. Importing Data to Power BI

    9. 7. Understanding Power Query UI

    10. 8. Intro to Transforming Data with Power Query 1

    11. 9. Intro to Transforming Data with Power Query 2

    12. 10. Re-Using M Scripts and Loading Data to Power BI

    13. Re-launching Power Query Editor and Refreshing Data

    14. Check your knowledge

    1. 11. Introduction to Power BI Reporting

    2. New Power BI Visualization UI

    3. 12. Visualizing reports 1 (Line Chart)

    4. 13. Formatting Charts

    5. 14. Creating an Additional Chart

    6. 15. Top N Filters on Bar Chart

    7. 16. Sorting a Visual

    8. 17. Page Filters with Filters Pane and Slicers

    9. 18. Edit Visual Interactions

    10. 19. Using Visuals Background to enhance reports

      FREE PREVIEW

    11. 20. Working with Shapes and Text Box

    12. 21. Working with Report Themes

    13. 22. Reusing a Report Page as Template

    14. 23. Adding a Back button to navigate pages B

    15. 24. Designing a Mobile View Report

      FREE PREVIEW

    16. 25. Publishing report to Power BI Online Service

    17. 26. Intro to Q and A

    18. 27. Module 1 Outro

    19. Assignment 1

    20. Check your knowledge

    1. 28. Intro to Data Modeling

    2. 29. Why build a data model

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

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

    5. 32. Prepare Data Model files in Power Query

    6. 33. Building Fact and Dimension Tables with Power Query

    7. 34. Resolving Table Relationship Issues

    8. 35. Confirm Relationships in Model View

    9. 36. Confirming Relationships

    10. Data Modeling Assignment

    1. 37. Introduction to DAX

    2. 38. Using CALENDARAUTO to generate Calendar Table

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

    4. 40. Connecting the Calendar table to the Fact Table

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

    6. 42. Writing a simple SUM Aggregator Measure

    7. 43. Understanding Filter Context 1

    8. 44. Understanding Filter Context 2

    9. 45. Introduction to CALCULATE function

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

    11. 47. Time Intelligence (Previous Month Values)

    12. 48. Calculating Variance

    13. 49. Calculating Percentage Share by Removing Filters

    14. 50. Calculate values for Same Period Last Year

    15. 51. Calculating YTD Values

    16. 52. Automatic Power BI Measures with Quick Measures

    17. DAX Assignment

    1. 53. Customize Theme

    2. 54. Create a Report Page Template

    3. 55. Compare Monthly Revenue against SPLY

    4. 56. Create a Forecast Line Chart

    5. 57. Using a Waterfall Chart to Visualize Variance

    6. 58. Create a Matrix table Visual with Data Bars

    7. 59. Create a Donut Chart

    8. 60. Create a Clustered Bar Chart

    9. 61. Create Bar Chart and Ribbon Chart

    10. Visualization Assignment 2

    1. 62. Intro to Data Preparation

    2. 63. Using the Append Method to combine Excel Worksheets

    3. 64. Using Workbook Property method to combine Excel Worksheets

    4. 65. Comparing Append and Workbook Property Consolidation Methods

    5. 66. Consolidating Clean Excel Workbooks from a folder

    6. 67. Consolidating unclean Excel Workbooks from a Folder

    7. Check your knowledge

    8. Rate the course

About this course

  • $20.00
  • 79 lessons
  • 5 hours of video content