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

Uplatz offers this comprehensive bundle course on BI Tools consisting of a combo of video courses on all topics that are associated with the leading Analytics & BI Tools viz. Tableau, Power BI, SAP BO. You will be awarded Course Completion Certificate at the end of the course.

Bundle Course Bi Tools

The Bundle Course Of BI tools includes 3 individual modules of course :

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

Tableau : Tableau is a Business Intelligence tool for visually analyzing the data. Users can create and distribute an interactive and shareable dashboard, which depict the trends, variations, and density of the data in the form of graphs and charts. Tableau can connect to files, relational and Big Data sources to acquire and process data. The software allows data blending and real-time collaboration, which makes it very unique. It is used by businesses, academic researchers, and many government organizations for visual data analysis. It is also positioned as a leader Business Intelligence and Analytics Platform in Gartner Magic Quadrant.

Power BI: Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector, and services - Power BI desktop, Power BI service based on Saas, and mobile Power BI apps available for different platforms. These set of services are used by business users to consume data and build BI reports. This tutorial covers all the important concepts in Power BI and provides a foundational understanding on how to use Power BI.

SAP BusinessObjects Business Intelligence : The SAP® BusinessObjects™ Business Intelligence (BI) platform is a flexible, scalable information infrastructure that helps you more easily discover and share insights for better business decisions. The integrated, unified infrastructure enables scalability from one to many tools and interfaces on premise, in the cloud, or as a hybrid approach.

Reed courses certificate of completion

Digital certificate - Included

Uplatz Certificate of Completion

Digital certificate - Included

• Tableau (1st course) - all lectures 5:33:39

  • 1: Tableau Overview 10:01
  • 2: Tableau Desktop Basics 02:32
  • 3: Tableau Desktop Installation Process 06:28
  • 4: Tableau Desktop Workspace Navigation 10:40
  • 5: Tableau Design Flow 07:08
  • 6: Connections to Multiple Data Sources Preview 18:04
  • 7: Hands-on - Tableau Data Connection 21:51
  • 8: Filters 31:46
  • 9: Hands-on - Tableau Filters 16:06
  • 10: Tableau Operators 18:30
  • 11: Bins - Groups - Sets - Parameters - Hierarchy 15:00
  • 12: Hands on - Tableau Sets - Groups etc. 13:35
  • 13: Basic Tableau Charts 23:26
  • 14: Hands-on - Basic Tableau Charts 21:24
  • 15: Tableau Advanced Topics 03:03
  • 16: Tableau Extensions 21:20
  • 17: Tableau Dashboards 26:30
  • 18: Tableau Story 20:27
  • 19: Tableau LODs 18:55
  • 20: Tableau Actions 26:53

• Tableau (2nd course) - all lectures 16:56:24

  • 21: Introduction to Business Intelligence 17:31
  • 22: Introduction to Tableau 33:45
  • 23: Tableau History 21:38
  • 24: Tableau Interface and Components 34:10
  • 25: Connecting to Database and Preparing Data 43:54
  • 26: Connecting to Database and Preparing Data - practical 33:13
  • 27: Data Refresh and Blending 30:50
  • 28: Data Refresh and Blending - practical Preview 41:22
  • 29: Sorting 19:38
  • 30: Sorting - practical 13:43
  • 31: Grouping 12:18
  • 32: Grouping - practical 24:55
  • 33: Sets 26:50
  • 34: Sets - practical 38:06
  • 35: Filters - Filter Shelves - Quick Filter 26:07
  • 36: Filters - Filter Shelves - Quick Filter - practical 20:49
  • 37: Parameters 31:36
  • 38: Parameters - practical 24:43
  • 39: Trend Lines and Reference Lines 20:42
  • 40: Trend Lines and Reference Lines - practical 25:39
  • 41: Building Dashboards and Story 23:15
  • 42: Building Dashboards and Story - practical 41:34
  • 43: Layouts and Formatting 23:52
  • 44: Layouts and Formatting - practical 36:38
  • 45: Interactivity 29:40
  • 46: Actions 28:37
  • 47: Maps 07:55
  • 48: Maps - practical 13:07
  • 49: Calculations 21:08
  • 50: Calculations - practical 14:17
  • 51: Modifying Table Calculations 14:15
  • 52: Modifying Table Calculations - practical 18:31
  • 53: Aggregations and LOD Expressions 27:50
  • 54: Aggregations and LOD Expressions - practical 37:12
  • 55: Advanced Charts and Graphs 15:18
  • 56: Advanced Charts and Graphs - practical 25:01
  • 57: Histogram 16:11
  • 58: Histogram - practical 11:51
  • 59: Tree Maps and Bubble Charts 09:54
  • 60: Tree Maps and Bubble Charts - practical 10:42
  • 61: Best Practices in Tableau 48:07

• Tableau (3rd course) - all lectures 46:15:23

  • 62: Introduction to Tableau 34:10
  • 63: Data Connections 1:08:01
  • 64: Dimensions and Measures 1:10:26
  • 65: Tableau Desktop Environment 45:10
  • 66: Building Basic Views Preview 35:00
  • 67: Working with Multiple Dimensions 1:02:18
  • 68: Working with Multiple Measures - part 1 58:40
  • 69: Working with Multiple Measures - part 2 43:33
  • 70: Geographic Analysis 1:15:34
  • 71: Filters - part 1 1:22:41
  • 72: Filters - part 2 47:20
  • 73: Filters - part 3 52:42
  • 74: Joins 1:43:51
  • 75: Blending - Sets - Bins 1:30:37
  • 76: Groups and Hierarchies 37:41
  • 77: Basic Types of Charts 45:22
  • 78: Cascading Filters 39:31
  • 79: Image Processing 21:40
  • 80: Sorting 36:55
  • 81: Calculations - part 1 1:02:51
  • 82: Calculations - part 2 55:10
  • 83: Calculations - part 3 1:03:47
  • 84: Calculations - part 4 1:33:23
  • 85: Calculations - part 5 1:18:40
  • 86: Calculations - part 6 51:40
  • 87: Advanced Data Blending 1:46:02
  • 88: Trendlines 50:06
  • 89: Advanced Calculations - part 1 2:32:33
  • 90: Advanced Calculations - part 2 1:08:07
  • 91: Advanced Charts - part 1 53:20
  • 92: Advanced Charts - part 2 47:14
  • 93: LOD - part 1 2:22:33
  • 94: LOD - part 2 1:21:49
  • 95: Actions 1:12:02
  • 96: Dashboards 2:20:23
  • 97: Advanced Dashboards - part 1 1:15:08
  • 98: Advanced Dashboards - part 2 1:17:17
  • 99: Formatting - part 1 1:12:21
  • 100: Formatting - part 2 58:44
  • 101: Pivot Transformations 31:06
  • 102: Order of Operations - part 1 53:30
  • 103: Order of Operations - part 2 36:25

• Power BI (1st course) - all lectures 4:41:12

  • 104: Introduction to Power BI 20:51
  • 105: Installation process of Desktop Power BI Preview 01:57
  • 106: Power BI Desktop - part 1 23:35
  • 107: Power BI Desktop - part 2 18:05
  • 108: Power BI Desktop - part 3 30:14
  • 109: Power BI Desktop - part 4 30:09
  • 110: Power BI Desktop - part 5 Preview 21:32
  • 111: Power BI Desktop - part 6 33:52
  • 112: Star Schema 09:10
  • 113: Merge Queries and Join Kind 07:49
  • 114: Data Model Structure 01:52
  • 115: Relationship View 10:39
  • 116: Cardinality - Cross Filter Direction - Active Properties 12:44
  • 117: M Language and DAX Language 16:22
  • 118: Report View - part 1 26:35
  • 119: Report View - part 2 15:46

• Power BI (2nd course) - all lectures 34:57:24

  • 120: Lecture 1 - Power BI (basic to adv) 2:00:46
  • 121: Lecture 2 - Power BI (basic to adv) 1:11:26
  • 122: Lecture 3 - Power BI (basic to adv) 1:12:22
  • 123: Lecture 4 - Power BI (basic to adv) 1:03:39
  • 124: Lecture 5 - Power BI (basic to adv) 1:07:33
  • 125: Lecture 6 - Power BI (basic to adv) 1:15:47
  • 126: Lecture 7.1 - Power BI (basic to adv) 1:06:13
  • 127: Lecture 7.2 - Power BI (basic to adv) 19:07
  • 128: Lecture 8 - Power BI (basic to adv) 1:13:51
  • 129: Lecture 9 - Power BI (basic to adv) 1:21:57
  • 130: Lecture 10.1 - Power BI (basic to adv) 33:47
  • 131: Lecture 10.2 - Power BI (basic to adv) 52:16
  • 132: Lecture 11 - Power BI (basic to adv) 1:15:55
  • 133: Lecture 12 - Power BI (basic to adv) 1:17:30
  • 134: Lecture 13 - Power BI (basic to adv) 06:58
  • 135: Lecture 14 - Power BI (basic to adv) 1:04:40
  • 136: Lecture 15 - Power BI (basic to adv) 1:45:08
  • 137: Lecture 16 - Power BI (basic to adv) 44:44
  • 138: Lecture 17 - Power BI (basic to adv) 55:26
  • 139: Lecture 18 - Power BI (basic to adv) 37:17
  • 140: Lecture 19 - Power BI (basic to adv) 54:27
  • 141: Lecture 20 - Power BI (basic to adv) 32:30
  • 142: Lecture 21 - Power BI (basic to adv) 40:35
  • 143: Lecture 22 - Power BI (basic to adv) 1:13:29
  • 144: Lecture 23 - Power BI (basic to adv) 1:28:03
  • 145: Lecture 24 - Power BI (basic to adv) 58:25
  • 146: Lecture 25 - Power BI (basic to adv) 1:00:07
  • 147: Lecture 26 - Power BI (basic to adv) 54:52
  • 148: Lecture 27 - Power BI (basic to adv) 50:23
  • 149: Lecture 28 - Power BI (basic to adv) 58:34
  • 150: Lecture 29 - Power BI (basic to adv) 46:31
  • 151: Lecture 30 - Power BI (basic to adv) 42:23
  • 152: Lecture 31 - Power BI (basic to adv) 1:17:24
  • 153: Lecture 32 - Power BI (basic to adv) 52:22
  • 154: Lecture 33 - Power BI (basic to adv) 40:57

• SAP BO - all lectures 26:43:54

  • 155: Introduction to SAP BO 1:35:18
  • 156: How to access BO components through Remote Desktop 57:33
  • 157: Working with Designer Preview 2:05:35
  • 158: Creating a Universe manually 1:00:08
  • 159: Creating Characters in SAP BO System 2:10:35
  • 160: Creating Data through Universe Tool 1:30:11
  • 161: Working with Transaction Codes 1:24:06
  • 162: Working with IDT and UDT and Web Intelligence 2:30:53
  • 163: Formatting Reports 2:00:16
  • 164: Working with Crystal Reports 1:01:37
  • 165: Dashboard Designing Components 1:40:21
  • 166: Information and Quick Design Tool 1:30:58
  • 167: Accessing different Data Sources from SAP Lumira 2:23:01
  • 168: Accessing Views using IDT 1:29:35
  • 169: Web Application Designer 2:14:32
  • 170: Working with IDT in connecting HANA Tables 1:09:15

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

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

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

SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE

1. Introduction:

• Understanding BusinessObjects Enterprise
• What is BusinessObjects Enterprise?
• Working with SAP BO Launchpad (Infoview)

1. 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

Everyone

Passion and determination to achieve your goals!

• Data Analyst
• MI/BI Analyst
• Dashboard Developer
• Tableau Developer
• Financial Data Analyst (Tableau Developer)
• Power Bi Developer
• Power BI Trainer

Currently there are no Q&As for this course. Be the first to ask a question.