Power BI Essential

Goals

Learn how to create interactive dashboards, custom reports, analyze data and share insights using Power BI, which will empower you to improve your business intelligence, monitor your daily business and assist data-driven decision-making process.

Before the course

Please ensure Power BI online service is signed up and Power BI Desktop is installed on your device before class.

• Sign up the power BI online Service
  • https://powerbi.microsoft.com/
  • Click TRY FREE to sign up
  • Please note: you need to use a work account or office 365 account
• Download and install Power BI Desktop
  • https://www.microsoft.com/en-us/download/details.aspx?id=58494
• Download and install Power BI mobile in phone

Objectives

By the end of this course, you should be able to:

• Understand and navigate between different Power BI tools and their functionality
• Connect various of data sources
• Build informative reports and dashboards
• Create, edit, and format visuals
• Work with basic DAX
• Publish and share reports and dashboards

Content

1)     Introduction

• Overview of Power BI concepts
• Navigate in Power BI service
• License types

2)     Power BI Service

• Introduction to Power BI Service
• User interface (Menus, Fields pane, Visualizations pane, workspaces etc.)
• Connect to data source
• Working with an Excel workbook
• Exercise: Connect to a sample
• Create reports with visualization
• Visual interaction
• How to use filter

3)     Work with report

4)     Create dashboard

5)     Quick insight

6)     Power BI publisher for excel (Analyze in Excel)

7)     Share dashboard and reports from Power BI Service

8)     Refresh dataset

9)     Power BI Desktop

• Introduction to Power BI Desktop
• Transform data
• Use the Query Editor
• Data modelling
• Manage relationships
• Create reports with visualizations
• More complex visualizations
• Publish from Power BI desktop

10)  Conclusion