Microsoft Power BI

This Hands-On course on Data Analysis is designed to equip you with the practical skills and mastery of the working domain and features of
Power Business Intelligence –
Power BI

Power BI Course Overview

This is a beginner-to-intermediate level Power BI course that aims to expose learners to the Power BI environment, and lay a solid foundation in building simple and complex, impactful, interactive dashboards. It is specially designed for professionals looking for a practical, hands-on, and highly engaging approach to learning business intelligence with Power BI Desktop.

POWER BI Course Key Features

Course Benefits

29078117_1656495026ZGgfinancial-profit

This course is designed to get you up & running with Power BI Desktop

29078026_1656494719P98certificate

Helps you unlock better business practices with simple-to-use functionality

29078063_1656494855FGenetworking

Work opportunities in a spectrum of industries

29078281_1656495525sU5agile_1

Make accurate data-driven business decisions

29078307_1656495599971community

Certificate of Completion from BNET Learning

NEXT BOOTCAMP STARTS

On January 21st, 2023

View the schedule and register now.
We will reach out to you with more information.
  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

TRAINING MODEL

Instructor-led Virtual Classes: This has participants virtually joining other participants in a facilitated intensive class. BNET Learning offers a small class learning environment led by experienced, certified and expertly trained instructors.

Advance your knowledge by taking the Data Analysis Training Using Power BI at a competitive price.

COURSE REQUIREMENTS

  • Who can take this course? – Anyone with a keen interest in learning Data Analysis & Visualization.
  • No prior knowledge or experience is needed.

WHY TRAIN WITH BNET LEARNING?

  • We have trained over 1000 professionals.

  • We parade a well-bred, highly skilled and experienced team of professionals.

OBJECTIVES

  • This course is designed for business professionals who want to analyze and visualize data using Power BI. 
  • In this course, you will learn how to use Power BI to create reports and dashboards that help you understand your data. 
  • You will learn how to connect to data sources, create data models, and create reports and dashboards.
  • You will learn how to use data analysis features to get insights from your data.
  • You will learn how to create visualizations, share your work, and collaborate with colleagues.
  • This course is not available for self-study. Please enroll in one of our upcoming live, instructor-led boot camps to attend.

CURRICULUM

BEGINNER

Lesson 1: Getting to Know Data Analysis
  • Overview of Data Analysis
  • Roles in Data
  • Tasks of a Data Analyst
  • Knowledge Check
  • Lesson Summary
Lesson 2: Introduction to Power BI
  • Meet Power BI
  • Downloading Power BI and adjusting settings/region
  • Power BI interface and workflow
  • Building blocks of Power BI
  • Knowledge Check
  • Lesson Summary
Lesson 3: Get Data in Power BI
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
Lesson 4: Clean, Transform, and Load Data in Power BI
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
Lesson 5: Design a Data Model in Power BI
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
Lesson 6: Introduction to Creating Measures Using DAX In Power BI
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
Lesson 7: Work with Power BI visuals
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
Lesson 8: Create a Data-Driven Story with Power BI Reports
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
Lesson 9: Create Dashboards in Power BI
  • Getting data from files, relational data sources, NoSQL database, from online sources, azure analysis services
  • Selecting a storage mode
  • Fixing performance issues
  • Resolve data import errors
  • Quiz, Practice Questions and Take-Home assessment
  • Summary
  •  

INTERMEDIATE

Lesson 1: More DAX functions
  • Use the Calculate function
  • Use relationships effectively
  • Create semi-additive measures
  • Work with time intelligence gregations
  • Quiz, Practice Questions, and Take-Home assessment
  • Summary
Lesson 2: Optimize a Model for Performance in Power BI
  • Introduction to performance optimization
  • Review performance of measures, relationships, and visuals
  • Use variables to improve performance and troubleshooting
  • Reduce cardinality
  • Optimize DirectQuery models with table-level storage
  • Create and manage aggregations
  • Quiz, Practice Questions, and Take-Home assessment
  • Summary
Lesson 3: Create paginated reports
  • Introduction to paginated reports
  • Get data
  • Create a paginated report
  • Work with charts on the report
  • Publish the report
  • Quiz, Practice Questions, and Take-Home assessment
  • Summary
Lesson 4: Perform Analytics in Power BI
  • Introduction to analytics
  • Explore statistical summary
  • Identify outliers with Power BI visuals
  • Group and bin data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Use advanced analytics custom visuals
  • Review Quick insights
  • Apply AI Insights
  • Quiz, Practice Questions, and Take-Home assessment
  • Summary
Lesson 5: Work with AI visuals in Power BI
  • Introduction to working with AI visuals
  • Use the Q&A visual
  • Find important factors with the key visual influencers
  • Use the Decomposition Tree visual to break down a measure
  • Quiz, Practice Questions, and Take-Home assessment
  • Summary
Lesson 6: Create and Manage Workspaces in Power BI
  • Introduction
  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection
  • Quiz, Practice Questions, and Take-Home assessment
  • Summary
Lesson 7: Manage Datasets in Power BI
  • Create dynamic reports with parameters
  • Create what-if parameters
  • Use a Power BI gateway to connect to on-premises data sources.
  • Configure a dataset scheduled refresh
  • Configure incremental refresh settings
  • Manage and promote datasets
  • Troubleshoot service connectivity
  • Boost performance with query caching (Premium)
  • Quiz, Practice Questions and Take-Home assessment
  • Summary

Frequently Asked Questions (FAQs)

Will a certificate be offered at the end of this course?

Yes, a certificate of completion from BNET Learning will be issued at the end of this course.

Is Power BI a big data analytics tool?

Yes, Power BI can not only help us generate quick analytics and insights but also help with large-scale real-time analytics on large amounts of data.

Do you offer data analysis training with other tools?

Yes, we have an advanced training package called Comprehensive Data Analysis Using Power BI & Tableau.

Is this a physical or online class?

All our classes are virtual, instructor-led classes

Do you offer corporate training for this course?

Yes, we offer special training packages for corporate clients.

Featured Courses

Some of Our popular courses and recommendations

Certified Business Analysis Professional (CBAP)

  • Location: Online
  • Course length: 40 hours

Scrum Master Certified (SMC)

  • Location: Online
  • Course length: 16 hours

Project Management Professional (PMP)

  • Location: Online
  • Course length: 35 hours