Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn

Advanced MS Excel Training
​(1 Day Compressed)

LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL INQUIRE@INSIGHTSMANILA.COM

MS PowerBI for Beginners

This training includes a thorough review of the basics of MS Power BI in connecting and transforming data, performing basic DAX calculations, and presenting in charts.

Part 1.  The PowerBI Interface
•Setting Up PowerBI for First Time Use
•Understanding the PowerBI Interface

Part 2.  Connecting Data
•Using the Query Editor
•Number-Specific Tools
•Date-Specific Tools
•Index Columns
•Conditional Columns
•Grouping Data
•Merging and Appending Queries
•Importing Data Using Folder Approach
•Managing Data Source Settings
•Formatting Data
•Defining Hierarchy

Part 3.  Data Modeling
•Creating Table Relationships
•Hiding Fields in Report View
•Analyzing Power BI Data using DAX Calculations
•Creating Calculated Columns
•Creating Measures
•DAX Syntax
•Common DAX Functions

Part 4.  Data Visualization
•Adding Simple Objects to the Power BI Canvas
•Basic Charts and Formatting Options
•Report Filtering Options
•Visualization
•Matrix Visuals
•Date Slicers
•Cards and KPI Visuals
•Geospatial Data and Mapping
•Showing Trends with Line and Area Charts
Report Interactions
•Publishing Reports

Join a public class

Home

Courses

Public Classes

Contact

Copyright © 2022