• +44 01379 671280
  • training@computertrainingsuffolk.co.uk
Microsoft Certified profesional

Microsoft Power Bi Training Courses.

Course Information

 

Overview

This 2 day course is designed for anyone working with a large amount of data who is wishing to analyse it and create eye catching visualisations. Participants will get hands-on experience learning key skills and concepts using example data based on real world scenarios.

Prerequisites

The student should be familiar with Excel and the concepts of datasets and basic reporting. Please note that this course is not suitable for inexperienced Excel or database users.

 

Course Outline 2 day

Getting Started

  • An Introduction to Power BI
  • Working with Power BI Desktop Files
  • Connecting to Data Sources with Power BI Desktop
  • Creating a Report with Visualizations
  • Doing More with Visualizations

 

Introduction to the Power BI Web App

  • Getting Started
  • Connecting to Data Sources with the Power BI Web App
  • Using Workspaces, Dashboards and Reports
  • Creating Custom Dashboards
  • Power BI Web App Features

Microsoft Power BI Introduction Course Outline

  • Power BI Desktop
  • The Power BI service
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Q&A; Natural Language Queries
  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • The Power BI Data Model
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • Configuring Data for Q&A
  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data
  • Understanding Relationships
  • Viewing Relationships
  • Creating Relationships
  • Cardinality
  • Cross Filter Direction
  • Why do we need DAX?
  • Functions
  • Context
  • Calculated Columns
  • Calculated Tables
  • Measures
  • Managing your Measures
  • Power BI Reports: Page Layout and Formatting
  • Multiple pages
  • Tables and Matrices
  • Creating Charts
  • Using Geographic Data
  • Cards, Gauges and KPI’s
  • Slicers
  • Drillthrough options
  • Report Page Tooltips
  • Buttons and Bookmarks
  • Focus and Spotlight
  • Power BI Themes
  • Create and deploy a custom theme
  • Changing the font size for all visuals and pages
  • Changing the number format for visuals
  • Inserting Pictures, Text Boxes and Shapes
  • Using DAX formulas on Cards to display the current filter value
  • Adding Row-Level Security
  • Publish to Web
  • Publish to the Power BI service
  • Creating a dashboard
  • Content Packs
  • Power BI Apps and Workspaces

 

TRAINING SERVICES

Microsoft Office Specialist Courses ( MOS ) courses – Office 2010, 2013, 2016, 365 and 2019 As well as accredited courses we deliver over 200 standard courses covering Microsoft, Apple and Adobe Delivery Styles – Group bookings, 1-2-1, Public courses, Tailored and Office Migrations. Complimentary Training Materials for delegates – We have a dedicated site with a wide range of Microsoft manuals available, new titles are released regularly.

Microsoft Computer training

Accredited and Experienced Trainers

– All our trainers are Microsoft accredited and experienced. You will have peace of mind knowing that our trainers have been personally interviewed and assessed by us for their product knowledge, communication and delivery skill

 

 

On-site Courses – our courses can be delivered on-site at your business premises. we adhere to strict covid guidance Live

Online Courses – our training courses can be delivered on-line with a live tutor via Zoom, Microsoft Teams or Web-ex virtual classroom software. COVID-19: Whilst the

Need to up-skill, re-skill or simply develop your digital skills for the workplace or personal use? We have a huge range of courses to support you in your learning covering all Microsoft Office packages including Word, Outlook, Excel, PowerPoint and MS Project and also offering courses in social media, Apple Macs, computer maintenance and much more.

we are an independent team of training providers in suffolk that are dedicated to helping you to build successful and profitable businesses. Our professionals have a wealth of expertise and knowledge in this field and can be sure to cater to all of your specific needs, no matter how big or small your business may be. So you can have peace of mind knowing that you are in the most capable of hands. We are confident that you won’t find a service quite like ours, anywhere else. Our training providers in suffolk will be on hand to help with all of your requirements whether you are a small establishment or large commercial company.