MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Power BI Features in Depth

Course Summary

Learn how you can easily search, access, and analyze data within and outside your organization in just a few clicks with Power BI—the business intelligence features that lie inside Microsoft Office.

  • +

    Course Syllabus

    • Introduction
      • Welcome
      • What you should know before watching this course
      • Using the exercise files
    • Getting Started: Self-Service, Power BI, and BI Tools
      • Understanding BI
      • What you need for Excel self-service BI
      • Understanding Office 365 Power BI
      • Enabling Component Object Model (COM) add-ins for Power Pivot and Power View
      • Installing Power Map
      • Installing Power Query
    • Using Power Query to Get Data
      • Searching for online data with Power Query
      • Types of Power Query data sources
      • Shaping data in the Query Editor
      • Inserting custom columns
      • Appending queries
      • Duplicating a query
      • Merging queries
      • Connecting to an Excel data source
      • Connecting to a commercial data source
      • Troubleshooting queries
    • Modeling Your Data with Power Pivot
      • About Excel data models
      • Using Excel tables
      • Using Power Queries
      • Understanding relationships
      • Creating relationships between tables
      • Using database tables
      • Cleaning up the data model
    • Enhancing PivotTables and PivotCharts with Power Pivot
      • Creating a PivotTable
      • Marking a data table
      • Adding slicers to the PivotTable
      • Adding a timeline to a PivotTable
      • Creating and formatting a PivotChart
    • Expanding the Data Model in Power Pivot
      • Building the Contoso data model
      • Adding calculated columns
      • Understanding DAX functions in Power Pivot
      • Adding a related column
      • Building a hierarchy
      • Creating a measure
      • Creating a key performance indicator (KPI)
    • Visualizing Geospatial Data with Power Map
      • Understanding spatial data
      • Creating a tour
      • Using formatting tools
      • Using categories
      • Adding a scene to the tour
      • Adding detail with annotations and text boxes
      • Inserting a 2D chart
      • Visualizing data over time
      • Capturing a map screenshot
      • Saving a Power Map video
    • Creating and Formatting Power View Reports
      • Understanding Power View
      • Creating and using a table visualization
      • Saving a Power View report
      • Formatting a report
      • Refreshing Power View data
      • Changing a table to a matrix visualization
      • Adding data to a visualization
      • Applying filters
    • Creating Other Power View Visualizations
      • Creating a column chart
      • Creating bar, line, and pie charts
      • Creating chart multiples to display data details
      • Creating a scatter chart
      • Creating a map visualization
      • Adding slicers to reports
      • Creating a card visualization
      • Using tiles for navigation
    • Sharing Your Data Using Power BI for Office 365
      • What you need for Power BI
      • Sharing and using Power Queries
      • Sharing a Power View report
      • Using the Power BI sites
      • Getting started with Power BI Q&A
      • Adding synonyms to a data model
      • Improving the data model for QA
    • Conclusion
      • Next steps

Course Fee:
USD 25

Course Type:


Course Status:



1 - 3 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top