Prerequisites:
The prerequisites for this course are a solid working knowledge of Windows and the use of a keyboard and mouse. It is also essential that you understand the advanced concepts related to data integration and Excel concepts
Classroom Outline:
DATA ANALYSIS WITH POWER BI
•Defining BI / Data Analysis / Visualization
•Power BI Desktop
•Excel vs Power BI
•Power BI Interface
CONNECTING TO YOUR DATA
•Navigator Window
•Importing vs Live Connection
•Relationship Types
•Cross Filter Direction
TRANSFORMING YOUR DATA
•Data View to Transform
•Power Query Editor
•Close & Apply vs Saving
•Combining Queries
•Adv Editor & M Language
DATA MODELING WITH DAX
•What is DAX
•Formula Bar
•DAX Error Checking
•Calculated Columns vs Measures
•Table Unions
VISUALIZATIONS FOR YOUR REPORTS
•Visualizations, Filters & Fields Pane
•Types of Visuals
•Microsoft Marketplace
•Enhancing Your Reports / Dashboards
INTERACTIVE VISUALIZATIONS
•Hierarchies
•Filters & Slicers
•Drill Through Filters
PUBLISHING TO THE POWER BI WEB APP
•Using Workspaces •Power BI Mobil App
This outline is a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.