Highlights
- Learn the fundamentals of Power BI and Business Intelligence (BI)
- Navigate the Power BI Desktop environment
- Use Query Editor to import and transform data from sources such as Excel
- Build reports, dashboards, and visualisations with Power BI
- Use DAX to perform calculations and manipulate data
- Publish and share Power BI dashboards and reports
- Understand Power BI security and user access principles
- Explore Power BI features and functionalities
- Discover the dynamic world of Power BI through expert-led instruction
- Gain practical experience, unlock powerful insights, and master data visualisation
- Enhance your skills and drive data-driven decision-making
Course Details
Power BI Training Course Introduction
- Power BI: What is it and why use it?
- Power BI Desktop vs Services - What is best for your use case?
- Power BI vs other BI tools (Gartner Magic Quadrant)
- Power BI User Interface Training
- Customising Visuals vs Theme vs Data Model
- Power BI Course contents review
Power BI for Desktop
- Data Models - How to structure your data using data science
- Power BI's Schemas - Data structure definition
- Connectivity - Connection options, e.g. real-time or stored/refreshed
- Design Environment - Learning how to build reports.
- Importing Data - How to get data into a data model.
- Dashboards in Desktop
- Get data from different sources
- Custom Colours
- Desktop Three views
- Data View: Column Sort, formatting, hiding columns
- Create and format visuals
- Slicers
- Control Filter interaction
- Drilldown data through hierarchies
- Drilldown through Auto dates
- Publish reports/Dashboards
- Monthly Updates
More on Power BI
- Power BI with your data
- Query Editor in brief
- Query Design explained
- Query editors tabs and menus
- Best Practice for Queries
- Applied Steps
- Advanced Query Editor
- Data Transformations
- Data cleaning
- Dataset merges
- Accessing Excel and csv data
- Merging techniques
- Managing Columns
Power BI Dashboard, Reports & Visualisations
- Power BI Reading View - Seeing what users see.
- Editing View - Customising user experience.
- Visualisations and Custom Visualisations - Telling a compelling story.
- Creating visuals (with no programming)
- Choosing the best visual
- Interactivity between visuals
- Formatting visuals and charts
- Types of Conditional Formatting
- Show matrix values on Rows vs Side by side
- Customise matrix column subtotals
- Matrix Drill-Down tools
- Viewing the Underlying Data Driving a Visualisation
Importing & Transforming Datasets
- Queries & the Query Editor - Controlling the data import process
- Shaping & Cleansing Data - Making real-world data usable.
- Combining Datasets and data sources - Appending and merging data from different sources.
- Functions - The M library of powerful data manipulation capability.
- Loading Transformed Data - Populating the Power BI data model.
DAX & Calculations in POWER BI
- Data Analysis Expressions - Powerful versatility at your command.
- Calculated Columns - Extending data tables.
- Measures - How your data is summarised.
- DAX Syntax - Learning the basic grammar of formula writing.
- DAX Functions - Building blocks for data manipulation.
- Dax Operators
- Implicit Vs Explicit measures
- Measures vs Calculated Columns
- Commonly Used DAX Functions
- DAX Aggregate functions
- IF conditional statements
Publishing, Sharing Dashboards, Report & Features with Power BI
- Power BI Dashboards - The easy-read overall summary ‘at a glance’
- Creating & formatting Dashboards
- Sharing Dashboards - Who gets to see what?
- Creating Workspace - Organising structure around people.
- Security - Restricting access to the ‘need to knows'
- Publishing Models to the Cloud Service
- Adding Users to Security Defined Roles
- Basic Sharing of Dashboards & Reports
- Multiple ways of sharing reports and Dashboards
- Creating App Workspaces
- Collaborating on Reports
- Publishing Organisational Apps for Distribution of Content
- Adding Users & Editing Workspaces
- Connecting to Apps
Who should attend
- Business Analysts
- Financial Analysts
- Quantitative Analysts (Quants)
- Data Scientists
- Financial Traders
- Data Engineers
- Professionals who need to create reports from sources such as Excel (Power Pivot), SQL Server, Python, and other databases or datasets.
Feedback
4.8 out of 5
"Our tailored "Power BI course" covered topics that we needed to know. The instructor truly cared about our learning. We felt supported from start to finish and we left with knowledge that genuinely mattered to our work" Brian Leek, Data Analyst, May 2024
“In this Power BI Training The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work. Our instructor showed real care for our learning. We felt supported throughout the entire course and gained knowledge that made a meaningful impact on our work - AG, Business Analyst, Power BI Advanced, February 2023"
Watch Live Client Feedback : JBI Power BI & Python Data Analytics courses