Data Analytics
2 Months
Online/Offline
⭐⭐⭐⭐⭐ (593+)
Enquire No:
+91 9448403469
Batches Start From:
1st,10th & 20th of every month
60 Days of Thorough Training Curriculum Designed by Industry Experts Live Training with the Corporate Experts Frequent Mock Interviews and Tests 2000+ Hiring Partners
60 Days of Thorough Training Curriculum Designed by Industry Experts Live Training with the Corporate Experts Frequent Mock Interviews and Tests 700+ Hiring Partners
Course Overview
2-Month Course Duration
We go over all the prerequisites needed to acquire a fantastic job, from the ground up.
100% Placement Assistance
Providing complete assistance with the preparation to crack the interviews
Placement Opportunities
We are assisting in finding better and more relevant job openings.
120+ hours of Live Training Interactive Sessions
Thorough guidance ensures the students gain the best out of the course.
why Data Analytics?
With GQT’s we ensure that the students are well-through with the theoretical insights and capable of hands-on implementation of the knowledge they acquire. Our courses are accompanied by relevant aptitude training and projects that would give the students a clear idea of the practical use of what they learn.
Instructors
Raghu is a B. E. in Computer Science and Engineering and has teaching experience of over 4.5 years. His expertise comprises Full Stack Java Development, Cyber security, A.W.S., Networking, Python Development and many more. He also possesses various certifications, including JAVA HackerRank, Oracle Certificatified Java Professional-8, Network Security Professional, and Azure - Az900.
Syllabus
8.1. Create EBS Volumes
8.2. Delete EBS Volumes
8.3. Attach and Detach EBS Volumes with EC2 instance
8.4. Creating and Deleting Snapshots
9.1. Understanding S3 durability and redundancy
9.2. Introduction about S3 Buckets
9.3. How S3 Uploading works and how to Download
9.4. How to S3 Permissions
9.5. How to implement S3 Object Versioning S3 Lifecycle Policies
9.6. Storage Gateways
9.7. Import Export
9.8. S3 Transfer Acceleration
9.9. Glacier Storage
10.1. Describing cloud front
10.2. Creating a cloud front distribution
10.3. Hosting a website of cloud front Distribution
10.4. Implementing global restrictions
10.5. Configuring origins and behaviors
11.1. Describe Hosted zones and Domain name understanding
11.2. How to Create hosted Zones
11.3. Hosting a Website with custom domain name
11.4. Understanding routing policies
12.1. Describing Security Practices for Cloud Deployment
12.2. AWS Shared Responsibilities and Securities
12.3. Importance of Cloud Trail
12.4. Describing Trust Advisor
13.1. Introduction to Amazon Virtual Private Cloud (VPN)
13.2. VPC Advantages and Understanding IP addressing CIDR
13.3. Default and Non-default VPC
13.4. Different Components in VPC
13.5. Describe, Create and Manage Amazon Virtual Private Cloud
13.6. Amazon VPC, Private Subnet and Public Subnet
13.7. AWS Networking, Security Groups and Network ACLs
13.8. Configuration and Management of VPN Connectivity
13.9. Subnet and Subnet Mask
14.1. Introduction to RDS
14.2. Different database services of AWS: Amazon RDS, Dynamo DB, Redshift etc.
14.3. Create MySQL RDS Instance, Oracle RDS Instance, MS SQL RDS Instance
14.4. Configuring the Database
14.5. Configuring Backup
14.6. Configuring the maintenance windows
14.7. Connecting to the Database
15.1. Creating a dynamo DB
15.2. Adding data manually
15.3. Learn about strong and eventual consistency
15.4. Calculating Read write consistency
15.5. Configuring alarms
16.1. Knowledge on Cloud watch – A monitoring Service
16.2. Create and Configuring Monitoring Services
16.3. How to perform setting threshold and Configuring actions
16.4. Creating a cloud watch alarm
16.5. Getting Statics for EC2 instances
16.6. Monitoring other AWS services
16.7. Configuring Notifications
16.8. Integrating Cloud watch with Autoscaling
17.1. What is SNS
17.2. Creating a Topic
17.3. Create Subscription
17.4. Subscribed to the subscription
17.5. SQS and SES
17.6. Lambda and Elastic Beanstalk
18.1. Troubleshooting EC2 instance
18.2. Troubleshooting using Cloud watch
18.3. Troubleshooting using ELB
18.4. Troubleshooting by using Cloud front
19.1. Backup and Disaster Recovery
19.2. How to manage Disaster Recovery and Backups
19.3. Best Practice for DR and Backups
19.4. AWS High Availability Design
20.1. An understanding of DevOps and the modern DevOps toolsets
20.2. The ability to automate all aspects of a modern code delivery and deployment pipeline using
20.3. Source code management tools – CVS, Git
20.4. Build tools – Apache ant, Maven
20.5. Test automation tools – Junit
20.6. Continuous Integration Tools – Jenkins, Team city
20.7. Configuration managements tools – Chef, Puppet, Ansible
Microsoft Excel(Duration 30hrs)
- The Ribbon: Identify the terminology and elements of the Ribbon.
- The Work Surface: Recognize the main terms used to describe Excel’s work canvas.
- Navigation: Utilize the keyboard or mouse to select cells and ranges in a spreadsheet.
- Controlling Your Start Experience: Decide what happens when you start the Excel application.
- Creating Your First File: Create your first Excel file, enter data, and create a table.
- Formatting: Format cells by selecting fonts and color fills to make information more attractive.
- Basic Math: Utilize basic mathematics including multiplication and division in Excel.
- Cell Styles and Conditional Formatting
- Introduction to Range Names
- Find and Replace
- Paste Special
- Text, Number & Date Functions
- IF and Related Functions
- Using Charts & sparklines
- Sorting and Filtering Lists
- Using Tables
- SmartArt and Drawings
- Comments and Hyperlinks
- Importing and Exporting Data
- SUMIFS COUNTIFS Excel
- Data validation lists
- LOOKUP and Related Functions
- Advanced Filter & filters functions
- Relative vs Absolute reference
- Database Functions
- Using Data Validation to ensure accuracy of data input.
- Custom Formats
- Data Tools, Data forecast & outline
- Multiple Workbooks Consolidation
- Pivot Tables & pivot charts
- Pivot tables on multiple tables.
- Shared Workbooks Tracking & Formula Auditing
- Protecting Worksheets
- Introduction to macro
- Start macro programming.
Finance and Accounting: – Financial services and financial accounting are the areas of finance that rely on and benefit from Excel spreadsheets the most. In the 1970s and early 1980s, financial analysts would spend weeks running advanced formulas either manually or in programs like IBM’s.
Marketing and Product Management: – While marketing and product professionals look to their finance teams to do the heavy lifting for financial analysis, using spreadsheets to list customer and sales targets can help you manage your salesforce and plan future marketing strategies based on past results.
Using a pivot table, users can quickly and easily summarize customer and sales data by category with a quick drag-and-drop.
Human Resources Planning: – While database systems like Oracle (ORCL), SAP (SAP), and QuickBooks (INTU) can be used to manage payroll and employee information, exporting that data into Excel allows users to discover trends, summarize expenses and hours by pay period, month, or year, and better understand how your workforce is spread out by function or pay level.
HR professionals can use Excel to take a giant spreadsheet full of employee data and understand exactly where the costs are coming from and how-to best plan and control them for the future.
Excel For Accounts
- Introduction Statistics In Excel
- Introduction Statistics in EXCEL
- Brief Overview of Statistics
- Mean, Median, & Mode
- Percentile and Percentile Rank
- Frequency Distributions
- Standard Deviation and Variance
- Trends in Data
- Introduction to Correlation
- Financial Statement Analysis
- Projecting Revenue Increases
- Calculating Percentage Change
- Calculating Gross Profit
- Calculating Gross Margin
- Excel application into Advance Business Situations
- Currency Exchange Rate Calculations: Using Absolute Cell Referencing
- Compensation Structure: Using Data to Create Sensitivity Analysis
- Analysing Cost Drivers via Common-Size Income Statements in Excel
- Goal Seek in Basic Business Case Scenario
- Goal Seek in Advanced Business Case Scenario
- Excel in accounting and effective spreadsheet design
- Accounting functions for calculating depreciation of assets / cash flows.
- Varying cell content and format with If functions and Conditional Formats
- Filtering / totalling data with advanced filter, subtotals, database functions
- Auditing and error checking your accounting spreadsheets.
- Financial Reporting: advanced graphs and charts
- Summarising accounting data with Pivot Tables and charts
- Automatically extending data selection with Dynamic Data Ranges
- Forecasting: What If Analysis with Goal Seek, Solver and Scenarios
- Forecasting and Budgeting: moving averages and trend analysis
- Introduction Statistics In Excel
Power query (Duration 10hrs)
- Power Query introduction.
- Import data into Power Query.
- Importing data from Excel file.
- Importing data from other files and folders.
- Loading and refreshing data.
- Data refresh. Query one source data change.Data transformation.
- column transformation.
- Row transformation.
- Inbuilt transformation in Power Query.
- Text transformation.
- Number transformation.
- Date transformation.
- Conditional column transformation.
- Consolidate and append data.
- Append data from excel table within same file.
- Append /duplicate /reference multiple queries.
- Import data from files in a folder.
- Import data from multiple files. In a folder.
- List of files in a folder.
- Changing path. Of source data.
- Merge queries. Multiple joins in Power Query.
- Multiple joins in Power Query (Merge queries.)
- Different joints in Power Query.
- Building blocks for m language.
- Introduction to building blocks in M.
- Text functions in Power Query.
- Date functions in Power Query.
- Conditional functions in Power Query.
- Case study. Part 2.
- Financial statements.
- Payroll data.
- Address book.
- Multiple filters on a Single column.
- Rows to column data set.
- Looking up discount rates.
- Invoice data.
- Sales analysis (Maxif, minif, meadianif, sumif) From multiple tables.
- Power Query objects.
- List as objects and list function in Power Query.
- Record as Object and Record functions in Power Query.
- Table and other object and table functions in Power Query.
- Case Study Part 2.
- Extracting only relevant data.
- Creating dynamic calendar table.
- Individual sales to total sales percentage.
- Multiple filters on a same column?
- Extracting day of week number and assigning it to respective column.
Power BI (Duration 25hrs)
- Introduction to Business Intelligence (BI)
- Stages of business intelligence (BI)
- Use cases of BI
- Various BI tools
- Overview of Data warehouse & concepts
- Introduction to Power BI
- Why Power BI
- Power BI Components
- Power BI pricing structure
- Building blocks of Power BI
- Architecture of Power BI
- Power BI vs Tableau vs QlikView
- Introduction of Power BI Desktop
- Installation of Power BI Desktop
- The key features of Power BI workflow
- Process of creating reports in Power BI
Hands-on Exercise –
- Demo of building a Power BI dashboard
- Source data from web
- Publish to cloud.
- Create power tables.
- Overview of Power BI desktop
- Data sources in Power BI
- Using files (excel, pdf, csv, etc.) as a data source
- Using SaaS connectors
- Extracting data from folders, and databases
- Working with Azure SQL database and database sources
- Connecting to Analysis Services
- Other data sources (OData, web, SharePoint etc.)
- Python & R script in Power BI
- Introduction of power query editor
- Advance editor
- Query dependency editor
Hands-on Exercise –
- Connect to a database
- Import data from an excel file
- Connect to SQL Server
- Analysis Service
- Connect to Power Query
- Connect to SQL Azure
- Connect to Hadoop
- Shaping data using Power Query Editor
- Formatting data
- Transformation of data
- Understanding of Data types.
- Data profiling for data quality check
- Naming conventions & best practices to consider.
- Identify and create appropriate keys for joins.
- Working with Parameters
- Merge Query
- Append Query
- Group by of data (aggregation of data)
- Applied steps (query settings)
- Duplicate & Reference tables
- Transpose of data
- Pivot & Un-pivot of data
- Custom columns
- Conditional columns
- Replace data from the tables.
- Split columns values
- Move columns & sorting of data
- Detect data type, count rows & reverse rows.
- Promote rows as column headers.
- Hierarchies in Power BI
- M query
Hands-on Exercise –
- Install Power BI Desktop and configure the settings.
- Use Query editor
- Write a power query.
- Transpose a table
- Introduction of relationships
- Creating relationships.
- Cardinality
- Cross filter direction
- Use of inactive relationships
- Introduction of DAX
- Why DAX is used.
- DAX syntax
- DAX functions
- Context in DAX
- Calculated columns using DAX.
- Measures using DAX.
- Calculated tables using DAX.
- Learning about table, information, logical, text, iterator,
- Time intelligence functions (YTD, QTD, MTD)
- Cumulative values, calculated tables, and ranking and rank over groups.
- Date and time functions.
- Identify poorly performing measures, relationships, and visuals.
- DAX advanced features
Hands-on Exercise –
- Create a Power Pivot Apply filters.
- Use advanced functionalities like date and time functions
- Embed Power Pivot in Power BI Desktop
- Create DAX queries for calculate column, tables and measures.
- Deep dive into Power BI data visualization
- Understanding Power View and Power Map
- Data visualization techniques
- Page layout & Formatting
- Power BI Desktop visualization
- Formatting and customizing visuals.
- Visualization interaction
- Custom visualization in Power BI
- Top-down and bottom-up analytics
- Drill down.
- Drill through
- Page navigations
- Bookmarks
- Selection pane to show/hide visuals.
- Comparing volume and value-based analytics.
- Combinations charts (dual axis charts)
- Filter pane
- Slicers
- Use of Hierarchies in drill down analysis
- Theme for corporate standards
- Power BI template for design reusability
- Mastering the best practices.
- Performance analyze in Power BI for monitoring performance of report.
- Power BI Q&A (Natural Language Query visual)
- Sync slicers
- Tooltips & custom tooltips
- Tables & matrix
- Conditional formatting on visuals
- Waterfall chart, KPI, Donut chart, Scatter chart
- Geographical data visualization using Maps.
Hands-on Exercise –
- Create a Power View and a Power Map
- Format and customize visuals.
- Deploy Power View on SharePoint and Excel
- Implement top-down and bottom-up analytics
- Create Power View reports, Charts, Scorecards
- Add a custom visual to report.
- Authenticate a Power BI web application.
- Embed dashboards in applications.
- Categorize, filter and sort data using Power View
- Create hierarchies.
- Use date hierarchies
- Use business hierarchies
- Resolve hierarchy issue
Tableau (Duration 25hrs)
- What is data visualization?
- Comparison and benefits against reading raw numbers.
- Real use cases from various business domains
- Some quick and powerful examples using Tableau without going into the technical details of Tableau.
- Installing Tableau.
- Interface
- Architecture of Tableau
- Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)
- Tableau field types
- Saving and publishing a data source
- Live vs extract connection
- Various file types
- The ways to share and export the work done in Tableau.
- Basic Charts
- Dual axes graphs
- Mark and highlight
- Sets (creating and editing sets, IN/OUT)
- Hierarchies
- Folders
- Sorting and Types.
- Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.
- Editing axes and annotations”
- Mark and highlight
- Sets (creating and editing sets, IN/OUT)
- Hierarchies
- Folders
- Sorting and Types.
- Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.
- Editing axes and annotations”
- Filters (addition and removal).
- Filters continuous date, dimensions, and measures.
- Filtering in Tableau.
- Types of filters
- Filtering the order of operations.
- K- means cluster analysis.
- Trend and references line.
- Visual analytics in Tableau.
- Forecasting, confidence interval, reference lines, and bands.
- Working on coordinate points.
- Plotting latitude and longitude.
- Editing Recognised location.
- Customizing geocoding Python maps WMS: Web Mapping Service.
- Working on the background image including add image.
- Maps Visualization Custom Territory.
- Plotting points on images and generating coordinates from them.
- How to create maps projects in Python?
- Creating dual axis maps and coordinating location.
- Calculations syntax and functions in Tableau.
- Various types of calculations including tables, strings, date, aggregate logic, and number.
- Levels of details: Fixed level, Low level, and high level.
- Quick table calculations
- The creation of calculated fields
- Quick LODS
- Creating parameters.
- Parameters in calculations.
- Using parameters with filters.
- Column selection parameters.
- Chart Selection parameters.
- How to use parameters in the filter session?
- How to use parameters in the reference line?
- What is Dashboard?
- Building and formatting a dashboard using size object, views, filters, and legends.
- Best practice of making creative as well as interactive dashboard using the action.
- Creating stories.
- Adding annotations with descriptions. Dashboards and stories.
- Highlighting actions, URL action and filter actions.
- Dashboard example using Tableau workspace and Tableau interface.
Course Features
Mentorship by Industry Experts
Get hands-on learning from the industry experts and polish your real-life application skills.
Industrial Boost camps
Polish your skills for the industry with the updated Industrial Boot Camps
Peer Networking
Learn with the like-minded individuals and grow together with them with the network you form
Placement Assistance
Get thorough placement assistance from finding openings to cracking the interview.
Course Fee
Online/Offline Training + Mentorship
Rs. 40,000/-
- Train with the industry experts
- Get access to the updated curriculum for the courses
- Prepare for technical and soft skill improvement
- Get a complete start to end guidance
- Placement assistance to find better opportunities
Register Here
Frequently Asked Questions
For the complete curriculum and the placement assistance through the Data Analytics course offered by GQT, it would cost you INR 40,000.
Student Testimonials
