Published 12/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 5.52 GB | Duration: 10h 24m

Practical Data Analytics & Business Intelligence with: SQL Matplotlib Python Excel Power BI Pandas

What you'll 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

Requirements

Computer and internet access required

Basic knowledge of excel advised but not mandatory

No need to even have SQL Server ed in advance, as we'll show you how to get it installed for free!

None - we will walk you through from an absolute bner level! No prior knowledge of SQL or PowerBI required

Description

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 databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsPower BIWhat 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.

Overview

Section 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

Section 2: Structured Query Language (SQL)

Lecture 3 Introduction to SQL - SQL Syntax and MySQL

Lecture 4 RDBMS - Data Integrity, Database Normalization

Lecture 5 Data Definition Language (DDL)

Lecture 6 Data Manipulation language (DML)

Lecture 7 Data Control Languages (DCL) and Domain Constraints

Lecture 8 Filtering Data and SET Operators in SQL

Lecture 9 Conditional Expressions in SQL

Lecture 10 Grouping Data

Lecture 11 Joining Multiple Tables (JOINS)

Lecture 12 SQL RANK Functions

Lecture 13 SQL Triggers and Stored Procedures

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

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

Section 4: PYTHON - Introduction to Basics of Python for Bners

Lecture 15 Python - Data Structures (Lists, Tuple, Dictionary) and String Manipulations

Lecture 16 Python - Implementation Of Lambda, Recursion, Functions.

Lecture 17 Python - Understand Of Libraries,Exploratory Data Analysis,Descriptive Analysis

Section 5: Microsoft Power BI (Business Intelligence Tool)

Lecture 18 Installation Power BI Desktop and Applications of Power BI

Lecture 19 Understand the Concepts of Maps using Power BI

Lecture 20 Power BI - Tables and Matrix

Lecture 21 Different Types of Power BI Slicers

Lecture 22 Introduction to Power Query

Lecture 23 Hands on with Power Query Operations

Lecture 24 Manipulations with Power Query Operations

Lecture 25 Build a Super Store Sales Data Analysis Dashboard

Section 6: Capstone Project - Sales and Production Analysis

Lecture 26 Capstone Project - Sales and Production Analysis

For those who are interested in Data Analytics and a gateway into Data Science,Bner 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,Bner Data Scientist

HomePage:

gfxtra__Data_Analy.part1.rar.html

gfxtra__Data_Analy.part2.rar.html

gfxtra__Data_Analy.part3.rar.html

gfxtra__Data_Analy.part4.rar.html

gfxtra__Data_Analy.part5.rar.html

gfxtra__Data_Analy.part6.rar.html