Note!: Check the Quality of Premium Courses Before Paying Thousands of Dollars for just $9.99 or Lifetime Membership for just $20 Click Here

Power BI and Dashboards for the Busy Professional

Self-service Business Intelligence with complex, insights-rich, interactive reports and dashboards in Power BI Pro

Beginner 5(212 Ratings)
Created by Editiorial Team Last updated Thu, 28-May-2020 English

Power BI and Dashboards for the Busy Professional Free Tutorial Download



What will i learn?
  • Microsoft Power BI for data analysis
  • Business Intelligence
  • Data Analysis

Curriculum for this course
1 Lessons 00:00:00 Hours
Download Section
1 Lessons 00:00:00 Hours
  • Here
Requirements
  • Familiarity with Microsoft Excel
  • Some basic data analysis exposure
+ View more
Description

**We give participants access to a shared Power BI pro account so they can practice all the full aspects of Power BI. We also do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!**

This course is a fully hands-on one to take you from just having an idea of what Power BI does to being able to create insights-rich and interactive reports/dashboards in Power BI that can drive business process and report automation and take you from just data analysis level to Business Intelligence (BI).


We cover the following aspects:

Get Data (bringing in your data for analysis)

  • Data Sources in Power BI Desktop

  • Connect to web data and web apps

  • Import Excel Workbooks

  • Connect to enterprise Database


Data Transformation, Power Query and DAX

  • Get Data

  • Model section of the report builder (Power BI Desktop)

    • Creating Relationships

    • Cardinality

    • Direction

  • Data section of the report builder (Power BI Desktop)

    • Data Type

    • Data Format

    • DAX

      • New Column

      • New Measure

      • New Table

      • Must know DAX formulas

      • DAX formula reference guide

    • Row level Security to control report access using roles (dept, function, branch, cost centre etc)

  • Report section of the report builder (Power BI Desktop)

    • Report creation

    • Native Visuals

    • Custom Visuals

    • Menu Tools for professional looking reports

    • Edit Interactions

    • Report creation from scratch

  • Power Query

    • Transforming and Combining Data before loading to Model

    • Common Power Query tasks

      • Unpivot

      • Pivot

      • Split Column

      • Append Tables

      • Merge Tables

      • Remove rows

      • Use first row as header

      • Merge Columns

      • Add Columns

      • Group By

      • Extract

      • Fill

      • Transpose

      • M Code reference resource


Report Publishing, Dashboards and Power BI Service

  • Understanding the concept of Workspaces

  • Publishing report (from Power BI desktop to Power BI service for consumption)

  • Controlling access to aspects of the report by role (region, department or level)

  • Published Report options

    • Exporting to PowerPoint or PDF

    • Embedding in SharePoint

    • Embedding in a website

    • Making it available via a web link

    • Sharing with specific users

    • Editing the report – adding new visuals, changing visuals used and creating new report pages

    • Adding comments and tagging users

    • Scheduling the report to send our daily or weekly to specific people

  • Creating a Dashboard

    • Can be created from one or more reports to show management useful analysis

    • Can incorporate data and visuals from other people’s dashboards or reports shared with you

    • Set Alerts to be instantly notified when a KPI is reached or an SLA is breached

    • Add actionable comments

    • Schedule the dashboard to be sent out daily or weekly to specific people

    • Share the dashboard with final users

  • Best practices

  • Setting automatic/scheduled refresh so new data is ingested automatically

  • Data Gateway configuration

    • The type of data sources that require data gateway


AI in Power BI and Settings

  • Q&A for autogenerating charts and tables in answer to questions

  • Organization wide settings

  • Account wide settings

  • Workspace settings

  • Dashboard settings

  • Report settings

  • Datasets settings


This is the course to solidify your Power BI proficiency.

Who this course is for:
  • Data Analysts
  • MIS Analysts
  • Financial Analysts
  • Project Managers
  • Supply Chain Analysts

Download Power BI and Dashboards for the Busy Professional Free


+ View more
Other related courses
00:00:00 Hours
0 5 Free
00:00:00 Hours
0 11 Free
00:00:00 Hours
Updated Tue, 12-May-2020
0 5 Free
00:00:00 Hours
0 6 Free
00:00:00 Hours
Updated Fri, 22-May-2020
0 1 Free
00:00:00 Hours
0 3 Free
00:00:00 Hours
0 5 Free
00:00:00 Hours
0 0 Free

Comments

About the instructor
  • 25 Reviews
  • 1575 Students
  • 585 Courses
+ View more
Tutsmonk is a learning platform which providers free courses to students and seekers

This is a website related to tutsmonk

Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
Free
Latest Added Course List
Benefits of Membership:
  • Instant access
  • Access premium content!
  • Lifetime member
  • Email and chat support
  • Mega/google drive downlod links
  • No limit on download
  • We care 100% about our members success !
Join Our Telegram Channel

Get Latest Course Update