71 Microsoft BI courses

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create complex Web Intelligence documents using advanced query and reporting techniques, including:Combined queries and sub-queriesCharacter and date string functionsVariables and calculation contextsLink documents using hyperlinks In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. Web Intelligence Core Report Design Reviewing Core Report Design Concepts Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC) Multiple Data Sources Synchronizing Data from Multiple Data Sources Creating Multiple Queries in a Document Synchronizing Data with Merged Dimensions Interacting with Other Data Providers Advanced Query Techniques Implementing Combined Queries Implementing Subqueries Creating a Query Based on Another Query Changing Data Sources Calculation Contexts Describing Calculation Contexts Redefining Calculation Contexts Implementing Extended Syntax Operators Implementing Extended Syntax Keywords Defining Calculation Context Formulas with Character and Date String Functions Creating Formulas with Character and Date String Functions Implementing the Right() Function Implementing the Replace() Function Implementing the SubStr() Function Implementing the Pos() Function Concatenating Character Strings Implementing Date Functions If Logic Executing If() to Group Data Executing the If() Function to Modify Calculation Behavior Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel Managing Hyperlinks in the Web Intelligence Interactive Panel Additional Reporting Techniques Implementing Data Tracking Implementing Additional Report Functions

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Data Consultants /Managers, Program/Project Managers, and Solution Architects. Overview Gain hands-on experience in running SAP BusinessObjects BI tools on top of SAP NetWeaver BW data In this course, students are provided with detailed knowledge on the integration for reporting of SAP BusinessObjects BI Platform 4.x with SAP NetWeaver 7.x. Overview of SAP BusinessObjects Business Intelligence(BI) 4.x and SAP NetWeaver Describing SAP BusinessObjects 4.x Semantic Layer in SAP BusinessObjects BI 4.x and Data Connectivity Describing Semantic Layer Technology Creating a Universe with the Information Design Tool SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP NetWeaver BW Creating a Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office Creating a Workbook with SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP BW SAP BusinessObjects Analysis, Edition for OLAP and SAP NetWeaver BW Creating a Workspace with SAP BusinessObjects Analysis, Edition for OLAP Creating a Workspace in SAP BusinessObjects Analysis, Edition for OLAP Based on a BW Query SAP BusinessObjects Design Studio and SAP NetWeaver BW Creating an Analytical Application in SAP BusinessObjects Design Studio Creating an Analytical Application with Scripting SAP BusinessObjects Dashboards and SAP NetWeaver BW Creating a Dashboard with SAP BusinessObjects Dashboards Creating a Dashboard with BEx Query SAP Crystal Reports and SAP NetWeaver BW Creating a Report with SAP Crystal Reports for Enterprise Creating a Report with SAP Crystal Reports 2013 Creating a Report with SAP Crystal Reports 2013 and SAP NetWeaver BW Differentiating SAP Crystal Reports 2013 and SAP Crystal Reports for Enterprise SAP BusinessObjects Web Intelligence and SAP NetWeaver BW Creating a Web Intelligence Document Creating a Web Intelligence Document for SAP NetWeaver BW SAP BusinessObjects Explorer and SAP NetWeaver BW Creating an SAP BusinessObjects Explorer Information Space Describing Data Connectivity between SAP BusinessObjects Explorer and SAP NetWeaver BW Information Distribution Reporting with Mobile Devices Creating Publications with SAP Crystal Reports and SAP BusinessObjects Web Intelligence Integrating BI Content with SAP NetWeaver Enterprise Portal

Duration 1 Days 6 CPD hours This course is intended for Experienced Web Intelligence report creators and analysts upgrading from a previous version of SAP BusinessObjects Web Intelligence to SAP BusinessObjects Web Intelligence 4.1. In this course, participants will gain an understanding of the Deltas between Web Intelligence 3.1 and 4.1. Content Preview Data Ribbon Options Context Menus Drag-and-Drop functionality Application Modes -Data Mode -Reading Mode -Design Mode Freeze Columns New options in the formula editor Grouping Data New Predefined Cells Element Linking New Charting Engine Direct Connectivity to SAP BW BEx Queries

Duration 2 Days 12 CPD hours This course is intended for System administrators Overview Prepare you to perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. In this course, students perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. SAP BusinessObjects Business Intelligence (BI) Platform Identifying the Components of the SAP BusinessObjects Business Intelligence BI Platform Content and Objects in the SAP BusinessObjects Business Intelligence (BI) Platform Viewing and Modifying Objects in the BI Platform Organizing Objects in the BI Platform Searching for Content in the BI Platform User and User Group Security in the SAP BusinessObjects Business Intelligence (BI) Platform Setting Up Users and Groups Administering Rights Application Security in the SAP BusinessObjects Business Intelligence (BI) Platform Managing Access to Applications Securing Applications Content Distribution Using Scheduling and Alerting Scheduling Objects Managing Instances Managing Calendars Managing Events Configuring Alerts and Alerting Publications and Publishing Designing Publications Additional course details: Nexus Humans BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Learn how to create queries in BEx Query DesignerLearn how to use advanced query functionsLearn how to perform OLAP analysis In this course, students obtain the knowledge to create query definitions using the BEx Query Designer and to make them available for OLAP analysis. Data Warehousing Describing Data Warehousing Describing Data Warehouse Architecture Using Reporting Tools Navigation Options in Reports Using the Navigation Options in Reports Saving Analysis Views Simple Queries Creating Simple Queries Finding a Query Filtering Query Definition Data Configuring Query Properties Key Figures and Structures in Queries Creating Restricted Key Figures Creating Calculated Key Figures Creating a New Formula with Boolean Operators Configuring Properties of Key Figures Using Exception and Nested Exception Aggregation Queries with Multiple Structures Creating Structures Resolving Formula Collision Designing Detailed Queries with the Cell Editor Characteristics and Hierarchies in Queries Configuring the Properties of Characteristics Running Display and Navigation Attribute Queries Adding Hierarchies to Reports Adding External Hierarchies to a Report Using Hierarchies and Structures Creating External Hierarchies Variables in Queries Using Variables Creating Characteristic Value and Text Variables in Queries Creating Hierarchy and Hierarchy Node Variables in Queries Creating Formula Variables in Queries Activating Business Content Variables Exceptions and Conditions in Queries Creating Exceptions in Query Design Creating Conditions in Query Design Report-Report Interface Using the Report-Report Interface Query Performance Optimization Optimizing Query Performance Configuring Query Read Mode Use Performance Monitoring Tools Queries Management and Authorizations Overview Managing Query Objects Describing Authorizations Reporting Options Outlining Reporting Options for SAP NetWeaver BW Additional course details: Nexus Humans BW305 SAP Business Warehouse Query Design and Analysis training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BW305 SAP Business Warehouse Query Design and Analysis course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.