Data Analysis with Microsoft Power BI Pro Course – Virtual
Go from beginner to advanced in Microsoft Power BI by creating data-backed visualisations, worksheets and dashboards to analyse, display and report insights and trends.
- All Courses
- Data Analytics
- Power BI
- Data Analysis with Microsoft Power BI Pro Course – Virtual
Course Overview
This intensive 3 days, hands-on Power BI Pro course helps you to gain a comprehensive, practical understanding of Power BI and takes you from complete beginner to advanced level.
Creating data-backed visualisations is key for data scientists, or any professional, to explore, analyse, and report insights and trends from data. Microsoft Power BI software is designed for this purpose. Power BI was built to connect to a wide range of data sources. It enables users to quickly create visualisations of connected data to gain insights, show trends, and create reports.
Power BI’s data connection capabilities and visualisation features go far beyond those that can be found in spreadsheets. It enables users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.
Since a tool is only as good as the person using it, it is important to gain an understanding of Power BI to maximise your effectiveness when analysing data.
Power BI is constantly being updated. Our course ensure you are able to use the very latest features and developments.
Price
Duration
3 Days
Training Options
Virtual
Data Analysis with Microsoft Power BI Pro Course Content:
Lesson 1: Analysing Data and Reporting with Power BI
- Topic A: Data Analysis and Visualisation for Business Intelligence
- Topic B: Interact with Reports in Power BI
Lesson 2: Connecting to Data
- Topic A: Create Data Source Connections
- Topic B: Configure and Manage Relationships
- Topic C: Save Files in Power BI
- Topic D: Secure and Troubleshoot Connections
Lesson 3: Cleaning, Transforming, and Loading Data
- Topic A: Load, Clean, and Shape Data with the Query Editor
- Topic B: Profile Data with the Query Editor
- Topic C: Shape Data with the Query Editor
- Topic D: Transform Data with the Query Editor
Lesson 4: Visualising Data with Power BI
- Topic A: Create Visualisations with Power BI
- Topic B: Select Visualisation Types with Power BI
Lesson 5: Enhancing Visuals for Data Analysis
- Topic A: Customise Visuals and Pages
- Topic B: Incorporate Tooltips in Visualisations
Lesson 6: Modelling Data with Calculations
- Topic A: Create Calculated Columns with DAX
- Topic B: Create Calculated Measures and Conditional Columns
Lesson 7: Customising and Filtering Reports
- Topic A: Create Data Hierarchies
- Topic B: Filter Reports
- Topic C: Discover Time-Intelligence Insights
- Topic D: Configure Slicers for Interactive Filtering
Lesson 8: Performing Advanced Analysis
- Topic A: Create Calculated Tables, Variables, and Parameters
- Topic B: Perform Statistical Analysis
- Topic C: Analyse Data with Advanced Power BI Features
Lesson 9: Sharing Reports and Creating Dashboards in the Power BI Service
- Topic A: Publish and Explore Reports in the Power BI Service
- Topic B: Create Dashboards
- Topic C: Add Q&A to Dashboards
Lesson 10: Managing and Collaborating in the Power BI Service
- Topic A: Manage Workspaces and Share Content
- Topic B: Collaborate with the Power BI Service
Lesson 11: Enhancing Reports and Dashboards
- Topic A: Optimise Usability and Performance
- Topic B: Create Mobile Reports for Power BI
Upon successful completion of this course, students will be able to:
- Analyse data with self-service BI
- Connect to data sources
- Perform data cleaning, profiling, and shaping
- Visualise data with Power BI
- Enhance data analysis by adding and customising visual elements
- Model data with calculations
- Create interactive visualisations
- Use advanced analysis techniques
- Enhance reports and dashboards
- Publish and share reports and dashboards
- Extend Power BI beyond the desktop
Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyse business data, visualise insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.
To ensure your success in this Power BI course you should have experience managing data with Microsoft Excel. Optionally, having experience with other data analytics tools, as well as an understanding of database design concepts and basic programming constructs will help you get even more out of this Power BI course.
To meet this prerequisite, you can take any one or more of the following courses:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
- Data Analysis with Microsoft Power BI Introduction
Choose Your Date & Location
Testimonials
Nora Neal
Shane Mcdonald
Cory Suarez
Marissa Buckley
Take Yourself Further With Infero
Top Power BI FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm