Introduction to Power BI Desktop
Learn to use Power BI Desktop to explore, analyze and visualize your data to make data driven business decisions
Upcoming Session
October 03 – 07
Live instructor-led training: 9am – noon PDT
Live office hours and support daily.
Trusted by Leading Companies
HANDS-ON LEARNING
Introduction to Power BI Desktop
This course will help you become proficient in Power BI by guiding you through an end-to-end process of turning your raw data into insightful reports.
Learn how to pre-process, address data quality issues, filter, and transform your data and build up clear, detailed, and interactive visualizations to carry out your analysis. This comprehensive course will be the best aid for analysts, researchers, data scientists, and anyone who wants to extract meaning from their data.
START FROM GROUND UP
Designed for Both Practitioners and Beginners
From the basics of installing Power BI on your system to building your own interactive dashboards, this course covers everything!
Worried about not having a lot of prior knowledge before diving into the world of Power BI? This course ensures that your foundation is crystal-clear. And for practitioners, the knowledge and confidence you gain will help you apply these same concepts to your own Power BI projects.
COMPLETE LEARNING ECOSYSTEM
Instructor-Led Training, Office Hours, Mentoring, and More
- Instructor-led, live training
- Daily, live office hours for Q&A
- Knowledge tests to assess your skill
- Portfolio project to showcase your work
- One-year access to all supplementary learning material
- Verified certificate from The University of New Mexico Continuing Education
Curriculum
What is Power BI & Power BI Desktop
Microsoft Power BI is a business intelligence tool that connects to various sources of data and builds coherent, visually immersive, and interactive visualizations making it easy to harvest insights.
Whether your data is in a simple Microsoft Excel workbook, a CSV file or in a collection of cloud-based and on-premises data warehouses, Power BI lets you easily connect, transform, model and visualize your data to derive actionable insights.
In this module, you will learn:
- What is Power BI and the business value of using Power BI
- Install and run Power BI Desktop
- Key components
- Explore regional settings
- Power BI features and workflow
Shaping data with Power BI Desktop
With Power BI Desktop, you can connect to many different data sources using its in-built data source connectors. Once the data is loaded, Power Query, the data transformation, and the data preparation engine behind Power BI help in transforming your data with the aid of a user-friendly set of ribbons, menus, buttons, and other interactive components. Power Query extends the same data transformation capabilities across all data sources.
In this module, you will learn
- Different types of data connectors
- To connect to data sources (Microsoft Excel, CSV, PBDIS)
- Data profiling (Column Quality, Distribution, and Profile)
- Basic transformations (changing data types, dealing with null values, errors, and other data quality issues)
- Index and conditional columns, and columns from example.
- Grouping and aggregating data
- Pivoting and unpivoting
- Merging and appending queries
- Using Power Query editor to shape and transform data
What is data modeling?
Data modeling is analyzing and defining all the different data from various data sources and defining the relationships between those bits of data.
With Power BI Desktop, you can combine different sources of data using relationships to form a unified data model to create visuals and reports. A relationship in a data model defines how different data sources are linked to each other like how relationships are in a relational database.
Building a great data model is about simplifying the disarray. A star schema is one way to simplify a data model, and you’ll learn how to implement this in your data model along with creating custom fields and values (known as calculated columns and measures) using Data Analysis Expressions (DAX) which is a programming language used in Power BI.
In this module, you will learn
- What is a data model
- Creating table relationships
- Managing relationships
- Relationship cardinality
DAX overview
Data Analysis Expressions (DAX) is the language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.
In this module, you will learn
- Creating DAX tables, columns, and measures
- DAX operators
- Basic math & statistic functions
- Basic date & time functions
- Text functions
- Using calculate & filter functions
Visualizing data with Power BI reports
Visualizing data with Power BI reports:
Power BI helps users easily analyze and visualize their data using a variety of visuals, bringing data to life, and drive better business decisions.
In this module, you will learn
- About the many in-built visualizations Power BI offers and their uses.
- Build basic visuals such as bar chart, line chart, hierarchy chart, sankey chart, etc.
- Building AI reports.
- Filtering, slicing, and drilling reports to analyze them
Earn a Verified Certificate
In association with
Earn a Power BI certificate from the University of New Mexico, verifying your skills. step into the market with a proven and trusted skillset.
Recommended by Working Professionals
Information Technology and Services
Harris Thamby | Microsoft
Iyinola Abosede-Brown
KPMG
Dylan Pierce
RVSHARE
Vishal Arora
Unisys
Taught by Practitioners
Our instructors are dedicated to helping you steer your career. With years of experience in the field, our instructors are professional data scientists and practitioners. They bring real-world stories and anecdotes to the class, adding immense value to your learning.
Learning Plan
10% OFF
Training Plan
$899
$999
- Pre-training material
- 15 hours of live instructions
- In-class learning material
- Daily office hours
- Learning platform access for 6 months
Add-on
Certification
$249
- Microsoft PL-300 exam coupon worth USD 165
- Verified certificate from The University of New Mexico
FAQs
Access to the program content depends on the plan you choose at the time of registration. Learn more about different plans here.
Introduction to Power BI is a 5 day long, 3 hours per day, for a total of 15 hours of training.
Classes are live and instructor-led. Office hours will be available for 5 days of the training in case students need assistance. Lectures will also be recorded to give students the option to go back and review.
The cost will depend on the plan purchased by the students and the discounts available at the time.
Please contact us at [email protected] for updated information on discount availability and payment plans.
We offer a learning plan with an optional add-on for this training.
- Training Plan. With this plan, you will get 15 hours of live training, pre-training material, downloadable Power BI file, learning platform access for 6 months and daily office hours during the training period.
- Certification Add-on. With this add-on, you will get one Microsoft PL-300 exam coupon and a verified certificate from The University of New Mexico worth 2 Continuing Education credits.
* The add-on can only be purchased with the Training Plan
Yes, we are offering an early-bird discount on the Training Plan.
To register for the program, simply view our packages and register for the upcoming cohort. The payment can be made online on our website, via invoice, or wire transfer.
Once you are registered for the program, you will receive a few emails from us. One of those emails will contain steps to create your learning portal account and access the program content.
Please follow the steps in the email to create your account. If you’re facing any difficulty please email us at [email protected] for assistance.
Get in touch
Feel free to ask questions or share your comments with us. We’ll get back to you soon.
You can also reach out to us by phone or email.
If you want to learn more about our trainings, register for an online info session.