Business Intelligence is a combination of knowledge in Business Process and Data Visualization Techniques.
To create Reports, Dashboards you also need to know the underline data structure, hence Structured Query Language is essential as well!
We will teach you well rounded BI solution from real world experience!
OVERVIEW:
1. SQL for BI — SQL techniques, especially Cubes, Analytic sql functions- GROUP BY,OVER PARTITION BY, ROLLUP
2. Intro to Data warehousing
— Fact table, Dimension, Measure, Star Schema
— DataMarts
— Inmon, Kimble Theories
3. Data visualization techniques, tools and best practices: Using Tableau
— Different type of charts and when to use them
— Creating Reports, Dashboards, scorecards
Details Syllabus:
MODULE-1: INTRODUCTION TO TABLEAU
- Architecture of Tableau
- Components of Tableau
- Roles Involved
- Tableau Development Environment
MODULE-2: TABLEAU INSTALLATION
- Software Installation
- Setup & Configuration
MODULE-3: TABLEAU VISUAL ANALYTICS-1
- Crosstab & Exporting Data
- Show Me
- Charts – Line, Bar & Bubble
- Blended Axis and Dual Axis
- Maps – Tree, Heat & Geo
- Mark Label & Tool Tip
- Trend Lines
- Reference Lines
- Dashboard
- Story Point
MODULE-4: TABLEAU VISUAL ANALYTICS-2
- Table Calculations
- Date Functions
- Summary Cards
- Groups & Hierarchies
- Forecasting
- Sets, Filters & Parameters
- Actions
MODULE-5: TABLEAU DATA SOURCES
- Understanding Tableau Desktop Structure
- Connecting to Different Data Sources
- In Memory Data & Data Extracts
- Data Blending
- Join Types
- Creating Calculated Fields
- Uploading Workbook to Tableau Server
- Customizing & Sharing Workbook
MODULE-6: TABLEAU ADVANCED
- Custom Geocoding
- Page Shelf
- Cascading Quick Filters
- Complex and Dynamic Measure Filtering
- Tableau API
- Tableau Server Metadata & Reporting
MODULE-7: TABLEAU SERVER ESSENTIALS
- Server Login
- Navigating Server Content
- Save and Share Customized Views
- Subscriptions
- Assigned Permissions
- Scheduling Extracts
- Tadadmin Comand
- Tabcmd Command