Home
Search results “Types of data analysis reports”
Analytical Reports: Writing Analytical Reports
 
04:13
This video introduces students to Analytical Reports, which are a common form of communication in the technical workplace. These reports present research addressing a specific problem or research question. The typical arrangement of an Analytical Report contains the following sections: Introduction, Methods, Results and Discussion (the IMRaD pattern). In this video, these sections are discussed by highlighting examples from a student report.
Views: 28150 umnWritingStudies
Data Analysis & Discussion
 
14:51
This video is meant to be used as an introductory lesson to Mini Research Writing focusing on Data Analysis and Discussion. As this is a mini class project, some of the requirements have been made simple due to time constraints. Plus, the focus of this mini research paper is to get students familiarized to the ways of writing an academic paper and the items that needs to be included. suitable for beginners!
Views: 28463 NurLiyana Isa
HR Reporting & Analytics
 
21:31
HR analytic solutions enable you to gain insights into your workforce, providing an understanding of how your employees are creating value by looking at the cause and effect relationships between data sets. An effective HR reporting and analytic solution leads to better understanding and informed decision making. This webcast takes you through the journey from simple HR reporting to driving insights and analysis out of your employee data.
Views: 18997 ThorogoodBI
Power BI Dashboard & Reports - Sales Analysis
 
10:06
Power BI Reports - Our Sales Analysis Solution Demonstration contains various generic reporting examples which have been popular client choices. View the metrics as Vs Prior or Vs Target, select your time periods and use the various drill downs to answer specific business questions. Know which products, stores or customers or salespersons are doing most of your business, and which are not very profitable. Spot trends in time, locations or products and be empowered to make data driven decisions. (http://databear.com) Through our custom apps, connecting your data to your solution has never been easier. To interact with many more of our solutions, visit http://databear.com/solutions/
IELTS Writing Task 1 - How to Analyze Charts, Maps, and Process Diagrams
 
18:55
In this IELTS Writing Task 1 lesson, you'll learn how to accurately analyze charts, maps, and process diagrams. I explain how you can use a question checklist to practice your Task 1 analysis abilities. I also give an example of each kind of Task 1 data set. Here are the checklist questions from the video: Instructions: To improve your ability to analyze Task 1 data, use the questions below when you see a new graph, chart, map, or process diagram. After you’re comfortable with the checklists, gradually try to use them less and less until you can analyze the data more easily. Graph or Chart: What are the axes (x and y)? What are the units of measurement? (e.g. amount, %, age, etc.) Is there more than one group being compared? (e.g. 3 different countries) Does it show change over time? (this is common for graphs) What are the time periods shown? (past, present, future) What is the general trend? (increase, decrease, etc.) Are there any large differences between groups or charts? Are there any groups or charts that share similarities? How can I break it into two parts? Map: Is there more than one map being compared? What are the time periods shown? (past, present, future) Are they in different maps or the same map? What are the most noticeable differences between the multiple maps or time periods? What parts of the map are the same in both maps/time periods? Can the map(s) be easily broken into two parts? How? Process Diagrams: Where is the start of the process? The end? How many total stages are there? What kind of process is it? Is it a cycle or a linear (start to finish) process? What does each stage do? And what is its connection with the previous stage? What is the end result? Is something produced? Can the process be easily broken into two parts? How? Watch more IELTS Master Writing Task 1 videos: https://www.youtube.com/playlist?list=PLQKm5R-SeKdOeIIbDm3k4-Bwt0PZNDdas Find more IELTS practice content: http://www.ielts-master.com
Views: 202915 IELTS Master
Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)
 
02:22:43
Download File: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch00/Excel2013StatisticsChapter00.xlsx All Excel Files for All Video files: http://people.highline.edu/mgirvin/excelisfun.htm. Intro To Excel: Store Raw Data, Data Types, Data Analysis, Formulas, PivotTables, Charts, Keyboards, Number Formatting, Data Analysis & More: (00:08) Introduction to class (00:49) Cells, Worksheets, Workbooks, File Names (02:54) Navigating Worksheets & Workbook (03:58) Navigation Keys (04:15) Keyboard move Active Sheet (05:40) Ribbon Tabs (06:25) Add buttons to Quick Access Tool Bar (07:40) What Excel does: Store Raw Data, Make Calculations, Data Analysis & Charting (08:55) Introduction to Data Analysis (10:37) Data Types in Excel: Text, Numbers, Boolean, Errors, Empty Cells (11:16) Keyboard Enter puts content in cell and move selected cell down (13:00) Data Type DEFAULT Alignments (13:11) First Formula. Entering Cell References in formulas (13:35) Keyboard Ctrl + Enter puts content in cell & keep cell selected (14:45) Why we don’t override DEFAULT Alignments (15:05) Keyboard Ctrl + Z is Undo (17:05) Proper Data Sets & Raw Data (24:21) How To Enter Data & Data Labels (24:21) Stylistic Formatting (26:35) AVERAGE Function (27:31) Format Formulas Differently than Raw Data (28:30) Keyboard Ctrl + C is Copy. Keyboard Ctrl + V is Paste (29:59) Use Eraser remove Formatting Only (29:19) Keyboard Ctrl + B adds Bold (29:57) Excel’s Golden Rule (31:43) Keyboard F2 puts cell in Edit Mode (32:01) Violating Excel’s Golden Rule (34:12) Arrow Keys to put cell references in formulas (35:40) Full Discussion about Formulas & Formulas Elements (37:22) SUM function Keyboard is Alt + = (38:22) Aggregate functions (38:50) Why we use ranges in functions (40:56) COUNT & COUNTA functions (42:47) Edit Formula & change cell references (44:18) Absolute & Relative Cell References (45:52) Use Delete Key, Not Right-click Delete (46:40) Fill Handle & Angry Rabbit to copy formula (47:41) Keyboard F4 Locks Cell Reference (make Absolute) (49:45) Keyboard Tab puts content in Cell and move selected Cell to right (50:55) Order of Operation error (52:17) Range Finder to find formula errors (52:34) Lock Cell Reference after you put cell in Edit Mode (53:58) Quickly copy an edited formula down a column (53:07) F2 key in last cell to find formula errors (54:15) Fix incorrect range in function (54:55) SQRT function & Fractional Exponents (57:20) STDEV.P function (58:10) Navigate Large Data Sets (58:48) Keyboard Ctrl + Arrow jumps to bottom of data set (59:42) Keyboard Ctrl + Shift + Arrow selects to bottom of data set (Current Range) (01:01:41) Keyboard Shift + Enter puts content in Cell and move selected Cell up (01:02:55) Counting with conditions or criteria: COUNTIFS function (01:03:43) Keyboard Ctrl + Backspace jumps back to Active Cell (01:05:31) Counting between an upper & lower limit with COUNTIFS (01:07:36) COUNTIFS copied down column (01:10:08) Joining Comparative Operator with Cell Reference in formula (01:12:50) Data Analysis features in Excel (01:13:44) Sorting (01:16:59) Filtering (01:20:39) Introduction to PivotTables (01:23:39) Create PivotTable dialog box (01:24:33) Dragging & dropping Fields to create PivotTable (01:25:31) Dragging Field to Row area creates a Unique List (01:26:17) Outline/Tabular Layout (01:27:00) Value Field Settings dialog to change: Number Formatting, Function, Name (01:28:12) 2nd & 3rd PivotTable examples (01:31:23) What is a Cross Tabulated Report? (01:33:04) Create Cross Tabulated Report w PivotTable (01:35:05) Show PivotTable Field List (01:36:48) How to Pivot the Report (01:37:50) Summarize Survey Data with PivotTable. (01:38:34) Keyboard Alt, N, V opens PivotTable dialog box (01:41:38) PivotTable with 3 calculations: COUNT, MAX & MIN (01:43:25) Count & Count Number calculations in a PivotTable (01:45:30) Excel 2013 Charts to Visually Articulate Quantitative Data (01:47:00) #1 Rule for Charts: No Chart Junk! (01:47:30) Explain chart types: Column, Bar, Pie, Line and X-Y Scatter Chart (01:51:34) Create Column Chart using Recommended Chart feature (01:53:00) Remove Field Buttons from Pivot Chart (01:54:10) Chart Formatting Task Pane (01:54:45) Vary Fill Color by point (01:55:15) Format Axis with Numbers by Formatting Source Data in PivotTable (01:56:02) Add Data Labels to Chart (01:57:28) Copy Chart & Create Bar Chart (01:57:48) Change Chart Type (01:58:15) Change Gap Width. (01:59:17) Create Pie Chart (01:59:23) Do NOT use 3-D Pie (01:59:42) Add % Data Labels to Pie Chart (02:00:25) Create Line Chart From PivotTable (02:01:20) Link Chart Tile to Cell (02:02:20) Move a Chart (02:02:33) Create an X-Y Scatter Chart (02:03:35) Add Axis Labels (02:05:27) Number Formatting to help save time (02:07:24) Number Formatting is a Façade (02:10:27) General Number Format (02:10:52) Percentage Number Formatting (02:14:03) Don’t Multiply Relative Frequency by 100 (02:17:27) Formula for % Change & End Amount
Views: 431451 ExcelIsFun
Qualitative analysis of interview data: A step-by-step guide
 
06:51
The content applies to qualitative data analysis in general. Do not forget to share this Youtube link with your friends. The steps are also described in writing below (Click Show more): STEP 1, reading the transcripts 1.1. Browse through all transcripts, as a whole. 1.2. Make notes about your impressions. 1.3. Read the transcripts again, one by one. 1.4. Read very carefully, line by line. STEP 2, labeling relevant pieces 2.1. Label relevant words, phrases, sentences, or sections. 2.2. Labels can be about actions, activities, concepts, differences, opinions, processes, or whatever you think is relevant. 2.3. You might decide that something is relevant to code because: *it is repeated in several places; *the interviewee explicitly states that it is important; *you have read about something similar in reports, e.g. scientific articles; *it reminds you of a theory or a concept; *or for some other reason that you think is relevant. You can use preconceived theories and concepts, be open-minded, aim for a description of things that are superficial, or aim for a conceptualization of underlying patterns. It is all up to you. It is your study and your choice of methodology. You are the interpreter and these phenomena are highlighted because you consider them important. Just make sure that you tell your reader about your methodology, under the heading Method. Be unbiased, stay close to the data, i.e. the transcripts, and do not hesitate to code plenty of phenomena. You can have lots of codes, even hundreds. STEP 3, decide which codes are the most important, and create categories by bringing several codes together 3.1. Go through all the codes created in the previous step. Read them, with a pen in your hand. 3.2. You can create new codes by combining two or more codes. 3.3. You do not have to use all the codes that you created in the previous step. 3.4. In fact, many of these initial codes can now be dropped. 3.5. Keep the codes that you think are important and group them together in the way you want. 3.6. Create categories. (You can call them themes if you want.) 3.7. The categories do not have to be of the same type. They can be about objects, processes, differences, or whatever. 3.8. Be unbiased, creative and open-minded. 3.9. Your work now, compared to the previous steps, is on a more general, abstract level. You are conceptualizing your data. STEP 4, label categories and decide which are the most relevant and how they are connected to each other 4.1. Label the categories. Here are some examples: Adaptation (Category) Updating rulebook (sub-category) Changing schedule (sub-category) New routines (sub-category) Seeking information (Category) Talking to colleagues (sub-category) Reading journals (sub-category) Attending meetings (sub-category) Problem solving (Category) Locate and fix problems fast (sub-category) Quick alarm systems (sub-category) 4.2. Describe the connections between them. 4.3. The categories and the connections are the main result of your study. It is new knowledge about the world, from the perspective of the participants in your study. STEP 5, some options 5.1. Decide if there is a hierarchy among the categories. 5.2. Decide if one category is more important than the other. 5.3. Draw a figure to summarize your results. STEP 6, write up your results 6.1. Under the heading Results, describe the categories and how they are connected. Use a neutral voice, and do not interpret your results. 6.2. Under the heading Discussion, write out your interpretations and discuss your results. Interpret the results in light of, for example: *results from similar, previous studies published in relevant scientific journals; *theories or concepts from your field; *other relevant aspects. STEP 7 Ending remark Nb: it is also OK not to divide the data into segments. Narrative analysis of interview transcripts, for example, does not rely on the fragmentation of the interview data. (Narrative analysis is not discussed in this tutorial.) Further, I have assumed that your task is to make sense of a lot of unstructured data, i.e. that you have qualitative data in the form of interview transcripts. However, remember that most of the things I have said in this tutorial are basic, and also apply to qualitative analysis in general. You can use the steps described in this tutorial to analyze: *notes from participatory observations; *documents; *web pages; *or other types of qualitative data. STEP 8 Suggested reading Alan Bryman's book: 'Social Research Methods' published by Oxford University Press. Steinar Kvale's and Svend Brinkmann's book 'InterViews: Learning the Craft of Qualitative Research Interviewing' published by SAGE. Text and video (including audio) © Kent Löfgren, Sweden
Views: 766967 Kent Löfgren
Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
 
55:13
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( 00:53 min mark) 2. How Data Must Be Setup ( 02:53 min mark) Sort: 3. Sort with 1 criteria ( 04:35 min mark) 4. Sort with 2 criteria or more ( 06:27 min mark) 5. Sort by color ( 10:01 min mark) Filter: 6. Filter with 1 criteria ( 11:26 min mark) 7. Filter with 2 criteria or more ( 15:14 min mark) 8. Filter by color ( 16:28 min mark) 9. Filter Text, Numbers, Dates ( 16:50 min mark) 10. Filter by Partial Text ( 20:16 min mark) Pivot Tables: 11. What is a PivotTable? ( 21:05 min mark) 12. Easy 3 step method, Cross Tabulation ( 23:07 min mark) 13. Change the calculation ( 26:52 min mark) 14. More than one calculation ( 28:45 min mark) 15. Value Field Settings (32:36 min mark) 16. Grouping Numbers ( 33:24 min mark) 17. Filter in a Pivot Table ( 35:45 min mark) 18. Slicers ( 37:09 min mark) Charts: 19. Column Charts from Pivot Tables ( 38:37 min mark) Formulas: 20. SUMIFS ( 42:17 min mark) 21. Data Analysis Formula or PivotTables? ( 45:11 min mark) 22. COUNTIF ( 46:12 min mark) 23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark) Getting Data Into Excel 24. Import from CSV file ( 51:21 min mark) 25. Import from Access ( 54:00 min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 1582550 ExcelIsFun
Aging Analysis Reports using Excel - How To
 
11:58
In this tutorial we learnt how to conduct aging analysis using Excel with different basic formulas. Complete aging analysis tutorial with conditional formatting and sparklines: https://goo.gl/LJi5nE To practice along please download the Excel exercise book at: https://goo.gl/PzQ4eG For more Excel Tutorials visit: http://pakaccountants.com/excel/ Social: Fb: http://facebook.com/exceltoexcel/ Tw: http://twitter.com/exceltoexcel/
Views: 33695 Hasaan Fazal
Qualitative Data Analysis - Coding & Developing Themes
 
10:39
This is a short practical guide to Qualitative Data Analysis
Views: 138154 James Woodall
R Markdown for a Data Analysis Report
 
17:44
Guide for my students on producing data analysis reports using R Markdown in the R Studio IDE.
Views: 20144 Homer White
How to create an interactive reporting tool in Excel
 
05:12
Microsoft Certified Trainer Melissa Esquibel shows you how to slice and dice data and present it in an attractive visual package.
3 essential Google Analytics reports to measure your activity
 
03:04
In this video, Sylvain, COO of SEO.fr will show you three types of Google Analytics reports designed to help you get a better grasp on your data and improve the decision-making process on your site. Contact the expert : http://bit.ly/2sgfG9o PrestaShop website: https://www.prestashop.com/ PrestaShop on Twitter: https://twitter.com/PrestaShop PrestaShop on Facebook: https://www.facebook.com/prestashop/
Views: 5887 PrestaShop Official
How to Create a Summary Report from an Excel Table
 
12:06
One of my viewers asked for my help in creating an Executive Summary Report - because her manager will not allow her to use a Pivot Table. Here are the tips and techniques that I demonstrate in this lesson: 1) Use Excel's Advanced Filter to Extract a list of unique customer names from a filed with over 4,000 records. 2) Convert a normal range of data cells into an Excel 2007 / 2010 Table (as a List in Excel 2003) - so that range references will update automatically when you append records. 3) Create Named Ranges of Cells that you can use in Formulas & Functions. 4) Use the SUMIF, AVERAGEIF and COUNTIF Functions in the Summary Report. I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video tutorials. Danny Rocks The Company Rocks
Views: 1129414 Danny Rocks
Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360)
 
30:35
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to other tables, and then build DAX Calculated Columns & Measures for Gross Profit that can be used in a Dynamic Dashboard with Map, Column Chart, Line Chart, Card and Slicer visualizations. During the whole process we will compare and contrast how the process is similar and different from Excel’s Power Query and Power Pivot DAX. The steps we will see in this video are: 1. (00:17) Introduction to entire process for Power BI Desktop, including looking at the finished Dashboard 2. (04:50) Import Multiple Excel Files From Folder 3. (05:44) Name Query 4. (06:02) Transform extension column to lowercase 5. (06:34) Filter Files to only include “.xlsx” file extensions 6. (07:05) Remove Columns 7. (07:18) November 2016 Power Query Update Problem 8. (08:05) Add Custom Column with Excel.Workbook Function to extract the Excel Objects from each File. 9. (09:40) Delete Content Column 10. (10:41) Filter to only include Excel Sheet Objects 11. (11:06) Filter to exclude sheets that contain the word “Sheet” 12. (11:40) Remove Columns 13. (11:51) Expand Data and Sheet Name Columns 14. (12:06) Change Field Names 15. (12:22) Change Data Types 16. (14:05) Add Custom Column to calculate Net Revenue Column then round Number.Round function. Then Add Fixed Decimal Data Type. 17. (15:59) Remove columns for Amount and Revenue Discount 18. (16:10) Close and Apply to add to Data Model 19. (17:05) Import Excel Manager Table. Change Data Types to Text. Close and Apply 20. (18:10) Create Relationship between Zip Code Columns 21. (19:03) Create DAX Calculated Column with the IF Function to Categorize Retail Data. Change Data Type. 22. (21:53) Create DAX Measures for: Total Revenue, Total COGS and Gross Profit. Add Currency Number Formatting with No Decimals Showing. 23. (24:28) Create DAX Measures for: Gross Profit Percentage. Add Percentage Number Formatting with Two Decimals Showing. 24. (25:35) Create Map Visualization for Zip Code & Gross Profit Data (Zip Code with relationship to Managers) 25. (26:20) Create Clustered Bar for Manager Names & Gross Profit Data (Zip Code with relationship to Managers) 26. (27:15) Create Clustered Column for Product & Gross Profit Data, with a Line Chart for Gross Profit Percentage 27. (28:19) Create Clustered Column for Payment Method & Gross Profit Data, with a Line Chart for Gross Profit Percentage 28. (28:45) Create Slicer for States. 29. (29:00) Create Card Visualization for Total Revenue, Total COGS, Gross Profit and Gross Profit Percentage. 30. (29:57) Summary Learn Power BI Desktop Basics. Introduction to Power BI Desktop. Getting Started with Power BI Desktop. Create Impactful Reports With Power BI Desktop. Microsoft Power BI.
Views: 136946 ExcelIsFun
Data Analysis and Report Writing Part 1
 
02:37
This video demonstrate how to start a data analysis report as a student project.
Views: 5766 Min Aung
How to Analyze Satisfaction Survey Data in Excel with Countif
 
04:16
Purchase the spreadsheet (formulas included!) that's used in this tutorial for $5: https://gum.co/satisfactionsurvey ----- Soar beyond the dusty shelf report with my free 7-day course: https://depictdatastudio.teachable.com/p/soar-beyond-the-dusty-shelf-report-in-7-days/ Most "professional" reports are too long, dense, and jargony. Transform your reports with my course. You'll never look at reports the same way again.
Views: 392268 Ann K. Emery
Data Analysis in SPSS Made Easy
 
14:06
Use simple data analysis techniques in SPSS to analyze survey questions.
Views: 856988 Claus Ebster
8-10 APA Style Reporting Statistical Results
 
03:23
After conducting a statistical analysis, you should write up the results in proper APA 6th edition style. We review some general rules for reporting significance levels and where to find results in SPSS output. Table of Contents: 00:19 - Write Up Results in APA Style
Views: 10487 Research By Design
Excel and Questionnaires: How to enter the data and create the charts
 
14:37
This is a tutorial on how to enter the results of your questionnaires in Excel 2010. It then shows you how to create frequency tables (using the countif function not the frequency function). The next stage is creating charts.
Views: 377525 Deirdre Macnamara
Why Use R? - R Tidyverse Reporting and Analytics for Excel Users
 
06:43
https://www.datastrategywithjonathan.com Free YouTube Playlist https://www.youtube.com/playlist?list=PL8ncIDIP_e6vQ0uQofezvKv3yPnL5Unxe From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours If you use Excel for any type of reporting or analytics then this course is for you. There are a lot of great courses teaching R for statistical analysis and data science that can sometimes make R seem a bit too advanced for every day use. Also since there are many different ways of using R that can often add to the confusion. The reality is that R can be used to make your every day reporting analytics that you do in Excel much faster and easier without requiring any complex statistical techniques while at the same time giving you a solid foundation to expand into those areas if you so wish. This course uses the Tidyverse standards for using R which provides a single, comprehensive and easy to understand method for using R without complicating things via multiple methods. It's designed to build upon the the skills you are already familiar with in Excel to shortcut your learning journey. If you're looking to learn Advanced Excel, Excel VBA or Databases then you need to check out this video series. In this videos series, I will show you how to use Microsoft Excel in different ways that will make you far more effective at working with data. I'm also going to expand your knowledge beyond Excel and show you tips, tricks, and tools from other top data analytics tools such as R Tidyverse, Python, Data Visualisation tools such as Tableau, Qlik View, Qlik Sense, Plotly, AWS Quick Sight and others. We'll start to touch on areas such as big data, machine learning, and cloud computing and see how you can develop your data skills to get involved in these exciting areas. Excel Formulas such as vlookup and sumifs are some of the top reasons for slow spreadsheets. Alternatives for vlookup include power query (Excel 2010 and Excel 2013) which has recently been renamed to Get and Transform in Excel 2016. Large and complex vlookup formulas can be also done very efficiently in R. Using the R Tidyverse libraries you can use the join functions to merge millions of records effortlessly. In comparison to Excel Vlookup, R Tidyverse Join can pull on multiple columns all at the same time. Microsoft Excel Power Query and R Tidyverse Joins are similar to the joins that you do in databases / SQL. The benefit that they have over relational databases such as Microsoft Access, Microsoft SQL Server, MySQL, etc is that they work in memory so they are actually much faster than a database. Also since they are part of an analytics tool instead of a database it is much faster and easier to build your analysis and queries all in the same tools. My very first R Tidyverse program was written to replace a Microsoft Access VBA solution which was becoming complicated and slow. Note that Microsoft Access is very limited in analytics functions and is missing things as simple as Median. Even though I had to learn R programming from scratch and completely re-write the Microsoft Access VBA solution it was so much easier and faster. It blew my mind how much easier R programming with R Tidyverse was than Microsoft Access VBA or Microsoft Excel VBA. If you have any VBA skills or are looking to learn VBA you should definitely checkout my videos on R Tidyverse. To understand why R Tidyverse is so much easier to work with than VBA. R Tidyverse is designed to work directly with your data. So If you want to add a calculated column that’s around one line of script. In Excel VBA, the VBA is used to control the DOM (Document Object Model). In Excel that means that you VBA controls things like cells and sheets. This means your VBA is designed to capture the steps that you would normally do manually in Microsoft Excel or Microsoft Access. VBA is not actually designed to work directly with your data. Note the most efficient path is to reduce the data pulled down from the database in the first place. This is referring to the amount of data you are pulling down from your data warehouse or data lake. It makes no sense to pull data from a data warehouse / data lake to pull into another database to query add joins / lookups to then pull it into Excel or other analysis tool. Often analyst build these intermediate databases because they either don’t have control of the data warehouse or they need to join additional information. All of these operations are done significantly faster in a tool such as R Tidyverse or Microsoft Excel Power Query.
Views: 15875 Jonathan Ng
Quick Data Analysis with Google Sheets | Part 1
 
11:40
Spreadsheet software like Excel or Google Sheets are still a very widely used toolset for analyzing data. Sheets has some built-in Quick analysis features that can help you to get a overview on your data and very fast get to insights. #DataAnalysis #GoogleSheet #measure 🔗 Links mentioned in the video: Supermetrics: http://supermetrics.com/?aff=1014 GA Demo account: https://support.google.com/analytics/answer/6367342?hl=en 🎓 Learn more from Measureschool: http://measureschool.com/products GTM Copy Paste https://chrome.google.com/webstore/detail/gtm-copy-paste/mhhidgiahbopjapanmbflpkcecpciffa 🚀Looking to kick-start your data journey? Hire us: https://measureschool.com/services/ 📚 Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books 📷 Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear Our tracking stack: Google Analytics: https://analytics.google.com/analytics/web/ Google Tag Manager: https://tagmanager.google.com/ Supermetrics: http://supermetrics.com/?aff=1014 ActiveCampaign: https://www.activecampaign.com/?_r=K93ZWF56 👍 FOLLOW US Facebook: http://www.facebook.com/measureschool Twitter: http://www.twitter.com/measureschool
Views: 18793 Measureschool
Types of Data: Nominal, Ordinal, Interval/Ratio - Statistics Help
 
06:20
The kind of graph and analysis we can do with specific data is related to the type of data it is. In this video we explain the different levels of data, with examples. Subtitles in English and Spanish.
Views: 923015 Dr Nic's Maths and Stats
Types of Reports
 
37:45
Views: 12714 Soft Skills
Quick Tips: Reporting on Optimize Data in Google Analytics
 
04:11
In this Quick Tip video, learn how to access your Optimize data in Google Analytics and get tips on the types of analysis you can do with the experiment ID, name, and variant ID, in Google Analytics.
Views: 2483 Google Analytics
Qualitative and Quantitative Data
 
02:01
Quantitative Data vs Qualitative Data Additional Information on Qualitative vs Quantitative Data http://www.moomoomath.com/qualitative-and-quantitative-data.html Data can be divided into two groups called quantitative and qualitative data Quantitative data is numerical Qualitative Data id descriptive data Let’s look at examples of both Examples of quantitative data would be The number of pets, time of day, the temperature outside Quantitative data can be graphed If you count or measure, you are collecting quantitative data There are two types of quantitative data, discrete and continuous Discrete data is usually data you can count and continuous data is usually data you measure. I have a separate video on these two types of data. Qualitative is descriptive or observations and uses words For example, the color of a house, smell of a sock, texture of a shirt Quantitative or Qualitative Consider a cat Quantitative Data would be the cat has 4 legs and weighs 10 pounds Qualitative data would be the cat is yellow, and has soft fur A bookshelf Quantitative would be you have 50 books and is 150 centimeters tall. Qualitative data would be it is multi-color and has a smooth texture You may also enjoy.. Qualitative and Quantitative Data https://www.youtube.com/watch?v=2X-QSU6-hPU Quantitative Qualitative Song https://www.youtube.com/watch?v=-S2EiPD4-W0 -~-~~-~~~-~~-~- Please watch: "Study Skills Teacher's Secret Guide to your Best Grades" https://www.youtube.com/watch?v=f3bsg8gaSbw -~-~~-~~~-~~-~-
Views: 166060 MooMoo Math and Science
Excel Magic Trick 1242: Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format
 
09:49
Download File: http://people.highline.edu/mgirvin/ex... Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and match just the data we want to create a smaller data set using Text To Columns, MATCH function, TRIM function, Filter, Formatting and Page Setup: 1. (00:08) Discuss our task of taking a lot of data, removing only what we want, and then formatting and doing page setup on final report 2. (01:06) Text To Columns to get county names for our report 3. (01:54) TRIM function to remove extra spaces 4. (02:23) Copy Paste Special Values AND Transpose 5. (03:06) MATCH & ISNUMBER functions to create helper column to match countries we need in our final report 6. (04:07) Filter to get Counties and GDP numbers 7. (04:44) Delete Year Columns we do not need. 8. (05:02)Highlight Filtered Table to get Visible Cells Only and paste records to new sheet 9. (05:21) Delete non-adjacent columns in report that are not need in final report 10. (05:33) Display Numbers in Millions using Custom Number formatting: #,##0,, 11. (06:10) Display Years with an M to indicate numbers are shown in millions using Custom Number formatting: 0” M” 12. (06:43) Making sure that we have title that indicates the monetary unit: Constant 2005 US Dollars 13. (07:05) Apply Table Design Principles 14. (07:05) Add Border below Field Names 15. (07:17) Alternate shading for columns with white and light blue to help the visual ease of reading report 16. (08:25) Make sure that text is aligned left and numbers are aligned right 17. (08:39) Page Set Up so report prints correctly Mr Excel & excelisfun Trick 174: Clean & Transform GDP Data Set: Advanced Filter? Or Power Query? Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter? Basic Excel Business Analytics Transforming Data
Views: 48907 ExcelIsFun
Data Collection: Understanding the Types of Data.
 
06:43
Data falls into several categories. Each type has some pros and cons, and is best suited for specific needs. Learn more in this short video from our Data Collection DVD available at http://www.velaction.com/data-collection-lean-training-on-dvd/.
Views: 154560 VelactionVideos
E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports
 
28:55
Download Start Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-04-PivotTablesStart.xlsx Download Finished Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-04-PivotTablesFinished.xlsx Pdf notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-04-PivotTables.pdf This video teaches all the tricks of PivotTables from Slicers to Show Values As to Dashboards. Learn how to create Cross Tab Repots, Dashboards, Frequency Distributions from Text Data and a CPA Pass Rate Report. This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more. Topics: 1. (00:12) Introduction 2. (01:35) What is a PivotTable? What is a Cross Tab Report. 3. (03:20) Build a Cross Tab Report with a PivotTable 4. (11:15) PivotTable Cached Data 5. (12:10) Building a Standard PivotTable as Part of Dashboard 6. (12:54) Standard PivotTable vs. Data PivotTable 7. (14:18) What is a Dashboard? 8. (17:20) Use Group By Feature to group Monthly and Yearly Amounts 9. (18:55) Summarize Values By to Change Aggregate Function 10. (19:35) Use Slicers to Filter Entire PivotTable 11. (23:21) Cell Phone Data Examples from Video to Build Frequency Distribution: 12. (24:18) Show Values As to Change to Specific Calculations 13. (25:20) CPA Data Examples from Video to Build CPA Pass Rate Report 14. (27:47) Practice Problems, Homework 15. (27:57) Summary The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 14887 ExcelIsFun
SPSS: How To Perform Quantitative Data Analyses For Bachelor's Research? 5 Basic Analysis Methods
 
08:32
1. Descriptives: 1:32 2. T test: 2:52 3. Correlation: 4:41 4. Chi square: 5:39 5. Linear regression: 6:45 This video discusses the basic statistical analytical procedures that are required for a typical bachelor's thesis. Five stats are highlighted here: descriptives, T test, correlation, Chi square, and linear regression. For requirements on reporting stats, please refer to the appendix of your research module manuals -- Frans Swint and I wrote an instructional text on APA reporting of stats. There is no upper limit in terms of how advanced your stats should be in your bachelor's dissertation. This video covers the basic procedures and is not meant to replace the instructions of your own research supervisor. Please consult your own research advisor for specific questions regarding your data analyses. Please LIKE this video if you enjoyed it. Otherwise, there is a thumb-down button, too... :P ▶ Please SUBSCRIBE to see new videos (almost) every week! ◀ ▼MY OTHER CHANNEL (MUSIC AND PIANO TUTORIALS)▼ https://www.youtube.com/ranywayz ▼MY SOCIAL MEDIA PAGES▼ https://www.facebook.com/ranywayz https://nl.linkedin.com/in/ranywayz https://www.twitter.com/ranywayz Animations are made with Sparkol. Music files retrieved from YouTube Audio Library. All images used in this video are free stock images or are available in the public domain. The views expressed in this video are my own and do not necessarily reflect the organizations with which I am affiliated. #RanywayzRandom #SPSS #Research
Views: 8704 Ranywayz Random
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
 
14:48
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 7190795 Excel Campus - Jon
How to build Interactive Excel Dashboards
 
52:26
Download file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create an interactive dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac. Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks
Views: 2115738 MyOnlineTrainingHub
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA
 
11:34
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA If your manager needs the report very frequently then you need to do the same task again and again. Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager. Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel. You can read our blog to go through instructions as well as download working and code files, Click here: http://yodalearning.com/tutorials/export-data-from-sql-to-excel-spreadsheet-using-vba/ You can enroll in our Excel VBA course: http://courses.yodalearning.com/p/excel-vba-tutorials CHECK SOME OF THE FREE COURSES WE OFFER http://courses.yodalearning.com/p/free-office-2016-tips Keep yourself updated. Follow us now! http://www.facebook.com/yodalearning http://www.twitter.com/yodalearning
Views: 101604 Yoda Learning Official
Data Collection Methods
 
02:10
This video was completed as part of a Masters project in DCU. It is the Introduction to a series of videos on Data Collection Methods
Views: 103211 Scott Crombie
Webinar:  How to Use Excel for Data Analysis and Reports Webinar
 
58:49
What do you do after you have entered all your data from a workshop evaluation or other self-administered questionnaire? Do you (gasp!) visually count the responses? Do you find someone who can do SPSS analysis? Do you file and forget? This webinar will show you how to build an Excel file that will automatically calculate all the frequencies (percents) of responses to questions, and then display the results on a print-ready report sheet. This method works best when the same questionnaire is used multiple times; however, getting the results without the attractive report is easy for even one-time events. This hour‐long webinar will teach you how to: 1. Use formulas in Excel to automatically analyze simple data. 2. Format a print-ready report from Excel data. 3. Increase your confidence in using Excel for data analysis and reports. Recommended prerequisites: Basic familiarity with Excel: the ability to enter data and use the Sum function to add numbers. No higher-level skill is needed! Presenter: Lyn Paleo has worked with non-profits for several decades and worked as an evaluator for 20 years. One of her interest areas is helping non-profits build the capacity to conduct basic evaluations in-house. For additional resources visit http://library.capacity4health.org.
Views: 45176 APIAHF
Data Analysis with MATLAB for Excel Users
 
59:52
This webinar highlights how MATLAB can work with Excel. Get a Free MATLAB Trial: https://goo.gl/C2Y9A5 Ready to Buy: https://goo.gl/vsIeA5 Learn MATLAB for Free: https://goo.gl/xIiHyG Many technical professionals find that they run into limitations using Excel for their data analysis applications. This webinar highlights how MATLAB can supplement the capabilities of Excel by providing access to thousands of pre-built engineering and advanced analysis functions and versatile visualization tools. Learn more about using MATLAB with Excel: http://goo.gl/3vkFMW Learn more about MATLAB: http://goo.gl/YKadxi Through product demonstrations you will see how to: • Access data from spreadsheets • Plot data and customize figures • Perform statistical analysis and fitting • Automatically generate reports to document your analysis • Freely distribute your MATLAB functions as Excel add-ins This webinar will show new features from the latest versions of MATLAB including new data types to store and manage data commonly found in spreadsheets. Previous knowledge of MATLAB is not required. About the Presenter: Adam Filion holds a BS and MS in Aerospace Engineering from Virginia Tech. His research involved nonlinear controls of spacecraft and periodic orbits in the three-body problem. After graduating he joined the MathWorks Engineering Development Group in 2010 and moved to Applications Engineering in 2012.
Views: 242136 MATLAB
Data Analytics using Hadoop - 10 Generate Reports And Dashboard using Tableau Public
 
20:17
1) Sign up for Tableau Account 2) Launch Tableau Public 3) Connect to data and rename field names 4) Create calculated field for year 5) Develop reports 6) Develop dashboard and save 7) Copy and paste the link or html code in social networking accounts or websites. 8) Published report can be manipulated to get different insights. Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/durga.v.gadiraju https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/dgadiraju
Views: 7453 itversity
MiniTab SixPack Process Capability Analysis (Normal) Report
 
06:19
While not exactly showing off my engineering prowess I want to also post videos that can help and inspire others with 'how-to' single-point lessons. This is a screen shot capture video I recorded of a former co-worker of mine showing me how to perform a process (normal) capability report using MiniTab 15 SixPack.
Views: 37453 Fred Webberking
Data Studio & Google Sheets Reports Tutorial - DataTable, GeoMap, Filters, Scorecard - Part 1
 
24:14
Pivot Table Video tutorial https://www.youtube.com/watch?v=T98RwlndSZk Video tutorial about using Google Data Studio with Google Sheets. You will learn how to analyze data and create reports using Google Sheets data in Data Studio. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Data Reconciliation and MIS Reporting using a Spreadsheet (MS Excel)
 
07:09
This video presents two simple functions in Microsoft Excel, that can be used to create meaningful Management Information System reports. The same functions and procedure can also be utilized for reconciling data.
Using Excel to Analyze Student Data
 
05:02
How to use Excel to gather statistical data for student assessments. Screencast created using screenr.com. http://www.screenr.com/GY5s
Views: 18483 Kurtis Hewson
How to analyze a case study?
 
23:32
This presentation describes an approach to analyze a case study - especially case studies from management discipline. Dr. Pradeep Racherla, Program Director & Associate Professor Marketing, Woxsen School of Business, elucidates different components of a case study and offers a framework to analyze a case study.
Views: 179627 Sanjay
Writing Tip #3: Writing Qualitative Findings Paragraphs
 
15:00
This video presents a "formula" for writing qualitative findings paragraphs in research reports. It presents the Setup-Quote-Comment model (SQC).
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
 
24:09
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels -- Column Headers 4. Row Labels -- Row Headers 5. Value Area -- this is where the calculation goes 6. Cross tabulation (row label and column label) 7. Double Click to create new sheet with data 8. Filter area -- filters whole report 9. Slicers 10. Value Field Settings Dialog box 11. Number Format For Value Field in Value Field Settings Dialog box 12. SUM function 13. Change Function in Value Field Settings Dialog box 14. Average Function 15. Format PivotTable 16. Layout For PivotTable 17. Multiple calculations: just drop field into value area multiple times and change function 18. Change Field Names in Value Field Settings Dialog box 19. Frequency Table to Count 20. Group By Dates
Views: 576897 ExcelIsFun