Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Microsoft Power BI

Version 2013 • 2016

2 Days, 9:00-4:00, 12 Hours

Microsoft Power BI is a robust analytics solution used to transform your data into powerful and rich visuals. You can view your entire business on a dashboard, create stunning interactive reports, and view your data consistently across your organization. Softek's 2-day course covers how to use Power BI components to bring your data to life and focus on what matters to you.

Introduction to Power BI Desktop

  • Learn the BI interface
  • Navigate the BI window
  • Upload data
  • Create visuals
  • Column charts
  • Maps
  • Cards
  • Create and modify reports
  • Import data

Loading Data with Power BI Desktop

  • Understand data sources
  • Load data
  • Refresh data
  • Reuse recent data sources
  • Pin data sources
  • Understand connection security

Transforming Datasets

  • Work in the query editor
  • Understand applied steps
  • Dataset shaping
  • Rename
  • Reorder
  • Merge columns
  • Filter data
  • Text ranges
  • Numeric ranges
  • Date/time ranges

Text-Based Visualization

  • Create tables
  • Create metrics
  • Create cards
  • Create multi-row cards
  • Enhance visuals

Charts in Power BI

  • Create charts
  • Pie
  • Donut
  • Funnel
  • Waterfall
  • Customize chart attributes
  • Use drilldowns
  • Create Bing maps
  • Use geographic data
  • Use gauges

Filtering Data

  • Filter different data types
  • Work with advanced text filters
  • Understand visual levels
  • Remove filters

Using Slicers

  • Create slicers
  • Format slicers
  • Use charts as slicers

 

Cleansing Data

  • Change data types
  • Detect data types
  • Replace values
  • Fill down
  • Group records

Data Mashup

  • Duplicate columns
  • Split columns
  • Customize columns
  • Aggregate data
  • Append data
  • Change data structure
  • Modify/rename/delete steps
  • Manage queries

Extending the Data Model with Calculated Columns

  • Concatenate columns
  • Build calculations across tables
  • Work with If and nested If statements
  • Understand and utilize DAX
  • Work with measures

Enhancing your Dashboard

  • Add textboxes
  • Modify page background
  • Add shapes
  • Organize visuals on the page
  • Export data from a visualization

Creating a Data Model

  • Format data fields
  • Apply a default summarization
  • Add hierarchies
  • Build relationships between tables
  • Deactivate relationships
  • Examine relationship options

PowerBI.com

  • Publish reports
  • Interact with reports
  • Create dashboards
  • Share dashboards
  • Create new reports

 

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

 

Investment

Public Class

$950 per student

 

Private Group Classes

Conducted at Your Office

$5700 flat fee for up to 6 students

$600 per additional student

Conducted at Softek's Facility

$6000 flat fee for up to 6 students

$600 per additional student

View Schedule or Register

Why choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee