Master in Microsoft Power BI Desktop and Service
Enhance your skills with comprehensive knowledge on Power BI Desktop, Power BI Online, and the required hands-on experience to solve real-time industry-based Power BI projects
Updated on Oct, 2023
Language - English
Duration -7 hours
This course is for individuals looking for jobs as business analysts, business development managers, data analysts, and reporting professionals, especially in the business intelligence domain. Apart from this, statisticians aiming to implement their statistics skill to derive business insights and marketing, finance, sales, and other domain professionals who need extensive business intelligence will also benefit.
Power BI is a business intelligence tool by Microsoft that provides analytics services. It provides interactive dashboards and visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves without having to depend on anyone else, as Power BI’s artificial intelligence is there to help you out. Power BI provides cloud-based BI services, known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers data modeling capabilities along with data preparation, data discovery, and interactive dashboards.
In this course, you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services. You’ll start with learning how to connect Power BI to different data sources. Then you’ll be able to transform your data using Power Query and create data models.
After this, you’ll also level up your data analysis skills using DAX and create calculated columns and measures. With the help of reports and visualization in Power BI, you’ll be able to present your data in an efficient and interactive way. And lastly, you’ll learn how to publish your reports and dashboards to the Power BI online service.
By the end of this course, you’ll be able to excel at your career as a business intelligence and data analyst professional.
What will you learn in this course:
- Learn how to connect Power BI to different data sources
- Transform your data using Power Query and create data models
- Learn data modeling concepts to find correlation in data
- Level up your data analysis skills using DAX and create calculated columns and measures
- Present data effectively and interactively using reports and visualization
- Publish your reports and dashboards to the Power BI online service
What are the prerequisites for this course?
- Microsoft Power BI Desktop installed on your computer (which is free) along with a basic understanding of Microsoft Excel will be beneficial but is not mandatory.
Check out the detailed breakdown of what’s inside the course
Business Intelligence Concepts and Introduction
- Introduction to Business Intelligence 05:00 05:00
- The Relation Between Business Intelligence and Data Warehouse 04:10 04:10
- Power BI Overview and Installation 02:25 02:25
- Introduction to Power BI Desktop 08:52 08:52
Connecting Power BI with Different Data Sources
Power Query for Data Transformation
Power BI Data Modeling – Relationship View and PowerPivot
Data Analysis Expression (DAX)
Reports and Visualization Types in Power BI
Power BI Publishing - Reports
Founded in 2004 in Birmingham, UK, Packt's mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.
Working towards that vision, we have published over 6,500 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done - whether that's specific learning on an emerging technology or optimizing key skills in more established tools.
As part of our mission, we have also awarded over $1,000,000 through our Open Source Project Royalty scheme, helping numerous projects become household names along the way.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Master prominent technologies at full length and become a valued certified professional.Explore Now