Data Analysis with Microsoft Power BI - Advanced

Infero Training Ltd

Course Content

Lesson 1: Analysing Data with Self-Service BI

• Data Analysis and Visualisation for Business Intelligence
• Self-Service BI with Microsoft Power BI

Lesson 2: Connecting to Data Sources

• Create Data Connections
• Configure and Manage Data Relationships
• Save Files in Power BI

Lesson 3: Performing Data Cleaning, Profiling, and Shaping

• Clean, Transform, and Load Data with the Query Editor
• Profile Data with the Query Editor
• Shape Data with the Query Editor
• Combine and Manage Data Rows

Lesson 4: Visualising Data with Power BI

• Create Visualisations in Power BI
• Chart Data in Power BI

Lesson 5: Enhancing Data Analysis

• Customise Visuals and Pages
• Incorporate Tooltips

Lesson 6: Modelling Data with Calculations

• Create Calculations with Data Analysis Expressions (DAX)
• Create Calculated Measures and Conditional Columns

Lesson 7: Creating Interactive Visualisations

• Create and Manage Data Hierarchies
• Filter and Slice Reports
• Create Dashboards

Lesson 8: Using Advanced Analysis Techniques

• Create Calculated Tables, Variables, and Parameters
• Enhance Visuals with Statistical Analysis
• Perform Advanced Analysis

Lesson 9: Enhancing Reports and Dashboards

• Enhance Reports
• Enhance Dashboards

Lesson 10: Publishing and Sharing Reports and Dashboards

• Publish Reports
• Create and Manage Workspaces
• Share Reports and Dashboards

Lesson 11: Extending Power BI Beyond the Desktop

• Use Power BI Mobile
• Extend Access with the Power BI API

.

Course Objectives

Upon successful completion of this Data Analysis with Microsoft Power BI Advanced course, you 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.

.

Testimonials from our Website and Google Reviews

I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan (Payroll Manager) from Decathlon UK

.

Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol

Martin Pountney

.

I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.

Michael Sexton

.

I attended the Microsoft Excel Basic and Excel Intermediate course which I found very useful. Martin is an excellent trainer, made you feel at ease, he is very helpful and patient. I wish I had undertaken the training ages ago as would have been very beneficial in my previous role.

Leela Patel

This Data Analysis with Microsoft Power BI PRO 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, which you could obtain by taking the following courses.

• Microsoft Excel Introduction
• Microsoft Excel Intermediate

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. The following courses are helpful but not required:

• Database Design: A Modern Approach
• Microsoft Excel - Data Analysis with Power Pivot
• Data Analysis and Visualisation with Microsoft Excel

Being proficient in Power BI can open the door to many career opportunities such as:

• Administrative Assistant
• Data Analyst
• Accountants
• Financial Analyst
• Retail Store Manager
• Project Manager
• Business Analyst