fbpx

Call Us Today! +91 99907 48956, +91 96503 08956 | info@analyticstraininghub.com

Data Analytics Intermediate Certification

The Data Analytics Intermediate Certification course concludes with data, operation, model, applications, techniques, and communication. It is a study of the allocated data with the help of statistical and operations analysis. The user can predict the models, optimization techniques and communication directly result in people associated with the organization. Any business model or decision-making is entirely based on quantitative methods and evidence-based data. Business data needs big data.

In This Course, You Will Learn we have the most demanding data analytics tools:-

Microsoft ExcelMy SQL / SQL ServerPower BITableau, and Python Core

VBA / Macros, we have kept it optional, however, if you are learning Python then VBA-Macros you can skip it.

(15K+ Satisfied Learners)
4.5/5

With all of the advantages of data analytics, the key benefits can be described in this way:

  • Data analytics reduces the costs associated with running a business. …
  • Data analytics cuts down the time needed to come to strategy-defining decisions.
  •  

Is a Data analytics certification worth it?

If you’re looking for a career in data analytics: yes! Gaining certification in data analytics will equip you with all of the necessary skills and know-how required to land a job as a data analyst.

Future Scope Of Data Analyst

A data analytics certification can make you eligible for a variety of relevant job roles, such as solution architect, data scientist, project manager, business intelligence professional, and statistician

Instructor -Led Online & Physical Classes

Batch Start DateClass TypeUpcoming SlotsTimingsLocation
29th Jan 2023OnlineSold Out
SAT & SUN (5.5 WEEKS)
7:30 PM to 9:30 PMOnline
12th Feb 2023OnlineFilling Fast
SAT & SUN
Weekend Batch
4:30 PM to 6:30 PMOnline
26th Feb 2023OnlineSAT & SUN
Weekend Batch
10:00 AM to 12:00 PMOnline
12th Mar 2023OnlineSAT & SUN
Weekend Batch
8:00 PM to 10:00 PMOnline
26th Mar 2023OnlineSAT & SUN
Weekend Batch
10:00 AM to 12:00 PMOnline

Start Your Course Now

INR 50,070/-
INR 27,000/- + 18% GST

Can’t find a batch you were looking for?

Course Content

For the curriculum, you will cover  in this course, click on the tab to check the detailed content

Module 1:- Getting Started with Excel

  • Introduction to Excel 2013/2016/2019/Office 365
  • Application Interface and Key Components of Excel
  • Navigating Through Excel Ribbon Tabs
  • Exploring Important Excel Options*
  • Live Session Exercise
  • Splitting data of Single Column into multiple
  • 10 Examples to use Auto-fill and Flash Fill
  • Magics of Go-To Special
  • Merge/Unmerge Cells & Wrap Text
  • Extracting Unique Values & Important Ribbon, General and Data Entry Keyboard Shortcuts

Module 2:- Formatting Essentials

  • Formatting Essentials Introduction
  • Custom Cell Number Formats
  • Custom Date/Time Formats
  • Working with Comments / Notes
  • Format Painter – A Quick way to copy ‘Formatting Attribute’
  • Paste Special
  • Table, Table Styles & Formatting
  • Freeze Panes

Module 3:- Functions & Formulas

  • Introduction to Excel Functions and Formulas
  • Basics of Functions & Formulas
  • Working with Cell References Types
  • Most Used Basics & Advanced Functions & Formulas
  • Working with Array Formulas
  • Creating Customized Formulas Step-by-Step with Live examples
  • Creating and Working with Dynamic Ranges using Function and Excel Table features
  • Formulas Debugging / Formulas Auditing
  • Types of Formula Errors / Error Handling Tricks
  • Text Functions: – CLEAN, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, and TEXT, etc.
  • Date & Time Functions: – DATE, DAYS, TIME, NOW, WEEKNUM, WORKDAY, and WORKDAY.INTL etc.
  • Math & Trig Functions: – INT, MOD, ROUND, ROUNDDOWN, SUMIF, SUMIFS, SUMPRODUCT etc.
  • Statistical Functions: – AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN, LARGE, etc.
  • Logical Functions: – IF, IFS, AND, OR, and IFERROR.
  • Lookup & Reference Functions: – FORMULATEXT, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, and OFFSET
  • Newly Introduced Functions in Recent Version of Excel*: – CONCAT, TEXTJOIN, IFS, SWITCH, DGET, UNIQUE, FILTER etc.
  • Nested Conditions/Customize Formulas*

Module 4:- Data Analysis

  • Data Sorting
  • Data Filtering
  • Named Ranges
  • 10 different ways to use Conditional Formatting
  • 10 other use of Data Validation
  • What-If Analysis

Module 5:- Excel Charts

  • Introduction to Excel Charts
  • Exploring the most commonly used Charts and Templates
  • Basics of Charts
  • Selecting Requirement based Charts
  • Working with Basic Charts:
  • Creating Customized / Advanced Charts
  • Creating Dynamic Chart
  • Working with Dynamic Interactive Charts in Excel using Drop Down
  • Working with Chart Elements, Formatting, Chart Styles, Properties, etc.

Module 6:- Pivot Tables

  • Introduction to Pivot Table
  • Creating a Pivot Table
  • Use of Calculated Fields/Items
  • Pivot Table Formatting
  • Grouping Items & Summarizing data in Pivot Tables
  • Grouping and Bucketing data in Pivot Table
  • Changing/Modifying Data Sources
  • Working with Pivot Table Designs & Layouts
  • Exploring Important Pivot Table Options & Field Settings
  • Pivot Table Filters
  • Changing Pivot Table Summary Calculation
  • Use of Slicers in Pivot Table
  • Using Source Data to Convert into Infographic Summary
  • Introduction to Pivot Charts

Module 1:- Getting Started with My SQL

  • An Introduction and Overview of MySQL
  • Installation and GUI Tools
  • An Overview

Module 2:- My SQL Fundamentals

  • Introducing SELECT statement
  • Introducing WHERE clause
  • Sort result with ORDER BY
  • Using FROM to specify the source tables
  • Importance of Clause Orders
  • Data Modification tricks

Module 3:- Creating Database & Tables

  • Creating a database
  • Creating a table
  • Creating Indexes
  • Controlling column behavior with constraints
  • Using foreign key constraints
  • Creating an ID column
  • Changing a schema with ALTER
  • Introducing NULL and NOT_NULL
  • Introduction to MySQL Data Types
  • Setting up default values
  • MySQL Warnings
  • Alerting a table

Module 4:- My SQL Functions & Clause

  • Introduction to MySQL Functions
  • String Functions – CONCAT, SUBSTRING, REPLACE, REVERSE, LENGTH, UPPER, LCASE etc.
  • Aggregate Functions – COUNT, MIN, MAX, SUM, AVG, ROUND etc
  • Date/Time Functions – CURDATE, CURTIME, CURRENT_DATE, LOCALTIME etc.
  • Control Flow Functions – IF, IFNULL, NULLIF etc.

Module 5:- Multiple Tables & Joins

  • Introduction to JOINS
  • Different types of JOINS
  • JOINS and Aliases
  • Multiple Table Joins
  • Creating a simple Subselect
  • Understanding of Primary keys and Foreign keys

Module 6:- Transactions, Stored Routines & Triggers

  • Transactions & Stored Routines
  • Triggers

Bonus Modules

  • Creating a New User Login
  • Granting access to new users
  • Backup and Restore databases
  • Important Keyboard Shortcuts Guide
  • Session Study Material
  • Situational Case Studies for Best Practice and Getting Ready for Corporate World
  • 6 Months Live Support via Phone/Email/Messages

Module 1:- Getting Started with Power BI Service

  • Get Power BI Tools
  • Introduction to Tools and Terminology
  • Dashboard in Minutes
  • Refreshing Power BI Service Data
  • Interacting with your Dashboards
  • Sharing Dashboards and Reports
  • Recap and What’s Next

Module 2:- Getting & Transforming Data with Power BI Desktop

  • Introduction to Power BI Desktop
  • Getting Data: Excel vs Power BI Desktop & Service
  • Data Structure for Q&A
  • DirectQuery vs Import Data
  • Recap and What’s Next

Module 3:- Modeling with Power BI

  • Introduction to Modeling
  • Setup and Manage Relationships
  • Cardinality and Cross Filtering
  • Default Summarization & Sort by
  • Creating Calculated Columns
  • Creating Measures & Quick Measures
  • Recap and What’s Next

Module 4:- Power BI Desktop Visualizations

  • Creating Visualisations
  • Color Formatting
  • Setting Sort Order
  • Scatter & Bubble Charts & Play Axis
  • Tooltips
  • Slicers, Timeline Slicers & Sync Slicers
  • Cross Filtering and Highlighting
  • Visual, Page, and Report Level Filters
  • Drill Down/Up
  • Hierarchies
  • Reference/Constant Lines
  • Tables, Matrices & Conditional Formatting
  • KPI’s, Cards & Gauges
  • Map Visualizations
  • Custom Visuals
  • Managing and Arranging
  • Drillthrough
  • Custom Report Themes
  • Grouping and Binning
  • Selection Pane, Bookmarks & Buttons
  • Recap and What’s Next

Module 5:- Power BI Service Visualization Tools

  • Introduction
  • Standalone Tiles
  • Data-Driven Alerts
  • Quick and Related Insights
  • Custom Q&A questions

Module 6:- Publishing & Sharing

  • Introduction
  • Sharing Options Overview
  • Publish from Power BI Desktop
  • Publish to Web
  • Share Dashboard with Power BI Service
  • Workspaces and Apps (Power BI Pro)
  • Content Packs (Power BI Pro)
  • Print or Save as PDF
  • Row Level Security (Power BI Pro)
  • Export Data from a Visualization
  • Publishing for Mobile Apps
  • Export to PowerPoint
  • Sharing Options Summary

Module 7:- Refreshing Datasets

  • Understanding Data Refresh
  • Personal Gateway (Power BI Pro and 64-bit Windows)
  • Replacing a Dataset
  • Troubleshooting Refreshing

Module 8:- Power BI & Excel Together

  • Options for Publishing from Excel
  • Pin Excel Elements to Power BI
  • Connect to Data using Power BI Publisher/Analyze in Excel
  • Excel 2016 Publish: Upload and Export to Power BI
  • Sharing Published Excel Dashboards

Module 1: Getting Started with Python Core

✓ Need of Programming with an Example
✓ Why Programming
✓ Advantages of Programming
✓ Different Programming Languages
✓ Introduction to Python
❑ A Brief History of Python
❑ Why Python
✓ Installing Python
✓ Creating Python File using IDLE
✓ Write your first Program in Python
✓ How to execute Python Program
✓ Identifier
❑ Rules for Naming Identifiers
✓ Variables
✓ Operator
❑ Operator Types
✓ Q&A

Module 2: Datatypes in Python

✓ Introduction to Python Data Types
✓ Strings
❑ Introduction to Python ‘String’ data type
❑ String Properties
❑ String built-in functions
❑ Programming with Strings
❑ String Formatting
✓ Lists and Tuples
❑ Introduction to Python ‘List’ data type
❑ List Properties
❑ List built-in functions
❑ Programming with Lists
❑ List Comprehension
❑ Introduction to Python ‘tuple’ data types
❑ Tuples as Read only lists
✓ Dictionary and Sets
❑ Introduction to Python ‘Dictionary’ data type
❑ Creating a dictionary
❑ Dictionary built-in functions
❑ Introduction to Python ‘set’ data types
❑ Set and Set properties
❑ Set built-in functions
✓ Q&A

Module 3: Conditional & Control Statements in Python

✓ Introduction to Conditional Statements
❑ Types of Conditional Statements
o If….Statement
o If….Else Statement
o Elif…. Statement
✓ Introduction to Loops
❑ Types of Loops in Python
o While….Loop
o For….Loop
o Nested Loop
✓ Introduction to Loop Control Statements
❑ Loop Control Statements Keywords
o Break Statement
o Continue Statement
o Pass Statement
✓ Q&A

Module 4: Functions in Python

✓ Introduction to Python Functions
✓ User Defined Functions
❑ Functions definition and return statement
❑ Calling a Function
❑ Parameters and Arguments
❑ Required Arguments
❑ Default Argument
✓ Variable Scope in Function
❑ Local Scope
❑ Global Scope
❑ Enclosing Scope
❑ Built-in Scope
✓ Modules and Packages
❑ Importing Module (from, import statement)
✓ Anonymous functions (Lambda)
✓ Q&A

Module 5: Exception Handling & OOPs Concepts

✓ Getting started working with Files
❑ File Objects and Modes of file operations
❑ Reading, Writing, and use of ‘With’ Keyword
❑ Read(), Readline(), Readlines(), Write(), Writeline()
✓ Introduction to Exception Handling
❑ Understanding Exceptions
❑ Handling An Exceptions
❑ Try, Except, Else, and Finalizing
❑ Raising Exceptions with: Raise, Assert
✓ Introduction to Object Orientated Programming (OOPs)
❑ Why OOPs
❑ Difference Between POPs and OOPs
❑ OOPs Concepts
❑ Python OOP Vs Other OOPs
❑ Class and Objects
❑ Relation Between Class and Objects
❑ Creating a Class
❑ Attributes
✓ Built-In Class Attributes
✓ Class Variable and Instance Variable
❑ Constructor and Destructor
❑ Multiple Constructors
❑ Abstraction
❑ Inheritance
✓ Inheritance Types
❑ Overloading
❑ Overriding
❑ Data Hiding
✓ Q&A

Module 6: Database Connectivity & Regular Expressions

✓ Introduction to Regular Expressions
❑ What are Regular Expressions
❑ Regular Expressions Operations
www.analyticstraininghub.com © 2016-2021 | Analytics Training Hub ( A Unit Of Medhya Analytics Solutions Pvt. Ltd.)
❑ Search Function
❑ Match Function
❑ Modifiers
❑ Patterns
✓ Database Connectivity
❑ Introduction to Database Connectivity
❑ Connections
❑ Executing Queries
❑ Transactions
✓ Q&A

Module 7: Data Manipulation & Data Visualization

✓ What is Data Manipulation
✓ Introductions to Pandas
✓ Data Manipulation with Pandas
✓ Data Structures & Series
✓ Data Frame
✓ Missing Values
✓ Data Operations
✓ Data Standardizations
✓ Pandas File Read (CSV, Excel, SQL) and Write Support
✓ Data Acquisition (Import & Export)
✓ Introduction to Data Visualization using Matplotlib
❑ Installing Matplotlib
❑ Plotting in Matplotlib
❑ Creating First Plot with Matplotlib
❑ Creating Column/Line/Scatter Plots
✓ Wrapping Python Core Program
✓ Q&

Highlights

✔️ 60 Hours / 30 Sessions
✔️ Per Session for 2 Hours

We have included unlimited real-life examples and case studies in our course.

After every session you will get assignments, study material & real-life case studies & Projects. 

In a set of the time period, you will be having access to getting support from our expert

After completing your course, we will provide you with a Course Completion Certificate

You will get 100% job assistance according to your CTC, Experience and Present skills

Need more details about the course, let’s connect with our experts

Let’s Get Our Expert’s Guidance



    Demand Data Analyst Skills to Get You Hired in 2023

    Skills in Demand

    Data Analytics skills give you the ability to design professional-level Dashboards with a lot of analysis. You can analyze complex data if you have knowledge of tools like Power BI, Python. 

    Employability Increases

    Nowadays companies are preferring those candidates for data management profile who has good skills in Microsoft Excel, VBA, My SQL & Power BI, Tableau, Python. Many companies heavily depend on these programs for Data Analysis along with visualization.

    Job opportunities on the rise

    Now, every brand & company has presence at social media that it why Data Analyst demand is increasing everyday. This makes it is a wise career move that has a future in business.

    Most Frequent Questions and Answers

    If you are asking why you should do this program then don’t do it.
    As we can see Data profile demand is increasing every day because data is the new oil for every business. And these skills are really in demand in almost every company. If you learn these skills with full of dedication and attempt all the provided study materials you will definitely earn confidence.
    For more detail, you can connect with one of our team members at #919650308956

    Of course. This course will give you a head start toward a brilliant professional life.

    Though we have so many reasons to join us, let us highlight main points:-

    1. After completing the course you will 3 months of support time period extra to revise the sessions which are not cleared to you, any problem you are not able to solve that you can take our team’s help
    2. We provide video recordings if any of the reason you skip your session
    3. We have well-experienced trainers to teach our students
    4. Project-based training / unlimited examples to make you understand about the subject / Case Studies after every session / Job Support and many more

    Yes, of course, you will be getting “Completion Certificate” 

    Anyone can learn this program, as these are the basic tools now so everyone should have knowledge of these tools, for more detail please call us @ 9650308956

    Obviously career opportunities are going to be increased after completing this course for both Data Management professionals or Non-Data Management professionals.
    But yes who all are into Data Management profile they have to learn many more applications to compete in their domain, please have a look

    Student Reviews

    I am currently attending the Data Analytics program from ATH and almost halfway through it. I was unsure while enrolling into online program, but my experience has been really great, though its online yet I feel that I can ask queries and they get answered as one does in physical sessions. People and the way they handle queries is very professional which is one thing i like the best about this institute.
    ATH student Review
    PALAK GOYAL
    Data Scientist

    Analytics Training Hub helped me in getting good knowledge of VBA, advanced Excel and Power BI. Trainers are very knowledgeable and they provide us with all support and guidance. After talking to Sheetal, I was more confident about the courses which I have planned. She is very helpful and always ready to help. Thanks to the entire team of ATH.
    Shubha Chatterjee
    IT Analyst

    I have joined ATH 4 months back, i was from non tech background, and was scared of starting Data Analytics , but I got the training from starting and trainers are very supportive in the entire session. Even after the sessions also i was getting complete support regarding placement. Thank you so much ATH for training me as a Data Analyst ✨
    Deepika Garg
    Marketing Analyst

    Recommended Courses

    Need help? Call our support team 7:00 am to 10:00 pm (IST) at (+91 999-074-8956 | 9650-308-956)

    Get In Touch

    Email: info@analyticstraininghub.com

    Data Analytics & Data Science Batches Starting from 12th of February 2023. For More Details:- Call Us Today! @ +91 99907 48956 | 91 96503 08956