Video1: CREATING DASHBOARDS USING Power BI: Course Overview
Hello and welcome yet another exciting course in the epiGuider series, entitled, “CREATING DASHBOARDS USING Power BI”. This video provides an overview of the course. Key sections covered include:
WHAT IS Power B1?
WHY Power BI?
COURSE PURPOSE
WHY YOU SHOULD TAKE THE COURSE?
COURSE REQUIREMENTS
WHO THIS COURSE IS FOR?
Curriculum
This course is divided into 6 main sections
Section 1: About the course
• Overview of the course
• Course curriculum
Section 2: Getting Started with Power BI
• Installation of Power BI
• Presentation of exercise.
• Data analysis Plan
Section 3: Getting Data into Power BI
• Explore the different Power BI data sources
• Getting Excel data (.xlsx format)
• Getting Excel data (.csv format)
• Getting Web data
Section 4: Data Cleaning within Power BI
• Removing data
• Transforming tables
• Transforming text columns
• Inserting new columns
• Entering custom data
• Appending/Merge Queries
• Adding an index column
• Data Relationships
• Data Lookup
Section 5: Creating the Power BI Dashboard proper (Data Visualisation)
• Introduction to reports
• Cards
• Maps
• Tables/Matrices
• Charts
• Gauges
• Slicers
• Q and A
• Decomposition trees
• Refining your dashboard
• How to use filters
• Creating a phone layout
Section 6: Sharing your created Dashboard/Report
Course Material:
1) owid-covid-data.xlsx: https://covid.ourworldindata.org/data...
2) owid-covid-data.csv: https://covid.ourworldindata.org/data...
3) Task for this course: https://1drv.ms/u/s!AmOGv3aL4LGRheohb...
epiGuder webisite: www.epiguider.com