Analysis and Visualisation with Microsoft Power BI

Learn how to turn data into powerful insights that direct and drive informed business decisions with Power BI – giving your business the edge over competitors. You will be able to use all key features in order to effectively analyse your data, create interactive reports and share your findings
Learn via
2 days or 4 evenings
  • Overview
  • Prerequisites
  • Learning Outcomes
  • What's included
  • Course Outline

The Microsoft Power BI is the most user-friendly report-based analytical tools, that is transforming the way that businesses read their performance data. It allows you to extract, analyse and comprehend large quantities of data – helping to ensure that you can present data in a logical manner and make informed business decisions. Its reporting application has been designed to help users, of all experiential levels, produce insightful data analysis. Learn how to turn data into powerful insights that direct and drive informed business decisions with Power BI – giving your business the edge over competitors.

This training is for anyone who wants to learn about self-service business intelligence with Microsoft Power BI – regardless of technical or analytical background. After the 2-day instructor-led and interactive training sessions, you will be able to use all key features in order to effectively analyse your data, create interactive reports and share your findings throughout your organisation.

There is no strong prerequisite for this course.

At the end of this course, you will be able to:
• Rapidly analyse, transform and present data
• Understand the Power BI platform
• Set up queries to extract and transform data
• Create efficient data models
• Design and publish interactive reports
• Confidently use DAX calculations

•Interactive training classes in 2 days (daytime timetable) or 4 evenings (evening timetable)
•Hands-on practice after the classes with a work-based assignment in 14-21 days
•Access to support by our mentors during the course period
•Pairview Certification for achieving this competency

Learning Goal: This module will introduce you to Power BI, its building blocks and the various fundamental concepts of power BI
• What is Business Intelligence
• Self Service Business Intelligence
…and more.

Learning Goal: This module will introduce you to Power BI Desktop. You will know how to extract data from various sources and establish connections with Power BI Desktop, perform transformation operations on data and the Role of Query Editor in Power BI.
• Overview of Power BI Desktop
• Data Sources in Power BI Desktop
…and more.

Learning Goal: This module will help you learn the basics of DAX in Power BI Desktop.
• Essential concepts in DAX
• Why is DAX important?
…and more.

Learning Goal: This module will help you understand the benefits and best practices of Data Visualisation. It will also help you in creating charts using Custom Visuals.
• Introduction to visuals in Power BI
• Charts in Power BI
…and more.

Learning Goal: This module will help you in creating Dashboards and publishing it on Power BI services. You will also be taught to monitor Real-time Data with REST API.
• Introduction to Power BI Service
• Dashboard vs. Reports
…and more.

Learning Goal: This module will help you in using connecting to and using data saved within an Excel file.
• Introduction to using Excel data in Power BI
• Upload Excel data to Power BI
…and more.

Learning Goal: This module will help you understand the various ways of sharing your report and dashboards with members of your organization.
• Publish Power BI Desktop Reports
• Print and Export Dashboards and reports
…and more.

What You Will Benefit From

Our expert knowledge and job-focused approach sets us apart in our quest to offer excellent services to our delegates and deliver on their career development goals.

Get Real Employable Skills

Our job-focused courses and quality curriculum is designed and taught by industry experts and highly experienced professionals, not academics, so you learn the high-impact skills that top companies want.

Gain Best Real-World Practices

Apply your skills in real time through interactive trainer-led practices during the classes, and after-class assignments. As you do so, you are empowered with the problem-solving skills and job market insights needed to capture most new job opportunities in this field or take your career to the next level.

Achieve Professional Certification

Obtain Pairview Certification for completing this course, recognised by many employers in the industry.

Personalised Support and Career Consultancy

You will have access to tailored support by our dedicated mentors while you learn and practise. Our mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track. They also give you valuable advice on professional and career development.

What They Think

Excellent training and hands-on practice with industry-relevant use cases to practise the skills. The projects are real-life client issues/problems which expose you to the world of data analysis, reporting and visualization and machine learning.

JMK Olly

Great company with thorough professionals that will ensure the process you are taken through is seamless as they will work around the clock to cater to your needs. Highly recommend Pairview for those wishing to make a career change or enter the world of Analytics.


The course delivery was very well-paced, and there were loads of practical examples which helped drive in the knowledge and provided a solid foundation. Really pleased with the service I received, and I will definitely recommend Pairview. I have many colleagues who also trained here and are doing very well in Data and MI analytics.

Ani Madu

Management Information Analyst

I knew about data analytics but hadn’t realised the opportunities available until I joined Pairview. Their staff was fantastic. The trainers were very knowledgeable and supportive. Overall, it was a great experience for me, and I secured a data analyst role even before I finished the CV Surgery with the Recruitment Consultant as part of the program.


Data Analyst

I undertook the Insight Analyst programme and although the fee was high, it was worth paying for it. The training was so impactful, with hands-on practices and real-life business scenarios. Sometimes I asked them for help with a next-day interview, the consultant tried his best to prep me that night. I am now an Insight Analyst, all thanks to


Insight Analyst

Ayodele Oduwole

Data Administration Specialist

Personalised Career Development Add-ons

We provide Add-on Services customised for your needs at every step of your learning journey to ensure your success.

  • Project-based Work Experience
  • CV Surgery
  • Placement Support
  • Recruitment Coaching

Gain indispensable experience with our projects

Gain work experience by undertaking real-world projects deriving from our consultancy work with global corporate clients. You will work on some of the most popular problems faced by businesses across industry sectors.

Learn by doing leads to real skills mastery and business acumen competency.



92%+   of delegates completed their projects with Merit or Distinction

4.6+   service ratings



  • 2 months of work experience
  • Assigned Project Manager for supervision and support
  • Weekly support sessions
  • Project presentation and personalised feedback
  • Unlimited submissions and feedback loops
  • Practical tips and industry best practices

Perfect your CV with our bespoke CV Surgery

Marketing yourself effectively to employers is critical so you can get the job you want for the best pay possible.

We will work with you personally on a one-to-one basis to perfect your CV. We will ensure it is a clear and accurate picture of your capabilities, is professionally written, and can capture interest of most recruiters and bring maximum opportunities of job interviews for your relevant roles.



100%   of final CVs captured job opportunities in the first few days

4.9+   service ratings



  • One personalised review and edit
  • Various templates sourced from successful job placements
  • Resume optimisation tips

Have access to our extensive recruitment network

We help our corporate clients solve skill shortage challenges and provide talent security in the hardest to find skill sets on the market. Gain access to the best job opportunities within our extensive recruitment network and channels.



98%+   of delegates got jobs or progressed their career upon completion

4.7+   service ratings



  • Personal assistance in your job search
  • Job opportunities from our corporate partners
  • 1-on-1 calls
  • Helps expand your professional network

Maximise your job opportunities and salary negotiation

Our Recruitment Consultant will help you target the most potential, relevant job opportunities across all available channels for job interviews and provide you with all the necessary interview preparation and techniques to enable you to successfully manage interviews and salary negotiations.

The Consultant will cover responses to those awkward or sensitive questions you may be asked and work with you to increase your level of personal impact and credibility at referral meetings and interviews through role play and practice. You will learn to project what you have to offer calmly and with confidence.



98%+   of delegates got jobs or progressed their career upon completion

4.7+   service ratings



  • Weekly recruitment consultancy sessions
  • Personalized feedback and career guidance
  • Demystifying the hiring process for you
  • Advice on recruitment tests
  • Advice on interview questions and techniques
  • Advice on negotiating job offers

Training and Career Development Services - Registration Fee


To register for a training or career development service, choose a Product/Service and Class Time to view the registration fee and click “Go To Checkout”. After completing the registration payment, a Consultant will get in touch with you and finalise your programme structure, class schedule and payment plan. For any enquiry, contact us: T: (+44) 0800 9078 235    |    E: [email protected]

Contact Us!

Have enquiries of a course/programme? Want a career consultation? Or look for bespoke training?

Let’s start a conversation!

All Rights Reserved © 2020

Welcome Back, We Missed You!

Download Now

Please fill out this form to view the brochure