Data Analytics

API Using Python

v Basics
v Rest Architecture
v Rest and Python
Libraries For Data Analysis
Numpy
v Array creation methods
v Multi-dimensional arrays
v Linear algebra using Numpy Architecture of Tableau
Core Basics of Python v Array ltering and update methods
v Introduction and Overview Pandas v Installation Of tableau Desktop
v Install and Setup Python and v Dataframe and Series v Architecture of Tableau
v PYcharm IDE v Grouping and Merging v Interface of Tableau ( layout, Toolbars, Data pane , Analytics pane )
v Variable Types and Input v Data formatting
v Basic Operators v Excel le handling functions
v Decision Making Working with Metadata & Data Blending
v Loops and Date & Time Matplotlib
v Numbers and Strings v Connection to Excels , PDFs and Cubes
v Lists,Tuples and Dictionary v Line plot,scatter plot and bar graph
v Managing Metadata and Extracts
v Built-in Functions,User Dened v Histogram
Functions v Data Preparation and dealing with Null values
v v Heatmaps
Built-In Modules v Data Joins ( Inner , Left , Right , Outer ) and Union
v v Violin plot and box plot
v File I/O v Cross DataBase joining
v Managing Directories Types of Data Analysis v Data Blending , Data & Refresh Extraction , incremental Extraction
v Exception handling v How to build Extract?
v Python Slice and Slicing Descriptive and Prescriptive Analytics
v Data Visualization
OOPS in Python v Data Sampling Creation of sets
v Classes and Self v Statistical Distribution Analysis Marks, Highlighting, Sort and Group, working Sets
v Class Constructor(__init__)and Destructor v Data Cleaning v
Creating of Sets, Editing Sets, IN/OUT, Sets Hierarchies
v Inheritance its Types and Polymorphism v Handling large Data sets v
Constant Sets, Computed Sets, Bins
v Clustering v
Database with SQL Predictive Analysis Working with Filters
v MySql Introduction v Machine learning algorithms
v
Install MySql Connector for python Create Parameters, Parameters in Calculations
v
v Regression v
Using Parameters with lters
v
Curd(Create,Update,Read,Delete) v Classication v
Column Selection Parameters
v Operations v Model Evaluation v
v Basic functions
Chart selection parameters
v All Types of Joins
v Encoding v
How to use Parameter in Filter Session
v v Dimensionality Reduction v
How to use Parameter in Calculating Fields
Wildcards v
v
v
Triggers How to use Parameter in Reference Line
v
v Union Tableau
v Stored Procedure
v Views
v Indexes , Constraints v Introduction to Data Visualization and power of Tableau
v What is data Visualization
Machine Learning v Comparison and benets against reading Raw numbers
v Real usage examples from various Business Domains
v Introduction to ML v Connecting to Data Source
v Regression Strategies v Tableau Data types and data preparation
v Classication Strategies TECHNOLOGIES PRIVATE LIMITED
 Tools of Data Analytics
Chart and Graphs Visualization Properties

v Dual Axes Graphs, Histogram v Stacked Charts and Clustered Charts

v Dual Axes Graphs, Histogram (Single and Dual Axes), v Line Charts, Area Charts, Bar Charts
v Box Plot, Pareto Chart, Motion Chart, Funnel Chart v 100% Stacked Bar & Column Charts
v Waterfall Chart, Tree Map, Heat Map, Market Basket analysis v Map Visuals: Tree, Filled, Bubble
v Using Show me Types of Charts, Text Table, Heat map, v Cards, Funnel, Table, Matrix
v Highlighted Table, Pie Chart, Tree map, Bar chart, Line Chart v Scatter Chart : Play Axis, Labels
v Bubble Chart, Bullet chart, Scatter Chart v Series Clusters & Selections
v Dual Axis Graphs, Funnel Charts, Pareto Chart, Maps, Hands on Lab, v Waterfall Chart and ArcGIS Maps
v Assignment, Funnel Chart, Waterfall Chart, Maps
Transformation Modeling
Dashboards and Stories
v Loading the dataset
v Transforming the datasets using powerbi query editor(creating new column and splitting column), merging,
v Build and Format a Dashboard (Size, Views, Objects, Legends and Filters),
v Performing mathematical calculations
v Best Practices for Creative and Interactive Dashboards using Actions
v modeling:-
v Create Stories (Intro of Story Points,
v DAX functions(aggregate functions)
v Creating and Updating Story Points,
v New columns and new measures.
v Adding Visuals in Stories, Annotations with Description)
v Groupby
v DashBoards & Stories, what is Dashboard, Filter Actions
v Related
v Highlight Actions, Url Actions , Selecting & Clearing values
v If-nested-if,divide
v DashBoard Examples
v Filtering
v Best Practices in Creating DashBoards,
v Sorting,manage
v New table,
Tableau Preparation
v Data visualization=piechart,scatter plot,bar graph,funnel chart,area chart,line chart,maps,
v Introduction to Tableau Prep. v Clusters in scatter plot
v How Tableau Prep helps to quickly combine join DAX Functions
v Shape and clean data for analysis create smart experiences with Tableu Prep.
v Get deeper insights into your data with great visual experience v 1:1, 1:M and M:1 Relations
v Make data preparation simpler and accessible, integrate Tableau Prep with Tableau v Connection with CSV
Analytical workow, seamless process from data v AVERAGEX and AVERAGE in DAX
v Preparation to analysis with Tableau Prep v KEEPFILTERS and CALCULATE
v COUNTROWS, RELATED, DIVIDE
Power BI Basics v PARALLELPERIOD, DATEDADD
v CALCULATE & PREVIOUS MONTH
v Power BI Job Roles in Real -time v USERELATIONSHIP, DAX Variables
v Power BI Data Analyst Job Roles v TOTALYTD , TOTALQTD
v Business Analyst - Job Roles v DIVIDE, CALCULATE, Conditions
v Power BI Developer - Job Roles v IF..ELSE..THEN Statement
v Power BI for Data Scientists v SELECTEDVALUE, FORMAT
v Comparing MSBI and Power BI v SUM, DATEDIFF Examples in DAX
v Comparing Tableau and Power BI v TODAY, DATE, DAY with DAX
v Types of Reports in Real-World v Getting the data from mysql into powerbi and dealing with it
v Interactive & Paginated Reports v AZURE and cloud computing concept with powerbi
v Analytical & Mobile Reports
v Data Sources Types in Power BI Projects
v Power BI Licensing Plans - Types
v Power BI Training : Lab Plan v Stock Market Analysis
v Power BI Dev & Prod Environments v Covid-19 Impact analysis
v Customer Sentiment analysis
v Automatic price prediction system

TECHNOLOGIES PRIVATE LIMITED

SCO 112-113, First Floor, Sector 34-A, Chandigarh Phone : 0172-4644644, 8699-644644
 Tools of Data Analytics
Excel Introduction Date and Time Functions

v Today, Now
v An overview of the screen,
v Day, Month, Year
v navigation and basic spreadsheet concepts
v Date, Datedif, Date Add
v Various selection techniques
v MONTH, Weekday
v Shortcut Keys
Advanced Paste Special Techniques
Customizing Excel v Paste Formulas, Paste Formats
v Data Validations
v Customizing the Ribbon v Transpose Tables
v Using and Customizing Auto Correct
v Changing Excel’s Default Options Sorting and Filtering
Lookup Functions
v Filtering on Text, Numbers & Colors
Formatting and Proofing v Sorting Options v Vlookup / Hlookup
v Advanced Filters on 15-20 different criteria(s) v Index and Match
v Creating Smooth User Interface Using Lookup
v Currency Format v Nested V lookup
v Format Painter
Printing Workbook v Reverse Lookup using Choose Function
v Formatting Dates v Worksheet linking using Indirect
v Setting Up Print Area v Vlookup with Helper Column
v Custom and Special Formats
v Customizing Headers & Footers
v Formatting Cells with Number formats, Font formats, Alignment,
v Designing the structure of a template
Borders, etc Pivot Tables
v Basic conditional formatting v Print Titles –Repeat Rows / Columns
v Creating Simple Pivot Tables
Analysis with Advance Excel v Basic and Advanced Value Field Setting
Mathematical Functions v Classic Pivot table
v Goal Seek Analysis v Choosing Field
v Prediction Analysis v Filtering Pivot Tables
v SumIf, SumIfs CountIf, CountIfs v Data Tables (PMT Function) v Modifying Pivot Table Data
v AverageIf, AverageIfs, v Solver Tool v Grouping based on numbers and Dates
v Nested IF, IF ELSE Statement v Calculated Field & Calculated Items
v AND, OR, NOT
Logical Functions v Arrays Functions
v What are the Array Formulas, Use of the Array Formulas ?
Protecting in Excel v If Function v Basic Examples of Arrays (Using ctrl+shift+enter).
v How to Fix Errors – if error v Array with if, len and mid functions formulas.
v Nested If v Array with Lookup functions.
v File Level Protection v Advanced Use of formulas with Array.
v Complex if and or functions
v Workbook, Worksheet Protection
Charts and slicers Excel Dashboard
Text Functions Data Validation
v Various Charts i.e. Bar Charts / Pie Charts / Line Charts
v Number, Date & Time Validation v Using SLICERS, Filter data with Slicers
v Upper, Lower, Proper v Text and List Validation v Manage Primary and Secondary Axis
v Left, Mid, Right v Custom validations based on formula for a cell
v Trim, Len, Exact v Dynamic Drop-down List Creation using Data Validation – Dependency List
v Concatenate
Excel Dashboard
v Find, Substitute
v Planning a Dashboard

TECHNOLOGIES PRIVATE LIMITED

SCO 112-113, First Floor, Sector 34-A, Chandigarh Phone : 0172-4644644, 8699-644644