Power BI Process • Connecting to Data • Manipulating and Modelling Data • Creating Visualisations • Formatting and Filtering • Creating and Publishing Reports Connecting to File based Data • Connecting to Excel Spreadsheets • Access/SQL Server Databases • Text Files Connecting to Service based Data Cloud • Based Data Sources (OData) • SharePoint Documents • Web Page Data Data Gateways • Personal and Organisational Data Manipulations • Column Transformations • Query Editor Example • Grouping within Columns • Appending Queries • Adding Custom Columns • Advanced Query Editing • Transforming Unstructured Data Data Modelling • Relationship Concepts • Viewing Relationships • Creating new Relationships • Editing Relationships Column Operations • Hiding Fields within the Dataset • Sorting by Columns • Changing Column Data Format • Creating a calculated column DAX Language • DAX Data Types, operators DAX Functions • Date, Time Intelligence Functions • Mathematical, Logical, Text and Statistical Functions Showing RELATED Columns Date Calculations Debugging Expressions • Conversion Errors • Empty or missing values Adding Measures • Setting the Measure’s Home Table • Columns vs. Measures Creating New Calculated Tables • Creating and Populating Dates Tables Visualising Data • Adding Visualisations to Report Page • Tables and Conditional Formatting • Pie, Line, Combination Charts • Maps and Geographic data • KPIs & Cards Visualisation Data Fields • Axis/Legend/Values Formatting Visualisations • Formatting Options • Tile Properties Report Pages • Adding and Formatting Report Page • Saving Reports
Power BI Process • Connecting to Data • Manipulating and Modelling Data • Creating Visualisations • Formatting and Filtering • Creating and Publishing Reports Visualising Data • Tables, Matrices • Tables and Conditional Formatting • Pie, Line, Combination Charts • Waterfall, Pyramid • Scatter Charts and animation • Maps and Geographic data • Gauges • KPIs & Cards Slicers and Filtering • Adding and Formatting Slicers • Filtering Pages, Reports & Tiles • Drill Through Fields • Drilldown techniques • Adding Visual Interactions • Quick Insights for Visualisations Formatting Visualisations • Conditional Formatting • Formatting Options • Tile Properties Analytics • Adding Trend Lines/Average Lines Manipulating Tiles • Tile Menu, moving and deleting • Focus Mode, Viewing, Spotlighting and exporting Tile data Report Pages • Adding and Formatting Report Page • Duplicating Report Pages • Adding Shapes to the Report Page Report Themes • Applying and Importing Themes • Customising & Saving current Theme Q & A in Power BI Desktop • Strategies for using Q&A features Hyperlinks and Navigation • Types of Hyperlink and Targets Bookmarks in Reports • Creating Bookmarks • Managing and Arranging Bookmarks • Bookmarking Objects • Running Slideshows from Bookmarks Selection Pane • Hiding and Showing Visualisations • Linking selection to Bookmarks Sharing Power BI Content • Power BI Content Packs • Packaging and Distributing – locations • Referring to Content Pack Data • Printing Reports and Pages • Exporting Reports and Pages to PDF • Examining PDF content & Features Sharing Strategies • Power BI Online Overview and options Refreshing Datasets • Refresh Strategies • Scheduled Refresh • Manual Refresh Configuring Power BI • Power BI Desktop Settings • Preview Features • Desktop Options
Power BI Process • Connecting to Data • Data Relationship Modelling • Data Manipulation • DAX Language and Expressions • Creating Visualisations Power BI Service • Signing in • Screen Layout • Workspaces • Menus and Settings • Controlling Workspace Access Publishing Power BI Reports • Create and Share Internally and Externally • Creating a Group Publishing Reports from Desktop • Workspace Content • Viewing Reports, Datasets & Dashboards Dashboards in Power BI Online • Dashboards vs Reports Creating a Dashboard • Dashboard Menu • Duplicating an Open Dashboard Adding Tiles to a Dashboard • Adding Web Content • Adding an Image, Text Box & Video • Adding Streaming Content • Pinning Tiles and Report Pages • Pinning Ranges from Connected • Excel Workbooks Printing a Dashboard Dashboard Options Sharing Dashboards • Sharing Process • Stopping Sharing • Sharing Outside the Organisation • Limitations and considerations • Troubleshoot sharing Refreshing Datasets • Refresh Strategies • Scheduled Refresh • Manual Refresh • Using Data Gateways Power BI DataSets • Using Datasets as Data sources • Creating Reports on connected Sets Exporting PBIT Templates • Applying Templates to Reports Sharing • Licensing Issues • Sharing Links • Sharing Reports in Teams • Sharing Reports on Web Sites • Generating Embed Codes • Sharing on SharePoint Pages Editing Reports in Power BI Online • Editing Features • Visuals & Data Panels • Saving Changes • Exporting edited Report • Avoiding overwriting changes
Thanks , your score has been emailed to you. If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.
Based on your answers, the most appropriate course for you would be:-
Enquire Now
Price Estimate
Book Now
AJ Training standard rate is £765.00 + VAT. *
* Rate excludes travel expenses, for an approximate on site price please add your details below.
All bookings will be invoiced and payment is due 10 Days before the course date. Following your booking you will receive an email confirming the details including course start times and location, we will attach a course overview, pre course questionaire, directions and an invoice. Should you require assistance or wish to book multiple courses, please call 01709 352307 or email info@ajtraining.net, we will be happy to help. All bookings will be charged at the advertised rates.
All bookings will be invoiced and payment is due 10 Days before the course date. Following your booking you will receive an email confirming the details including course start times and location, we will attach a course overview, pre course questionaire, directions and an invoice. Should you require assistance or wish to book multiple courses please call 01709 352307 or email info@ajtraining.net and we will be happy to help. All bookings will be charged at the advertised rates. The prices shown are per delegate, per day and exclude VAT.
There are currently no scheduled courses. Please fill out the details below and we would be happy to scheduled a course around your availability. Should you require assistance or wish to book multiple courses, please call 01709 352307 or email info@ajtraining.net, we will be happy to help. All bookings will be charged at the advertised rates. The prices shown are per delegate, per day and exclude VAT.
Please complete the form below to enquire about one company / bespoke courses. All bookings will be charged at the advertised rates. The prices shown are per day and exclude VAT.
Our experienced training team have designed each package from the ground up, to ensure it delivers on content and is simple to follow. We always include both video and exercises to help you along the way.
Each of our paid courses comes with our full support, if you get stuck, want to check your understanding or require any additional information, this is all part of the service and our team are here to help!
eLearning package per user @ £39.99 Plus VAT 12 months online access
Although eLearning packages offer a great stand alone product we also offer anyone who attends a standard course the option of adding the complementing eLearning package for only £25.00. For more information or multiuser access please : Call : 01709 352307 Visit : Contact us page Email : info@ajtraining.net
AJ Respond to all online bookings within 3 working hours, we will email you back to confirm prices, availability and content of the requested course. Once confirmed we will forward joining instructions along with an invoice payable 10 days before the course date.
£245.00 per delegate per day
Please complete the form below. If you have a date in mind please let us know by completing the "request date". We will be in touch shortly to discuss your training needs and proposed date for the scheduled course. Should you require assistance or wish to book multiple courses, please call 01709 352307 or email info@ajtraining.net, we will be happy to help. All bookings will be charged at the advertised rates. Prices quoted are per deletgate, per day.
Thank you for your . If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.
Our course schedule covers the standard training for the coming months, if the dates or course you require is not listed then please call 01709 352307 or email info@ajtraining.net and we will happily schedule additional courses.