Data Engineer/Data Scientist – Power BI/ Python/ ETL/SSIS
Data Engineer/Data Scientist – Power BI/ Python/ ETL/SSIS, available at $54.99, has an average rating of 4.35, with 125 lectures, based on 332 reviews, and has 33733 subscribers.
You will learn about Connecting to various data sources Extracting Data Cleaning Data Transforming Data Loading Data Data Visualization Exploring Pandas DataFrame Creating SSIS Package Debugging SSIS Package Creating and publishing reports Data Modeling This course is ideal for individuals who are Beginners to Data Science or Beginners to Data Engineering or Beginner Data Analyst or Beginner Data Engineer It is particularly useful for Beginners to Data Science or Beginners to Data Engineering or Beginner Data Analyst or Beginner Data Engineer.
Enroll now: Data Engineer/Data Scientist – Power BI/ Python/ ETL/SSIS
Summary
Title: Data Engineer/Data Scientist – Power BI/ Python/ ETL/SSIS
Price: $54.99
Average Rating: 4.35
Number of Lectures: 125
Number of Published Lectures: 124
Number of Curriculum Items: 125
Number of Published Curriculum Objects: 124
Original Price: $149.99
Quality Status: approved
Status: Live
What You Will Learn
- Connecting to various data sources
- Extracting Data
- Cleaning Data
- Transforming Data
- Loading Data
- Data Visualization
- Exploring Pandas DataFrame
- Creating SSIS Package
- Debugging SSIS Package
- Creating and publishing reports
- Data Modeling
Who Should Attend
- Beginners to Data Science
- Beginners to Data Engineering
- Beginner Data Analyst
- Beginner Data Engineer
Target Audiences
- Beginners to Data Science
- Beginners to Data Engineering
- Beginner Data Analyst
- Beginner Data Engineer
A common problem that organizations face is how to gathering data from multiple sources, in multiple formats, and move it to one or more data stores. The destination may not be the same type of data store as the source, and often the format is different, or the data needs to be shaped or cleaned before loading it into its final destination.
Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.
SQL Server Integration Services (SSIS) is a useful and powerful Business Intelligence Tool . It is best suited to work with SQL Server Database . It is added to SQL Server Database when you install SQL Server Data Tools (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.
SSIS can be used for:
-
Data Integration
-
Data Transformation
-
Providing solutions to complex Business problems
-
Updating data warehouses
-
Cleaning data
-
Mining data
-
Managing SQL Server objects and data
-
Extracting data from a variety of sources
-
Loading data into one or several destinations
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.
In this beginners course you will learn how to get started with this powerful toolset. We will cover topics like connecting to and transforming web based data sources. You will learn how to publish and share your reports and visuals on the Power BI service.
Data scienceis the study of data. It involves developing methods of recording, storing, and analyzing data to effectively extract useful information
Data is a fundamental part of our everyday work, whether it be in the form of valuable insights about our customers, or information to guide product,policy or systems development. Big business, social media, finance and the public sector all rely on data scientists to analyse their data and draw out business-boosting insights.
Pythonis a dynamic modern object -oriented programming language that is easy to learn and can be used to do a lot of things both big and small. Python is what is referred to as a high level language. That means it is a language that is closer to humans than computer.It is also known as a general purpose programming language due to it’s flexibility. Python is used a lot in data science.
This course is a beginners course that will introduce you to some basics of data science using Python.
What You Will Learn
-
How to set up environment to explore using Jupyter Notebook
-
How to import Python Libraries into your environment
-
How to work with Tabular data
-
How to explore a Pandas DataFrame
-
How to explore a Pandas Series
-
How to Manipulate a Pandas DataFrame
-
How to clean data
-
How to visualize data
Course Curriculum
Chapter 1: Power BI Setup
Lecture 1: Introduction
Lecture 2: What is Power BI
Lecture 3: What is Power BI Desktop
Lecture 4: Office 365 Setup
Lecture 5: Activating Office 365 Apps
Lecture 6: Logging into Office 365
Lecture 7: Installing Power BI Desktop
Lecture 8: Power BI Desktop Tour
Chapter 2: Overview of Power BI
Lecture 1: Power BI Overview- Part 1
Lecture 2: Power BI Overview- Part 2
Lecture 3: Power BI Overview- Part 3
Lecture 4: Components of Power BI
Lecture 5: Building Blocks of Power BI
Lecture 6: Exploring Power BI Desktop Interface
Lecture 7: Exploring Power BI Service
Lecture 8: Power BI Apps
Chapter 3: Power BI : Connect to Web Data | Transform Web Data
Lecture 1: Connecting to Web Based Data
Lecture 2: Clean and transform data: Part 1
Lecture 3: Clean and transform data: Part 2
Lecture 4: Combining Data Sources
Lecture 5: Creating visuals – Part 1
Lecture 6: Creating visuals – Part 2
Lecture 7: Publishing Report to Power BI Service
Chapter 4: Database Server Setups
Lecture 1: What is SQL Server
Lecture 2: Minimum SQL Server Installation Requirements
Lecture 3: SQL Server Editions
Lecture 4: SQL Server Download
Lecture 5: SQL Server Installation
Lecture 6: Install SSMS
Lecture 7: Connecting to SQL Server with SSMS
Lecture 8: Install Sample Database in SQL Server
Lecture 9: What is PostgreSQL
Lecture 10: PostgreSQL Minimum Installation Requirements
Lecture 11: Installing PostgreSQL
Lecture 12: Installing PostgreSQL on MacOS
Lecture 13: Installing PostgreSQL on Linux
Lecture 14: Connecting to PostgreSQL Server with pgAdmin4
Lecture 15: Installing PgAmin on MacOS
Lecture 16: Installing PgAmin on Linux
Lecture 17: Install Sample Database in PostgreSQL
Chapter 5: Power BI: Connecting to Databases Data Sources
Lecture 1: Connecting to SQL Sever with Power BI
Lecture 2: Connecting to PostgreSQL Server with Power BI
Lecture 3: Connecting to Access Database File
Chapter 6: Power BI: Transforming Data
Lecture 1: Changing Locale
Lecture 2: Connecting to Access Database File
Lecture 3: Power Query Editor and Queries
Lecture 4: Creating and Managing Query Groups
Lecture 5: Renaming Queries
Lecture 6: Splitting Columns
Lecture 7: Changing Data Types
Lecture 8: Removing and Reordering Columns
Lecture 9: Duplicating and Adding Columns
Lecture 10: Creating Conditional Columns
Lecture 11: Connecting to files in a folder
Lecture 12: Appending Queries
Lecture 13: Merge Queries
Lecture 14: Query Dependency View
Lecture 15: Transforming Less Structured Data: Part 1
Lecture 16: Transforming Less Structured Data: Part 2
Lecture 17: Creating Tables
Lecture 18: Query Parameters
Chapter 7: Power BI: Data Modelling
Lecture 1: What is Data Modelling
Lecture 2: Creating and managing data relationships
Lecture 3: Creating Calculated Columns
Lecture 4: Connecting to PostgreSQL Database Server – Part 2
Lecture 5: Optimizing Models for reporting
Lecture 6: Time Intelligence
Lecture 7: Applying Filters on Visuals
Chapter 8: Microsoft Visual Studio Setup
Lecture 1: What is Visual Studio
Lecture 2: Minimum installation requirements for visual studio
Lecture 3: Installing Visual Studio
Lecture 4: Visual studio workloads
Lecture 5: Installing SQL Server Data Tools- SSDT
Lecture 6: Installing SSDT Designer Templates
Chapter 9: Implementing ETL Using SSIS
Lecture 1: What is ETL
Lecture 2: ETL Process Illustration
Lecture 3: What is SSIS
Lecture 4: Creating SSIS Package in Visual Studio 2019
Lecture 5: Creating SSIS Package in Visual Studio 2015
Lecture 6: Exploring data source: Part 1
Lecture 7: Exploring data source: Part 2
Lecture 8: Control flow: Part 1
Lecture 9: Control flow: Part 2
Lecture 10: Data flow: part 1
Lecture 11: Data flow: part 2
Lecture 12: Debugging SSIS Package : Part 1
Lecture 13: Debugging SSIS Package : Part 2
Lecture 14: Handling SSIS Package Errors : part 1
Lecture 15: Handling SSIS Package Errors : part 2
Chapter 10: Data Science | Python Setup
Lecture 1: What is Jupyter Notebook
Instructors
-
Bluelime Learning Solutions
Making Learning Simple
Rating Distribution
- 1 stars: 10 votes
- 2 stars: 12 votes
- 3 stars: 39 votes
- 4 stars: 113 votes
- 5 stars: 158 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024