Business Intelligence Courses


10988: Managing SQL Business Intelligence Operations

This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed Business Intelligence (BI) data sources and expanding to personal and external/public data sources.

Read More

10990: Analyzing Data with SQL Server Reporting Services

This course teaches attendees how to implement a SQL Server® 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Read More

10994: Data Analysis Fundamentals Using Excel

The main purpose of this course is to give participants the ability to add analysis capabilities to Excel® spreadsheets. It also provides participants with a foundation to learn about more advanced data analytics with Excel or Power BI®.

Read More

20332 Advanced Solutions of Microsoft SharePoint Server 2013

This course examines how to plan, configure, and manage a Microsoft® SharePoint® Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the search experience, how to develop and implement a governance plan. and how to perform an upgrade or migration to SharePoint Server 2013.

Read More

20339-2 Advanced Technologies of SharePoint 2016

This course will teach participants how to plan, configure, and manage the advanced features in a SharePoint® 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft® Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Participants also will learn about Business Intelligence (BI) solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016. NOTE: This course is the second in a sequence of two courses for IT Professionals.

Read More

20461 Querying Microsoft SQL Server 2014

This course provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft® SQL Server® 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Read More

20464 Developing Microsoft SQL Server 2012/2014 Database

This course introduces participants to SQL Server® and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

Read More

20466 Implementing Data Models and Reports with SQL Server 2012/2014

The focus of this course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint® Server PerformancePoint Services, and discover business insights by using data mining.

Read More

20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012/2014

This course teaches participants how to plan and design a BI solution that is based on Microsoft® SQL Server® 2014 and other Microsoft BI technologies.

Read More

20767: Implementing a SQL Data Warehouse

This course provides attendees with the knowledge and skills to provision a Microsoft® SQL Server® database. It covers SQL Server provision both on-premise and in Azure®, and covers installing from new and migrating from an existing install.

Read More

20768: Developing SQL Data Models

The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course also helps you prepare for the certification exam.

Read More

20778: Analysing Data with Power BI

This course provides participants with the knowledge and skills to analyse data with Power BI®.

Read More

50433: PowerPivot for End-Users

This course will teach participants how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. They will also explore how PowerPivot workbooks can be integrated with SharePoint®.

Read More

55163: Preparing Your Data for Power BI

This course is designed to introduce participants to the SQL Business Intelligence Semantic Model (BISM) Tabular model, data modelling, and DAX.

Read More

55164: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

This course teaches participants how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI® into graphs, charts, KPIs, reports, and other visualizations for use in their business.

Read More

Crystal Reports 2016: Part 1

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, participants will create a basic report by connecting to a database and modifying the report's presentation.

Read More

Crystal Reports 2016: Part 2

In this course, participants will create complex reports and data sources using the tools in Crystal Reports® 2016. They will not only create more sophisticated reports including subreports, cross-tabs and running totals but will also increase the speed and efficiency of their reports by using SQL queries.

Read More

DA-100T00: Analysing Data with Power BI

This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing and analysing data with Microsoft® Power BI®. The course will also show participants how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show participants how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Read More

Data Analysis and Visualization with Microsoft Excel

Analysing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft® Excel® is designed for this purpose. This course will show participants how to use Excel to connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. At the end of this course, these capabilities will enable participants to turn data into thoughtful action.

Read More

Microsoft Excel for Office 365: Dashboards

With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. This course introduces the basics of data analysis and how to use Microsoft® Excel® to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights.

Read More

Microsoft Office Excel 2016/2019: Dashboards

This course builds upon the foundational knowledge presented in either of the Microsoft® Office Excel® 2016/2019: Part 1 (Desktop/Office 365™) courses. It will help participants start down the road to creating advanced workbooks and worksheets that they can use to create dashboards. The ability to analyse massive amounts of data, extract actionable intelligence from it, and present that information to decision-makers is the cornerstone of driving a successful organization that can compete at a high level.

Read More

Microsoft Office Excel: Data Analysis with PivotTables

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. You already have experience working with Excel® and creating basic PivotTables to summarize data. But, Excel® is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyse, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance of success for everyone involved.

Read More

Microsoft Office Excel: Data Analysis with Power Pivot

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyse large amounts of data quickly. Fortunately, Excel® provides Power Pivot to help users organize, manipulate, and report on their data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analysing data.

Read More

Microsoft Power BI: Data Analysis Practitioner

Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.

Read More

Microsoft Power BI: Data Analysis Professional

Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.

Read More

SAP Crystal Reports 2020: Part 1

Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Thus, organizations use reporting tools to access data sources and generate customized reports. In this course, participants will create a basic report using SAP® Crystal Reports® 2020 by connecting to a database and modifying the report's presentation.

Read More

SAP Crystal Reports 2020: Part 2

Until now, you have used SAP® Crystal Reports® 2020 to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, participants will create complex reports and data sources using the tools in Crystal Reports 2020. They will create more sophisticated reports including subreports and cross-tabs but also increase the speed and efficiency of their reports by using SQL queries. By creating subreports, cross-tabs, and running totals, they will turn raw data into meaningful customized reports that will help their business run more smoothly. Participants will also learn to use tools that can increase the speed with which data is retrieved and thus eliminate any performance issues they may be faced with.

Read More

SQL for Data Analytics

This course covers everything participants need to progress from simply knowing basic SQL to telling stories and identifying trends in data. Participants will be able to start exploring their data by identifying patterns and unlocking deeper insights. They will also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, they will understand how to become productive with SQL with the help of profiling and automation to gain insights faster. By the end of the course, participants will be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of analytics professional.

Read More