67 Microsoft BI courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. Overview After completing this course, students will be able to: ? Perform Power BI desktop data transformation. ? Describe Power BI desktop modelling. ? Create a Power BI desktop visualization. ? Implement the Power BI service. ? Describe how to connect to Excel data. ? Describe how to collaborate with Power BI data. ? Connect directly to data stores. ? Describe the Power BI developer API. ? Describe the Power BI mobile app. The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Introduction to Self-Service BI Solutions Introduction to business intelligence Introduction to data analysis Introduction to data visualization Overview of self-service BI Considerations for self-service BI Microsoft tools for self-service BI Lab : Exploring an Enterprise BI solution Introducing Power BI Power BI The Power BI service Lab : Creating a Power BI dashboard Power BI Using Excel as a data source for Power BI The Power BI data model Using databases as a data source for Power BI The Power BI service Lab : Importing data into Power BI Shaping and Combining Data Power BI desktop queries Shaping data Combining data Lab : Shaping and combining data Modelling data Relationships DAX queries Calculations and measures Lab : Modelling Data Interactive Data Visualizations Creating Power BI reports Managing a Power BI solution Lab : Creating a Power BI report Direct Connectivity Cloud data Connecting to analysis services Lab : Direct Connectivity Developer API The developer API Custom visuals Lab : Using the developer API Power BI mobile app The Power BI mobile app Using the Power BI mobile app Power BI embedded

Duration 1 Days 6 CPD hours This course is intended for Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents. Roles can include management at all levels, team leaders or anyone who needs to commission the production of reports or dashboards. It is assumed that attendees on the course are familiar with charts. Please note that this course is not suitable for new Excel users, delegates need Ability to create charts Ability to use filters in data Overview This course covers the use of Power BI Desktop and the Power BI service hosted in Office 365 to identify core features, terminology and processes applicable when using reports or dashboards.Delegates will learn how to: Power BI Concepts and Main Features How a report is created Navigating reports and dashboards How to apply filters and slicers To use Insights, Analytics and Natural Language Queries Power BI provides a variety of methods for using reports and dashboards within which data can be viewed and analyzed visually. Getting Started with Power BI Power BI Concepts and Versions Introduction to Main Features: Jargon buster From Data to Reports and Dashboards Visualizations Overview Visualizations Available Visualizations as Filter Reports and Dashboards Similarities and differences Understanding what you are looking at Understanding what you are looking at Using a Report in Power BI Filters, sorting and using slicers See the actual data See Data and See Records Drill visualizations Off the shelf data analysis Quick Conditional Formatting Analytics lines Use Insight for Increases and Decrease Forecast Analytics Changing calculations and Show As Working with Dashboards Dashboards in Power BI Defined How is a dashboard different from a report? Working in the Dashboard window

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence 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 Writing Analytical Queries for Business Intelligence 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.

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.

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owners/Team Leads/Power Users. In this course, students are enabled to transform Excel workbooks into captivating dashboards for executives and business users. Introduction to Dashboards Creating Interactive Dashboards Using an Embedded Excel Workbook in the Dashboard Data Visualizations with Charts Using Data in a Range Using Data in a Series Preparing Future Data by Ignoring End Blanks Dashboard Distribution Distributing a Dashboard Single Value Components Using Single Value Components Alerts Setting Up Alerts Selectors Using Selectors Setting Default Values for Selectors Selecting Multiple Items Common Components Using Images in a Dashboard Using Tables in a Dashboard Using an Interactive Calendar in a Dashboard Adding a URL to a Dashboard Components Used as Selectors Using the Chart Component as a Selector Using the Map Component as a Selector Format Options Configuring Proportional Size and Position Using Themes to Apply Formats Using Templates to Apply Formats Applying Globalization Dynamic Visability Adding Dynamic Visibility Using Formulas to Create Dynamic Visibility Creating Multi-Layer Dashboards Dashboard Design Optimization Optimizing Dashboard Design Dashboard Connection to Live Data Using Live Data Sources Setting Up an XML Connection Using Web Services to Connect to Data Using the Query Browser to Connect to Data Using the Portal Data Connection to Connect to Data Additional course details: Nexus Humans BOX310 SAP BusinessObjects Dashboards 4.1 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 BOX310 SAP BusinessObjects Dashboards 4.1 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.

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 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 3 Days 18 CPD hours This course is intended for Analyst Developer End User Implementer Overview Schedule and Burst Reports Perform Translations Create Reports Integrated With Oracle BI EE Administer BI Publisher Server Describe BI Publisher Technology and Architecture Create reports from OBI EE data sources Create and Modify Data Models Create RTF Templates by Using Template Builder Explore and Use the Form Field Method for Creating RTF Templates Create Layouts by Using the Layout Editor This Oracle BI Publisher 12c training will help you build a foundation of understanding how to best leverage this solution. Through Classroom Training or Live Virtual Class Training, you'll learn the ins and outs of how to use this solution. BI Publisher Technology and Architecture Functional Components Layout Templates Multitier Architecture Enterprise Server Architecture and Performance and Scalability Document Generation Process and Output Formats Supported Data Sources Bursting Overview Internationalization and Language Support Getting Started with BI Publisher Logging In, the Home Page, and Global Header, and Setting Account Preferences Viewing Reports Managing Repository Objects Managing Favorites Using Create Report wizard to Create Reports Selecting Data: Data Model, Spreadsheet, and BI Subject Area Configuring Report Properties Using the Data Model Editor Exploring the Schemas Used in the Course Exploring the Data Model Editor UI and the Supported Data Sources Creating a Private Data Source Creating a Simple Data Model based on a SQL Query Data Set Using Query Builder to Build a Query Viewing Data and Saving Sample Data Sets Adding Parameters and LOVs to the Query Configuring Parameter Settings and Viewing Reports with Parameters Working with Layout Editor Opening the Layout Editor and Navigating the Layout Editor UI Creating a Layout by Using a Basic Template Inserting a Layout Grid Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats Inserting and Editing Charts, and Converting Charts to a Pivot Tables Adding Repeating Sections, Text Items, and Images Working with Lists, Gauges and Pivot Tables Creating Boilerplates Using Template Builder to Create RTF Templates Using the BI Publisher Menu Bar Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data Adding a Chart to an RTF Template Designing an RTF Template for a BI Publisher Report Creating a BI Publisher Report by Using Template Builder in Online Mode Exploring the Basic and Form Field Methods Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting BI Publisher Server: Administration and Security Describing the Administration Page Creating the JDBC Connections Setting, Viewing, and Updating Data Sources Describing the Security Model for BI Publisher and Oracle Fusion Middleware Describing Groups, Users, Roles, and Permissions Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS Describing and Configuring BI Publisher Scheduler Integrating with Oracle BI Presentation Services and Oracle Endeca Server Scheduling and Bursting Reports Scheduling and Describing a Report Job and Related Options Managing and Viewing a Report Job Viewing Report Job History Scheduling a Report with Trigger Describing Bursting Adding a Bursting Definition to a Data Model Scheduling a Bursting Job Integrating BI Publisher with Oracle BI Enterprise Edition Configuring Presentation Services Integration Navigating Oracle BI EE Creating a Report based on OBI EE Subject Area Creating a Data Model and Report based on a BI Server SQL Query Creating a Data Model and Report based on an Oracle BI Analysis Adding a BI Publisher Report to an Oracle BI EE Dashboard Creating Data Models and BI Publisher Reports Based on Other Data Sources Configuring Presentation Services Integration Describing the Web Services Data Source Describing the HTTP (XML/RSS Feed) Data Source Explaining Proxy Setting for Web Services and HTTP Data Sources Creating a BI Publisher Report based on an External Web Service Creating a BI Publisher Report based on an HTTP Data Set Creating a BI Publisher Report Based on XML File Creating a BI Publisher Report Based on CSV Data source Performing Translations Describing Translation Types Translating by Using the Localized Template Option Translating by Using the XLIFF Option Managing XLIFF Translations on BI Publisher Server Describing the Overall Translation Process Describing Catalog Translation Exporting and Importing the XLIFF for a Catalog Folder Additional course details: Nexus Humans Oracle BI Publisher 12c R1: Fundamentals 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 Oracle BI Publisher 12c R1: Fundamentals 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.

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Additional course details: Nexus Humans Oracle BI 11g R1 - Build Repositories 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 Oracle BI 11g R1 - Build Repositories 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.