+91-9582696793info@afapl.in

DIGITAL TECHNOLOGY TRAINING ACADEMY

 

 Aggregate falcon academy is one of the leading training companies in Delhi in the domain of Digital technology. We excel in varied technical courses such as Python, SQL, SAS.

Aggregate falcon academy has the vision to empower and enable the youth of India.  We create a curriculum in a manner that we can cover a maximum course in a short time.

Here is a list of some of the job-oriented technical courses in which we train people.

 

  • Do you know that Python is now one of the fastest growing languages?
    There are 55,000 jobs available for python developers!
  • Google work with Python language for their various applications. Also, they have a separate portal for this language.
  • Python being an open-source and high-level language has dynamic features. Moreover, this language is simple to write, read and understand. Python language is mostly used for game development, web development, web applications etc.

Here is the course content of Python which we teach in our Academy

● Introduction to Python Data Types Simple arithmetic operations Variables
● Introduction to String
● Indexing and Slicing String
● Print Formatting with String Exercise Problems-1

● List
● Dictionaries
● Tuples
● Sets
● Boolean
● I/O with File (CSV, TXT, TAB) File I/O
● Exercise Problems – 2

● Comparison Operators
● Chaining Comparison Operators
● IF – ELSE – ELIF statements
● For loops
● While Loops
● List Comprehensions Exercise Problems – 3

● Functions
● *args and **kwargs
● Lambda Expression, Map and Filter
● Exercise Problems – 4

● Introduction
● Attributes and Class Keyword
● Class Object, Attributes and Methods Special Methods
● Exercise Problems – 5

● Error and Exception Handling Try
● Except
● Exercise Problem – 6

Structured Query Language ( SQL) is a language for interacting with the database. In other words, this language manipulates, retrieve and store the data in the different databases. It is an ANSI & ISO standard. Microsoft SQL Server and Oracle are database products which support SQL. The only answer to handle complex data is SQL.

The future of being an SQL developer is bright. SQL developers get handsome salary. Employers demand SQL developers in their organisation. And this is the reason we provide the training on SQL.

● DATA TYPES
● Primary Key and Foreign Key
● Create Table
● Constraints
● INSERT
● UPDATE
● DELETE
● ALTER
● UNIQUE
● DROP
● CHECK
● NOT NULL
● Exercise – 5

● SELECT
● DISTINCT
● WHERE
● COUNT
● LIMIT
● ORDER BY
● BETWEEN
● IN
● LIKE
● Exercise – 1

● VIEWS
● Common Table Expression (CTE)
● RANK and DENSE RANK
● PIVOT
● UNPIVOT
● Exercise – 6

● AS Statement
● Inner Join
● Join TYpes
● Outer Join
● Exercise – 3

● MIN, MAX, SUM, AVG
● GROUP BY
● HAVING
● Exercise – 2

● Timestamp and Extract Mathematical Function
● String functions

As per the research by International Data Corporation, by 2020 there will be around 50 times more in the world!

Tableau is the data visualisation software. This software completely fits into today’s world. In the spectrum of data, visualisation Tableau is leading. Due to it’s growing popularity this is the right time to learn about this software. There is a very high demand for tableau experts in the industry.

Moreover, the high ranking companies like Dell, Groupon, Facebook, Sony Electronics, Sunguard, General Motors are looking for tableau experts

We at Aggregate falcon academy have prepared an extraordinary training course on this emerging software “Tableau”. Here is the course content of Tableau  which we teach in our Academy

● Level of Detail (LOD)
● Sets
● Parameters
● Set Actions
● ParameterActions

● Join vs blending
● Whentousewhat?
● Real-time use cases with exercise

● Options in Formatting your Visualization
● Working with Labels and Annotations
● Effective Use of Titles and Captions
● Introduction to Visual Best Practices

● Combining multiple visualizations into a dashboard
●Making your work sheet interactive by using actions and filters
● An Introduction to Best Practices in Visualization

● Publish to Reader
● PackagedWorkbooks
● Publish to Office
● Publish to PDF
● Publish to Tableau Server and Sharing over the Web

● Connecting to Data and introduction to data source concept
● Working with data files versus database server
● Understanding the Tableau workspace
● Dimensions and measures
● UsingShowMe!
● Tour of Shelves (How shelves and marks work)
● BuildingBasicViews
● Help Menu and Samples
● Saving and sharing your work

● Why Tableau? Why Visualization?
● Level Setting–Terminology
● Getting Started – creating some powerful visualizations quickly
● The Tableau Product Line
● Things you should know about Tableau

● 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

● Filter
● Highlight
● URL

● Marks
● Size and transparency
● Highlighting
● Working with dates
● (Views and Advanced SQL)
● 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

● Line Charts, Pie Charts and Bar Charts Water Fall Chart
● Dough-nut Chart
● 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
● Trend lines
● Table Calculations

Statistical Analysis System is an analytical software which was developed for predictive analytics,  multivariate analysis, data management, business intelligence and advanced analytics. This software can change and retrieve the data from numerous sources for performing statistical analysis on them.

SAS is very old software and one of the most renowned tools in data science. This tool of SAS programming is in the realm of data science from approximately 40 years. Data Science is exponentially growing nowadays and so is the need for the SAS programmer.

If you are choosing your career as a SAS programmer then you made the right choice. Here is the course content of SAS  which we teach in our Academy

● Introduction To SAS System & Architecture, History And Various Modules, Features, Variables & SAS, Syntax Rules, SAS Data Sets, Data Set Options, Operators, Reading Raw Data, Infile Statement With all possible Options, Working With External Files & Options, Multiple Observations, Input Styles, Select Statement, Leave and Continue Statements, Creating & Redefining Variables, Where Statement, If – Then Else Statement, Output Statement, Put Statement, Do Loops, Modifying And Combining Data Sets, Updating Master Data Set, Display Manager Commands, SAS Functions, An Introduction To Arrays And Array Processing, Data Step Merge

● BASE SAS PROCEDURES

● Proc sort, Proc Print, Proc Means, Proc Freq, Proc Plot, Proc Chart, Proc Copy, Proc Summary, Proc Append, Proc Datasets, Proc Contents, Proc Delete, Proc Format, Proc Import, Proc Export

● SAS/SQLIntroduction To SAS/ SQL, Features, Uses, Terminology, Functions, Formatting Output, Group By Clause, Order By Clause, Having Clause, Case Expression And Conditional Logic, Creating – Populating & Deleting Tables, Alter Table Statement, Changing Column’s Length, Joins, Constraints, Renaming A Table & Columns, Views SAS/MACROS, Macro Concepts, Macros And Macro Variables, Creating Macro Variables, Using Macro Variables, Creating Modular Code With Macros, Invoking A Macro, Adding Parameters To Macros, Macros With Conditional Logic, Using Various Procedures In Macros, Automatic Variables, Macro Functions, Including External Macros
● SAS/ODS
Creating RTF File, Creating Html File, Creating Pdf File SAS/GRAPH, Chart Procedure, Vertical, Horizontal, Pie, Group, Subgroups, Plot Procedure, Title And Footnote Statements, Multiple Plots & Overlay, Symbol Statement
● SAS/GRAPH
Chart Procedure, Vertical, Horizontal, Pie, Group, Subgroups, Plot Procedure, Multiple Plots & Overlay, Symbol Statement, Title and Footnote Statements
● SAS/REPORTS
Frequency Report, One-Way Frequency Report, Cross Tabular Frequency Report, Summary Statistics, Creating A List Report, Define Statement, Order Usage and Group, Printing Grand Totals, Rbreak Statement, Tabulate Procedure, One-Dimensional Tables, Two-Dimensional Tables, Obtaining A Total, Analysis Variables with options, Summary Statistics

There is no company in the world who do not use computers. More precisely “Excel”. Across the globe, excel is the tool which widely used to analyse, present and record the data.  Excel plays a crucial role in Business intelligence. Excel is one of the applications which is used by each and every individual across the world.

If you have proper training in excel then there are high chances that any organisation can hire you. We at Aggregate Falcon Academy conducts this course. This course opens the door of each and every person getting the job.

Here is the course content of Excel which we teach in our Academy

Introduction, Interface, Tabs and Ribbons, Document Windows, Navigation Tips, Office Button and Save

Introduction, Entering Data, Fonts, Fills, and Alignment, Cut, Copy, and Paste, Paste Special, Undo and Redo, Moving, Finding, and Replacing a Value, Cell Styles, Comments

Naming and Moving Worksheets, Copying Worksheets, Adding, Deleting and Hiding Worksheets, Grouping Worksheets, Moving, Copying, Deleting and Hiding Grouped Worksheets

Introduction, Using Operations, Creating Formulas, AutoSum, Common Formulas, Searching for Formulas, Copying Formulas, Using Relative and Absolute References

Introduction, Currency Format, Format Painter, Formatting Dates, Custom and Special Formats

Inserting and Deleting Columns and Rows, Inserting & Deleting Cells, Inserting Multiple Columns & Rows, Modifying Cell Width and Height, Hiding and Un-hiding Rows and Columns

Introduction, Workbook Views, Show/Hide, Zoom Features, Freeze Panes, Split Windows, Viewing Multiple Windows, Minimize The Ribbon, Worksheet Backgrounds, Watermark

These courses can take your career to a completely new level. Connect to us to know more about these courses or to register in these courses.

AGGREGATE FALCONS ACADEMY PVT LTD

WhatsApp chat
Enquiry Now

Please fill up the form below and our advisors will get in touch you.