• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

BUY THIS COURSE (USD 31 USD 69)
4.6 (182 reviews)
( 954 Students )

 

Bundle Course - BI Tools (Tableau - Power BI - SAP BO)

You will develop your skills as a BI/Analytics Professional to derive information from data, analyze complex business problems, derive useful trends.
( add to cart )
Save 55% Offer ends on 30-Jun-2024
Course Duration: 75 Hours
Preview Bundle Course - BI Tools (Tableau - Power BI - SAP BO) course
View Course Curriculum   Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Cutting-edge
Trending
Job-oriented
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

BI Tools bundle course consists of self-paced courses on 3 of the leading Business Intelligence & Reporting tools in the industry. These are:

1) Tableau
2) Power BI
3) SAP BusinessObjects Business Intelligence

  

Tableau is a visual investigation platform changing the manner in which we use information to tackle issues—enabling individuals and associations to capitalize on their information. As the leader in modern business intelligence, the Tableau platform is known to quickly and easily transform any type of data from nearly any system into active insights. It's as easy as dragging and dropping.

With Uplatz's Tableau course you will learn - 

Data Visualization, Business Intelligence tools, Introduction to Tableau, Tableau Architecture, Tableau Server Architecture, VizQL, Introduction to Tableau Prep, Tableau Prep Builder User Interface, Data Preparation techniques using Tableau Prep Builder tool, and more. 

 

Power BI is a Business Intelligence, cloud-based platform that provides non-technical users with tools to analyse, visualize and store data. Power BI is simple and user friendly and best for the user familiar with Excel.  It converts data from different sources to interactive dashboards and BI reports and is used by data analyst and business intelligence to a create report. Power BI includes several components: Power BI desktop, gateway, mobile app and services. It allows user to connect to SQL database, Azure cloud and web platform like Facebook, Google analytics etc.

This PowerBI course by Uplatz provides comprehensive knowledge on the end to end process involved in PowerBI. This training will help you to master in data analyst and business intelligence in great details.

 

SAP BusinessObjects Business Intelligence (simply known as SAP BO or BOBJ) is a reporting and analytics tool aimed at providing business insights and management reporting. SAP BO suite consists of a number of reporting applications that allow users to discover data, perform analysis to derive insights and create reports that visualize the insights. 

SAP BusinessObjects BI enable the organizations to connect to any data source, structured and unstructured, relational, multidimensional or hybrid databases, OLAP cubes, documents, e-mails, social media, etc., process this data into useful information, and place it in the users hands for easy, yet dynamic and personalized visualization leading to increased sales, conversions, and customer experience.

Course/Topic 1 - Tableau (basic to advanced) - all lectures

  • Tableau Tutorial provides basic and advanced concepts of Tableau. Our Tableau Tutorial is designed for beginners and professionals both. Tableau is a data visualization tool or business intelligence tool which analyzes and shows data in a chart or report fast. It is very easy to use, because it does not require any programming skill.

    • 34:10
  • In this tutorial, we are going to learn about data sources or data connections in Tableau. We will start with the basics and explore in detail how to make connections with different types of data sources in Tableau. So, let’s get started.

    • 1:08:07
  • In this tutorial, we will discuss about Dimensions and Measures, what they are and how we use them.

    • 1:10:32
  • This tutorial walks you through the features and functions of Tableau Desktop. As you work through this tutorial, you will create multiple views in a Tableau workbook. The steps you'll take and the workbook you'll work in are based on a story about an employee who works at headquarters for a large retail chain. The story unfolds as you step through asking questions about your business and its performance.

    • 45:18
  • Building Basic Views

    • 35:06
  • In this session you will learn to combine dimensions if you want to encode a data view using multiple dimensions.

    • 1:02:18
  • In this tutorial, Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis.

    • 58:48
  • Building a table of multiple measures in Tableau is straightforward. You can build the table using only two pills. Use the dimension Measure Names and the measure Values. This also works to compare multiple measures side by side in a Tableau bar chart. Building the multiple measures bar chart is covered towards the end of this video.

    • 43:37
  • This tutorial walks you through some of the most common tasks you might perform when creating maps in Tableau.You'll learn how to connect to and join geographic data; format that data in Tableau; create location hierarchies; build and present a basic map view; and apply key mapping features along the way.

    • 1:15:34
  • In this Tableau Tutorial, you will learn how to apply filters on data in a Tableau workbook. Here, you will learn about applying simple Tableau filters on data visuals as well as about some advanced types like extract filters, interactive filters, etc. So, open your Tableau Desktop and learn with us!

    • 1:22:41
  • Tableau provides the ability to filter individual views or even entire data sources on dimensions, measures, or sets. What’s more, most of these filters can be put into the hands of you and your end users to change – a powerful tactic for finding stories in the data.

    • 47:24
  • The filters can be applied in a worksheet to restrict the number of records present in a dataset. Various types of filters are used in Tableau Desktop based on different purposes. The different types of filters used in Tableau. The name of filter types is sorted based on the order of execution in Tableau.

    • 52:45
  • Data joining is a very common requirement in any data analysis. You may need to join data from multiple sources or join data from different tables in a single source. Tableau provides the characteristics to join the table by using the data pane available under Edit Data Source in the Data menu.

    • 1:43:51
  • Data Blending is a very powerful feature in Tableau. It is used when there is related data in multiple data sources, which you want to analyze together in a single view.

    • 1:30:37
  • Hierarchies are logical relationships between categories such as Country, State, City. Groups are selections of attributes that you may want to examine because they are outliers or of a specific type.

    • 37:42
  • This video puts together different Tableau Charts with the type of data you’re analyzing and questions you want to answer, to help you find the appropriate chart for your needs.

    • 45:22
  • Cascading filters are filters in which the selections in the first filter can change the options in the second filter to limit them to only those values that are relevant to the first filter.

    • 39:32
  • As tableau being a visual intelligence tool, we can display the output in the form of visuals. If you want to display the values associated in the form of image, then we can be able to perform the imaged processing in tableau.

    • 21:41
  • Sorting of data is a very important feature of data analysis. Tableau allows the sorting of data of the fields, which are called dimensions.

    • 36:59
  • This video describes how to create and use calculated fields in Tableau using an example. If you're new to Tableau calculations or to creating calculated fields in Tableau, this is a good place to start.

    • 1:02:56
  • You'll learn Tableau calculation concepts, as well as how to create and edit a calculated field. You will also learn how to work with the calculation editor and use a calculated field in the view.

    • 55:14
  • Table Calculations are basically a special type of field that computes on the local data. The following article is going to take you through all you need to know to start using Table Calculations in Tableau.

    • 1:03:50
  • Table calculations in Tableau are basically transformations you apply to the values in a visualization. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.

    • 1:33:23
  • Tableau Table Calculations are the special type of calculated field. Unlike regular calculated fields, table calculations in Tableau are based on the data that is currently visualized in a report. This article shows how to create Tableau table calculations, and how to use their properties.

    • 1:18:40
  • In this Tableau tutorial I will discuss a basic quick table calculation and try to demystify what is happening behind the scenes. All of the following will hopefully be made clearer in the video.

    • 51:44
  • Data Blending is a very powerful feature in Tableau. It is used when there is related data in multiple data sources, which you want to analyze together in a single view. It is a method for combining data that supplements a table of data from one data source with columns of data from another data source.

    • 1:46:02
  • You can show trend lines in a visualization to highlight trends in your data. You can publish a view that contains trend lines, and you add trend lines to a view as you edit it on the web.

    • 50:06
  • Table calculations are among the most powerful features Tableau has to offer for answering your analytical questions. You can select from a collection of pre-defined calculations or create your own Table Calculation from scratch using Table Calculation functions.

    • 2:32:33
  • A table calculation is a transformation we apply to the values of a single measure in our view, based on the dimensions in the level of detail.

    • 1:08:16
  • Tableau provides a complete range of chart styles. You really don’t even have to understand why a particular chart is better. If you rely on the show me button, tableau will provide an appropriate chart based on the combination of measures and dimensions you’ve selected.

    • 53:25
  • In this session you will learn about the next step of advanced chart which help you in creating the chart.

    • 47:14
  • Level of Detail (LOD) expressions are used to run complex queries involving many dimensions at the data source level instead of bringing all the data to Tableau interface. A simple example is adding dimension to an already calculated aggregate value.

    • 2:22:33
  • Moving on with our Tableau learning spree, in this tutorial we are going to learn about another interesting topic, that is, Level of Detail or LOD in Tableau. In this tutorial, we are going to learn about the types of LOD expressions, how to create LODs in Tableau with examples.

    • 1:21:49
  • Add context and interactivity to your data using actions. Users interact with your visualizations by selecting marks, or hovering, or clicking a menu, and the actions you set up can respond with navigation and changes in the view.

    • 1:12:02
  • Using the Sample-superstore, plan to create a dashboard showing the sales and profits for different segments and Sub-Category of products across all the states.

    • 2:20:23
  • Tableau dashboard is a group of various views which allows you to compare different types of data simultaneously. Datasheets and dashboards are connected ones if any modification happens to the data that directly reflects in dashboards. It could be the best way to visualize and analyze the data.

    • 1:15:08
  • A dashboard is a collection of different kinds of visualizations or views that we create on Tableau. We can bring together different elements of multiple worksheets and put them on a single dashboard. The dashboard option enables us to import and add charts and graphs from worksheets to create a dashboard. On a dashboard, we can place relevant charts and graphs in one view and analyze them for better insights. Now, we will learn in a stepwise manner how to create a dashboard in Tableau Desktop.

    • 1:17:17
  • Tableau has a very wide variety of formatting options to change the appearance of the visualizations created. You can modify nearly every aspect such as font, color, size, layout, etc. You can format both the content and containers like tables, labels of axes, and workbook theme, etc.

    • 1:12:21
  • In our part 2, we study how to create a word cloud in Tableau, in this tutorial, we are going learn about the Tableau formatting, the various types of formats in Tableau: Formatting the Axes, Change the Font, Change the Shade and Alignment, Format Borders. We will learn about them and thus move a step further in our journey of mastering Tableau. So, let’s start Tableau Formatting.

    • 58:49
  • Sometimes, analyzing data that is stored in a crosstab format can be difficult in Tableau. When working with Microsoft Excel, text file, Google Sheets, and .pdf data sources, you can pivot your data from crosstab format into columnar format. If you are working with other data sources, you can Pivot using custom SQL (Tableau Desktop).

    • 31:10
  • In this session you will learn about the order of operations in Tableau, sometimes called the query pipeline, is the order in which Tableau performs various actions. Actions are also known as operations. Many operations apply filters, which means that as you build a view and add filters, those filters always execute in the order established by the order of operations.

    • 53:30
  • In this last video, you will understand how Tableau works it is useful to know the order in which it manipulates and filters data when producing your view. This process is called the order of operations. It helps to know the order of operations so you can use it to your advantage when using any kind of filter or level of detail calculation, or if you ever find yourself confused as to why Tableau won’t produce the view you want.

    • 36:31

Course/Topic 2 - Tableau - all lectures

  • In this video lecture we learn basic about Tableau. Tableau is a business intelligent tool for visually analysing the data.

    • 10:01
  • In this video we talk about Tableau Desktop Basics and also cover all the Basic topics of Tableau Desktop.

    • 02:32
  • In this video we learn how to install Tableau business intelligent tool into your desktop and process of Tableau Desktop Installation.

    • 06:28
  • In this video we about Tableau Desktop Workspace Navigation and cover all the importance of Tableau Desktop Workspace Navigation.

    • 10:40
  • In this session we talk about Tableau Design Flow and also cover all the different types of Tableau Design Flows.

    • 07:08
  • In this video we learn about Connections to Multiple Data Sources and cover all techniques of data sourcing.

    • 18:04
  • In this video we talk about Hands-on - Tableau Data Connection and also cover different between live and exact Tableau Data Connection.

    • 21:51
  • In this session we learn basic about Tableau Filters and different types of filters we can use in Tableau business tool.

    • 31:46
  • Data can be organized and simplifies by using various techniques in Tableau. In this session we also cover types of filters and condition of filters in Tableau.

    • 16:06
  • In this session we learn about Tableau Operators. Types of Tableau Operators and how to use these Tableau Operators.

    • 18:30
  • In this video we talk about Bins - Groups - Sets – Parameters and also cover all the parameters we use in Tableau.

    • 15:00
  • In this session we learn about Hands on - Tableau Sets and cover all different sets in Hands on - Tableau Sets..

    • 13:35
  • In this session we talk about Basic Tableau Charts and learn about different types of charts.

    • 23:26
  • In this video we talk about Hands on - Basic Tableau Charts how to make pie chart and importance of charts in Tableau business tool.

    • 21:24
  • In this lecture we learn the Tableau Advanced Topics like Advance graphs, LODS and its usage and extensions etc.

    • 03:03
  • In this video we talk about Tableau Extensions and cover all different types of extensions in a single video.

    • 21:20
  • In this Lecture section we talk and overview the Tableau Dashboards and explore the Dashboards of Tableau.

    • 26:30
  • In this lecture session we talk about the Tableau Story. In Tableau story is a sequence of visualization that work together to convey the information.

    • 20:27
  • In this video we talk about Tableau LODs extension and importance of LODs extension in Tableau business tool.

    • 18:55
  • In this lecture session we talk about Tableau Actions and also cover all Actions filters.

    • 26:53

Course/Topic 3 - Power BI (basic to advanced) - all lectures

  • This is an introductory video of Power BI to get you started in this tutorial video, learn how to get started using Microsoft Power BI. Power BI allows you to get insight from your business data.

    • 2:00:46
  • Microsoft Power BI is one of the most popular Data Visualization and Business Intelligence tool. The Power BI tool is the collection of apps, data connectors, and software services which are used to get the data from different data sources, transforms data, and produces useful reports.

    • 1:11:26
  • In Microsoft Power BI services which are based on SaaS and mobile Power BI apps that are available for different platforms. These set of services are used by the business users to consume data and to build Power BI reports.

    • 1:12:22
  • This tutorial helps you to clear all the essential concepts in Power BI and provides enough knowledge on how to use Power BI or how to work on Power BI.

    • 1:03:39
  • The BI term refers to Business Intelligence. It is a data-driven decision support system, which helps you to analyse the data and provide actionable information. It helps the business manager, corporate executives, and other users in making their decisions easily.

    • 1:07:33
  • This Business intelligence refers to the applications, technologies, and practices for the collection, analysis, integration, and presents the business information. The purpose of business intelligence is to support better decision making.

    • 1:15:47
  • Business intelligence is used to improve all parts of a company by improving access to the firm's data and then using that data to increase profitability. Companies that practice BI can translate their collected data into insights their business processors.

    • 1:06:13
  • Power BI is a Data Visualization, and Business Intelligence tool which helps to convert data from different data sources into interactive dashboards and BI reports. It provides interactive visualizations with self-service business intelligence capabilities where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.

    • 19:07
  • Power BI provides multiple connectors, software, and services. These services based on the SaaS and mobile Power BI apps which are available for different platforms. These set of services are used by business users to consume data and to build BI reports.

    • 1:13:51
  • Power BI dashboard is a single page, also called a canvas that uses visualization to tell the story. It is limited to one page; therefore, a well-designed dashboard contains only the most essential elements of that story.

    • 1:21:57
  • A Power BI report is a multi-perspective view into the dataset, with visualizations which represent different findings and insights from that dataset.

    • 33:47
  • Power BI Desktop and Power BI Services support a large range of data sources. Click on the Get Data button, and it shows you all the available data connections. You can connect to different Flat files, Azure cloud, SQL database, and Web platforms, also such as Google Analytics, Facebook, and Salesforce objects. It includes an ODBC connection to connect to other ODBC data sources.

    • 52:16
  • In this section of the Power BI tutorial, we will learn about each of these Power BI services or components and their roles.

    • 1:15:55
  • In this section, we will briefly walk through a case study of Power BI. This will help to understand the role of Power BI in a real-life scenario.

    • 1:17:30
  • Moving forward in our Power BI tutorials series, let us explore some important features of Power BI thoroughly. Power BI is an efficient business intelligence tool loaded with data visualization and analytics rich features.

    • 06:58
  • This Power BI tutorial we’re going to learn from the basics then we will gradually move upwards, learn about its components and how it works.

    • 1:04:40
  • In this tutorial, we studied Power BI Architecture. Today, we will discuss Power BI Building Blocks. In this Power BI Tutorial, we are going to explore the components of Power BI: Visualizations, Datasets, Reports, Dashboards, and Tiles. So, let’s start the Power BI Building Blocks Tutorial.

    • 1:45:08
  • In this Power BI Tutorial, we will discuss Power BI Query, Power BI Pivot, Power BI View, Power BI Map, Power BI Q&A, Power BI Desktop, Power BI Website, and Power BI Mobile Apps. So, let’s start the Power BI Components Tutorial.

    • 44:44
  • we learn how to download and Install Power BI. First of all, we will see a list of an operating system which supports Power BI. Moreover, we will study, seven simple and quick steps to install power BI on windows.

    • 55:26
  • In this lesson, we are going to discuss the pros and cons of Power BI. As we learned from the tutorial on Features of Power BI, it’s a great tool to use for data analysis and discovering important insights. But, let us go into a little detail and learn about the advantages and disadvantages of Power BI so that you can have some basis to compare it with other tools.

    • 37:17
  • In this Power Bi tutorial, we will study about Power BI data modeling. Moreover, we will see how we use Data Modeling in Power BI, and how to Create Calculated Columns in Data Modeling in Power BI.

    • 54:27
  • In addition, we will talk about how to Create a Calculated table in Power BI Data Modeling and Use information Modeling and Navigation.

    • 40:23
  • In Power BI Tutorial, we talked about Power BI Dashboard. Here, we are going to create Workspace in Power BI or in other words we are creating groups in Power BI Workspace.

    • 40:35
  • Moving forward in our series of Power BI tutorials, the next interesting topic is Power BI Dashboard. Power BI Dashboard is a fundament element in Power BI Desktop.

    • 1:13:29
  • In Power BI tutorial, we studied How to Create Workspace in Power BI. Today, in this instructional exercise, we will figure out how to Share Power BI Dashboard – Outside Organization/Clients. Moreover, we will discuss different ways to share internal & external clients.

    • 1:28:03
  • Despite the fact that Power BI is intended for you to impart a dashboard to clients who are inside a similar association, you can likewise impart dashboards to individuals from different associations.

    • 58:25
  • In this Power BI tutorial, we will learn about how Power BI Create dashboard & report on iPhone, iPad, Android Phone, Android Tablet, Windows 10. Moreover, we will discuss the How power BI view dashboard on land space mode of Windows 10 Devices.

    • 1:00:07
  • Whenever you will search for Power BI Desktop on Google, you will find many websites covering the installation and functions of Power BI in a technical language. But here I am providing you with all the aspects of Power BI in a very simple language.

    • 54:52
  • In this Power BI tutorial, we will learn about Interface with information in Power BI work area. Moreover, we will learn how to connect to data in Power BI Desktop.

    • 50:23
  • In our tutorial, we discussed Analytics Pane in Power BI. Today, in this Q & A in Power BI Desktop Tutorial, we will learn how to add a missing relationship and rename tables and columns. Moreover, we will study how to fix incorrect data types and choose the data category for each date and geography column. At last, we will cover to normalize your model.

    • 58:34
  • In this tutorial, we will study Power BI Measure. Today, we are going to learn the Power BI Archived Workspace. Moreover, we will study the Confinements and Moving Content in your Archived Workspace in Power BI. At last, we will cover the Power BI Archived Workspace in Office 365.

    • 46:31
  • In this video, we talked about the Power BI Archived Workspace. In this Power BI Data Source Tutorial, we are going to learn Data Sources for Power BI Services. Moreover, we are going to discuss how data originates from an alternate source and some subtle elements. Along with this, we will cover the types of data sources for Power BI.

    • 42:23
  • In this Power BI tutorial, we will study Power BI Data Source. Today in this Power BI Admin tutorial, we will learn about the various roles of Power BI administration: Purchasing, REST API, and Security.

    • 1:17:24
  • Continuing with our Power BI tutorial series, now, we will learn about Power BI Report Server. As we know, Power BI as a technology is a collection of several other technologies and services. Power BI Report Server is one such crucial technology. Here, we will learn about its different aspects.

    • 52:22
  • In this session we are going to explore the working of a table in Power BI. In addition, we will discuss when to use a Power BI table with its prerequisites. Along with this we will study how to Create a table & Format the table, and adjust the column width of a table in Power BI.

    • 40:57

Course/Topic 4 - Power BI - all lectures

  • Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations and see how other organizations have used this solution to drive business results with actionable insights.

    • 20:51
  • In this session, with Power BI Desktop, you can build advanced queries, models, and reports that visualize data. You can also build data models, create reports, and share your work by publishing to the Power BI service.

    • 01:57
  • This is the first part of Basic Dashboard in Power BI. In this video you will learn how to create a basic dashboard with simple data points.

    • 23:35
  • In this Video, we will show you how can you install Power PI desktop in PC.

    • 18:05
  • The third part in a series of Microsoft Power BI tutorials for beginners. This tutorial cover Filter’s pane and the Slicers.

    • 30:14
  • In this Part 4, video shows the time slicer feature of Power BI Desktop. Also running some simple statistics using the matrix visualization.

    • 30:09
  • In this Part 5 session you will learn about how to create a simple R script in Power BI desktop using the grid Extra package for displaying data and the dplyr package for data munging.

    • 21:32
  • In this Microsoft Power BI video, you will learn how to represent the data in a Map using Power BI. For this purpose, a data that contains the columns such as a State, Province, Country, City, ZIP Code/Postal Code, etc. must be present in the database

    • 33:52
  • In this video you can explore, what is Star Schema, why it is important in Power BI, Among the most basic design skills in designing a data warehouse solution is the star schema design.

    • 09:10
  • In this Power BI Tutorial, you will look at how to use Power Query in Power BI Desktop to merge different queries and join kind. This Microsoft Power BI tutorial for beginners is aimed at new Power BI users.

    • 07:49
  • In this video we will go through the basics of data modelling in Power BI, to get you started fast and easy.

    • 01:52
  • In this video, learn how to use relationship’s view, what other views exist in Power BI Desktop and why it's important to use them.

    • 10:39
  • This video explains the importance of cross filter direction in Microsoft Power BI. It discusses how the single or bi-directional filter affects the data in the report.

    • 12:44
  • In this video you will see details about m language and dax language.

    • 16:22
  • In this video you will learn how to create two interactive Power BI dashboards, plus a decomposition tree using the free Power BI tools.

    • 26:35
  • In this video, we will show you how you can use a parameter, within a Power BI report, to dynamically change the data in a report.

    • 15:46

Course/Topic 5 - SAP BO - all lectures

  • In this video tutorial, you will get a brief introduction on SAP BO, how it came to be known as SAP BI, what are the different layers in SAP BI, characteristics in Data Warehouse, schema, master data tables and also a detailed explanation on how a student can access and work on the server for practicing his daily SAP system works.

    • 1:35:18
  • In this tutorial, you will learn how you can access the Business Object components in the SAP system through remote desktop. You will also be able to understand a detailed explanation on the different designing components. Lastly, you will get a detailed demonstration on how to work on the different design tools in the SAP system.

    • 57:33
  • In this lecture, you will be able to understand what a Designer is in the SAP BO module and how to work with the different designing tools available in the SAP system. You will also learn what is a Universe, Role of a Universe and the Semantic Layer in the initial screen of the designing tool.

    • 2:05:35
  • In this tutorial, you will learn how to create a Universe in the designing tool of the BO module, manually. This is explained in a detailed demonstration by the Instructor which will help you in getting a practical experience on the work process. Further, you will also understand what the different types of OLTP systems are and what is their role in the SAP BO design tool.

    • 1:00:08
  • In this tutorial, you will learn how you can create the characters in the SAP BO system, how IDT and UDT helps in the Online Analytic Process (OLAP). You will also learn how to create an infocube and what are the steps to be followed while creating an infocube in the SAP BW system.

    • 2:10:35
  • In this video, you will learn how to create data from scratch using the Universe Design tool in the SAP BO module. You will also learn how you can create the BSO in the system tool, using a pictorial description of the entire work process.

    • 1:30:11
  • To access anything from the ECC server, one needs to know the Transaction Codes. In this video, you will learn about these Transaction Codes or T-Codes which will be used in working on the SAP BO system module. You will also get an overview on the Object Hierarchies, which allows users in performing multi-dimensional analysis.

    • 1:24:06
  • In this tutorial, you will be learning the role of IDT and UDT in the SAP BO Design Tool. You will also learn about the types of Web Intelligence and the entire work process with a detailed demonstration from the instructor. Along with this, you will be learning on how to create reports and the different fields and attributes required in creating the reports.

    • 2:30:53
  • In this video lecture, you will learn the different formatting options available to create and modify reports in the SAP BO Design Tools. You will learn how to add rows and columns, category, margins, pictures, articles and others. Further, you will learn how to work on the sub-reports and the functionalities available in the crystal reports. Moreover, you will also get an overview on the dashboard components.

    • 2:00:16
  • In this lecture, you will learn what are the parameters to be used while working on a crystal report by a user. Also, you will see a detailed demonstration on how to work on the Table Article Label, Article Lookup and the Body of the report.

    • 1:01:37
  • In this lecture, you will learn about the different types of dashboard designing components used in the SAP BO module. Further, you will learn how to work on the SAP Lumira Design component, how to add new data set, characteristic dimensions and the different modes in the Lumira Designing Tool.

    • 1:40:21
  • In this video tutorial, you will get a detailed and practical demonstration on how to work on the Information and Quick Design Tool in the SAP BO module. You will also get some more detail concepts and work around on the SAP Lumira Designing Tool.

    • 1:30:58
  • In this tutorial, you will be learning how to connect to a SAP HANA database. Also, you will learn how to use the database and the data models. Moreover, you will also learn how to do the HANA connectivity. This whole work process will be practically demonstrated by the instructor in detail.

    • 2:23:01
  • In this video, you will learn how to access the views using Information Design Tool (IDT), which can be done using the HANA Data Acquisition Connector. You will also be learning how to assign a data source and also working on the whole of the data source work process.

    • 1:29:35
  • In this tutorial, you will learn what is a Web Application Designer (WAD) and what is its role in connecting with the BW Server. You will also learn how to work on the Basis Analysis Layout Template, which is a pre-defined standard template used for ad-hoc slicing and dicing data sources. You will also learn how to work on the attribute views.

    • 2:14:32
  • In this last video lecture, you will learn how you can connect to HANA tables and modules using IDT. You will further learn to work on the SAP HANA business layer and other concepts related to the SAP BO module.

    • 1:09:15
Course Objectives Back to Top

The main objective of this course is to gain proficiency in the top leading business intelligence reporting tools. The main objectives are:

·          To understand the essentials of data analytics in the industry

·          To be familiar with the steps involved in the analytics process

·          Toknow about the fundamental principles of data science and the business analytics

·          To gain factual knowledge such as terminologies, classification, methods and trends

Course Syllabus Back to Top

Bundle Course – BI Tools - Course Syllabus

 

  Tableau – Course Syllabus

 

ï‚·       Tableau History, Interface and Components

 

 

 

ï‚·       Connecting to databases and preparing data

 

 

 

ï‚·       Data Refresh and Blending

 

 

 

ï‚·       Sorting

 

 

 

ï‚·       Grouping

 

 

 

ï‚·       Creating Sets

 

 

 

ï‚·       Filters

 

 

 

ï‚·       Filter shelves

 

 

 

ï‚·       Quick Filter

 

 

 

ï‚·       Parameters

 

 

 

ï‚·       Formatting

 

 

 

ï‚·       Trend Lines and reference lines

 

 

 

ï‚·       Drills

 

 

 

ï‚·       Introduction to Dashboards and Story

 

 

 

ï‚·       Building dashboards

 

 

 

ï‚·       Layouts and Formatting

 

 

 

ï‚·       Interactivity

 

 

 

ï‚·       StoryPoints

 

 

 

ï‚·       Maps

 

 

 

ï‚·       Background Images

 

 

 

ï‚·       Calculations Syntax

 

 

 

ï‚·       Modifying Table calculations

 

 

 

ï‚·       Aggregations and LOD Expressions

 

 

 

ï‚·       Advanced Charts and graphs (Pareto, Waterfall, Funnel,..)

 

 

 

ï‚·       Histograms

 

 

 

ï‚·       Tree maps and bubble charts

 

 

 

ï‚·       Best practices

 

 

 

ï‚·       Case Studies

 

 

 

 

 

Power BI Syllabus

 

Power BI Complete Introduction

 

·         Power BI Introduction

 

·         Data Visualization, Reporting

 

·         Business Intelligence(BI), Traditional BI, Self-Serviced BI

 

·         Cloud Based BI, On Premise BI

 

·         Power BI Products

 

·         Power BI Desktop (Power Query, Power Pivot, Power View)

 

·         Flow of Work in Power BI Desktop

 

·         Power BI Report Server, Power BI Service, Power BI Mobile

 

·         Flow of Work in Power BI / Power BI Architecture

 

·         A Brief History of Power BI

 

·          

 

PBI Desktop Installation, PBI Desktop &Service Overview

 

·         Power BI Desktop Installation

 

·         Building Blocks of Power BI

 

·         Datasets, Visualizations, Reports, Dashboards, Tiles

 

·         Power BI Desktop User Interface

 

·         Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas

 

·         Overview of Power Query / Query Editor – Extract, Transform & Load Data

 

·         Connecting to Data Sources, Establish connection to the Excel source

 

·         Importing Data into Power BI or Query Editor

 

·         Transforming the Data using Power Query

 

·         Model the Data using Power Pivot – Relationship View

 

·         Creating New Measures and New Columns using DAX – Data View

 

·         Visualizing the Data using Power View and Power Maps – Report View

 

·         Saving and Publishing the Visuals or Reports

 

·         Logon to Power BI Service

 

·         View the Reports in PBI Service and Share the reports

 

 

 

Power Query

 

Introduction to Power Query – Extract, Transform & Load

 

·         Data Transformation, Benefits of Data Transformation

 

·         Shape or Transform Data using Power Query

 

·         Overview of Power Query / Query Editor, Query Editor User Interface

 

·         The Ribbon (Home, Transform, Add Column, View Tabs)

 

·         The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar

 

·         Advanced Editor – Complete ETL Code

 

·         Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model

 

·         Power Query Conceptually

 

 

 

Datatypes and Filters in Power Query

 

·         Datatypes, Changing the Datatype of a Column

 

·         Filters in Power Query

 

·         Auto Filter / Basic Filtering

 

·         Filter a Column using Text Filters

 

·         Filter a Column using Number Filters

 

·         Filter a Column using Date Filters

 

·         Filter Multiple Columns

 

Inbuilt Column Transformations

 

·         Remove Columns / Remove Other Columns

 

·         Name / Rename a Column

 

·         Reorder Columns or Sort Columns

 

·         Add Column / Custom Column

 

·         Split Columns

 

·         Merge Columns

 

·         PIVOT, UNPIVOT Columns

 

·         Transpose Columns

 

 

 

In built Row Transformations

 

·         Header Row or Use First Row as Headers

 

·         Keep Top Rows, Keep Bottom Rows

 

·         Keep Range of Rows

 

·         Keep Duplicates, Keep Errors

 

·         Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows

 

·         Remove Duplicates, Remove Blank Rows, Remove Errors

 

·         Group Rows / Group By

 

 

 

Combine Queries (Append Queries & Merge Queries)

 

Append Queries / Union Queries

 

·         Append Queries

 

·         Append Queries as New

 

·         Append 2 or more files individually with different queries

 

·         Appending multiple files of same type from a folder using single query

 

·         Query Options

 

·         Copy Query, Paste Query

 

·         Delete Query, Rename Query

 

·         Enable Load, Include in report Refresh

 

·         Duplicate Query, Reference Query

 

·         Move to Group, Move Up, Move Down

 

 

 

Merge Queries / Join Queries

 

·         Merge Queries, Merge Queries as New

 

·         Default Types of Joins / Join Kinds / Merge Type

 

·         Left Outer (all from first, matching from second)

 

·         Right Outer (all from second, matching from first)

 

·         Full Outer (all rows from both)

 

·         Inner (only matching rows)

 

·         Left Anti (rows only in first)

 

·         Right Anti (rows only in second)

 

·         Cartesian Join or Cross Join

 

 

 

Power Pivot

 

Power BI Data Modeling – Relationship View

 

·         Data Modeling Introduction

 

·         Relationship, Need of Relationship

 

·         Relationship Types / Cardinality in General

 

·         One-to-One, One-to-Many (or Many-to-One), Many-to-Many

 

·         AutoDetect the relationship, Create a new relationship, Edit existing relationships

 

·         Make Relationship Active or Inactive

 

·         Delete a relationship

 

·         Cross filter direction (Single, Both), Assume Referential Integrity

 

 

 

Enhancing the Data Model – DAX

 

·         What is DAX, Calculated Column, Measures

 

·         DAX Table and Column Name Syntax

 

·         Creating Calculated Columns, Creating Measures

 

·         Implicit Vs Explicit Measures

 

·         Calculated Columns Vs Measures

 

·         DAX Syntax & Operators

 

·         DAX Operators

 

·         Types of Operators

 

·         Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators

 

 

 

DAX Functions Categories

 

·         Date and Time Functions

 

·         Logical Functions

 

·         Text Functions

 

·         Math & Statistical Functions

 

·         Filter Functions

 

·         Time Intelligence Functions

 

 

 

DAX Date & Time Functions

 

·         YEAR, MONTH, DAY

 

·         WEEKDAY, WEEKNUM

 

·         FORMAT (Text Function) à Month Name, Weekday Name

 

·         DATE, TODAY, NOW

 

·         HOUR, MINUTE, SECOND, TIME

 

·         DATEDIFF, CALENDAR

 

·         Creating Date Dimension Table

 

 

 

DAX Text Functions

 

·         LEN, CONCATENATE (&)

 

·         LEFT, RIGHT, MID

 

·         UPPER, LOWER

 

·         TRIM, SUBSTITUTE, BLANK

 

 

 

DAX Logical Functions

 

·         IF

 

·         TRUE, FALSE

 

·         NOT, OR, IN, AND

 

·         IFERROR

 

·         SWITCH

 

 

 

DAXMath and Statistical Functions

 

·         INT

 

·         ROUND, ROUNDUP, ROUNDDOWN

 

·         DIVIDE

 

·         EVEN, ODD

 

·         POWER, SIGN

 

·         SQRT, FACT

 

·         SUM, SUMX

 

·         MIN, MINX

 

·         MAX, MAXX

 

·         COUNT, COUNTX

 

·         AVERAGE, AVERAGEX

 

·         COUNTROWS, COUNTBLANK

 

DAX Filter Functions

 

·         CALCULATE

 

·         ALL

 

·         RELATED

 

 

 

DAX Time Intelligence Functions

 

·         Time Intelligence Introduction

 

·         TOTALMTD, TOTALQTD, TOTALYTD

 

·         PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR

 

·         NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR

 

·         SAMEPERIODLASTYEAR

 

·         YOY Growth

 

·         MOM Growth

 

 

 

Power View

 

Report View / Power View

 

·         Report View User Interface

 

·         Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas

 

·         Visual Interactions

 

·         Interaction Type (Filter, Highlight, None)

 

·         Visual Interactions Default Behavior, Changing the Interaction

 

 

 

Filters in Power View

 

·         Filter Types

 

·         Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters

 

·         Filter Sub Types

 

·         Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering

 

·         Numeric field filters, Text field filters, Date and Time field Filters

 

 

 

Grouping, Binning & Sorting

 

·         Grouping and Binning Introduction

 

·         Using grouping, Creating Groups on Text Columns

 

·         Using binning, Creating Bins on Number Column and Date Columns

 

·         Sorting Data in Visuals

 

·         Changing the Sort Column, Changing the Sort Order

 

·         Sort using column that is not used in the Visualization

 

·         Sort using the Sort by Column button

 

 

 

Hierarchies and Drill-Down Reports

 

·         Hierarchy Introduction, Default Date Hierarchy

 

·         Creating Hierarchy, Creating Custom Date Hierarchy

 

·         Change Hierarchy Levels

 

·         Drill-Up and Drill-Down Reports

 

·         Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level

 

·         Drilling filters other visuals option

 

 

 

Power BI Visualizations

 

·         Visualizing Data, Why Visualizations

 

·         Visualization types, Field Wells

 

·         Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data

 

·         Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data

 

·         Leveraging Power BI Custom Visuals

 

 

 

Visuals for Filtering

 

·         Slicer Visualization

 

·         When to use a Slicer

 

·         Create and format Slicer Visualization

 

·         Hierarchy Slicer (Custom Visualization)

 

·         When to use a Hierarchy Slicer

 

·         Create and format Hierarchy Slicer

 

·         Advantages of Hierarchy Slicer

 

 

 

Visualizing Categorical Data

 

·         Create and Format Bar and Column Charts

 

·         Create and Format Stacked Bar Chart Stacked Column Chart

 

·         Create and Format Clustered Bar Chart, Clustered Column Chart

 

·         Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart

 

·         Create and Format Pie and Donut Charts

 

·         Create and Format theTree Map Visual

 

·         Create and Format Scatter Charts

 

 

 

Visualizing Trend Data

 

·         Line and Area Charts

 

·         Create and Format Line Chart, Area Chart, Stacked Area Chart

 

·         Combo Charts

 

·         Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart

 

·         Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

 

 

 

Visualizing KPI Data

 

·         Create and Format Gauge Visual, KPI Visual

 

·         Create and Format Card Visualization, Multi Row Card

 

 

 

Visualizing Tabular Data, Geographical Data & R Script Visual

 

·         Create and Format Table Visual, Matrix Visualization

 

·         Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual

 

·         Create and Format R Script Visual

 

 

 

Power BI Service

 

Power BI Service Introduction

 

·         Power BI Service Introduction, Power BI Cloud Architecture

 

·         Creating Power BI Service Account, SIGN IN to Power BI Service Account

 

·         Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service

 

·         My Workspace / App Workspaces Tabs

 

·         DATASETS, WORKBOOKS, REPORTS, DASHBOARDS

 

·         Working with Datasets, Creating Reports in Cloud using Published Datasets

 

·         Power BI Datasets Live Connection using Desktop

 

·         Working with Workbooks, working with Reports, Sharing Reports

 

 

 

Dashboards Development

 

·         Creating Dashboards

 

·         Pin Visuals and Pin LIVE Report Pages to Dashboard

 

·         Advantages of Dashboards

 

·         Interacting with Dashboards

 

·         Adding Tiles to Dashboards

 

·         Web Content, Image, Text Box,Video

 

·         Formatting Dashboard

 

·         Sharing Dashboard

 

 

 

Data Gateways

 

·         Introduction to Data Gateways

 

·         How Data Gateways work

 

·         Connect to an on premise Data Source by using a Data Gateway

 

·         Download Data Gateway

 

·         Installing a Data Gateway

 

·         Types of Gateways

 

·         On-premises Data Gateway, On-premises Data Gateway (personal mode)

 

·         Manage Data Gateway

 

·         Add and Remove Administrators

 

·         Add Data Source, Add or Remove Users to a Data Source

 

·         Refresh On Premise Data

 

·         Configuring Automatic Refresh using Schedules

 

 

 

Collaboration in Power BI using App Workspace

 

·         Introduction to App Workspaces

 

·         Create an App Workspace

 

·         Add Members to App Workspace to Collaborate

 

·         App Workspace Access

 

·         Admin, Member, Contributor

 

 

 

Sharing Power BI Content using Apps and Content Packs

 

·         Introduction to App

 

·         Publish an App

 

·         Update a Published App

 

·         Manage Content in App

 

·         Include in App, Exclude in App

 

·         Sharing App

 

·         Entire Organization, Specific individuals or group

 

·         Un publishing an App

 

·         Content Pack Introduction

 

·         Create Content Pack

 

·         Sharing Content Packs

 

·         Specific Groups, My Entire Organization

 

·         Selecting the Content / Items to Publish or Share

 

 

 

Row Level Security in Power BI

 

·         Introduction to Row Level Security

 

·         Row Level Security (RLS) with DAX

 

·         Manage Roles, Creating Roles, Testing Roles

 

·         Adding Members to Roles in Power BI Service

 

·         Dynamic Row Level Security

 

·         Creating Users Table and Adding to the Model

 

·         Capturing users using UserName () or UserPrincipalName () DAX Functions

 

 

 

 

 

 

 

SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE

 

 

 

SAP BusinessObjects (BO) Business Intelligence is a reporting tool offered by SAP. SAP BO offers intelligent solutions that can be made use of by people ranging from analysts and other people who work with information to CEO’s.

 

1. Introduction:

 

Understanding BusinessObjects Enterprise

What is BusinessObjects Enterprise?

Working with SAP BO Launchpad (Infoview)

2. SAP Business Objects Web Intelligence and BI Launch Pad 4.1 

 

SAP Business Objects Dashboards 4.1

BI launch pad: What’s new in 4.1

Restricting data returned by a query

Enhancing the presentation of data in reports

Formatting reports

Calculating data with formulas and variables

Using multiple data sources

Analyzing data

Managing and sharing Interactive Analysis documents

Reporting from Other Data Sources

Introducing Web Intelligence

Accessing corporate information with Web Intelligence

Understanding how universes allow you to query databases using everyday business terms.

Managing documents in InfoView

Viewing a Web Intelligence document in InfoView

Setting Info View Preferences

Creating Web Intelligence Documents with Queries

Getting new data with Web Intelligence

Creating a new Web Intelligence document

Modifying a document’s query

Working with query properties

Restricting Data Returned by a Query

Modifying a query with a predefined query filter

Applying a single-value query filter

Using prompts to restrict data

Using complex filters

Displaying data in tables and charts

Presenting data in free-standing cells

Enhancing the Presentation of Reports

Using breaks, calculations, sorts and report filters

Ranking data to see top or bottom values

Using alerter to highlight information

Organizing a report into sections

Copying data to other applications

Alternative Query Techniques Using Combined Queries Using Sub-Queries

Creating a Query based on another Query

Character and Date String Functions Using the character string functions Concatenating different data types Using date functions

Using If Logic

Grouping data using If() logic

Using If() to modify calculation behaviour

Advanced Reporting Features Formatting breaks

Creating custom sorts

Displaying document data in free-standing cells

Alternative Query Techniques Defining Combined Query Types Using Combined Queries

Using Sub-Queries

Creating a Query on a Query

Character and Date String Functions Understanding Character Strings

Using Date Functions User-Defined Objects Creating User Objects

Using a User Object in a Query

Editing a User Object Deleting a User Object Storing a User Object Grouping Data

 3. Information Design Tool 4.0 

 

What is the Information Design Tool (IDT)

Create a project

Create a connection to a relational database (Single and Multiple databases)

Create the data foundation with Single & Multiple databases

Define the different types joins in a data foundation

Create a business layer

Create folders and objects

Resolve Loops and Use alias

Resolve Loops Use contexts

Resolving the fan traps and Chasm traps problem

Define data restrictions

Work with LOVs

Use Parameters restrict data

Use @functions also Aggregate Awareness

Create Derived Tables and Index Awareness

Maintain universes

Deploy and manage and maintain universes

4. Universe Designer Tool 4.0 

 

Understanding Business-Objects Universes.

Understanding how universes allow users to query databases using their everyday business terms.

Creating Universe Connections.

The course database and universe.

Creating the universe.

Building and populating the Universe Structure.

Defining joins in a universe.

Creating Dimension Objects.

Understanding classes and objects.

Creating Measure Objects.

Understanding measure objects.

Using List of Values.

Resolving Loops.

Resolving loops using aliases.

Resolving loops using contexts.

Chasm traps and Fan traps.

Restricting the data returned by objects.

Using Functions with Objects.

Using @ Functions.

Using Hierarchies.

Working with hierarchies.

Aggregate Awareness.

Derived Tables

Securing Universes.

Managing Universes

5. SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)

 

Crystal Xcelsius Overview

Creating Dashboards using Query As A Web Service (QAAWS) and Live Office

Create Drill Down dashboard reports

What’s new in SAP Business Objects Dashboards 4.0

Creating a Visualization

Producing interactive visualizations

Getting around in Xcelsius

Working with your Excel workbook

Visualizing data with charts

Using Xcelsius Components

Formatting a Visualization

Applying formatting options

Using themes and templates to apply formatting

Adding Interactivity to a Visualization

Using selectors

Adding dynamic visibility

Using live data sources

Connecting to BO Universes using Query as a Web Service

Using Live Office data

Creating Complex dashboards

 

6. SAP Crystal Reports 2011 

 

Creating reports

Selecting records

Organizing data on reports

Formatting & section formatting

Creating basic and complex formulas

Using variables

Using report templates

Applying conditional reporting

Building parameterized and specialized reports

Summarizing data with cross tabs

Using report sections

Representing data visually

Managing reports

Distributing reports

Using repository and repository data sources

Report processing

Linking Crystal Reports to Webi reports

Drill down reports

 

 

 

Certification Back to Top

This BI Tools Training course is designed for exploring the structure, concepts of BI Tools modules.

Business intelligence (BI) tools are types of application software which collect and process large amounts of unstructured data from internal and external systems, including books, journals, documents, health records, images, files, email, video and other business sources.

BI reporting tools pull and read data from your company's data sources, on premises and in the cloud. The reporting tool is able to identify measurements such as sales, revenue, inventory counts, etc. and apply dimensions such as date, purchase order, or customer information to create analyses.

Microsoft Power BI. Microsoft's BI suite provides interactive business intelligence capabilities to help marketers create dashboards and reports.

Zoho Analytics.

Google Data Studio.

Qlik.

Tableau.

Freshworks CRM.

HubSpot.

Looker.

 

Uplatz online training guarantees the participants to successfully go through the BI Tools certification provided by Uplatz. Uplatz provides appropriate teaching and expertise training to equip the participants for implementing the learnt concepts in an organization.

Course Completion Certificate will be awarded by Uplatz upon successful completion of the BI Tools online course.

Career & Jobs Back to Top

The draws an average salary of $100,080 per year depending on the knowledge and hands-on experience. BI Tools  Associate job roles are in high demand and make for a rewarding career.

A Business Intelligence Analyst, or Business Intelligence Specialist, is responsible for managing data retrieval and analysis within an organization. Their duties include organizing data points, communicating between upper management and the IT department and analyzing data to determine a corporation's needs.

Note that salaries are generally higher at large companies rather than small ones. Your salary will also differ based on the market you work in.

The following are the job titles:

Business Intelligence Analyst

Business Intelligence Specialist

Interview Questions Back to Top

1.      What is Business Intelligence?


The business intelligence is used for reporting the data of any business which is very vital and using which management of any organization will make the right decision for the growth of the business.

2. List out the decisions made by an organization or business using business tool?

  • BI is used to decide whether a business is running as per plan
  • BI is used to classify which things are actually going wrong.
  • BI is used to monitor corrective actions.
  • BI is used to find the recent trends of the business

2. Mention the different stages and benefits of Business Intelligence?

There are totally five stages of Business Intelligence:

·         Data Source

·         Data Analysis

·         Decision-making support

·         Situation Awareness

·         Risk Management

3. Mention the benefits if using business intelligence?

Following are benefits of Business Intelligence:

  • Improves decisions making.
  • Helps to make right decisions
  • Optimize internal business process
  • Gain operational efficiency.
  • Helping for new revenues.

4. What are different Business Intelligence tools available in the market?

There are different intelligence and reporting tools available:

  • SAP Business Intelligence
  • Business Object
  • Tableau
  • Microsoft Business Intelligence Tool

5.      Define universe in Business Analytics?

The universe is type of semantic layer in between database and user interface. In simple words, it is one of the interfacing layers in between the client and data warehouse.

6.      List the differences between OLAP and OLTP?

OLTP is helping to provide source data in a data warehouse and OLAP used to analyze the same.

7.      Define dashboard in a data warehouse?

The dashboard refers the arrangement of all the reports and graphical representations on one page. It refers to the collection of reports in a different format.

8.      Define Power BI Desktop?

 

Power BI Desktop is a free desktop application which is used to provide data exploration, modeling and report creation to highlight data.

9.      Define Data Source?

Data Source is extracting data from multiple sources

10.  Define Data Analysis?

Data analysis provides proper report based on data of collection

11.  Define Decision-making support?

Decision-making support is using information in right way.

12.  Define Situation Awareness?

Situation awareness is used to filter irrelevant information and set the remined information for business context

13.  Define Risk Management?

Risk management is used to take corrective actions at different situations

14.  Define Fact table

A Fact table is the center table in star schema of a data warehouse. It actually holds quantitative information for analysing purpose.

15.  Define Dimension Table?

A dimension table is one of the vital tables in a star schema of a data warehouse, which is used to store attribute, or dimension, that details the objects in a fact table.

 

 

 

 

Course Quiz Back to Top
Start Quiz
Q1. What are the payment options?
A1. We have multiple payment options: 1) Book your course on our webiste by clicking on Buy this course button on top right of this course page 2) Pay via Invoice using any credit or debit card 3) Pay to our UK or India bank account 4) If your HR or employer is making the payment, then we can send them an invoice to pay.

Q2. Will I get certificate?
A2. Yes, you will receive course completion certificate from Uplatz confirming that you have completed this course with Uplatz. Once you complete your learning please submit this for to request for your certificate https://training.uplatz.com/certificate-request.php

Q3. How long is the course access?
A3. All our video courses comes with lifetime access. Once you purchase a video course with Uplatz you have lifetime access to the course i.e. forever. You can access your course any time via our website and/or mobile app and learn at your own convenience.

Q4. Are the videos downloadable?
A4. Video courses cannot be downloaded, but you have lifetime access to any video course you purchase on our website. You will be able to play the videos on our our website and mobile app.

Q5. Do you take exam? Do I need to pass exam? How to book exam?
A5. We do not take exam as part of the our training programs whether it is video course or live online class. These courses are professional courses and are offered to upskill and move on in the career ladder. However if there is an associated exam to the subject you are learning with us then you need to contact the relevant examination authority for booking your exam.

Q6. Can I get study material with the course?
A6. The study material might or might not be available for this course. Please note that though we strive to provide you the best materials but we cannot guarantee the exact study material that is mentioned anywhere within the lecture videos. Please submit study material request using the form https://training.uplatz.com/study-material-request.php

Q7. What is your refund policy?
A7. Please refer to our Refund policy mentioned on our website, here is the link to Uplatz refund policy https://training.uplatz.com/refund-and-cancellation-policy.php

Q8. Do you provide any discounts?
A8. We run promotions and discounts from time to time, we suggest you to register on our website so you can receive our emails related to promotions and offers.

Q9. What are overview courses?
A9. Overview courses are 1-2 hours short to help you decide if you want to go for the full course on that particular subject. Uplatz overview courses are either free or minimally charged such as GBP 1 / USD 2 / EUR 2 / INR 100

Q10. What are individual courses?
A10. Individual courses are simply our video courses available on Uplatz website and app across more than 300 technologies. Each course varies in duration from 5 hours uptop 150 hours. Check all our courses here https://training.uplatz.com/online-it-courses.php?search=individual

Q11. What are bundle courses?
A11. Bundle courses offered by Uplatz are combo of 2 or more video courses. We have Bundle up the similar technologies together in Bundles so offer you better value in pricing and give you an enhaced learning experience. Check all Bundle courses here https://training.uplatz.com/online-it-courses.php?search=bundle

Q12. What are Career Path programs?
A12. Career Path programs are our comprehensive learning package of video course. These are combined in a way by keeping in mind the career you would like to aim after doing career path program. Career path programs ranges from 100 hours to 600 hours and covers wide variety of courses for you to become an expert on those technologies. Check all Career Path Programs here https://training.uplatz.com/online-it-courses.php?career_path_courses=done

Q13. What are Learning Path programs?
A13. Learning Path programs are dedicated courses designed by SAP professionals to start and enhance their career in an SAP domain. It covers from basic to advance level of all courses across each business function. These programs are available across SAP finance, SAP Logistics, SAP HR, SAP succcessfactors, SAP Technical, SAP Sales, SAP S/4HANA and many more Check all Learning path here https://training.uplatz.com/online-it-courses.php?learning_path_courses=done

Q14. What are Premium Career tracks?
A14. Premium Career tracks are programs consisting of video courses that lead to skills required by C-suite executives such as CEO, CTO, CFO, and so on. These programs will help you gain knowledge and acumen to become a senior management executive.

Q15. How unlimited subscription works?
A15. Uplatz offers 2 types of unlimited subscription, Monthly and Yearly. Our monthly subscription give you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews each month. Minimum committment is for 1 year, you can cancel anytime after 1 year of enrolment. Our yearly subscription gives you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews every year. Minimum committment is for 1 year, you can cancel the plan anytime after 1 year. Check our monthly and yearly subscription here https://training.uplatz.com/online-it-courses.php?search=subscription

Q16. Do you provide software access with video course?
A16. Software access can be purchased seperately at an additional cost. The cost varies from course to course but is generally in between GBP 20 to GBP 40 per month.

Q17. Does your course guarantee a job?
A17. Our course is designed to provide you with a solid foundation in the subject and equip you with valuable skills. While the course is a significant step toward your career goals, its important to note that the job market can vary, and some positions might require additional certifications or experience. Remember that the job landscape is constantly evolving. We encourage you to continue learning and stay updated on industry trends even after completing the course. Many successful professionals combine formal education with ongoing self-improvement to excel in their careers. We are here to support you in your journey!

Q18. Do you provide placement services?
A18. While our course is designed to provide you with a comprehensive understanding of the subject, we currently do not offer placement services as part of the course package. Our main focus is on delivering high-quality education and equipping you with essential skills in this field. However, we understand that finding job opportunities is a crucial aspect of your career journey. We recommend exploring various avenues to enhance your job search:
a) Career Counseling: Seek guidance from career counselors who can provide personalized advice and help you tailor your job search strategy.
b) Networking: Attend industry events, workshops, and conferences to build connections with professionals in your field. Networking can often lead to job referrals and valuable insights.
c) Online Professional Network: Leverage platforms like LinkedIn, a reputable online professional network, to explore job opportunities that resonate with your skills and interests.
d) Online Job Platforms: Investigate prominent online job platforms in your region and submit applications for suitable positions considering both your prior experience and the newly acquired knowledge. e.g in UK the major job platforms are Reed, Indeed, CV library, Total Jobs, Linkedin.
While we may not offer placement services, we are here to support you in other ways. If you have any questions about the industry, job search strategies, or interview preparation, please dont hesitate to reach out. Remember that taking an active role in your job search process can lead to valuable experiences and opportunities.

Q19. How do I enrol in Uplatz video courses?
A19. To enroll, click on "Buy This Course," You will see this option at the top of the page.
a) Choose your payment method.
b) Stripe for any Credit or debit card from anywhere in the world.
c) PayPal for payments via PayPal account.
d) Choose PayUmoney if you are based in India.
e) Start learning: After payment, your course will be added to your profile in the student dashboard under "Video Courses".

Q20. How do I access my course after payment?
A20. Once you have made the payment on our website, you can access your course by clicking on the "My Courses" option in the main menu or by navigating to your profile, then the student dashboard, and finally selecting "Video Courses".

Q21. Can I get help from a tutor if I have doubts while learning from a video course?
A21. Tutor support is not available for our video course. If you believe you require assistance from a tutor, we recommend considering our live class option. Please contact our team for the most up-to-date availability. The pricing for live classes typically begins at USD 999 and may vary.



BUY THIS COURSE (USD 31 USD 69)