-
Oracle SQL Fundamentals
-
Oracle – SQL
-
Oracle SQL – Home
-
Oracle – SQL – Introduction
-
Oracle – SQL – Environment Setup
-
Oracle – SQL – Getting Started
-
Oracle – SQL – DDL Statements
-
Oracle – SQL – Create Table
-
Oracle – SQL – Alter Table
-
Oracle – SQL – Drop Table
-
Oracle – SQL – Truncate Table
-
Oracle – SQL – Constraints
-
Oracle – SQL – Not Null Constraint
-
Oracle – SQL – Unique Constraint
-
Oracle – SQL – Primary Key Constraint
-
Oracle – SQL – Check Constraint
-
Oracle – SQL – Foreign Key Constraint
-
Oracle – SQL – Managing Constraints
-
Oracle – SQL – Data Manipulation Language
-
Oracle – SQL – Insert Statement
-
Oracle – SQL – Update Statement
-
Oracle – SQL – Delete Statement
-
Oracle – SQL – Select Statement
-
Oracle – SQL – Sorting Data
-
Oracle – SQL – Filtering Data
-
Oracle – SQL – Functions
-
Oracle – SQL – General Functions
-
Oracle – SQL – Joins
-
Oracle – SQL – Group Functions
-
Oracle – SQL – Group By Clause
-
Oracle – SQL – Creating Users
-
Oracle – SQL
-
Business Intelligence Basics / Data warehouse Fundamentals
-
Microsoft Power BI Desktop Visualisation
-
Basics of Data warehouse Concepts / BI Concepts (Data Model types , Facts and Dimensions)
-
Overview of Power BI Tools.
-
Introduction to Tools and Terminology.
-
Connecting to Microsoft Excel , Web Data , Overview of Power Query Editor , Data Model.
-
Gives you an overview of the interface and gets you started in creating
-
your first Power BI Report
-
gets you started with the Power Query Editor (cleaning up messy data)
-
create your custom datestable using MCode Method.
-
you learn advanced Power Query Transformation Steps
-
Using Themes and Import Custom Themes from Gallery.
-
How to set up your data model – Setup and Manage relationships.
-
Using Edit Interactions.
-
Creating Calculated Columns.
-
Starting with Measures and Quick Measures.
-
DAX: SUMX function
-
Create a measures table to keep all the custom measures at single Place.
-
DAX: SUMX with RELATED
-
DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, FILTER,
-
ALLSELECTED, MAX
-
Build your Report, use custom visuals
-
DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, DATEADD
-
RANKX, ALL, GENERATESERIES, IF with Parameter
-
DAX Timeintelligence: CALCULATE, FILTER, ALLSELECTED, MAX (=> cumulative Sales)
-
Visualizing DAX Calculations.
-
Hierarchies and Groups Concepts.
-
Using Various types of graphs and Slicers to filter the data.
-
Using Filters – Page and Report Level.
-
Using Tool Tips at Page Level and Field Level
-
Conditional Formatting in Tables and Graphs.
-
Using Buttons and Actions.
-
Creating Bookmarks with Various actions.
-
Using Ask a Questions to create Custom visuals.
-
Using Market Place to add Custom visuals to Visualisations (Aster , Radar , Sankey and Chord Plots demo)
-
Use Scrollers and Hierarchy Slicers from Market Place.
-
Sample Reports using Database Tables – Demo to connect any database.
-
Publish reports to Power BI Service.
-
Creating Dashboards and Insights.
-
Interacting with your Dashboards
-
Sharing Dashboards and Reports.
-
Basics of Data warehouse Concepts / BI Concepts (Data Model types , Facts and Dimensions)
-
Additional Topics: (with DAX)
-
Advanced Topics: (With DAX)
-
Tableau Data Visualisation
-
Introduction and Overview
-
BI and Data warehouse Overview
-
Why Tableau? Why Visualization?
-
Getting Started – creating some powerful visualizations quickly
-
The Tableau Product Line
-
Things you should know about Tableau
-
Getting Started
-
Connecting to Data and introduction to data source concept
-
Working with data files versus database server
-
Understanding the Tableau workspace
-
Dimensions and Measures
-
Using Show Me!
-
Tour of Shelves (How shelves and marks work)
-
Building Basic Views
-
Help Menu and Samples
-
Saving and sharing your work
-
Creating Views
-
Marks
-
Size and Transparency
-
Highlighting
-
Working with Dates
-
Date aggregations and date parts
-
Discrete versus Continuous
-
Dual Axis / Multiple Measures
-
Combo Charts with different mark types
-
Geographic Map Page Trails
-
Heat Map
-
Density Chart
-
Scatter Plots
-
Pie Charts and Bar Charts
-
Small Multiples
-
Working with aggregate versus disaggregate data
-
Analyzing
-
Sorting & Grouping
-
Aliases
-
Filtering and Quick Filters
-
Cross-Tabs (Pivot Tables)
-
Totals and Subtotals Drilling and Drill Through
-
Aggregation and Disaggregation
-
Percent of Total
-
Working with Statistics and Trend lines
-
Getting Started with Calculated Fields
-
Working with String Functions
-
Basic Arithmetic Calculations
-
Date Math
-
Working with Totals
-
Custom Aggregations
-
Logic Statements
-
Formatting
-
Options in Formatting your Visualization
-
Working with Labels and Annotations
-
Effective Use of Titles and Captions
-
Introduction to Visual Best Practices
-
Building Interactive Dashboard
-
Combining multiple visualizations into a dashboard
-
Making your worksheet interactive by using actions and filters
-
An Introduction to Best Practices in Visualization
-
Sharing Workbooks
-
Packaged Workbooks
-
Publish to Tableau Server and Sharing over the Web
-
Putting it all together
-
Scenario-based Review Exercises
-
Best Practices
-
Introduction and Overview
-
Oracle Business Intelligence 12c
-
Repository Basics
-
Building the Physical Layer of a Repository
-
Building the Business Model and Mapping Layer of a Repository
-
Building the Presentation Layer of a Repository
-
Testing and Validating a Repository
-
Managing Logical Table Sources
-
Adding Calculations to a Fact
-
Working with Logical Dimensions
-
Using Aggregates
-
Using Partitions and Fragments
-
Using Repository Variables
-
Modeling Time Series Data
-
Security
-
Creating Oracle Business Intelligence Dashboards
-
Configuring Oracle Business Intelligence Dashboards
-
Creating Dashboard Prompts and Variables
-
Using Oracle Business Intelligence Delivers
-
Repository Basics
-
Oracle Data Integrator 12c
Publish reports to Power BI Service.
The lesson content is empty.