[PDF] [PDF] Broucher Hike 2020 - iTech Analytic Solutions

[PDF] Tableau Fundamental Concepts

Different File extension types in Tableau 1 tbm 2 twb 3 tde tab reports 8 conditional formatting in cross tab report Advanced Dashboard Techniques 1

[PDF] 33 Ways to Tableau by Ryan Sleeper

This is a very subtle technique for reducing the saturation of the color and making A great deal of thought went into Tableau's default formatting including the 

[PDF] Intelligent Design: Introducing Tableau 30 - Perceptual Edge

product of thoughtful choices, including the newest version: Tableau 3 0 With this Formatting controls appear in a panel on the left that covers up the data panel Brushing is the name for the technique that was developed by information 

[PDF] Tableau Visual Guidebook - WordPresscom

Formatting: making your viz shine Although it seems simple, formatting your fonts , colors, tool-tips, viz sizing and the orientation of your views can change 

[PDF] VizDJ Tableau Charts and Tips V1035 - Tableau Training UK

This is a collection of some great Tableau charts and tips from blogs and articles 126) Rethinking Slider Parameter Formatting in Tableau By Luke Stanke 69

[PDF] Visual Analysis Best Practices - DataPlusSciencecom

Simple Techniques for Making Every Data Visualization A Tableau dashboard is a collection of several related visualizations shown on a single Although it might seem like a small detail, the formatting of your views can change everything 

[PDF] Tableau Blueprint - Tableau Help - Tableau Software

information, see Using Tableau Blueprint on page 6 and Skills by Tableau Education see how much easier analytics will be when they have a well- formatted 

[PDF] Broucher Hike 2020 - iTech Analytic Solutions

Sorting Techniques Filtering Techniques Different type of Charts Tableau Dashboard Formatting Techniques Dashboard Publishing Sharing the Dashboard

[PDF] Tableau for Healthcare Professionals - HealthDataViz

24 fév 2014 · and formatting techniques, and understand best practices for enterprise wide Tableau deployments Onsite training computers will be equipped 

[PDF] Onsite Course Tableau for Healthcare - HealthDataViz

employ advanced calculating and formatting techniques, and understand best practices for enterprise wide Tableau deployments Onsite training computers 

[PDF] forme algébrique d'un nombre complexe exercice

[PDF] forme bilinéaire et quadratique exercices corrigés

[PDF] forme bilinéaire symétrique définie positive

[PDF] forme canonique second degré exercice corrigé

[PDF] forme indéterminée 0/0

[PDF] forme indéterminée math

[PDF] forme quadratique matrice

[PDF] forme trigonométrique d'un nombre complexe

[PDF] formes indéterminées limites d'une fonction

[PDF] forms in oracle apps interview questions

[PDF] formulaire remboursement france billet fnac

[PDF] formulaire renouvellement acs cpam

[PDF] formulaire renouvellement amethyste 93

[PDF] formulaire renouvellement forfait améthyste 93

[PDF] formulaire rétractation freebox

Click on the icons to connect with iTAS

100%

PRACTICAL CLASSES

BY PROFESSIONALS

TO MAKE YOU EXPERT

OUR APP

IS YOUR

NEW

TEACHER

Free

Course videos

availabletill

20thSep 2021 Only

Click here to Download

NEW BATCHES

ITAS GIFT

FOR THIS

GANESHCHATURTHI

CLICKONTHE

COUPON

TOAVAILTHE

GIFT "iTechAnalytic Solutions" (iTAS), Analytics service provider in Corporate Trainings &

Development contributing towards the requirement

of current IT & NON ITindustries.

Team iTASis constituted majorly by young,

energetic, dynamic professionals and headed by well-versed domain experts possessing a wide range of custom analytic & programming skills involving the latest and most effective development technologies

Consultants are domain experts with more than 15

years of experience from various reputed organizations

ABOUT iTAS

6

WHY iTAS?

Simple and Industry

Oriented training

without much usage of Jargons

Provide Solutions to

Build Operations to

Save Time/Cost

for Clients and to Increase

Profitability

Trainers are

Professionals

in various domains with

15+ years of

experience

Trainings are in

sync with various learning speeds of Individuals

Real time examples

are provided with every course

Candidates can

bring their data to get trained based on their requirements

Free Project

Assistance

for Professionals & Freshers

Candidates can

attend any number of batches 7

COURSES OFFERED

8

COURSES

OFFERED

Advanced Excel Pro+

VBA Macros Pro+

BI Using Power BI

BI Using Tableau

R Programming

Python Programming

Data Visualization

Data Science

Advanced Excel

VBA Macros

Dashboard Designing

Excel Automation

Advanced MS Access

SQL Server

Advanced PowerPoint

MIS Reporting

9

COURSE PRICE LIST

Course Actual Price

(*Live Class)

Offer price

(*Live Class) **Videos with Sessions

Videos

without

Sessions

BI USING POWER BI20,00010,0005,0001,999

TABLEAU20,00010,0005,0001,999

PYTHON PROGRAMMING20,00010,0005,0001,999

R LANGUAGE20,00010,0005,0001,999

SQL SERVER20,00010,0005,0001,999

MY SQL20,00010,0005,0001,999

SQL USING MS ACCESS10,0006,0003,0001,499

VBA MACROS9,0006,0003,0001,499

VBA MACROS PRO+9,0006,0003,0001,499

ADVANCED EXCEL PRO+8,0005,0002,500999

ADVANCED EXCEL6,0004,0002,000999

EXCEL AUTOMATIONS4,5003,0001,500699

DASHBOARD DESIGNING4,0002,5001,250599

REPORTING TECHNIQUES4,0002,5001,250599

MS WORD3,0002,0001,000499

MS POWERPOINT3,0002,0001,000499

*18% GST Applicable on all Fees

*Live Class includes instructor led training (Classroom/Online) for the total no. of hours per course,

along with YouTube link of recorded videos & study materials

**Recorded videos of course topics along with 2hours of live online session for any queries regarding the course

10

PACKAGE PRICE LIST

PackageActual Price

(Live Class*)

Offer Price

(Live Class*)

Videos**

with Sessions

Videos

without

Sessions

MS OFFICE PACKAGE12,0006,0003,0001,499

MIS REPORTING37,50024,00012,0004,999

BUSINESS ANALYTICS57,50035,00017,5007,499

DATA ANALYTICS77,50045,00022,5008,999

ADD-ON PACKAGE60,00035,00017,5005,999

*18% GST Applicable on all Fees

*Live Class includes instructor led training (Classroom/Online) for the total no. of hours per course,

along with YouTube link of recorded videos & study materials

**Recorded videos of course topics along with 2hours of live online session for any queries regarding the course

ADVANCED EXCEL

11 oIntroduction oSpreadsheet Principles oUnderstanding Screen Layout oCreating Auto List & Custom List oEntering, Selecting and Editing Data oUnderstanding References o(Relative, Absolute & Mixed) oWorking on Various Functions & Formulas

Common Basic Functions

Logical Functions

Text Functions

Date & Time Functions

Lookup & Reference Functions

Mathematical Functions

Conditional Functions

oFormula Auditing oVarious Calculation Techniques oWorking on Ranges (Static & Dynamic) oSorting Techniques oVarious Data Filtering Techniques oFormatting Techniques (Cells, Range, Sheets)

Conditional Formatting

Number Formatting

Table Formatting

oData Validation Techniques oWorking on Data Tools

Data Consolidation

Group and Outline

Text to Columns

Flash Fill

oNew Ink Effects oMicrosoft Translator oLinking various Sheets and Files oCreating Charts (Basic & Advanced) oUnderstanding Sparklines o(Line, Column, Win/Loss) oWorking with Tables oPivot Tables & Pivot Charts oWorking on Slicers & Timelines oProtecting Sheets & Files oUnderstanding Various Excel Window Techniques oViewing Excel Spreadsheet in various Layouts oAdvanced Printing Techniques oTemplates Themes oExcel Projects oTips & Tricks

Rs. 6,000Rs. 4,000DURATION : 12 HRS

ADVANCED EXCEL PRO+

12 oAdvanced Filters oAdvanced Number Formatting oAdvanced Conditional Formatting oAdvanced Sorting Techniques oAdvanced Formulas oAdvanced Data Validations o3D Models oData Modelling oPower Queries oAdvanced Pivoting Techniques oSlicers, Timelines oPower Pivots oDAX Functions oAdvanced Charting Techniques oSparklines oProtecting Workbook

Rs. 8,000Rs. 5,000DURATION : 12 HRS

VBA (VISUAL BASIC FOR APPLICATIONS) 13 oIntroduction oUnderstanding VBA, VBE, Macro Security oObject Hierarchy oUnderstanding Various Objects oDeveloping Programming Skills oNaming Conventions oWorking on Input Box & Message Box oWriting Simple Programs oExecuting VBA Codes oModifying & Commenting VBA Codes oDebugging VBA Codes oWorking on Procedures and Functions oUnderstanding Different Type of Modules oUnderstanding Variables, Data Types & Events oConditional Statements o(If, If-Elseif, Nested If, Select Case) oLoops o(For, For Each, Do While, Do Until) oWorking with Various Modules o(Sheet, Workbook, User Form, Class) oWorking with Arrays oProgramming on Various Objects o(Workbook, Pivot Table, Charts, Sheets,

Range, Cells)

oRecording Macros oProtecting Sheets, VBA Codes oError Handling oTips and Tricks on Handling VBA Projects

Rs. 9,000Rs. 6,000DURATION : 12 HRS

VBA MACROS PRO+

(VISUAL BASIC FOR APPLICATIONS) 14 oWorking with Shapes oWorking with Charts oWorking with Objects oWorking with Dialog Boxes oWorking with File Management oReports using Maps oVarious Applications Connection

Outlook

MS Access

MS Word

MS PowerPoint

oAdvanced UserForms oAdvanced Pivoting Options oCreate Add-ins oAdd Custom Tab oAdd Button to Ribbon oAdd Macros to Buttons in Ribbon oCreating User Defined Functions oBasic Automation oBasic Dashboard, Tool Designing

Rs. 9,000Rs. 6,000DURATION : 12 HRS

15 oIntroduction oUnderstanding Database Terminologies oDBMS & RDBMS oNormalization, oData Integrity, Database Relationship oUnderstanding Screen Layout oCreating a Database oData Import & Export from Various Data sets oWorking with Tables

Creating, Save, Rename Table

Understanding Various Data types

Setting field properties

Setting Field properties & Validation Rules

Modify Table Structure

oUnderstanding SQL (DDL, DML) oWorking with Queries

Writing Queries using SQL & Design View

Using WHERE, GROUP, ORDER BY, HAVING

oDifferent Types of JOINS

MS ACCESS

oCreating a Multiple Table Query

Expressions & Expression Builder

Using an IIF Function

Displaying Top or Bottom Values

Crosstab & Parameter Queries

Make-Table, Delete, Append, Update Queries

oWorking with Forms oWorking with Reports oTips and Tricks on Handling MS Access Projects

Rs. 10,000Rs. 6,000DURATION : 12 HRS

16 oIntroduction oUnderstand Dashboard Concepts oUnderstand Client Requirements oData Visualization Techniques oDesigning Cover Page, Buttons, Banners oNavigation Techniques oUnderstanding Reporting & Calculation Sheets oUnderstanding Raw Data oData Modelling oWorking on Charts & Tables oWorking with Active X Controls oWorking with User Form Controls oCreating Reports Using

Pivot Table, Pivot Charts

oCreating Dashboards using Slicers oWorking with External Data oExporting Data to Excel, Access,

PPT, TXT, CSV

DASHBOARD DESIGNING,

AUTOMATION, REPORTING

oImporting Data from Excel, Access,

PPT, TXT, CSV

oExporting Charts, Tables to PowerPoint oUpdating Charts, Table in

PowerPoint automatically

oLinking Charts, Tables in PowerPoint oConverting Reports into PDF oSecuring Dashboards and Reports oProjects oTips & Tricks

Rs. 12,500Rs. 8,000DURATION : 12 HRS

17 oINTRODUCTION

Getting Started

Basic Syntax

Keywords & Identifiers

Statements & Comments

Variables

Type Conversion

I/O and Import

Operators

Namespace

oDATATYPES

Numbers, List, Tuple, String, Set,

Dictionary, Nested Dictionary,

Arrays, Matrix, List Comprehension

oFLOW CONTROL

If...Else

Elif oLoops

For Loop

While Loop

Break and Continue

Pass Statement

Looping Technique

PYTHON PROGRAMMING

oFUNCTIONS

Function

Function Argument

Recursion

Anonymous Function

Global, Local and Nonlocal

Global Keyword

oModules oFILE HANDLING

File Operation

Directory

oException

Exception Handling

User-defined Exception

oOBJECT & CLASS

Python OOP

Python Class

Python Inheritance

Multiple Inheritance

Operator Overloading

Rs. 20,000Rs. 12,500DURATION : 12 HRS

18 oIntroduction oTableau Products oMenus oScreen Layout oConnect Data to Various Data Source oDifferent File Types oShow Me oData Terminology oTableau Fundamentals oExtracting Data oData Types oFields Operations oEditing Meta Data oData Joining oData Blending oWorking on Folders oCreating Hierarchies oWorking on Worksheets oCreating Reports oOperators

BI USING TABLEAU

oFunctions oTable Functions oType Conversion Functions oTable Calculations oLOD Expressions oSorting Techniques oFilters Techniques oGrouping oSets oBins oParameters oWorking on Various Charts oDual Axis Reports oReference Lines oFormatting Techniques oMaps oCreating Dashboards oWorking on Dashboard oPublish Dashboard

Rs. 20,000Rs. 12,500DURATION : 12 HRS

19 oIntroduction oAbout Business Intelligence? oPower BI Products oScreen Layout oMenus oData Terminologies oViews oImport Data for Various Data Source oUnderstanding File Types oWorking on Objects & Visuals oEdit Queries by using Power Query oData Types

Number

Date/time

Text

Boolean

oData Modelling

Data View

Relationship View

Create & Manage Relationships

oFormatting Visualizations oData Drill oDifferent Views oBookmarks oGrouping oJoins oKPI Visuals oWorking on Various Charts & Visualizations

BI USING POWER BI

oAnalytics Pane oFilters oParameters oIntroduction to DAX

What Is DAX

What Is a Data Model

Components of a DAX Data Model

Datatypes

Operators

Operator Precedence

Relationships

Calculations

DAX Functions

Date and time Functions

Time-intelligence Functions

Filter Functions

Information Functions

Logical functions

Mathematical Functions

Statistical Functions

Text Functions

FORMAT Functions

oVariables oDebugging and Optimizing oReports and Datasets oPower BI Dashboards oPublish Dashboard & Reports oSharing Power BI Work

Rs. 20,000Rs. 12,500DURATION : 12 HRS

20 oGetting Started with SQL Server oWhat is SQL Server oInstall the SQL Server 2017 Developer Edition oConnect to the SQL Server oExplore an SQL Server Sample Database oLoad the SQL Server Sample Database oLogin Database oCreate Database oSelect Database oDrop Database oCreating Backups oRestoring Databases oCreate Users oAssign Permissions oMonitor Database oSQL Server Basics oQuerying dataquotesdbs_dbs17.pdfusesText_23