YoVDO

Microsoft Excel: Learn Power BI Dashboards Basics!

Offered By: Skillshare

Tags

Microsoft Excel Courses Business Intelligence Courses Data Visualization Courses Microsoft Power BI Courses Data Cleaning Courses Data Modeling Courses Power Query Courses Power Pivot Courses Power View Courses

Course Description

Overview

Last time you opened an Excel Power BI Dashboard and are overwhelmed by the number of things to do. You don't know how to make the best use of your time.

But it doesn't have to be this way!

You Will Walk Away With...

  • MORE TIME!
  • Create your own Power BI Dashboard from scratch!
  • Understand the essence of the Power BI visualizations, and see them in action!
  • See how Power BI is used with real examples!
  • Understand how Power Query, Power View, and Power Pivot are used together!

After this class you will be able to:

  • Actually SMILE when you open a Power BI Dashboard :-)
  • Brag to your friends about how you can use Microsoft Power BI confidently!

If you're like me, you use Microsoft Power BI on a daily basis for important tasks, text processing, or reports. Whether it's for business or personal related projects, everyone wants to be able to use Power BI freely and easily.

We will learn how to create your own report dashboard from your source data! You will learn:

  • Installing Power BI Desktop for FREE
  • Getting Data from a data source (Excel Power Query)
  • Cleaning Data (Excel Power Query)
  • Creating a Data Model (Excel Power Pivot)
  • Create cool visualizations and charts (Excel Power View)
  • Publishing it to your own dashboard online (Power BI Website)

And you will use live source data in creating your own Power BI Dashboard!


Syllabus

  • Welcome to the Power BI Course!
  • Excel Power BI Introduction
  • Power BI High Level Flow
  • Excel Power Query Introduction
  • Excel Power Pivot Introduction
  • Excel Power View Introduction
  • Install Power BI and Sign Up
  • The Big Picture
  • Power BI - Get Data
  • Power BI - How to Get More Data
  • Power BI - Modelling Data
  • Power BI - Adding Relationships Manually
  • Power BI - Visualization
  • Power BI - Visualization Customization
  • Power BI - More Visualizations
  • Power BI - Visualization Format and Analytics
  • Power BI - Ask a Question
  • Advanced - Real World Example
  • Advanced - Get Data
  • Advanced - Modelling Data
  • Advanced - Visualization with multiple charts
  • Advanced - Publishing
  • Advanced - Power BI Website
  • Your Project - Create your own Dashboard!
  • Advanced Tips - Introduction on the Data Setup
  • Advanced Tips - Using Bookmarks to Save Space
  • Advanced Tips - Drillthrough
  • Advanced Tips - Date Hierarchy
  • Advanced Tips - Forecasting
  • Advanced Tips - Word Wrap, Mini Map and Advanced Editor Options
  • Advanced Tips - Format Painter
  • Advanced Tips - Bookmarks and Filters
  • Thank You!

Taught by

Bash (BizTech Matters)

Related Courses

Design Computing: 3D Modeling in Rhinoceros with Python/Rhinoscript
University of Michigan via Coursera
3D SARS-CoV-19 Protein Visualization With Biopython
Coursera Project Network via Coursera
Access Bioinformatics Databases with Biopython
Coursera Project Network via Coursera
Accounting Data Analytics
University of Illinois at Urbana-Champaign via Coursera
Lean Data Approaches to Measure Social Impact
Acumen Academy