- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Introduction to Microsoft Power BI
This online course training will teach you how to use Power Apps visualizations, which allow your Business Analysis users to get Business Analytics and take actions from their Power BI reports in real-time. Moreover, we’ll look into the ways that Power BI and SQL Server Analysis Services can be integrated for enterprise-level data models and analysis for business decisions.Â
Included In This Course
Included In This Course
10 Training Hours
65 On-demand Videos
Closed Captions
11 Topics
75 Prep Questions
Certificate of Completion
Course Description
What is Power BI?
Power BI is a member of the Power Platform. Power BI is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your Power BI Dashboard Business users to derive business insights and take actions from right within their Power BI reports and dashboards, essentially your business intelligence platform. Finally, this Introduction to Microsoft Power BI course will explore the intersections between Power BI and Microsoft’s enterprise-level data modeling and analysis platform, SQL Server Analysis Services.
About this video course
Through this course you will have access to hours of video content and will learn the varied techniques and best practices that adhere to business intelligence skills and technical requirements for utilizing Power BI and develop interactive visualizations. In addition, as a Business analysts you’ll be given a comprehensive overview of how to access data from various sources–both relational or non-relational. Finally, students we’ll learn key concepts to explore ways on how to manage and deploy reports as well as dashboards in order to share your insights with others effectively.
Power BI Course Topics Objectives
- Make the most of Power BI’s data by ingesting, streamlining, and transforming it
- Leverage Advanced Power of model data to optimize your performance and scalability
- Develop and generate reports for data examination, allowing you to make well-informed decisions
- Leverage advanced report analytics to make sound decisions
- Improve business processes and easily distribute and collaborate on reports with colleagues
- Unleash the power of Power BI to produce stunning paginated reports!
Frequently Asked Questions About Introduction to Microsoft Power BI
What exactly will I learn in this course?
You’ll learn how to use Power BI’s data by ingesting, streamlining, and transforming it. You’ll develop and generate reports for data examination, learn to make well-informed decisions, and improve business processes. The course also includes creating Power App visuals, managing and deploying reports, and integrating Power BI and SQL Server Analysis Services​.
I’m a beginner. Is this course suitable for me?
Yes! This course is designed to introduce you to Microsoft Power BI. It covers a wide range of topics, from the basics of data preparation and loading, to creating reports and dashboards, and even advanced analytics. So, whether you’re a beginner or someone looking to expand their knowledge of Power BI, this course has something for you.
Who’s going to be teaching me?
The course is taught by James Ring-Howell, a full-stack developer with over 40 years of experience. James has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. He has also been teaching technology courses for over 20 years.
How is the course structured?
The course is divided into 11 modules, each focusing on a specific topic. Modules cover everything from preparing and loading data, designing a data model, creating model calculations using DAX, creating reports and dashboards, creating paginated reports, performing advanced analytics, creating and managing workspaces, creating Power App visuals, and integrating Power BI with Analysis Services.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
Introduction to Microsoft Power BI Course Content
Module 1 - Prepare Data
1.1 Course Introduction
1.2 Module 1 Introduction
1.3 Introduction to Power BI
1.4 Get data from various data sources
1.5 Preview source data
Module 2 - Clean, Transform, and Load Data
2.1 Module 2 Introduction
2.2 DimEmployee Example
2.3 DimEmployeeSalesTerritory Example
2.4 DimReseller Example
2.5 FactResellersSales Example
2.6 ResellerSalesTargets Example
2.7 Color Formats Example
Module 3 - Design a Data Model
3.1 Module 3 Introduction
3.2 Introduction to Data Modeling
3.3 Model Relationships
3.4 Table Configuration
3.5 Model interface
3.6 Quick Measures
3.7 Many-to-many relationships
3.8 Row-level security
Module 4 - Create Model Calculations using DAX
4.1 Module 4 Introduction
4.2 DAX context
4.3 Calculated Tables
4.4 Calculated Columns
4.5 Managing Date Tables
4.6 Measures
4.7 Filter Manipulation
4.8 Time Intelligence
Module 5 - Create Reports
5.1 Module 5 Introduction
5.2 Basic Report Creation
5.3 Example Page 1
5.4 Example Page 2
5.5 Example Page 3
5.6 Report Publishing
5.7 Enhancing Reports
5.8 Drill-Through Pages
5.9 Conditional Formatting
5.10 Buttons and Bookmarks
Module 6 - Create Dashboards
6.1 Module 6 Introduction
6.2 Dashboard Basics
6.3 Real Time Dashboards
6.4 Enhanced Dashboards
Module 7 - Create Paginated Reports
7.1 Module 7 Introduction
7.2 Introduction to Power BI Report Builder
7.3 Report Layouts
7.4 Report Data
7.5 Report Tables
Module 8 - Perform Advanced Analytics
8.1 Module 8 Introduction
8.2 Introduction to Advanced Analytics
8.3 Scatter Chart
8.4 Forecast
8.5 Decomposition Tree
8.6 Key Influencers
Module 9 - Create and Manage Workspaces
9.1 Introduction to Workspaces
9.2 Working with Workspaces and the Portal
Module 10 - Create Power App Visuals
10.1 Module 10 Introduction
10.2 Introduction to Power Apps Visual
10.3 Creating the App
10.4 Basic Power Apps Concepts
10.5 Refreshing the Report
Module 11 - Analysis Services and Power BI
11.1 Module 11 Introduction
11.2 Introduction to Analysis Services
11.3 Connecting with Multidimensional Models
11.4 Premium Workspaces and Analysis Services
11.5 Course Wrap Up
Your Training Instructor
James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.
$49.00
OR
Subscribe To All-Access
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
$49.00 $14.99 Monthly
Introduction to Microsoft Power BI
Introduction to Microsoft Power BI
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$49.00
Master the skills to effectively manage SQL Server with our Microsoft 70-764 training course. Get started today!
The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.
$49.00
Master the skills to become a Microsoft Certified Solutions Associate with our 70-462 Administering SQL Server course. Enroll now and start your journey!
In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
$49.00
Enhance your web dev skills with our CSS online course. From basic concepts to advanced techniques, everything you need to know to create stunning websites.
Cascading Style Sheets (CSS) provides the ability to create visually pleasing and sophisticated websites. In this CSS3 Training course, users at all levels will be instructed on how to use it effectively with ease.
I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.