#7 Connecting Database & Power Query | Data Analyst: Python, Power BI, Tablue, SQL

Описание

? Download Files: https://bitly.ws/Ui4A
Data Analyst | Business Intelligence: Python,BI,Tableau,SQL
Learn Data Analytics and Business Intelligence Skill using : Python | Power BI | Power Query | Tableau | SQL
------
VIDEO TIMESTAMPS ⏱?
===
00:00:00 - 1. Connecting to Data Source
00:07:26 - 2. Power Query Editor and Queries
00:14:26 - 3. Creating and managing query groups
00:19:10 - 4. Renaming Queries
00:24:14 - 5. Splitting Columns
00:31:31 - 6. Changing Data Types
00:37:40 - 7. Removing and Reordering Columns
00:44:42 - 8. Duplicating and Adding Columns
00:48:22 - 9. Creating Conditional Columns
00:54:47 - 10. Connecting to files in a folder
01:02:14 - 11. Appending Queries
01:09:22 - 12. Merge Queries
01:15:25 - 13. Query Dependency View
01:19:59 - 14. Transform less structured data
01:29:19 - 15. Create Tables
01:33:14 - 16. Query Parameters

----
What you'll learn

Connect to multiple data sources
Clean and transform Data
Model Data
Transform less structured data
Create data relationships
Create queries with Power query
Merge queries with Power query
Create reports
Create visualizations
Create dashboards
----
Description

- Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. A data analyst gathers, cleans, and studies data sets to help solve problems. Here's how you can start on a path to become one.

- Data analytics is the process of examining data sets to extract information that may be hidden from the casual user and draw conclusions about the impact of that information. Data analytics can range from the simplest of business intelligence, to online analytical processing, all the way up to very advanced analytics.

- A data analyst collects, cleans, and interprets data sets in order to answer a question or solve a problem. They can work in many industries, including business, finance, criminal justice, science, medicine, and government.

- Data analysis is the process of gleaning insights from data to help inform better business decisions. The process of analysing data typically moves through five iterative phases:


Identify the data you want to analyse
Collect the data
Clean the data in preparation for analysis
Analyse the data
Interpret the results of the analysis
------
#dataanalytics #excel #powerbi #powerquery #python