Course Details
Full Stack Data Analytics
Data Analytics
Created On
June 30, 2023Description
Data analytics is the process of examining, cleaning, transforming, and interpreting data to extract meaningful insights, patterns, and trends. It involves using various statistical and computational techniques to make informed decisions and solve real-world problems. Data analytics plays a crucial role in business, science, healthcare, finance, and many other fields by helping organizations uncover hidden information within their data, optimize processes, and drive data-driven decision-making.
Overview
The **Full Stack Data Analytics course** is designed to provide a comprehensive understanding of data analytics techniques and tools. It covers a wide range of topics, from **fundamental statistics to advanced data visualization and analysis using popular tools like Power BI, Tableau, MySQL, and Python.** The course is designed to provide a comprehensive understanding of data analytics techniques and tools.
Features
- Comprehensive Curriculum
- Hands-on Learning
- Industry-Standard Tools
- Practical Data Transformation
- Course material
- Course resources
- Lifetime Dashboard access
- Doubt clearing one to one.
- Doubt clearing through mail & support team
- Internship Anytime
- Resume building
- Interview Preparation
- Mock Interview
- Live interactive instructor lead classes.
- Regular assessment
- Q&A Sessions with industrial experts.
- Internal Hiring
What you'll learn
- Creating interactive visualizations with Power BI and Tableau.
- Statistical foundations for data analysis.
- Geospatial Analytics
- Cards and Filters
- Data cleaning and transformation with Power Query.
- M Language
- Tableau
- Python fundamentals for data manipulation.
- SQL data analysis using MySQL.
- Excel essentials for data management.
Prerequisites
Curriculum
- 34 modules
Statistical Types
Population vs Sample
Measures of Central Tendency
Measures of Variability
Sample Variance and n-1
Standard Deviation
Variables
Random Variables
Percentiles and Quartiles
Five-Number Summary
Histograms
Gaussian Distribution
Standard Normal Distribution
Z-score Applications
Basics of Probability
Addition Rule in Probability
Multiplication Rule in Probability
Permutation
Combination
Log-Normal Distribution
Central Limit Theorem
Skewed Distributions and Mean-Median-Mode Relationship
Covariance
Pearson and Spearman Correlation
P-value Explanation
Confidence Intervals
Hypothesis Testing - Confidence Interval and Z-Test
Hypothesis Testing
Basic Charts in Power BI Desktop
Column Chart
Stacked Column Chart
Pie Chart
Donut Chart
Funnel Chart
Ribbon Chart
Include and Exclude
Exporting Data from Visual
Introduction to Tables and Matrix
Creating Tables in Power BI
Formatting Tables
Conditional Formatting in Tables
Aggregation Techniques in Tables
Introduction to Matrices
Conditional Formatting in Matrices
Working with Hierarchies in Matrices
Sub-Total and Total Calculations in Matrices
Number Formatting in Tables
Line Chart
Drill Down in Line Chart
Area Chart
Line vs. Column Chart
Scatter Plot
Waterfall Chart
Tree Map
Gauge Chart
Number Card
Text Card
Formatting of Text Cards
Date Card
Date Card (Relative Filtering)
Multi-Row Card
Filter on Visual
Page-Level Filtering
Filter on All Pages
Deep Dive Analysis in Power BI
Text Slicers
Formatting Text Slicers
Date Slicers
Formatting Date Slicers
Number Slicers
Animated Bar Chart Race
Drilldown Donut Chart
Drilldown Column Chart
Word Cloud
Sankey Chart
Infographic Visualization
Play Axis Chart
Scroller Chart
Sunburst Chart
Histogram Visualization
Inserting Images
Inserting Text
Inserting Shapes
Inserting Buttons
Web URL Actions
Page Navigation Actions
Bookmark Actions
Deep Dive through Actions
Creating a Superstore Report
Setting up Your Power BI Service Account
Publishing Reports to Power BI Service
Exporting Power BI Reports
Collaborating on Power BI Reports
Creating Interactive Dashboards in Power BI Service
Resolving Issues with Power BI Dashboards
Streamlining Data Refresh with Power BI Gateway
Manipulating Text Data in Power Query
Combining Columns in Power Query
Splitting and Trimming Text in Power Query
Changing Case in Power Query
Adding Prefix and Suffix in Power Query
Extracting Substrings in Power Query
Extracting Text with Delimiters
Extracting Year, Quarter, Month, and Day in Power Query
Calculating Date Differences in Power Query
Obtaining Month and Day Names in Power Query
Analyzing Day, Week of Month, and Year in Power Query
Extracting Date and Time Information in Power Query
Computing Age in Power Query
Determining Day of Year, Quarter, and Month in Power Query
Numeric Manipulation in Power Query
Essential Number Functions in Power Query
Calculating Percentages and Modules in Power Query
Rounding Numbers in Power Query
Identifying Even and Odd Numbers, and Determining Sign in Power Query
Merging CSV Files in Power Query
Combining Excel Sheets and Tables in Power Query
Consolidating Excel Sheets or Tables with Different Columns in Power BI
Appending Multiple Excel Files from a Folder in Power BI
Concatenating Different Data Sources in Power BI
Data Integration with Power Query
Combining Sheets or Tables in Power Query
Merging Data from Multiple Excel Files or Workbooks in Power BI
Blending Data from Different Sources in Power Query
Advanced Data Merging with Multiple Criteria in Power BI
Dynamic Column Creation in Power Query
Splitting Text Using Column Examples in Power BI
Merging Columns Using Column Examples in Power BI
Creating Date-based Columns Using Column Examples in Power BI
Generating Alphanumeric Columns Using Column Examples in Power BI
Conditional Column Creation in Power BI - Single Column
Conditional Column Creation in Power BI - Two Columns Comparison
Conditional Column Creation in Power BI - Comparing Two Columns
Conditional Column Creation in Power BI - Date-based Conditions
Key Concepts in Power Query (Power BI)
Filling Data Down in Power BI
Grouping and Aggregating Data in Power Query (Power BI)
Transposing Data in Power Query (Power BI)
Unpivoting Data in Power Query (Power BI)
Managing Data Types in Power Query (Power BI)
Handling Errors and Replacing Values in Power Query (Power BI)
Filtering Rows in Power Query (Power BI)
Manipulating Columns in Power Query (Power BI)
Exploring the M Language Basics
Leveraging IsIn Date Functions in M Language - Power BI
Performing Date Calculations with Add and Subtract Functions in M Language - Power BI
Essential Date Functions in M Language - Power BI
Fundamental Text Functions in M Language - Power BI
Unveiling the Power of Simple M Code in Power BI
Unlocking the Full Potential: Discovering All 900+ M Functions in Power BI
Installing and Setting Up Tableau
Tableau vs Excel: A Comparative Analysis
Navigating the Tableau Interface
Connecting to Data Sources in Tableau
Creating Visualizations in Tableau
Data Manipulation and Analysis in Tableau
Interactive Dashboards in Tableau
Sharing and Publishing Tableau Visualizations
Advanced Features and Techniques in Tableau
Column Chart Visualization
Horizontal Bar Chart
Stacked Column Chart
Stacked Bar Chart
Data Filtering: Keep Only, Exclude
Advanced Data Filtering: Keep Only, Exclude 2
Publishing to Tableau Public
Pie Chart, Multiple Pie Charts
Packed Bubble Chart
Word Cloud OR Word Map
Formatting payal
Filled Map
Symbol Maps
India Map
Histogram
Text Table with Multiple Measures
Measure Names and Measure Values
Line Chart
Line Chart with Multiple Measures
Discrete Vs. Continuous Line Chart
Discrete Vs. Continuous
Lollipop Chart
Line Vs. Column Chart
Dual Axis Chart
Column vs. Shapes
Bar in Bar Chart
Calculated fields
Conditional Column Chart
Column chart with Shapes based on condition
Conditional Maps
Map with Pie Chart
Map with WMS
Funnel Chart
Enhanced Funnel Chart
Calendar Visualization
Dumbbell Chart
Circular Chart
Multi-Level Donut Chart
Performance Gauge
Comparative Bullet Chart
Introduction to Table Calculations
Advanced Table Calculations - Compute Using
Table Calculations with Relative References
Ranking Chart - Bump Chart
Enhanced Bump Chart with Circle Markers
100% Stacked Column Distribution Chart
Scatter Plot
Scatter Plot with Images OR Shapes
Bubble Chart
Animation - Column Chart
Animation - Line Chart
Animation - Column vs. Line Chart
Heat Maps
Heat Map with Shapes
Heat Map with Conditional Formatting
Pareto Chart
Rounded Bar Chart
MySQL Fundamentals Exploring MySQL Essentials Setting Up MySQL on macOS Introduction to MySQL - Key Points to Remember
SQL Fundamentals
Data Analytics Overview
MySQL Installation and Setup
Troubleshooting and Future Planning
Table Creation Basics
Data Entry and Manipulation
Customer Question Analysis
Section 3 Overview
Key Concepts: Primary Key, Default, and NULL
Creating Tables with Primary Key and Default Values
Testing the Newly Created Table
Data Addition and Q&A
Updating Customer Information
Deleting Records from the Customers Table
Understand the new lco user DB
Task for CONCAT
Task for REPLACE
task for SUBSTRING
Task for reverse and CHAR_LENGTH
Task for case conversion and DOCS
Working with DISTINCT
Sorting with ORDER BY
Limiting Results with LIMIT
Pattern Matching Queries
Counting Data
SQL Modes and Grouping
Analyzing with MIN, MAX, and Subqueries
Grouping with MAX and MIN
Aggregating with SUM and AVERAGE
Complex Filtering with AND and OR
Selecting Data within a Range
Conditional Selection with CASE THEN
Database Fundamentals
Understanding Integer and String Data Types
Working with Date, DateTime, and JSON Data Types
Examples of Date and Time Manipulation
Retrieving Current Date and Time
Joining Tom and Jerry Tables
Exploring Different Types of SQL Joins
Explaining the Concept of FOREIGN KEY
Working with a New Database
Performing an INNER JOIN Task
Understanding ONE to MANY and MANY to MANY Relationships
Joining Multiple Tables (3 or more)
Completing a LEFT JOIN Task
Completing a RIGHT JOIN Task
Exploring FULL OUTER JOIN and UNION Operations
Database Engines: INNODB and Beyond
Understanding ACID in Databases
Introduction to Section 9
Exploring the Inner Workings of Practice Database: FILM
Introduction to Python: Installation and Setup
Python Fundamentals: Conditionals and Basics
Conditionals and Loops in Python
Mastering Loops in Python
String and List Manipulation in Python
Exploring Lists: Manipulation and Operations
Python Data Structures: Tuple, Set, and Dictionary
Advanced Python Functions: Techniques and Best Practices
Excel Launchpad
Exploring the Excel Startup Screen
Navigating the Excel User Interface
Personalizing the Excel Quick Access Toolbar
Deep Dive into Excel Interface Features
Unveiling the Excel Workbook Structure
Saving Your Excel Work
Opening Excel Documents
Handy Excel Shortcut Keys
Mastering Data Entry and Formulas
Crafting Informative Spreadsheet Titles
Manipulating Numeric Data in Excel
Inputting Dates with Precision in Excel
Harnessing the Power of Cell References
Building Essential Formulas in Excel
Demystifying Relative and Absolute Cell References
Navigating the Order of Operations in Excel
Understanding the Anatomy of an Excel Function
Mastering the SUM() Function in Excel
Unleashing the Power of MIN() and MAX() Functions
Calculating with Confidence using the AVERAGE() Function
Harnessing the Counting Abilities of the COUNT() Function
Tackling Adjacent Cells Error in Excel Calculations
Streamlining Calculations with the AutoSum Command
Speeding Up Calculations with Excel's AutoSum Shortcut Key
Effortless Formula Replication with the AutoFill Command
Efficient Data Movement and Copying in Excel
Managing Rows and Columns in Excel Worksheets
Resizing Cells for Optimal Presentation in Excel
Controlling Visibility: Hiding and Unhiding Rows and Columns in Excel
Customizing Worksheet Names in Excel
Removing Unwanted Worksheets in Excel
Seamlessly Moving and Copying Worksheets in Excel
Mastering Data Formatting in Excel
Harnessing the Power of Font Formatting in Excel
Enhancing Visual Appeal: Cell Background Color in Excel
Borders for Emphasis: Adding Borders to Excel Cells
Advanced Excel Cell Borders Techniques
Currency Formatting in Excel: Making Data Monetary
Percentage Formatting in Excel: Displaying Proportions
Excel's Format Painter: Copying Formatting with Ease
Creating Custom Styles for Data Formatting in Excel
Streamlining Data Presentation: Merging and Centering Cells in Excel
Visual Clarity: Conditional Formatting in Excel
Fine-Tuning Conditional Formatting in Excel
Instructors
Experienced Technostragist with three decades in IT, excelling in Sales, Product Management, and Marketing across IT hardware, networking, and software. Proven strategic planner, startup pioneer, and mentor for large teams. Marketing authority in areas such as Business Incubation, Branding, and Sales. Vast industry expertise spans ITES, IT Hardware, IT Training (Software), Distribution, and Retail. Recognized for interpersonal leadership, intuitive decision-making, and a collaborative approach. Complemented by four years as a Data Scientist, enhancing analytical and problem-solving skills with a deep passion for coding and a knack for simplifying complex concepts,
₹18000.00
- 34 Modules
- 100 Hours
- Data Analytics
Login to Purchase the Course