Description
This Power BI Course provides the skills and knowledge needed to use Power BI. This is a vital programme for many analytical and managerial jobs. It enables you to manipulate, arrange and analyse sets of data. You can also create summaries and dashboards. it creates interactive business intelligence reports. It is useful for anyone with either analytical or managerial tasks at work.
Course Format
The training is available online and is suitable for beginners. Our learning system is state of the art and is provided by Microsoft Platinum Partners. The training uses a virtual tutor inside the training system. The virtual tutor function will guide you through work-simulated, provide exercises and correct any errors you may make. This is a very interactive method of learning, which helps you gain confidence and real skills.
The training system is adaptable and accessible at all hours of the day, meaning you may begin the course at any time and study according to your schedule. It’s like having your own personal IT tutor at your disposal at all times.
Power BI Course
The training course has a duration of six months, but you continue to be able to access the learning material for one year. Start dates are flexible. You can start on any date.
Training Course Content
Connecting and preparing data with Excel and other sources
- Connecting Power BI to an Excel workbook
- Managing the imported Excel data
- Importing an Excel file
- Cross-tables from Excel
- Connecting Power BI to a database
- Extracting, organising and filtering data from the imported base
- Creating columns from examples and adding conditional columns
- Connecting to other data sources (txt, csv, pdf, SharePoint list)
- Practical exercises with solutions to consolidate learning
Setting up a model in Power BI
- Setting up the relationships within the model
- Creating the calendar table
- Developing the explicit measures in your model
- Organising the fields in the Model view
- Practical exercises with solutions to consolidate learning
DAX Formulas
- What is the DAX concept?
- How to apply the CALCULATE function
- The ALL function
- Counting items using the COUNTROWS or the DISTINCTCOUNT functions
- Trend analysis using the DATEADD function
- Practical exercises to consolidate learning
Interactions within Power BI
- How to build natural interactions
- Drilling down into more detailed data
- Practical exercises to consolidate learning
How to create Dashboards and Interactive Visuals
- Develop a dashboard
- Create a bar chart/line chart/pie chart
- Use a card to show summary data
- Illustrating geographical data
- Creating a table and cross-table
- Using slicers
- Practical exercises with solutions to consolidate learning
Applicative Designs within dashboards and models
- Principles of applicative design
- User experience design
- Develop the page backgrounds
- Adding slicers, tooltips and dynamic titles
- Conditional formatting in tables
- Overview of the process
- Create the theme
- Adding visuals and buttons to the tabs
- Using bookmarks
- Practical exercises to consolidate learning
Publication
- Publish a dashboard
- Use a Published Dashboard
- Power BI Publishing Service
- Practical exercises to consolidate learning
Dates and Duration
This is a flexible study course. You can start at any time, and you can study on a flexible schedule. You have up to one year to complete the training. The average learning hours are 6 hours.
Course Requirements
To take this Power BI Course, you will need at least Intermediate Excel or Advanced Excel skills.
Benefits
- Training developed by experts in the field
- User-friendly
- Realistic work simulated exercises enable you to apply your learning more effectively.
- CPD Accredited Training written by Microsoft Platinum Partners
- Build career skills
- CPD Certification issued on successful completion
- Power BI is a great additional skill for a wide range of careers
- Professional qualification to build your CV and job options
- Flexible training schedule
