Skip to content

Data Engineering & Analytics

Data Analytics with PowerBI

Available in:Remote

UCI:3030

Live and Instructor-Led

Course fee
No-Cost
Course level
Intermediate
Length
10 weeks
Training hours
90
Prerequisites
Must be a Per Scholas Alumnus

Course Overview

Embark on Data Analytics with Power BI (UCI 3030), a 10-week course designed to equip learners with essential skills in data analytics. Explore the fundamentals of relational databases and SQL while gaining proficiency in querying and data manipulation.

Additional Info

What You'll Learn

Upon successful completion of all course requirements, learners will:

  • Apply fundamental principles of relational databases, utilizing SQL to retrieve and manipulate data effectively.
  • Optimize database performance through advanced SQL techniques, including creating indexes for efficient query processing.
  • Implement key constraints for data integrity and design triggers to automate actions, ensuring a robust and secure relational database management system.
  • Create database views for simplified data access and to enhance overall database management.
  • Utilize statistical measures of variability to analyze data.
  • Navigate the Power BI Desktop interface proficiently, connecting and shaping data for meaningful analysis.
  • Explore data visualization using Power BI, creating visually compelling and informative reports to convey insights effectively.
  • Write Data Analysis Expressions (DAX) for calculated columns and measures and demonstrate proficiency in advanced data analysis techniques.
  • Apply a systematic approach to various types of data analysis, utilizing appropriate tools and techniques to extract meaningful insights from diverse datasets.
  • Develop the ability to conceptualize data analysis as a continuous and iterative process, recognizing the importance of refining strategies based on ongoing insights and feedback.
StartsApply byEndsWeeksMeets
Oct 20, 2026Oct 6, 2026Jan 15, 202710Tuesday, Thursday6:00 PM – 9:00 PM ET
Nov 16, 2026Nov 2, 2026Feb 5, 202710Monday, Wednesday, Friday6:00 AM – 9:00 AM ET
Nov 24, 2026Nov 10, 2026Feb 12, 202710Tuesday, Thursday4:30 AM – 9:00 AM ET

Related Courses

  • Gain an immersive understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job. Understand how to clean and organize data for analysis, learn key analytical skills (data cleaning, analysis, & visualization) and tools (spreadsheets, SQL, R programming, Tableau) and how to visualize and present data findings in dashboards and presentations.

    No-CostRemote26 weeks260 training hoursGoogle Data Analytics
  • Transform raw data into powerful business insights. Master the tools and critical thinking skills that solve today's complex business problems.

    No-CostRemote9 weeks25 training hours
  • The Business Intelligence Analyst (UCI 3088) learning plan combines cutting-edge methodologies like Enterprise Design Thinking with essential technical skills in data analysis, visualization, and business strategy. Participants will gain a comprehensive toolkit to analyze data, create actionable insights, and drive meaningful outcomes in today's competitive business landscape.

    No-CostRemote6 weeks50 training hours
  • Use Big Data methodologies to collect and analyze large amounts of data from different sources, using IBM Watson Studio and open-source tools. Achieve advanced proficiency in topics such as Apache Hadoop, Ambari, MapReduce, Spark, Mlib ZooKeeper, Big SQL, HDFS, YARN, and HBase.

    No-CostRemote10 weeks80 training hours