height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=945058072538609&ev=PageView&noscript=1"

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

Analytics training hub logo

DATA ANALYTICS P1

Learn Most-In Demand Reporting Tools
Microsoft Excel, My SQL along with Data Visualization tool Power BI

(10K+ Satisfied Learners)
4.5/5

Add Ons

MS PowerPoint Training

Avail this Optional Program in Just 2,000/- INR

Microsoft Certification Exam

Avail this Optional Program in Just 2,200/- INR

Soft Skill Training

Avail of this Optional Program in Just 1,200/- INR

Data Analytics

Data analytics is the process of extracting meaningful insights and patterns from large sets of data. It plays a crucial role in today’s data-driven world by enabling businesses and organizations to make informed decisions and gain a competitive edge. By analyzing data, organizations can identify trends, detect anomalies, and predict future outcomes. Data analytics also helps in optimizing processes, improving operational efficiency, and identifying customer preferences and behaviors. It empowers businesses to target their audience more effectively, personalize their offerings, and enhance overall performance. In essence, data analytics is indispensable in unlocking the potential of data and driving success in various domains.

Batch Slot

Batch Start DateLocationUpcoming SlotsTimings
14th Apr 2024Online & OfflineSold Out
SAT & SUN
10:00 PM - 12:00 PM
21st Apr 2024Online & OfflineFilling Fast
SAT & SUN (4 WEEKS)
Weekend batch
TBD
5th May 2024Online & OfflineSAT & SUN
Weekend Batch
TBD

Course Fees

INR 31,270/-
INR 17,000/- + 18% GST

Can’t find a batch you were looking for?

Course Curriculum

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 from Single Column into multiple
  • 10 Examples to use Auto-fill and Flash Fill
  • Magic 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 different 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:- Introduction to Power BI

  • What is Data Analytics & Data Visualization
    • Introduction to Data Analysis
    • Introduction to Data Visualization
    • What is Business Intelligence?
    • Overview of Self-Service Business Intelligence (SSBI) Tools
    • Leading Self-service tools
    • Comparison of Leading Visualization Tools
  • Getting Started with Power BI
    • Introduction to Microsoft Power BI
    • Why Power BI
    • Power BI Elements
    • Basic Components of Power BI
    • Building Blocks of Power BI
    • Key Benefits of Power BI
  • Hands-On
    • Power BI Installation
  • Skills Gained
    • Understanding of Data Analysis & Visualizations
    • Concepts of Business Intelligence
    • Installing Power BI on the System
    • Elements and Building Blocks of Power BI

Module 2:- Getting Data from Different Data Sources

  • Power Bi Desktop (Getting Data)
    • What is Power BI Desktop
    • Quick Walk-through Power BI Interface
    • Views in Power BI Desktop
    • Report View
    • Data view
    • Model view
    • Understanding ETL Concepts: Extract, Transform & Load
    • Data Sources in Power BI Desktop
    • Connecting and Getting data from different sources in Power BI
    • Getting data from Excel, CSV, Access, etc
    • Saving Workfile
  • Hands-On
    • Identifying and retrieving data from different data sources
    • Extracting and Loading data into Power BI
    • Preparing Data
  • Skills Gained
    • Concepts of ETL tool
    • Getting data from multiple sources

Module 3:- Clean, Transform and Load the Data

  • Shaping Data using Power Query
    • Loading data into Power BI Desktop
    • What is Query Editor
      • Cleaning Data with Query Editor
    • Transforming Data with Query Editor
      • Unpivoting Columns
      • Eliminating Rows / Columns
      • Changing / Modifying Data Types
      • Adding Custom Columns
      • Replacing Values / NULL
      • Promoting / Demoting Row as Header
      • Modifying and managing existing ‘Steps’
    • Extracting Date Components from Date-Time
    • Introduction to “M Query”
    • Combining Data
      • Append Merge / Joins, Transpose & Formatting Data Operations
    • Hands-On
      • Cleaning Data using Power Query Editor
      • Shaping the data
      • Transforming and cleaning the data
      • Merging Rows / Columns from multiple tables
      • Joins / Append activities
    • Skills Gained
      • Data Transformation using Query Editor
      • Loading the data
      • Understanding of “M Query”

Module 4:- Design a Data Model

  • Introduction to Data Modeling
    • Understanding of Relationship
      • What is Relationship?
      • One to Many Vs One to One Relationship
    • Auto-Detect Relationship during Load
    • Dimension Table Vs Fact Table
    • Cardinality in Data Modeling
    • Creating Relationship Manually
    • Managing Data Relationship
    • Editing Relationship
    • Creating Calculated Columns
    • Creating Measures
    • Optimizing Data Models for Better Visuals
    • Cross Filter Direction
    • Defining Hierarchies
  • Hands-On
    • Creating Model Relationships
    • Managing Relationships
    • Creating Measures
    • Creating hierarchies
  • Skills Gained
    • Understanding the basics of data modeling
    • Defining relationships and their cardinality
    • Understand star schema and its’ importance
    • Managing relationships

Module 5:- DAX Formulas & Calculations

  • Introduction to Data Analysis Expression (DAX)
    • Importance of DAX
    • Data Types in DAX
    • Defining Calculation Type
      • Calculated Column Vs Calculated Measures
      • Adding New Measures to Report
      • Creating Calculated / DAX Tables
    • DAX Syntax & Operators
    • Most Important & Common Basics & Advanced DAX Functions
      • Aggregate Functions
      • Logical Functions
      • Time-Intelligence Functions
      • Information Functions
    • DAX Variables
    • Formatting DAX Code
    • Handling Errors in DAX Expressions
  • Hands-On
    • Creating Calculated Tables
    • Creating Calculated Columns and Measures
    • Writing DAX calculations to perform Data Analysis
    • Beautifying DAX
    • Creating Variables
  • Skills Gained
    • Understanding DAX
    • Create Calculated Columns, Measures & Tables
    • Working with Advanced functions e.g. Time-Intelligence, Filter contexts etc.

Module 6:- Data Visualization & Creating Reports

  • Introduction to Visuals in Power BI
    • Creating Visualization
    • How to use Visual
    • Exploring Visualizations’ List
    • Exploring Most Common & Important Visualizations
      • Bar, Column, Line and Area Charts
      • Pie, Donut, and Gauge Charts
      • Single Number Cards and Multi Row Cards
      • Table & Matrix Visuals
      • Combo Chart, Funnel and Treemap Charts
      • Slicer, KPI and Custom Visuals
      • Map & Filled Map Visuals
    • Modifying Color Properties of Charts and Visuals
    • Shapes, Text Box, Buttons, and Images
    • Types of Filters
    • Slice and Dice Data in Power BI
    • Drilling-Up/Down
    • Understanding Custom Visuals & How to add them
    • Customizing Canvas
      • Setting up Canvas & Must Know Global Fonts
      • Page Layout & Formatting
    • Bookmarks in Power BI
    • Reports in Power BI
    • Conditionally formatting tables/matrixes
    • Activity: Creating Sales Report
  • Hands-On
    • Creating visual and charts
    • Designing a report
    • Managing visual fields and format properties
  • Skills Gained
    • Creating and selecting effective visualizations
    • Designing report page layout and Visual modification
    • Adding report navigation & basic functionalities
    • Creating visually stunning reports

Module 7:- Power BI Service and Managed Workspaces

  • Introduction to Power BI Service & Workspaces
  • What is Power BI Service
    • Exploring Interface of Power BI Service
    • Understanding the Admin Portal settings
  • What is Power BI Workspace
    • Understanding of “Workspace”
    • My Workspace Vs New Workspace
    • Creating New Workspace
    • Sharing and Managing Workspaces
  • Roles in workspaces in Power BI
  • Exploring Power BI Licensing
    • Power BI Free Vs Power BI Pro Vs Premium
  • Hands-On
    • Publishing reports on Power BI Service
    • Creating workspaces
    • Sharing and Managing Reports
    • Moving important assets to App and Publishing app in Power BI
  • Skills Gained
    • Knowledge of Power BI Service (Cloud)
    • Workspaces in Power BI
    • Creating and managing a workspace

Module 8:- Creating Dashboard in Power BI

  • Dashboard in Power BI
    • Introduction to Dashboard
    • Difference between Report Vs Dashboard
    • Preparing and Creating Dashboard
      • Configuring a Dashboard
      • Pinning Visuals to Dashboard
    • Dashboard Tiles
      • Pinning Tiles
    • Dashboard Widgets
    • Introduction to Power BI Q&A
      • Asking questions about data
      • Fetching results using Q&A
      • Using Q&A to create a dashboard tile
    • Quick Insights in Power BI
      • Data Analysis using Quick Insights
    • Sharing and Collaborating Dashboard with Business Users
  • Hands-On
    • Creating a Dashboard
    • Pinning visuals to Dashboard
    • Adding text/video widgets to Dashboard
    • Sharing and Moving Dashboard to distributed app
    • Use of Power BI Q&A to question your data
  • Skills Gained
    • Dashboard creation from report
    • Enhancing dashboard usability
    • Importance of Q&A and Quick Insights

Module 9:- Data Gateway, Security & Schedule Refresh

  • Report Security in Power BI
  • Introduction to Row-level Security (RLS)
    • Setting up and Enforcing Row-level security
    • Implementing Row-level security
  • Data Gateway & Report Scheduling
    • What is Data Gateway
    • Types of Gateway
      • On-premises data gateway (personal mode)
      • On-premises data gateway (standard mode)
    • Installing Data Gateway
    • Data Gateway System Requirement
    • Benefits of Data Gateway
    • Scheduled Refresh & Refreshing Data
    • Managing Data Source
      • Adding and removing a Data Source
    • Hands-On
      • Configuring & Implementing RLS
      • Managing datasets
      • Setting up On-Premise Data Gateway
      • Connecting Reports on Power BI Cloud with Local Data Files
      • Schedule dataset refresh
    • Skills Gained
      • Dashboard creation from report
      • Enhancing dashboard usability
      • Importance of Q&A and Quick Insights

Bonus Module:- In-Class Project

  • In-Class Project: Building Sales Report & Dashboard from Scratch
    • Extracting Data from the Local Source
    • Transforming Data using Power Query
      • Cleaning, Shaping and Preparing the data if necessary
    • Loading Data to Power BI Desktop
    • Building Data Model
    • Visual and Charts
    • Row-level Security
    • Publishing Reports
    • Power BI Service
    • Creating Dashboard
  • Hands-On
    • Analyzing Sales data
    • Derive conclusions from the patterns and trends shown in the visualization
  • Skills Gained
    • Report and Dashboard creation
    • Publishing, sharing and collaborating it with Business users

Request For More Information

Data Analytics P1

Basic to Advanced Excel, My SQL & PowerBI
31270
20,060/- Inclusive of GST
  • Live Sessions of 50 Hours
  • Industry Level Training
  • Hands on Practice
  • Completion of Certificate
  • Session Study Material, Case Study
  • Session Recording Access for 9 Months
  • Support Access for 6 Months

Venue Details:-

B1/H3, 91 SpringBoard, MOHAN CO-OPERATIVE, Mathura Rd, Industrial Area, BLOCK B, Delhi, 110044
Call us at +91 96503 08956

Who should do this course?

A Data Analytics course can be beneficial for a wide range of individuals who are interested in working with data and extracting valuable insights. Here are some groups of people who should consider taking a data analytics course:

Professionals in the Field of Data Analysis

If you are already working as a data analyst or in a related role, a data analytics course can help you enhance your skills, stay updated with the latest tools and techniques, and deepen your understanding of data analysis concepts.

Business Professionals and Managers

Data analytics has become increasingly important in making informed business decisions. Managers, executives, and professionals in marketing, finance, operations, and other domains can benefit from a data analytics course to effectively utilize data and gain insights for strategic decision-making.

Aspiring Data Scientist

Data analytics is a foundational skill for aspiring data scientists. A data analytics course can provide a strong foundation in data analysis techniques, statistical concepts, and programming languages commonly used in data science, such as Python or R.

Students and Graduates

Data analytics courses can be valuable for students and recent graduates who are interested in pursuing a career in data analysis or related fields. It can help them gain a competitive edge in the job market by developing relevant skills and demonstrating their proficiency in data analysis.

Entrepreneurs & Business Owners

Data analytics courses can be valuable for students and recent graduates who are interested in pursuing a career in data analysis or related fields. It can help them gain a competitive edge in the job market by developing relevant skills and demonstrating their proficiency in data analysis.

Ultimately, anyone who wants to harness the power of data, whether for personal or professional purposes, can benefit from a data analytics course. It equips individuals with the knowledge and skills necessary to extract valuable insights from data and make informed decisions in today’s data-driven world.

Job Roles

Key Skills

Certificate

TRAINING CERTIFICATION

Earn your certificate

Your certificate and skills are essential for launching your career and competing in a global environment.

Share your achievement

You should communicate your accomplishment on LinkedIn, Twitter, and Facebook; include it in your resume; show it off to your friends and colleagues.

Data Analyst Demand

Skills in Demand

Basic Data Analytics skills give you the ability to design professional-level Dashboards. You can build complex reports if you have knowledge of Power BI. However, with the knowledge of Power BI, you can do more.

Employability Increases

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

Job opportunities on the rise

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

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

Let’s Get Our Expert’s Guidance



    Most Frequent Questions and Answers

    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

    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 very basic now so every company prefers their every employee should have knowledge of the basics for these tools, for more detail you can connect with one of our team members at #919650308956

    Of course. This course will give you a head start towards 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

    Check Out the Demo Videos

    Student Reviews



    If you are in search of Data Analytics Course & Job Assistance then this place is good to opt. Before joining them I was actually in doubt whether they will be able to help me to get the job in this field or not but now I am really happy. I have got a good job along with ultimate learning.
    Ath student review
    Radha sharma
    Business Intelligence Analyst


    Hello I am Himani a working professional I have completed my analytics Training from ATH. My experience with ATH is very nice 👍 I am happy with the trainers knowledge they are really knowledgeable and guide us well, I have learnt Power BI Tableau VBA each trainer is specialised in there specific fields.
    Himani Verma
    Data Analyst

    Got Certified from Analytics Training Hub, I enrolled for Data Analytics (Excel, My SQL, Power BI, Python) Had a great experience taking Online live sessions...the trainers are well experienced and knowledgeable and their way of teaching is so good, I was totally fresher and learnt each and every thing from scratch. Thank you ATH Team for your support
    Sonamdeep Kaur
    Quantitative 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 Batch Starting from 14th Apr'24. For More Details:- Call Us Today! @ +91 97118 17956 | 91 96503 08956