The course focuses on querying databases, creating multi-user databases with navigation interfaces, and discuss setting the user experience. You will create dashboards using Excel features, Power BI tools (Power View, Power Pivot, Power Query, and 3D Map) of Excel along with the Power BI Desktop suite to visual your data.