Data Analyst: Power BI - Power Pivot - PowerQuery - PivotChart - DAX

Описание

Course Resource: https://shorturl.at/qOSX7
VIDEO TIMESTAMPS ⏱? 1. Office 365 Setup
00:00:00 Introduction
00:02:01 The Data Analyst
00:03:07 Office 365 Trial
00:16:30 Activating Office 365 Apps
00:20:12 Logging into Office 365
00:25:55 What is Power Pivot
00:27:13 Office Versions of Power Pivot
00:28:56 How to enable Power Pivot in Excel

2. Preparing Data Using Power Query
00:30:30 What is Power Query
00:34:11 Connecting to a data source
00:38:47 Preparing your query
00:43:42 Cleansing your data
00:51:28 Enhancing your query

3. Consume and enhance data using Power Pivot
01:01:00 Creating your data model
01:07:25 Import more data and build relationships
01:14:41 Create lookups as new fields with DAX
01:21:49 Analyze data using Pivot Tables
01:30:36 Analyze data using Pivot Charts
01:39:04 Refreshing Source Data
01:46:45 Updating Queries
01:56:14 Creating new reports

4. Power BI Setup
02:03:40 What is Power BI
02:09:43 What is Power BI Desktop
02:13:32 Installing Power BI Desktop
02:21:16 Exploring Power BI Desktop


5. Overview of Power BI
02:27:33 Power BI Overview Part 1
02:32:07 Power BI Overview Part 2
02:36:16 Power BI Overview Part 3
02:41:13 Components of Power BI
02:44:33 Building Blocks of Power BI
02:54:09 Power BI Desktop Interface
03:00:21 Exploring Power BI Service
03:04:54 Power BI Apps

6. Connecting to Web Data with Power BI
03:08:57 Connecting to web data source
03:14:14 Clean and transform data Part 1
03:21:55 Clean and transform data Part 2
03:31:52 Combining Data Sources

7. Data Visualization with Power BI
03:40:02 Creating Visuals in Power BI Part 1
03:46:21 Creating Visuals in Power BI Part 2
03:51:55 Publishing Report to Power BI Service

8. Connecting to Databases with Power BI
03:56:45 What is SQL Server
03:59:47 Minimum Installation Requirements
04:04:16 Download SQL Server
04:08:59 Install SQL Server
04:18:51 Install SSMS
04:24:45 Connecting to SQL Server
04:32:40 Download Sample Database
04:39:24 Connecting SQL Server to Power BI
04:46:50 What is PostgreSQL
04:48:39 Installing PostgreSQL
04:59:36 Connecting to PostgreSQL Server
05:09:27 Download Sample Database
05:21:25 Connect PostgreSQL To Power BI Part 1
05:24:58 Connect PostgreSQL To Power BI Part 2
05:30:09 Import and Transform Data From Access Database File

9. Data Transformation Using Power BI
05:43:18 Changing The Locale
05:45:16 Connecting to Access Database File
05:52:29 Power Query Editor and Queries
05:59:27 Creating and Managing Query Groups
06:04:06 Renaming Queries
06:09:05 Splitting Columns
06:16:34 Changing Data Types
06:22:29 Removing and Reordering Columns
06:29:27 Duplicating and Adding Columns
06:33:05 Creating Conditional Columns
06:39:28 Connecting to files in a folder
06:46:55 Appending Queries
06:54:04 Merging Queries
06:59:53 Query Dependency View
07:04:33 Transforming Less Structured Data Part 1
07:13:54 Transforming Less Structured Data Part 2
07:23:54 Creating Tables
07:27:49 Query Parameters

10. Data Modelling with Power BI
07:37:21 What is Data Modelling
07:38:07 Creating and managing data relationships
07:50:09 Creating Calculated Columns
08:01:08 Optimizing Models for reporting
08:12:34 Time Intelligence
08:17:03 Applying Filters on Visuals

----------------------------------------
Description
As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media.

For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products from, your spending habits, and much more.

With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business. Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.