Power BI Data Analysis & Visualization Training

Power BI Data Analysis & Visualization Training Course Power BI Data Analysis & Visualization Training
By TED Integrated
Business Intelligence:

Analyzing & Visualizing Data using Power BI

“Learn to publish reports to the Power BI service that allows business users to consume dashboards through the web and their mobile devices.”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Analyzing & Visualizing Data using Power BI
Training Category:
Information Technology
Target Audience:
This course is for participants whose job responsibilities include creating Excel reports, clean & analyze data as well as conducting analytics and data science.
Duration:
2 Days
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Reading Materials
  • Computer Lab Work
  • Lecture
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This course is taught to publish those reports to the Power BI service, create dashboards, and share to business users so that they can consume the dashboards through the web and their mobile devices. Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. With Power Query, non-technical Excel users can access large corporate and Internet-based databases to conduct analysis and produce reports.

Power Query is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016.

Course Objectives ›

After completing this Power BI course, participants should be able to:

  • Import Data from several of the data source.
  • Structure unstructured data (Data Cleansing)
  • Prepare data for analyzing and visualizing.
  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.

Prerequisites ›

Excel Introduction or Intermediate Level. Previous experience with database concepts is helpful but not required. Basic exposure to programming constructs (such as looping and branching).

Course Outline ›

DAY 1

Module 1: Introduction to Power Query

  • Installing Power Query
  • Creating a Simple Query
  • Editing a Simple Query

Module 2: Common Data Import Sources

  • Working with CSV files
  • working with Text Files
  • Working with Excel Files
  • Working with other file types

Module 3: Working with Data from the Web

  • Scraping Data from Web Pages
  • Calling a Web Service
  • Finding Data Using a Power Query Online Search

Module 4: Working with Folders and Multiple Files

  • Working from Data from the Windows File System
  • Combining Data from Multiple Files

Module 5: Filtering and Sorting Rows

  • Using Auto-Filter
  • Using Number, Text and Date Filters
  • Filtering Rows by Range
  • Removing Duplicate Values
  • Filtering out Rows with Errors
  • Sorting

Module 6: Changing Values in a Table

  • Replacing Values
  • Text Transformations
  • Number Transformations
  • Date/Time Transformations
  • Replacing Missing Values

Module 7: Table Transformations

  • Unpivoting Columns to Rows
  • Transposing a Table
  • Creating Custom Columns
DAY 2

Module 1: Introducing Power BI

  • Getting started with Power BI
  • Uploading data to Power BI
  • Introducing natural-language queries
  • Introducing Quick Insights
  • Introduction to reports
  • Introducing Visual Interactions
  • Decorating the report
  • Saving the report
  • Pinning a report
  • Filtering a report
  • Module 2: Sharing the dashboard

    • Inviting a user to see a dashboard
    • Inviting users outside your organization
    • Creating a group workspace in Power BI
    • Turning on sharing with Microsoft OneDrive for Business
    • Viewing reports and dashboards on mobile devices

    Module 3: Using Power BI Desktop

    • Connecting to a database
    • Loading from multiple sources
    • Using Query Editor
    • Hiding or removing tables
    • Handling seasonality and sorting months

    Module 4: Improving Power BI reports

    • Choosing the right visualizations
    • Choosing between standard visuals
    • Using custom visualizations
    • First steps with custom visualizations
    • Improving reports by using custom visualizations
    • Identifying conditions when custom visualizations are required
    • Using DAX in data models
    • Creating high-density reports

    Module 5: Power BI and Excel

    • Excel and Power BI
    • Import an Excel table into Power BI
    • Import Excel files with data models and Power View sheets
    • Connect OneDrive for Business to Power BI
    • Excel data in Power BI summary

    Contact us now ›

    • Course content customization
    • In-house training request
    • Available public program
    • Consultation services
    • Other inquiries
    Contact Customer ServiceCall : +603-2386-7788
    Email Customer Service E-mail : [email protected]

    Related Courses ›

    Published by: ,