Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +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 Hrs 52 Min
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!
You Might Also Be Interested In Our Comprehensive SQL Courses
- Microsoft SQL Database Design
- Introduction to Microsoft Power BI
- Querying SQL Server With T-SQL – Master The SQL Syntax
- Microsoft SQL Database Administration : Optimize Your SQL Server Skills
- Microsoft Server – SQL Data Analysis
- Microsoft SQL – SQL Big Data
- SSAS : Microsoft SQL Server Analysis Services
Key Term Knowledge Base: Key Terms Related to Microsoft Power BI
Understanding key terms in Microsoft Power BI is crucial for efficiently navigating and utilizing this powerful business analytics tool. These terms form the foundation of Power BI’s functionality and are essential for anyone looking to leverage Power BI for data analysis, visualization, and business intelligence.
| Term | Definition |
|---|---|
| Power BI Desktop | A free application installed on a local computer for designing and publishing reports to the Power BI service. |
| Power BI Service | A cloud-based service (SaaS) for viewing and interacting with Power BI reports. |
| DAX (Data Analysis Expressions) | A formula language used in Power BI for creating custom calculations in Power BI reports. |
| Power Query | A data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. |
| Data Model | The structure of a database, including tables, relationships, and keys, used to manage and organize data. |
| Visualization | The graphical representation of data in Power BI, including charts, graphs, and maps. |
| Dashboard | A collection of visualizations from one or more reports, displayed on a single canvas in Power BI. |
| Report | A collection of visuals, data models, and queries in Power BI. |
| Slicer | A Power BI feature for filtering data in reports or visualizations. |
| Dataset | A collection of data that you import or connect to. |
| Data Source | The original location from where data is imported into Power BI. |
| Power BI Pro | A subscription-based version of Power BI that offers additional features like sharing reports and collaboration. |
| Power BI Premium | An advanced version of Power BI that provides greater scale and performance for large organizations. |
| DirectQuery | A feature in Power BI that allows direct connection to a database, enabling real-time data updates. |
| Live Connection | A connection type in Power BI to directly connect to a data source, providing real-time data access. |
| Query Editor | A tool in Power BI for transforming and cleaning data before loading it into a data model. |
| Measures | Calculations used in data analysis, typically involving aggregations. |
| Power BI Mobile | An application for accessing Power BI reports on mobile devices. |
| Publish | The act of sending a Power BI report from Power BI Desktop to the Power BI service. |
| Data Refresh | The process of updating data in a Power BI report or dataset to reflect the latest information. |
This list covers the fundamental concepts and tools within Power BI and is a great starting point for anyone engaging with this powerful analytics platform.
ChatGPT can make mistakes. Consider checking important informat
Frequently Asked Questions About Introduction to Microsoft Power BI
What is Microsoft Power BI and How Does It Benefit Businesses?
Microsoft Power BI is a business analytics tool that allows you to visualize your data and share insights across your organization, or embed them in an app or website. It connects to a wide range of data sources and enables interactive dashboards and reports. Power BI helps businesses make informed decisions based on data-driven insights.
Can Power BI Integrate with Other Microsoft Products?
Yes, Power BI offers seamless integration with other Microsoft products like Azure, SQL Server, Excel, and Office 365. This integration enhances the analytics and reporting capabilities, allowing users to draw data from these services for more comprehensive insights.
Is Power BI Suitable for Non-Technical Users?
Absolutely. Power BI is designed with a user-friendly interface that is accessible for both technical and non-technical users. Its intuitive drag-and-drop features and simple data navigation tools make it easy for anyone to create reports and dashboards without advanced technical know-how.
What are the Different Versions of Power BI and Which One Should I Choose?
Power BI comes in various versions including Power BI Desktop (free), Power BI Pro (subscription-based), and Power BI Premium (for large-scale deployment). The choice depends on your needs; Power BI Desktop is suitable for individual users, Power BI Pro for collaboration among teams, and Power BI Premium for large organizations needing dedicated cloud resources.
How Secure is Data in Power BI?
Microsoft Power BI provides robust security features at every level, including data storage, data transmission, and user access control. It uses Azure Active Directory for identity management and allows administrators to control user access and permissions, ensuring that sensitive data remains secure.
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.
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
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
Get certified in Microsoft 70-463: Implementing a Data Warehouse with SQL Server with ITU Online. Get expert-led training and start your career today!
In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
$49.00
Learn how to develop cutting-edge web applications with Microsoft .NET 4.5 Programming and HTML5. Enroll now and get certified!
In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.
Mary Beth helped me. She was wonderful.