Data Analysis and Business Intelligence with Python & SQL
- Description
- Curriculum
- FAQ
- Reviews
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.
-
3Introduction to SQL - SQL Syntax and Download MySQLVideo lesson
-
4RDBMS - Data Integrity, Database NormalizationVideo lesson
-
5Data Definition Language (DDL)Video lesson
-
6Data Manipulation language (DML)Video lesson
-
7Data Control Languages (DCL) and Domain ConstraintsVideo lesson
-
8Filtering Data and SET Operators in SQLVideo lesson
-
9Conditional Expressions in SQLVideo lesson
-
10Grouping DataVideo lesson
-
11Joining Multiple Tables (JOINS)Video lesson
-
12SQL RANK FunctionsVideo lesson
-
13SQL Triggers and Stored ProceduresVideo lesson
-
18Installation Power BI Desktop and Applications of Power BIVideo lesson
-
19Understand the Concepts of Maps using Power BIVideo lesson
-
20Power BI - Tables and MatrixVideo lesson
-
21Different Types of Power BI SlicersVideo lesson
-
22Introduction to Power QueryVideo lesson
-
23Hands on with Power Query OperationsVideo lesson
-
24Manipulations with Power Query OperationsVideo lesson
-
25Build a Super Store Sales Data Analysis DashboardVideo lesson
External Links May Contain Affiliate Links read more