BIG DATA & BUSINESS INTELLIENCE

About Course

You will learn how to design data reporting dashboard for management team to derive insight and make business growth decision.

Discover the fundamentals of data science, the Python language, and its ecosystem.
Examine Python data science tools like Pandas and Numpy.
Learn how to retrieve, clean, and prepare data.
Learn how to access and prepare data by cleaning and organizing it.
Examine the possibility of using the suggested idea in practical data science applications.
Utilize efficient data visualization methods to assist you in handling intricate data structures.

Course Content

Environment Set-up
The Anaconda distribution as Python Data Science platform Overview on Python virtual environment set-up. Running Python code in Jupyter notebook

The Anaconda distribution as Python Data Science platform.

00:00
Overview on Python virtual environment set-up.

00:00
Running Python code in Jupyter notebook

00:00

Python core concepts

The Anaconda distribution as Python Data Science platform.

00:00
Built-in data types in Python.Working with strings, numbers, lists, tuples and dictionaries.

00:00
Control flow statements.

00:00
Conditional execution with if statements.

00:00
Conditional loops with where statements.

00:00
Looping over a sequence with for statements.

00:00
Defining and using custom functions.

00:00
Defining and using custom functions.

00:00
Defining and using custom functions.

00:00
Defining and using custom functions.

00:00
Working with dates and times.

00:00
Accessing data on file (CSV, JSON)

00:00

Missing data in pandas

NumPy

Data Visualisation in pandas

Data Visualisation with matplotlib and plotly

Data Analysis in pandas

Retrieving data in pandas

Working with text data in DataFrames

Power BI Training Courses Introduction

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Environment Set-up The Anaconda distribution as Python Data Science platform Overview on Python virtual environment set-up. Running Python code in Jupyter notebook

The Anaconda distribution as Python Data Science platform.

Overview on Python virtual environment set-up.

Running Python code in Jupyter notebook

Python core concepts

The Anaconda distribution as Python Data Science platform.

Built-in data types in Python.Working with strings, numbers, lists, tuples and dictionaries.

Control flow statements.

Conditional execution with if statements.

Conditional loops with where statements.

Looping over a sequence with for statements.

Defining and using custom functions.

Defining and using custom functions.

Defining and using custom functions.

Defining and using custom functions.

Working with dates and times.

Accessing data on file (CSV, JSON)

Missing data in pandas

Identifying missing data points

Filtering out missing data

Filling missing data with given values, interpolation and other filling strategies.

NumPy

Working with muti-dimensional arrays with NumPy

Arithmetic operation with NumPy arrays

Vectorised operations with NumPY arrays

Stats and linear algebra with NumPy

Slicing and indexing NumPy arrays

Data Visualisation in pandas

Plotting Data from a series or DataFrame Object

Bar plots, Line plots, Scatter plots, Histograms and other common charts

Basic Customisation of charts

Data Visualisation with matplotlib and plotly

Overview on the basic types of charts available with the Python libraries

Bar plots, line plots, histograms, scatter plots, pie charts

Customising the layout and format of a chart

Examples of static visualisation with matplotlib

Examples of interactive visualisation with plotly

Data Analysis in pandas

Extracting summary statistics over DataFrame objects

Performing data aggregation queries (groupby)( method)

Aggregating multiple columns in the same query

Exploratory analysis of new datasets

Retrieving data in pandas

Querying data to extract specific rows and columns

Filtering data on specific conditions

Understanding pandas indexing

Working with text data in DataFrames

Using the str attribute in pandas objects

String manipulation functions in pandas

Filtering data with string pattern matching

Power BI Training Courses Introduction

Power BI – What is it and why use it?

Power BI Desktop vs Services – What is best for your use case?

Power BI vs other BI tools (Gartner Magic Quadrant)

Power BI User Interface Training

Customising Visuals vs Theme vs Data Model

Power BI Course contents review

Student Ratings & Reviews

Environment Set-up
The Anaconda distribution as Python Data Science platform Overview on Python virtual environment set-up. Running Python code in Jupyter notebook