Data Analysis & Visualization: Python | Excel | BI | Tableau - Skillcept Online

Current Status

Not Enrolled

Price

Subscribe Now

Get Started

Take this Course

Data Analysis & Visualization: Python | Excel | BI | Tableau

Module Content

Expand All

Download All Resources 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Introduction and Download All Resources

Data Analysis with Python 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Kaggle Datasets

Exploring Pandas DataFrame

Analysing and manipulating pandas dataframe

What is data cleaning?

Basic data cleaning

Data Visualization

Visualizing qualitative data

Visualizing quantitative data

Data Analysis with Power BI 38 Topics

Expand

Lesson Content

0% Complete 0/38 Steps

What is Power BI

What is Power BI Desktop

Installing Power BI Desktop

Power BI Desktop tour

Power BI Overview: Part 1

Power BI Overview: Part 2

Power BI Overview: Part 3

Components of Power BI

Building blocks of Power BI

Exploring Power BI Desktop Interface

Exploring Power BI Service

Connecting to web data

Clean and transform data : Part 1

Clean and transform data : Part 2

Combining Data Sources

Creating Visualization : Part 1

Creating Visualization : Part 2

Publishing Reports to Power BI Service

Importing and transforming data from Access db file

1 of 2

Data Analysis with Excel 19 Topics

Expand

Lesson Content

0% Complete 0/19 Steps

Office 365 setup ( Optional)

Activating office 365 ( Optional)

Logging into office 365 (Optional)

What is Power Pivot

Office versions of power pivot

Enable Power Pivot in excel

What is Power Query

Connecting to a data source

Preparing query

Enhancing query

Creating a data model

Building data relationships

Create lookups with DAX

Analyse Data with Pivot Tables

Analyse data with Pivot Charts

Refresh Source Data

Create new reports

Connecting to Relational Databases with Power BI 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

What is SQL Server

SQL Server Editions

Download SQL Server

Install SQL Server

Connecting to SQL Server with SSMS

Attach sample database to SQL Server

Connecting to SQL Server with Power BI

What is PostgreSQL

Installing PostgreSQL

Connecting to PostgreSQL

Attach sample database to PostgreSQL

Connecting to PostgreSQL with Power BI – Part 1

Connecting to PostgreSQL with Power BI – Part 2

Data modelling with Power BI 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

What is data modelling

Creating and managing data relationships

Creating calculated columns

Optimizing models for reporting

Time intelligence

Applying filters on visuals

Data Analysis and Visualization with Tableau 19 Topics

Expand

Lesson Content

0% Complete 0/19 Steps

What is Tableau

Tableau Public Desktop

Tableau Public Desktop Overview – Part 1

Tableau Public Desktop Overview – Part 2

Tableau Data Sources

Tableau File Types

Tableau Help Menu

Connecting to a data source

Join related data sources

Join data sources with inconsistent fields

Exploring Tableau Interface

Re-order fields in visualization

Splitting text into multiple columns

Presenting data using stories

Add duplicate and rename worksheet

Re-order clear and delete worksheet