Microsoft Power BI Interactive Data Visualizations course image

Microsoft Power BI Interactive Data Visualizations

Turn CSV, TXT, Excel, and database data into reports and dashboards in Power BI Online by merging, grouping, summarizing, and calculating in Power BI Desktop.

$595.00

Description

Turn CSV, TXT, Excel, and database data into reports and dashboards in Power BI Online by merging, grouping, summarizing, and calculating in Power BI Desktop.

Price$595Per person
Time6 course hoursOn-demand video and labs, plus 1 hour of coaching
DeliveryOn-demand asynchronous trainingWith online support and 1 hour of coaching
CredentialCertificate of completionFrom We Can Code IT

About this course

This course takes you from scattered exports and text files to an online dashboard. You will bring CSV, TXT, and Excel files and a database table into Power BI Desktop, then merge, group, summarize, and calculate to get the numbers you need. You will build a report with slicers and publish a dashboard in Power BI Online that your team can use.

Who it is for

This course suits business managers, team leads, project managers, and analysts whose data lives in system exports, spreadsheets, and text files.

Prerequisites

Excel familiarity, including PivotTables

No prior Power BI experience is needed

Requirements

Requires a Windows PC

Power BI Desktop (free, Windows only)

A Microsoft work account with access to Power BI Online

Course data files and a sample database connection supplied by WCCI

What you will be able to do

  • You will be able to explain how Power BI Desktop and Power BI Online work together.
  • You will be able to import CSV, TXT, and Excel files with the correct delimiters, headers, and data types.
  • You will be able to connect to a database table or view and choose between import and DirectQuery.
  • You will be able to merge queries, group and summarize data, and add simple calculated columns and measures.
  • You will be able to build a report with slicers and publish a dashboard in Power BI Online.

Syllabus

1

Power BI Desktop and Power BI Online 0.5 hours

Power BI Desktop, Power BI Online, How the two connect.

Lab: You will open a finished report in Desktop and find the same report in Power BI Online.
2

Bring in CSV, TXT, and Excel Files 1 hour

Delimiters and headers, Data types, Excel worksheets, Repeatable imports.

Lab: You will import a CSV export, a TXT file, and an Excel worksheet and set them up to refresh.
3

Connect to a Database 1 hour

SQL tables and views, Import mode, DirectQuery in plain terms.

Lab: You will connect to a sample database view and add it alongside your file data.
4

Merge, Group, and Summarize 1.5 hours

Merge queries, Group By, Calculated columns, Simple measures.

Lab: You will merge your file and database data, group it by region and month, and add totals and averages.
5

Build the Report 1 hour

Core visuals, Slicers, Summary page.

Lab: You will build a one-page summary report with slicers for date and region.
6

Publish and Build a Dashboard in Power BI Online 1 hour

Publishing, Dashboard tiles, Mobile view.

Lab: You will publish your report, build a dashboard in Power BI Online, and check its mobile layout.
+

Coaching sessions 1 hour

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 1 hour of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

Microsoft Power BI Interactive Data Visualizations

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

This price is within TechCred's maximum of $1,000 per person, per credential.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.

Syllabus