- 44
- 86 952
FlowThruAnalytics
United States
Приєднався 26 бер 2021
Real World scenarios from a 15-year data analytics professional.
Live Data Analysis - Pivot Tables, Pivot Charts - Excel Tutorial
Want more practice on real BI/Data Analyst Projects?
www.flowthruanalytics.com/
============================================================
Going at it live. Microsoft Excel pivot tables, pivot chart, correlation matrix.
I thought this file was from the Google Data Analytics Certificate coursework - I could be wrong! That's what the download at Kaggle said.
=============================================================
0:00 The Lead Up
8:41 The Problem
14:46 The Answer
=============================================================
relevant topics: microsoft excel, correlation, pivot tables, pivot charts, data analytics, data analyst, business intelligence
www.flowthruanalytics.com/
============================================================
Going at it live. Microsoft Excel pivot tables, pivot chart, correlation matrix.
I thought this file was from the Google Data Analytics Certificate coursework - I could be wrong! That's what the download at Kaggle said.
=============================================================
0:00 The Lead Up
8:41 The Problem
14:46 The Answer
=============================================================
relevant topics: microsoft excel, correlation, pivot tables, pivot charts, data analytics, data analyst, business intelligence
Переглядів: 167
Відео
What is Power Query and Power Pivot in Excel? - Simply Explained - Tutorial with Example
Переглядів 125Рік тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Project files: www.flowthruanalytics.com/simply-explained-power-query-pivot What is Power Query? What is Power Pivot? How does it relate to classic Microsoft Excel? I give an explanation as well as example. 0:00 Problem Statement 0:37 Explanation of PQ/PP 1:53 Project Example relevant topics: microsoft excel, power ...
The Excel Functions I Use Every Day as an Analyst - XLOOKUP, SUMIFS - Learn Excel - Tutorial
Переглядів 152Рік тому
Completed file: www.flowthruanalytics.com/analyst-excel-functions Microsoft Excel has hundreds of functions. Here I review the key ones I use all day every day. 0:05 XLOOKUP 0:50 SUMIFS 1:57 COUNTIFS 2:58 Text to Column 3:39 CONCATENATE 4:26 RIGHT LEFT 5:01 SORT 5:41 IF THENS relevant topics: microsoft excel, xlookup, sumifs, countifs, text to columns, concatenate, right left, sort, if thens, d...
Data Analyst Portfolio Project #2 | Power BI to SQL Tutorial | HR Turnover Rate
Переглядів 497Рік тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Project files: www.flowthruanalytics.com/hr-turnover-9-18-22-raw-files In this project for Data Analysts and Business Intelligence Analysts, I create a view in SQL and then connect to that view in Microsoft Power BI. I then create a report in Power BI based on the data from SQL server. 0:00 Introduction 0:36 Data Re...
Data Analyst Portfolio Project | Power BI Tutorial | Hospital Staffing
Переглядів 492Рік тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Data files: www.flowthruanalytics.com/er-staffing-data In this project we will load files from Microsoft Excel into Power BI, and then compute various staffing ratios. Perfect for a data analyst portfolio project. 0:00 Intro 0:45 Data Review 1:14 Load the Data into PBI 2:47 Calendar Table 3:52 Create the Relationshi...
The Papa Bowl - A Professional Analyst Analyzes the Rationale
Переглядів 50Рік тому
Having been stunned just like the rest of you after learning about Papa John's new product, the Papa Bowl, I decided to dig deeper. I perform basic cost decomposition and financial modeling in Microsoft Excel using queries and formulas. relevant topics: data, excel, financial reports, data analytics, analyst, business intelligence, tutorial for beginners
Analyst Analyzes Best Buy's Decision to Close Early - Pivot Tables, Decision Matrix - Excel Tutorial
Переглядів 1222 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Completed file: www.flowthruanalytics.com/best-buy-completed-file In this video I use data analytics and pivot tables in Microsoft Excel to outline how I would analyze Best Buy's decision to close stores earlier in the evening. Highly fictionalized data - for illustrative purposes only. Yes, I should've computed yea...
Did Chicago Mafia Hits Increase in Summer Months? Data Cleansing Tutorial - Excel Pivot Tables
Переглядів 1772 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Link to data: reallifeexcel.gumroad.com/l/hwtvo Skip to 14:00 for answer. I found this Chicago 1970s mafia dataset in a reddit post. I use it as an example of how to cleanse data before analysis in Excel Pivot Tables. From there I chart some trends. 1) Who was the most prolific hit man? 2) Which years were most dead...
The Data Cleansing Skills I Use as a Professional Analyst | Tutorial | Microsoft Excel
Переглядів 4072 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Link to file: reallifeexcel.gumroad.com/l/inivn I cover the Microsoft Excel data cleansing skills I use as a data analyst. These incude: delimit, concatenate, delete blanks, find replace, remove duplicates, text case, right and left, lookups
If You Are An Aspriring Analyst, Learn These Big Picture Microsoft Excel Concepts
Переглядів 2392 роки тому
This quick video goes beyond individual Excel skills and discusses bigger picture concepts you will need to understand when approaching a problem.
The Perfect Use Case for Power Query in Excel - Tutorial - Combine Files for a Pivot Report
Переглядів 6332 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Files: reallifeexcel.gumroad.com/l/ykapp In this video for Microsoft Excel I review the perfect use case for Power Query and pivot tables. This is a great real world example for analysts.
Watch a Professional Analyst Use Pivot Tables on Corporate Sales Data - Excel Tutorial
Переглядів 1,6 тис.3 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Completed file: www.flowthruanalytics.com/sales-dataset-and-solutions In this video I analyze a corporate sales dataset. I use pivot tables and charting in Microsoft Excel to analyze trends and relationships between various sales metrics. Perfect for beginner to intermediate analysts looking for an excel tutorial. 0...
Watch a Professional Analyst Use Pivot Tables to Analyze HR (Human Resources) Data - Intermediate
Переглядів 2,6 тис.3 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Completed file: www.flowthruanalytics.com/hr-employee-attrition-file Note: at .26 seconds I incorrectly reverse the definition of the attrition column. In this intermediate tutorial for Microsoft Excel I analyze a Human Resources data set. I use pivot tables and charting to look at attrition rates as a function of a...
Watch a Professional Analyst Use Pivot Tables to Analyze Sales Data in Excel - Easy
Переглядів 2223 роки тому
In this easy tutorial for Microsoft Excel I analyze a sales data set. I use pivot tables and slicers to look at sales by region, profits, margins, and more. Enjoy!
How a Professional Analyst Uses Pivot Tables on Marketing Data in - Excel Tutorial - Easy
Переглядів 1,2 тис.3 роки тому
Want more practice on real BI/Data Analyst Projects? www.flowthruanalytics.com/ Completed file: www.flowthruanalytics.com/bank-marketing-file In this pivot table tutorial for Microsoft Excel, I analyze a marketing campaign for a bank. We are looking at factors surrounding whether or not a customer took an offer for a certificate of deposit. Enjoy! relevant topics: excel, data, pivot tables, piv...
How a Professional Analyst Uses Pivot Tables on Survey Data - Excel Tutorial - Medium
Переглядів 2,2 тис.3 роки тому
How a Professional Analyst Uses Pivot Tables on Survey Data - Excel Tutorial - Medium
When to Use a Line Chart vs a Bar Chart vs a Combo Chart in Excel - Charting Concepts
Переглядів 883 роки тому
When to Use a Line Chart vs a Bar Chart vs a Combo Chart in Excel - Charting Concepts
Watch a Professional Analyst Use Pivot Tables on Amazon Sales Data - Excel Tutorial - Medium
Переглядів 4,4 тис.3 роки тому
Watch a Professional Analyst Use Pivot Tables on Amazon Sales Data - Excel Tutorial - Medium
Generate a Random Value from a List in Excel
Переглядів 13 тис.3 роки тому
Generate a Random Value from a List in Excel
Excel Dashboard - Create This Interactive Dashboard in Excel with Pivot Tables and Pivot Charts
Переглядів 3273 роки тому
Excel Dashboard - Create This Interactive Dashboard in Excel with Pivot Tables and Pivot Charts
Excel for Beginners - Start Here - Tutorial from a Professional Analyst
Переглядів 403 роки тому
Excel for Beginners - Start Here - Tutorial from a Professional Analyst
I Use This Awesome Excel Heatmap Format ALL THE TIME as a Professional Analyst - How to Create It
Переглядів 1063 роки тому
I Use This Awesome Excel Heatmap Format ALL THE TIME as a Professional Analyst - How to Create It
Watch Me Analyze Patient Satisfaction Data - Pivot Tables, Charting, Analytics - Excel Tutorial
Переглядів 4 тис.3 роки тому
Watch Me Analyze Patient Satisfaction Data - Pivot Tables, Charting, Analytics - Excel Tutorial
IF Function in Excel Tutorial - Easy to Advanced
Переглядів 483 роки тому
IF Function in Excel Tutorial - Easy to Advanced
VLOOKUP vs INDEX MATCH (also XLOOKUP) in Excel - Differences and Which is Better From a Pro Analyst
Переглядів 533 роки тому
VLOOKUP vs INDEX MATCH (also XLOOKUP) in Excel - Differences and Which is Better From a Pro Analyst
Watch a Professional Analyst Use Pivot Tables to Analyze Student Test Score Data in Excel - Medium
Переглядів 6 тис.3 роки тому
Watch a Professional Analyst Use Pivot Tables to Analyze Student Test Score Data in Excel - Medium
INDEX MATCH With Multiple Criteria - Excel Tutorial
Переглядів 1,2 тис.3 роки тому
INDEX MATCH With Multiple Criteria - Excel Tutorial
VLOOKUP With Multiple Criteria - Excel Tutorial
Переглядів 373 роки тому
VLOOKUP With Multiple Criteria - Excel Tutorial
Watch Me Analyze Hospital Data in Excel - Pivot Tables, Conditional Formatting, Regression
Переглядів 18 тис.3 роки тому
Watch Me Analyze Hospital Data in Excel - Pivot Tables, Conditional Formatting, Regression
Excel Test for a Job Interview - SUM, AVERAGE, VLOOKUP, INDEX MATCH, Formatting, and More
Переглядів 2613 роки тому
Excel Test for a Job Interview - SUM, AVERAGE, VLOOKUP, INDEX MATCH, Formatting, and More