Visual data with Microsoft Power BI

Course Outline:

• Connect to your data.
• Understand MS POWER BI terminology and interface.

Visuals:

• Creating visuals,
• Chart types,
• Geographic maps,
• Heat maps,
• Tree maps,
• Pie charts,
• bar charts and many other types of charts,
• Importing custom designs and custom chart types.
• Choosing suitable chart types.
• Single measures, multiple measure,
• double axes, displaying dates, drilldown, sorting visuals.
• Analysis Lines.
• Filters and slicers.

Formatting:

• Formatting visuals.

Working with the data:

• Preparing data using queries.
• Calculations: Create calculated columns and measures.
• Columns vs Measures.
• Quick Measures.

Functions:

Built-in Functions for dates, maths and strings.

DAX calculations:

• Relationships
• DAX calculations.

Final presentation

• Final presentation: Reports, publish reports, create dashboards

INCLUDED:

• PCWorkshops Certificate on completion
• Course notes , examples, exercises, Course Homework / Revision work
• After the course, 1 free Question session via Gotomeeting.com.