Why learn Data Analytics?

The abundance of data has transformed businesses. With a boom in the use of analytics, having the skills required to work with data isn't just valuable - it's the necessity of the time . Data Analytics have a tremendous impact on business action plans. The demand for Data Analytics specialists is on the rise while the supply remains very low. Thats why Data Analytics professionals get jobs very quickly.

This course includes

  • More than 27 hours on-demand videos

  • 45 plus downloadable resources

  • Unlimited access for 12 months

  • Certificate of completion

What you 'll learn

  • Connect to any data source automate ETL process.

  • How to use Data Analysis Expressions to analyze complex data.

  • Create business insights and bespoke reports.

  • Database concepts and create small to medium size databases.

  • Talk to database with SQL and perform data mining

  • Create a business solution and automate business process with Visual Basic for Applications

  • Who should attend

    Anybody who want to learn Data Analytics and Business Intelligence.

  • Prerequisites

    Basic knowledge of Microsoft Excel.

  • Required Software

    Microsoft Excel 2016 or later. Microsoft Office 365 is preferred. Microsoft Access 2016 or later. Microsoft Power BI Desktop Python - Latest Version

Course curriculum

  • 1

    Data Analytics in Business

    • What is Data Analytics

    • Data Analytics Process

    • Module-1
  • 2

    Modern Challenges and Power Query

    • Modern Challenges for Everyone

    • What is Power Query?
  • 3

    Extract, Transform and Load

    • How to import delimited files

    • Import a named range from Excel file

    • Append Operations

    • Importing files from a folder

    • Aggregate data from Current Workbook

    • Aggregate data from other workbooks

    • Unpivoting data

    • Importing a non-delimited Text File

    • Merging Tables and Queries

    • Importing data from Web

    • Transpose and Unpivot complex data

    • Grouping and Summarizing Data

    • Transposing Stacked Data

    • Conditional Logic in Power Query

    • Practice Problem

    • Module-2
  • 4

    Data Modelling and Evaluation

    • Types of Data Analytics

    • What is Power Pivot?

    • Loading data to PowerPivot data model.
  • 5

    Calculated columns vs DAX Measures

    • How to add Calculated Columns in PowerPivot?

    • What is DAX - Data Analysis Expressions.

    • How to add DAX Measures?
  • 6

    Time Intelligence in Power Pivot

    • Standard vs. Custom Calendar

    • Table Relationships

    • Increase drilldown limit of Power Pivot

    • Practice DAX Measures

    • Calculate() - Your new friend

    • How to use Disconnected Tables.

    • Time Intelligence functions

    • More Time Intelligence functions
  • 7

    Conditional Measures

    • SWITCH(), IF() and BLANK() functions
  • 8

    Iterator Functions

    • SUMX(), MAXX(), RANKX() and TOPN() functions
  • 9

    Multiple Data Tables

    • Multiple data tables - Data Granularity and Data Relationships

    • Module-3
  • 10

    Data Visualization

    • What is Power BI?
  • 11

    Installation of Power BI

    • Power BI Installation
  • 12

    Power BI Desktop

    • Import and Transform Data

    • Import Data from CSV files

    • Import Data from Excel files

    • Import Data from a Database File

    • Data Relationships

    • Creating your First Report

    • Time Intelligence in Power BI.

    • Optimizing Data Models for Reporting

    • How to create and maintain hierarchies

    • How to create a data table on the fly

    • Line and Bar Chart

    • Analytics Pane

    • Visual, Page and Report Level Filters

    • Export data and spotlight a visual

    • Table Styles and Conditional Formatting

    • Card, Guage visuals and Dynamic Dashboards

    • Page View and Page Size

    • Visual Relationships

    • Bookmark and Slide Show
  • 13

    Power BI Services

    • Power BI Services

    • How to create a dashboard in Power BI Services

    • Quick Insights

    • Add Tiles in a dashboard

    • Phone View

    • Power BI Q & A

    • Featured Questions

    • Export Data
  • 14

    Power BI Mobile

    • Power BI Mobile

    • Module-4
  • 15

    Database Management

    • What is Microsoft Access?

    • How to create a database in Microsoft Access.
  • 16

    Tables

    • MS Access Tables

    • How to create a table?

    • Table Properties

    • Primary key in Access table

    • Data Entry in Access Table

    • Import Data into MS Access Table
  • 17

    Queries

    • What is MS Access Query?

    • How to create a query?

    • Query design

    • How to add criteria in a query.

    • Date criteria in a query

    • IN operator in a query

    • Calculated fields in a query

    • Manipulating fields

    • Grouping data in a query

    • IIF and SWITCH function

    • Creating a parameter query

    • Relationships

    • Multi Tables Query
  • 18

    Forms

    • What is an Access form?

    • Creating a basic form.

    • Form Design -Creating a form from scratch

    • Adding controls to a form

    • Combo Box and use of Wild card

    • How to add a subform

    • How to clear controls on a form

    • Display image in a form and Dlookup function
  • 19

    Reports

    • Access Reports

    • How to create report instantly

    • How to create a report from scratch

    • How to add sub totals in Access Report

    • How to add a calculated field in MS Access Report

    • Print your report

    • Conditional Formatting in MS Access Report
  • 20

    Macros

    • Macros in MS Access

    • Automate report sharing

    • Pack your application

    • Module-5
  • 21

    Lets talk to database

    • What is Structured Query Language

    • Why should you learn SQL?

    • The SELECT statement

    • Syntax of SELECT statement.

    • Eliminating DUPLICATE rows

    • Sorting information

    • Review and Practice

    • What is an Expression in SQL?

    • Specifying Explicit values

    • Types of SQL Expressions

    • Naming the Expression

    • Examples

    • Review and Practice

    • Filtering your data

    • Review and Practice

    • Data Sets

    • Inner Joins

    • Review and Practice

    • Outer Joins

    • Unions

    • Subqueries

    • Aggregate functions

    • Grouping Data

    • Top Values

    • Connecting to another database

    • Alias names to tables

    • Modifying Data - UPDATE statement

    • Modifying Data - INSERT statement

    • Modifying Data - DELETE statement

    • Creating Table using SQL

    • Module - 6
  • 22

    Automate the process

    • Visual Basic for Applications - VBA

    • MS Access Objects, methods and Properties

    • VBA Branching Constructs

    • Variables, Data Types and Remarks

    • Option Group and Option Buttons

    • SELECT CASE statement

    • Creating a function in VBA

    • Sequence of statements to execute

    • Microsoft Access Event Model

    • How to scroll data in a form

    • Dialog Boxes

    • Import Data from Excel Files

    • Import all sheets from Excel Workbook

    • Import all Excel files from a folder

    • Action Queries

    • Append Query - A small project

    • Update Query - A small project

    • Delete Query - A small project

    • Google Maps - A small project

    • Pack up your application

    • Module-7
  • 23

    Analyzing data with Python

    • Python - The Basics

    • Python Installation

    • Welcome to Jupyter Notebook

    • Your first program in Python

    • Variables

    • Strings

    • Numbers

    • Numbers and the str() function

    • Comments

    • Lists in Python

    • Editing Lists in Python

    • Organizing lists in Python

    • Looping through an entire list

    • Creating numerial lists

    • Tuples

    • IF statement

    • Working with Sets

    • Dictionary

    • User input and While loop

    • Functions

    • Working with External Files

    • Data Visualization

    • Pandas

    • Python in Power BI

    • Module-8
  • 24

    Cybersecurity

    • Understanding Cybersecurity

    • Malware and its types

    • Threat protection policies
  • 25

    Projects

    • Rent a Car

Buy now

One year subscription