Data Analysis and Business Intelligence with Python & SQL

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!

Menu