Data Analysis and Business Intelligence with Python SQL_1

Data Analysis and Business Intelligence with Python & SQL, available at $59.99, has an average rating of 3.13, with 26 lectures, based on 4 reviews, and has 1371 subscribers.

You will learn about Core SQL – the INTO statement for creating new tables and using the CASE statement to compute new columns based on conditions Intermediate SQL – using window functions such as ROW_NUMBER, RANK, PARTITION, and learning running totals to increase the functionality of datasets Perform Data Analysis with Microsoft SQL Intermediate SQL – understanding the importance of subquerying, views, and variables in SQL data analysis as well as the importance of stored procedures Core SQL – the SQL interface, navigation, importing data for analysis This course is ideal for individuals who are For those who are interested in Data Analytics and a gateway into Data Science or Beginner Business Intelligence Analyst or Students who are willing to put in a couple of hours to learn about analytics or For those who are new and curious about SQL & Power BI or Beginner Data Scientist It is particularly useful for For those who are interested in Data Analytics and a gateway into Data Science or Beginner Business Intelligence Analyst or Students who are willing to put in a couple of hours to learn about analytics or For those who are new and curious about SQL & Power BI or Beginner Data Scientist.

Enroll now: Data Analysis and Business Intelligence with Python & SQL

Summary

Title: Data Analysis and Business Intelligence with Python & SQL

Price: $59.99

Average Rating: 3.13

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Core SQL – the INTO statement for creating new tables and using the CASE statement to compute new columns based on conditions

Intermediate SQL – using window functions such as ROW_NUMBER, RANK, PARTITION, and learning running totals to increase the functionality of datasets

Perform Data Analysis with Microsoft SQL

Intermediate SQL – understanding the importance of subquerying, views, and variables in SQL data analysis as well as the importance of stored procedures

Core SQL – the SQL interface, navigation, importing data for analysis

Who Should Attend

For those who are interested in Data Analytics and a gateway into Data Science

Beginner Business Intelligence Analyst

Students who are willing to put in a couple of hours to learn about analytics

For those who are new and curious about SQL & Power BI

Beginner Data Scientist

Target Audiences

For those who are interested in Data Analytics and a gateway into Data Science

Beginner Business Intelligence Analyst

Students who are willing to put in a couple of hours to learn about analytics

For those who are new and curious about SQL & Power BI

Beginner Data Scientist

In business, being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid analysts. It’s becoming an essential part of many roles.

If that sounds daunting, don’t worry. There is a growing set of tools designed to make data analysis accessible to everyone, in this huge-value, four-course Data Analysts Toolbox bundle we look in detail at three of those tools: Excel, Python, and Power BI.

In isolation Excel, Python, and Power BI are useful and powerful. Learn all three and you are well on your way to gaining a much deeper understanding of how to perform complex data analysis.

This Data Analysts Toolbox bundle is aimed at intermediate Excel users who are new to Python and Power BI. All courses include practice exercises so you can put into practice exactly what you learn.

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records into a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

Power BI

What is Power BI and why you should be using it?

To import CSV and Excel files into Power BI Desktop.

How to use Merge Queries to fetch data from other queries.

How to create relationships between the different tables of the data model.

All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.

All about using the card visual to create summary information.

How to use other visuals such as clustered column charts, maps, and trend graphs.

How to use Slicers to filter your reports.

How to use themes to format your reports quickly and consistently.

How to edit the interactions between your visualizations and filter at visualization, page, and report level.

Course Curriculum

Chapter 1: Introduction to Data Analytics – BI and SQL Tools

Lecture 1: Course Content – Became a Data Analyst or Business Analyst

Lecture 2: How Not to Learn Data Analytics Tools

Chapter 2: Structured Query Language (SQL)

Lecture 1: Introduction to SQL – SQL Syntax and Download MySQL

Lecture 2: RDBMS – Data Integrity, Database Normalization

Lecture 3: Data Definition Language (DDL)

Lecture 4: Data Manipulation language (DML)

Lecture 5: Data Control Languages (DCL) and Domain Constraints

Lecture 6: Filtering Data and SET Operators in SQL

Lecture 7: Conditional Expressions in SQL

Lecture 8: Grouping Data

Lecture 9: Joining Multiple Tables (JOINS)

Lecture 10: SQL RANK Functions

Lecture 11: SQL Triggers and Stored Procedures

Chapter 3: Capstone Project : Data Analytics on Movie Reviews in SQL

Lecture 1: Capstone Project : Data Analytics on Movie Reviews in SQL

Chapter 4: PYTHON – Introduction to Basics of Python for Beginners

Lecture 1: Python – Data Structures (Lists, Tuple, Dictionary) and String Manipulations

Lecture 2: Python – Implementation Of Lambda, Recursion, Functions.

Lecture 3: Python – Understand Of Libraries,Exploratory Data Analysis,Descriptive Analysis

Chapter 5: Microsoft Power BI (Business Intelligence Tool)

Lecture 1: Installation Power BI Desktop and Applications of Power BI

Lecture 2: Understand the Concepts of Maps using Power BI

Lecture 3: Power BI – Tables and Matrix

Lecture 4: Different Types of Power BI Slicers

Lecture 5: Introduction to Power Query

Lecture 6: Hands on with Power Query Operations

Lecture 7: Manipulations with Power Query Operations

Lecture 8: Build a Super Store Sales Data Analysis Dashboard

Chapter 6: Capstone Project – Sales and Production Analysis

Lecture 1: Capstone Project – Sales and Production Analysis

Instructors

Akhil Vydyula
Data Scientist | Data & Analytics Specialist | Entrepreneur

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 1 votes

4 stars: 0 votes

5 stars: 1 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!