Data Science Hands On (Powerbi, Sql, Tableau, Spark, Python)

Learn tangible skills and deliver more value in your role

What you'll learn

Build a Dashboard in PowerBI

Build a Dashboard in Tableau

Analyze Complex Data with SQL

Analyze Services Data with Spark

Load, Analyze, and Visualize data in Python using Jupyter Notebooks

Requirements

Basic understanding of data structures

Familiarity with programming languages

Knowledge of Data Visualizations

Description

Unlock your potential with the power of data. Welcome to Data Science Hands On, your one-stop-shop to master the world of Data Science. Dive deep into the core concepts and tools that will empower you to interpret, analyze, and leverage data in a meaningful way.Our expert-led, comprehensive online course caters to both beginners and experienced professionals, covering the most sought-after skills in the data industry - SQL, Spark, Tableau, PowerBI, and Python.PowerBI: Learn how to create interactive and visually appealing dashboards using PowerBI. You will explore data visualization techniques, build compelling reports, and leverage advanced features to effectively communicate data-driven insights.Tableau: Dive into the world of Tableau and master the art of data visualization. Discover how to transform raw data into compelling visual representations, build interactive dashboards, and utilize Tableau's extensive set of tools to analyze and present data in an intuitive manner.SQL: Develop a strong foundation in SQL (Structured Query Language), the standard language for managing and querying relational databases. Learn how to retrieve, manipulate, and analyze data efficiently using SQL commands, and gain valuable skills for data extraction and data manipulation tasks.Python: Explore the versatile programming language, Python, which is widely used in data science. From data manipulation and cleaning to statistical analysis and machine learning, you will learn how to leverage Python's extensive libraries and frameworks to work with data effectively.Spark: Discover Apache Spark, a powerful open-source distributed computing system designed for big data processing. You will understand the fundamental concepts of Spark, explore its ecosystem, and learn how to leverage its capabilities to process large-scale data, perform advanced analytics, and build scalable data pipelines.This course goes beyond the theoretical, focusing on practical, hands-on exercises and real-world applications of these tools. By the end of this course, you will have a comprehensive understanding of the entire data science process, and you'll be ready to apply your new skills to start solving real-world problems.Whether you're looking to advance your career, kickstart a new one, or simply eager to unravel the mysteries hidden within data, Data Science Hands On will guide you every step of the way. We provide lifetime access to all course materials, regular updates as technologies evolve, and a supportive online community to foster your learning journey.Join the "Data Science Hands On" online course today, and start your journey towards becoming a Data Science expert. The world of data is at your fingertips!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Using This Course

Section 2: PowerBI Fundamentals

Lecture 3 Introduction and PowerBI Overview

Lecture 4 PowerBI Setup

Lecture 5 Connecting to Your Data

Lecture 6 Transforming Data

Lecture 7 Creating a Data Model

Lecture 8 Building Reports

Lecture 9 Advanced Filtering of Reports

Lecture 10 Building a Dashboard

Lecture 11 Formatting Your Dashboard

Section 3: Sales Dashboard in Tableau

Lecture 12 Tableau Setup

Lecture 13 Visual Exploration

Lecture 14 Building a Dashboard

Lecture 15 Sharing on Tableau Public

Section 4: Analyzing Employee Data with SQL

Lecture 16 Intro and Setup

Lecture 17 Employee Data Structure

Lecture 18 Analyzing Employee Data

Section 5: Services Analysis with Spark

Lecture 19 Spark Setup on Databricks

Lecture 20 Working with Data in Spark

Lecture 21 Aggregating data in Spark

Lecture 22 Visualizing Data in Spark

Section 6: Sales Analysis in Python

Lecture 23 Python Setup in Jupyter Notebooks

Lecture 24 Working in Pandas

Lecture 25 Presenting Analysis in Notebooks

Section 7: Outro

Lecture 26 Outro

Data Newbies and Pros looking to expand their skillset with tangible results