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.
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
Power BI Desktop and Power BI Online 0.5 hours
Power BI Desktop, Power BI Online, How the two connect.
Bring in CSV, TXT, and Excel Files 1 hour
Delimiters and headers, Data types, Excel worksheets, Repeatable imports.
Connect to a Database 1 hour
SQL tables and views, Import mode, DirectQuery in plain terms.
Merge, Group, and Summarize 1.5 hours
Merge queries, Group By, Calculated columns, Simple measures.
Build the Report 1 hour
Core visuals, Slicers, Summary page.
Publish and Build a Dashboard in Power BI Online 1 hour
Publishing, Dashboard tiles, Mobile view.
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.
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.