Data Science Hands On (PowerBI, SQL, Tableau, Spark, Python)

Name: Data Science Hands On (PowerBI, SQL, Tableau, Spark, Python)
Rating: 4.5 (132 reviews)

Delve Into Hands-On Data Science: Build 5 Unique Projects Using Python, SQL, Spark, PowerBI, & Tableau.

Created byBen Sullins, Lahcen Bouya

Last updated 5/2023

English

English [Auto],

What you'll learn

Master PowerBI & Tableau to build interactive dashboards that effectively communicate data-driven insights.
Develop a solid understanding of SQL, the bedrock of data manipulation and querying, enabling you to analyze complex datasets with ease.
Dive into Apache Spark's distributed computing system to process and analyze large-scale data, and construct efficient data pipelines.
Get hands-on with Python, learning to load, clean, analyze, & visualize data using Jupyter Notebooks, a tool cherished by data science professionals worldwide.
Apply your skills to real-world projects, reinforcing your understanding and preparing you to tackle data science challenges in your career or future studies.

Course content

8 sections • 30 lectures • 8h 0m total length

Introduction1:48
Data Science Hands On is a comprehensive online course designed to equip you with practical skills in the field of data science. This course is ideal for aspiring data scientists, analysts, and professionals who want to enhance their analytical capabilities and gain a competitive edge in today's data-driven world.
Throughout this course, you will delve into the essential tools and technologies used in the data science ecosystem, including PowerBI, Tableau, SQL, Python, and Spark. By combining theory with hands-on exercises and real-world examples, you will develop a solid foundation in these core areas, enabling you to tackle complex data problems and extract valuable insights.
Here's a breakdown of the key topics covered in the Data Science Hands On course:
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.
By the end of the Data Science Hands On course, you will have acquired a practical skill set in PowerBI, Tableau, SQL, Python, and Spark. You will be equipped with the tools and techniques necessary to extract actionable insights from complex datasets, create compelling visualizations, and build robust data-driven solutions.
Join us on this exciting journey to become a proficient data scientist and unlock a world of opportunities in the field of data science. Enroll in Data Science Hands On today and empower yourself with the skills that are in high demand in the industry.
Using This Course1:20
Learn how to navigate the Udemy course interface, access notes, announcements, and downloads, use the CSV for SQL practice, track progress, and earn a certificate.

Introduction and PowerBI Overview0:55
Explore self-service analytics with Microsoft Power BI, collect and cleanse data, build a data model, analyze insights, and craft a sales-focused dashboard using your own data.
PowerBI Setup1:51
Download, install, and launch Power BI on Windows 10 or higher with a Microsoft account. Mac users are not supported; log in from initial screen to begin connecting to data.
Connecting to Your Data2:08
Connect to data in Power BI by importing an Excel dataset, exploring the navigator, selecting orders, people, and returns, loading, and beginning data transformations.
Transforming Data2:48
Creating a Data Model2:59
Building Reports7:36
Build a basic report by selecting orders, using a card visualization, and dragging fields to show total orders, sales, and profit for 2019. Add a slicer for year.
Advanced Filtering of Reports2:15
Building a Dashboard4:19
Build a connected dashboard with a top subcategories stacked bar chart filtered to the top ten by sales and a line chart of orders by month, plus a table.
Formatting Your Dashboard6:02

Spark Setup on Databricks3:04
Set up the Databricks community edition to run Spark by creating a Python notebook that can run SQL, Scala, and R, then attach a cluster and execute a print command.
Working with Data in Spark5:03
Import a CSV file into the file store, create a table with Spark read format and inferred schema, then create a temp view with SQL and save as parquet.
Aggregating data in Spark5:15
Upload data from a CSV, infer a schema, and query a Spark table using SQL and PySpark to demonstrate distinct regions and in-memory aggregation.
Visualizing Data in Spark4:54

Python Setup in Jupyter Notebooks1:55
Working in Pandas5:52
Learn to load data with pandas read_csv, create a dataframe, extract year from dates, and perform grouped aggregations with describe and sum to reveal insights.
Presenting Analysis in Notebooks10:44
present data in notebooks using markdown and pandas, and create interactive plots with plotly express. visualize time series with line charts, bar charts, and trellis charts to compare yearly trends.

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!

Who this course is for:

Beginners Interested in Data Science
Business Analysts and Managers
Professionals Looking to Upskill
Academics and Researchers
Data Enthusiasts
Entrepreneurs & Business Owners
Students in STEM Fields
Those who are considering a career change into data science
Individuals from non-technical fields who deal with data regularly and want to learn how to analyze and interpret it more effectively.

Data Science Hands On (PowerBI, SQL, Tableau, Spark, Python)

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

PowerBI Fundamentals9 lectures • 31min

Sales Dashboard in Tableau4 lectures • 1hr 1min

Analyzing Employee Data with SQL3 lectures • 35min

Services Analysis with Spark4 lectures • 18min

Sales Analysis in Python3 lectures • 19min

Insights from Data Leaders4 lectures • 5hr 14min

Outro1 lecture • 1min

Requirements

Description

Who this course is for: