Home
Search results “Format of a data analysis report”
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: 17465 Homer White
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: 20916 NurLiyana Isa
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: 26213 umnWritingStudies
Analytical Reports [BAS 120]
 
02:05
This video will cover the four parts of an analytical report in business analytics, including the introduction, data, analysis, and results and conclusion sections. Table of Contents: 00:00 - Analytical Reports 00:03 - Introduction 00:13 - Report Introduction 00:23 - Data 00:42 - Analysis 01:15 - Results & Conclusion 01:32 - Summary 01:54 - Copyright Information
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.
Making data mean more through storytelling | Ben Wellington | TEDxBroadway
 
14:19
Ben Wellington uses data to tell stories. In fact, he draws on some key lessons from fields well outside computer science and data analysis to make his observations about New York City fascinating. Never has a fire hydrant been so interesting as in this talk. Ben Wellington is a computer scientist and data analyst whose blog, I Quant NY, uses New York City open data to tell stories about everything from parking ticket geography to finding the sweet spot in MetroCard pricing. His articles have gone viral and, in some cases, led to policy changes. Wellington teaches a course on NYC open data at the Pratt Institute and is a contributor to Forbes and other publications. This talk was given at a TEDx event using the TED conference format but independently organized by a local community. Learn more at http://ted.com/tedx
Views: 157439 TEDx Talks
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: 1531802 ExcelIsFun
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: 1095861 Danny Rocks
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: 44101 ExcelIsFun
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: 6626265 Excel Campus - Jon
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: 365477 Ann K. Emery
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: 358659 Deirdre Macnamara
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/
R Data Analysis Solution: Generate Reports of Data Analysis with R Markdown & knitR | packtpub.com
 
11:16
This playlist/video has been uploaded for Marketing purposes and contains only selective videos. For the entire video course and code, visit [http://bit.ly/2v1WJoT]. R Markdown provides a simple syntax to define analysis reports. Based on such a report definition, knitr can generate reports in HTML, PDF, Microsoft Word format, and several presentation formats. • Create a new R Markdown document • Generate an HTML document based on the markdown file • Generate a PDF or Word document For the latest Big Data and Business Intelligence video tutorials, please visit http://bit.ly/1HCjJik Find us on Facebook -- http://www.facebook.com/Packtvideo Follow us on Twitter - http://www.twitter.com/packtvideo
Views: 2756 Packt Video
Excel 2013 Data Analytics Webinar: How to Structure and Analyze large data with Power BI tools
 
01:02:47
In this 1 hour Webinar, Dr. Nitin Paranjape (Office MVP) will show you how to structure and analyze large amount of data in just a few seconds using Excel 2013's Power BI features: Pivot Table, Power Pivot, Power Query and Power View. Topics covered: - Purpose of data analysis (2:30) - Data Analysis process (4:06) - Good data vs Bad data (5:34) - Rules for Good data (9:05) - Common Examples of badly formatted data (10:41) - How to handle cross-tab data with Power Query (14:44) - Gather data from the web with (18:57) - Power Query's Data Catalogue Search (20:00) - Split Column by Delimiter (20:05) - Refresh live data in Power Query (23:20) - Summarize Data in Pivot Tables (24:26) - Do Calculation right inside Pivot Tables with Calculated Fields (27:33) - Avoid Wrong calculations with Get Pivot Data (29:10) - Data Visualization with Conditional Formatting & Quick Analysis (31:12) - Limitations of Pivot Table (34:38) - Why use Power Pivot (35:19) - Analyze 43 million rows of data within Power Pivot (36:40) - Build interactive dashboards with Power View (41:42) - Share Power View reports on Sharepoint (47:15) - Manage viewing rights with Excel's Browser View option - Create 3D map reports in Power Map (49:38) - Power BI Preview (55:20) - Summary: Which tool to use in which scenario? (59:03) - Notes to Developers (59:17) This is a recording of the Data Analytics Webinar for Microsoft, powered by Economic Times. The webinar was conducted by Dr. Nitin Paranjape, Office MVP and Microsoft Regional Director.
Views: 13904 Efficiency 365
How to Write a Lab Report
 
11:09
Sherri Seligson walks you through the steps of writing a lab report for your science courses. https://homeschool-101.com/wp-content/uploads/2017/04/How-to-Write-a-Lab-Report-1.pdf
Views: 64701 Apologia World
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: 416502 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: 26284 Hasaan Fazal
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: 702855 Kent Löfgren
How to Clean Up Raw Data in Excel
 
10:54
Al Chen (https://twitter.com/bigal123) is an Excel aficionado. Watch as he shows you how to clean up raw data for processing in Excel. This is also a great resource for data visualization projects. Subscribe to Skillshare’s Youtube Channel: http://skl.sh/yt-subscribe Check out all of Skillshare’s classes: http://skl.sh/youtube Like Skillshare on Facebook: https://www.facebook.com/skillshare Follow Skillshare on Twitter: https://twitter.com/skillshare Follow Skillshare on Instagram: http://instagram.com/Skillshare
Views: 82109 Skillshare
MS Excel 2010 Tutorial: Employee Sales Performance Report, Analysis & Evaluation - PART 1
 
07:54
http://www.excelfornoobs.com http://www.subjectmoney.com http://www.subjectmoney.com/articledi... What we have built here is a Microsoft Excel template that can be used to analyze the performance of sales representatives with a focus on restaurant servers (waiters and waitresses). In this example we are analyzing the quarterly performance of the restaurant as a whole, and each sales unit (the servers). We will also take a deeper look into each month that the quarterly sales report consists of: January, February and March. Our goal in analyzing this sales report is to improve the sales performance of our servers.
Views: 87348 Surfwtw
Lab Reports: Data Processing and Analysis Tutorial: On-Level
 
07:55
Use this tutorial to help you write and format the data analysis and processing section of your lab report.
Views: 362 DMHS Science
Import Data, Analyze, Export and Plot in Python
 
16:16
A common task in data science is to analyze data from an external source that may be in a text or comma separated value (CSV) format. By importing the data into Python, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. This demonstrates how to import data, perform a basic analysis such as average values, trend the results, save the figure, and export the results to another text file.
Views: 38016 APMonitor.com
Jaspersoft 7 Data to Reporting & Analysis Tutorial
 
05:44
This tutorial starts by showing how to connect to a data source and create a metadata layer called a “Domain” in Jaspersoft. This is used to prepare data, make it easy for non-technical users to understand, and enable them to create self-service reports and analyses on their own.
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: 44841 APIAHF
How to Report Statistics in APA Style
 
09:23
Tutorial for reporting statistics in an APA style manuscript, including using special scripts/symbols and the Equation Editor function in Word 2010 for Windows. Learn basic format for reporting results of chi-squared test of independence, correlation, t test, and ANOVA. Subtitles available: click on the CC button toward the bottom right of the video. Menu available for jumping to chapters in the flash video posted on the KSU Psych Lab website (link below). Terrence Jorgensen Kennesaw State University Psychology Lab http://psychology.hss.kennesaw.edu/resources/psychlab/
Views: 95761 Terry Jorgensen
Analyze Stock Data with Microsoft Excel
 
17:50
Visualization of data is a powerful method to see trends and make decisions. Microsoft Excel trending capabilities are tools to visualize large data sets, such as financial information on company performance.
Views: 15971 APMonitor.com
Lab report analysis sections
 
03:10
Description of how to write the analysis section of a lab report
Views: 3971 Swanson Does Science
Data Analysis in MySQL and Excel 2013 - Example
 
04:55
In this video I show how to import a table from MySQL into Excel so that seasonal analysis can be conducted.
Views: 28332 Michael Herman
How to Analyze Survey Data Part 1 - Unpivot Data with Power Query
 
05:44
Checkout the full article and download the file at: http://www.excelcampus.com/pivot-tables/analyze-survey-data-in-excel/ Learn how to use Power Query to transform multiple choice survey data in Excel. This survey data has been exported to Excel in a format that is not easy to use for a pivot table. In this video you will learn how to use the Unpivot feature in Power Query to transform or normalize the data. This will make it easier to analyze with a pivot table and chart. Please subscribe to my free email newsletter to get more Excel tips and tutorials like this. http://www.excelcampus.com/newsletter PART 2: https://youtu.be/h-sKEPEvwZ8 PART 3: https://youtu.be/NBgL8ItVdKY
Views: 36562 Excel Campus - Jon
Data Analysis and Report Writing Part 1
 
02:37
This video demonstrate how to start a data analysis report as a student project.
Views: 5650 Min Aung
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.
Use Excel Pivot Tables to analyse your SALES
 
07:58
This video shows the potential power of Excel and pivot tables to analyse your sales. But first you have to set up a datamart in order to make it all possible!
Views: 87130 MrDatamart
Analysis of Research Report
 
00:26
Find APA formatted examples of an Analysis of Research Report for HCS 438 - Statistical Applications at the University of Phoenix. Go to: http://www.research-paper-example.com/analysis-of-research-report.html Find multiple examples of: Analysis of Research Reports Visual Data Displays Project Sample Charts or Graphs paper Uses of Statistical Information paper Statistics in the Workplace Analysis of Data Reports
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: 185540 IELTS Master
Import Data and Analyze with Python
 
11:58
Python programming language allows sophisticated data analysis and visualization. This tutorial is a basic step-by-step introduction on how to import a text file (CSV), perform simple data analysis, export the results as a text file, and generate a trend. See https://youtu.be/pQv6zMlYJ0A for updated video for Python 3.
Views: 203167 APMonitor.com
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: 125684 ExcelIsFun
Become an Excel Wizard With Python
 
55:31
In this talk, we will explore how the Python's openpyxl module allows your Python programs to read and modify Excel spreadsheet files. By using Python, you can take your Excel and data manipulation skills to the whole new level. PERMISSIONS: The original video was published on Six Feet Up Corp YouTube channel with the Creative Commons Attribution license (reuse allowed). CREDITS: Original video source: https://www.youtube.com/watch?v=ueq1iTWQU5U
Views: 214134 Coding Tech
TrueSight IT Data Analytics: Creating a data pattern with custom date format
 
04:40
This video helps you create a data pattern with a custom date format and a corresponding custom subpattern. For more information about data patterns, see the BMC online product documentation portal at https://docs.bmc.com/docs/display/itda11/Managing+data+patterns.
Views: 462 BMCdocs
How to write a science report
 
08:40
How to write a science report Written for any high school science report or conversion to a science fair poster. Specifically I have used this for many years for KS3, IGCSE and IB science reports. Basically goes over the just the basically most important sections of variables, tables and graphs, and discussion with error analysis. This is mostly focused around the IGCSE level, good for KS3 extension, good for IB to get the basics before working on a higher level needed. My science report template for IGCSE - grade 10-11: TITLE OF PRACTICAL The title must be specific and include the dependent and independent variables. For example, ‘An Investigation of the Concentration of Vitamin C in Different Brands of Orange Juice’ NOT: ‘An Investigation into the Amount of Vitamin C in Orange Juice’. Don’t use the word amount in the report – it is too vague. Make sure your complete report is easy to read with all the clear headings. Don’t add unnecessary information. Have everything formatted well. You are writing a piece of functional English using scientific terminology that would be understandable to your peers. Introduction This needs to give the marker a quick understanding of what you are doing or any other relevant background information. Include chemical reactions, or scientific theories and models. Variables Independent Variable: Write the variable you will change here Give the range of 5 increments here including the instruments with range, uncertainties and units. Eg. I will change the length using the following increments: 0,5,10,15,20 using a 0.0-30.0 ± 0.5cm ruler. Dependent Variable: Write the variable you will measure here Explain how you will measure it, what instrument, range and units Controlled Variables: Write all the variables that are important to control. Explain how you will measure them and control them, and what instrument you will use to measure that it is controlled and stays the same Equipment List your equipment including ranges and uncertainties eg. Measuring cylinder 0.0-100.0 ± 0.5cm3 The equipment and method will repeat some aspects of your variables section. Method Include a diagram and number the steps. Label the diagram: ‘Figure 1: Experimental set up’. Results Table with units in the headings eg. Temperature (± 0.5⁰C). Label the table: ‘Table 1: …’ eg. ‘Table 1: Temperature data for varying amounts of acid’. This is so you can refer to it in your paragraphs. Make sure you have correct significant figures eg. For the above temperature heading, 0.0 not 0. Also if the uncertainty is 0.5, you can only have readings of .0 or.5, not .1, .2 etc.. Make the first column the independent variable, and the first row the dependent variable. Data analysis: Graph with units and headings. Label the graph: ‘Graph 1:…’ etc similarly to explanation above. Make your graphs and tables as easy to read as possible. Have it big enough to clearly see detailed grid lines, marked points and line of best fit with equation. Continuous data is a scatter graph, discontinuous data is a bar graph. Have one example calculation to represent all the data analysis you have done. Clearly write the equation, substitute, and give final answer all with units. Start by writing something like, ‘This is the example calculation for the first reading...’ Discussion In the first paragraph, explain the relationship of the graph. This is also called the conclusion or the generalization of the results. Be sure to distinguish between line and curved relationships etc. Explain the result using scientific models and theories from the syllabus. In a separate paragraph, explain anomalous results (eg. are not exactly on the line of best fit if line graph). Explain why a particular data point is not perfect. Be specific and use units when talking about data values. Talk about any systemic or random error and whether to accept or reject these points. Write separate paragraphs for separate ideas. Final paragraphs. This is to judge your method – what was inaccurate and how to improve it (create better ways to do it). Each paragraph is to: 1. List an error in the method used 2. Explain the error scientifically and how it would have affected the results – higher, lower values? 3. Specifically show what changes can be made to the method to decrease this error Don’t confuse, split up or mix up your paragraphs. Use what you have learnt in English about functional writing and clear paragraph structure. References Use an accepted format (use www.easybib.com). Try not to have pictures from another source or you have to reference it. Reference all your research. http://www.mrwengibchemistry.com/ Connect with me: Facebook: https://www.facebook.com/IBChemistry2016/ Twitter: https://twitter.com/andrewweng0406 Google plus: https://plus.google.com/u/0/108611113268141564345 Pinterest: https://www.pinterest.com/mrandrewweng040/ib-chemistry/
Views: 13196 Andrew Weng
Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model
 
01:43:05
Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm Buy excelisfun products: https://teespring.com/stores/excelisfun-store In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: 1. (00:05) Introduction 2. (01:39) Sort 3. (03:02) Sorting one column 4. (03:23) Sorting multiple columns 5. (09:06) Sorting Mixed Data 6. (10:50) Filter feature 7. (13:22) Filter Drop-down Arrows to see Unique List 8. (15:34) Filter Different Data Types 9. (18:30) Filter to Extract Records 10. (20:54) OR Logical Test (OR Criteria) Discussion 11. (22:52) AND Logical Test (AND Criteria) Discussion 12. (28:23) BETWEEN and NOT Criteria 13. (30:57) PivotTable. Discussion of Crosstabulated tables and PivotTables as “Calculations with Criteria”, both AND Criteria and OR Criteria. 14. (33:05) PivotTable Basics: 1) Drag and Drop Field Names to add criteria to PivotTable, 2) Cross Tabulated Table, 3) Layout Formatting, 4) Number Formatting 15. (37:41) Adding Slicers 16. (40:21) Creating a Custom Style for a PivotTable 17. (44:48) Name PivotTable 18. (46:12) Create PivotTable using “Summarize Values By”, which allows us to change the Aggregate Functions like: SUM, COUNT, AVERAGE. 19. (51:49) Group Dates by Month and Year 20. (54:50) Create PivotTable using “Show Values As” to calculate “% of Column Total”. 21. (56:09) Hide items in Slicer 22. (57:24) Connect Multiple Slicers to Multiple PivotTables. 23. (58:57) Sort in PivotTable. 24. (01:00:11) Create multiple PivotTables with a single click using “Show Report Filter Pages” 25. (01:03:10) Why we need Power Query and Power Pivot Data Model 26. (01:05:21) Introduction to Power Query (Get & Transform) 27. (01:07:04) Power Query Example 1: Clean and Transform Data Table, Create PivotTable Based on Power Query Update, 3) Add new data to table and Refresh to update Query and PivotTable 28. (01:18:25) Power Query to Unpivot a Crosstabulated Table into a Proper Data Set. 29. (01:24:54) Introduction to Power Pivot and the Data Model 30. (01:25:32) Power Query to import multiple Text File tables with over one million records combine them into a single Table. We will use the “From File, From Folder” option. 31. (01:33:20) Load the million records in Power Query into the Power Pivot Data Model. 32. (01:34:42) Add an Excel Table into the Power Pivot Data Model 33. (01:35:30) Update Power Query 34. (01:36:36) Build a relationship between tables in the Power Pivot Data Model. 35. (01:38:08) Build PivotTable from Millions of Records from Two Tables 36. (01:40:34) Add new Text File to Folder and Update PivotTable. 37. (01:41:22) Summary
Views: 251355 ExcelIsFun
Map a Report or Report Template to a Data Source: Crystal Reports for Enterprise 4.0 FP3
 
05:39
Visit us at http://www.sap.com/LearnBI to view our full catalog of interactive SAP BusinessObjects BI suite tutorials.
Views: 2522 SAP Analytics
How to Analyze Sales Data with Excel
 
15:09
Learn how to analyze product sales data using Excel features like pivot tables and charts. For more info. pls. visit http://chandoo.org/wp/2010/09/22/analyzing-product-launch-sales/
Create a report template without a data source: Crystal Reports 2011
 
05:02
Visit us at http://www.sap.com/LearnBI to view our full catalog of interactive SAP BusinessObjects BI Suite tutorials.
Views: 16685 SAP Analytics
Simple Data Analysis for Teachers Using Excel
 
04:50
Exploring some basic data analysis in excel
Views: 45641 Jon Jasinski
OBIEE 11g Reports and Dashboards: Build Another Analysis Using Formatting and Column Properties
 
10:32
Build Another Analysis Using Formatting and Column Properties is an excerpt from OBIEE (Oracle Business Intelligence Enterprise Edition) 11g Reports and Dashboards Video Training: http://www.informit.com/store/obiee-oracle-business-intelligence-enterprise-edition-9780134289304?WT.mc_id=Social_YT 6+ Hours of Video Instruction -- OBIEE 11g (Oracle Business Intelligence Enterprise Edition) Reports and Dashboards LiveLessons introduces students to the querying and analytical capabilities of Oracle Analytics using the web interface. This course is primarily for business analysts or programmers utilizing OBIEE for analysis. Students will leave the course being able to produce reports and retrieve information from the Oracle RDBMS using the OBIEE web interface. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka covers how to create, modify, run, and refine ad hoc queries. Students will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports and make these reports and information easy to access (dashboards). The final lesson focuses on using BI Publisher to transform these reports into polished/formatted/quality reports in about any language or format required. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and more than 200 published articles. He is also the video author of several LiveLessons including Oracle SQL, Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons. He is frequently published in Oracle trade journals, blogs regularly, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the OBIEE interface Retrieve data in a variety of formats Use report formatting Build dashboards and pass parameters Work with the publishing tool that is included in the base product Understand a variety of tips and techniques for distributing, saving, downloading various reports and data Who Should Take This Course Business analysts Programmers Course Requirements No prior knowledge of OBIEE is required A working knowledge of BI tools would be helpful New Player Enables Streaming and Download Access Now you can stream and download videos for unlimited 24/7 online/offline access and ownership. Streaming—Watch instantly as the video streams online in real time; after purchase, simply click Watch Now to get started. Download—Download video files for offline viewing anytime, anywhere; after purchase, simply click the Download icon within the player and follow the prompts. Plus, enjoy new player features that track your progress and help you navigate between modules. http://www.informit.com/store/obiee-oracle-business-intelligence-enterprise-edition-9780134289304?WT.mc_id=Social_YT
Views: 4059 LiveLessons
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: 234656 MATLAB
OBIEE 11g Reports and Dashboards: Define the Data Sources and Create the Data Model
 
04:39
Define the Data Sources and Create the Data Model is an excerpt from OBIEE (Oracle Business Intelligence Enterprise Edition) 11g Reports and Dashboards Video Training: http://www.informit.com/store/obiee-oracle-business-intelligence-enterprise-edition-9780134289304?WT.mc_id=Social_YT 6+ Hours of Video Instruction -- OBIEE 11g (Oracle Business Intelligence Enterprise Edition) Reports and Dashboards LiveLessons introduces students to the querying and analytical capabilities of Oracle Analytics using the web interface. This course is primarily for business analysts or programmers utilizing OBIEE for analysis. Students will leave the course being able to produce reports and retrieve information from the Oracle RDBMS using the OBIEE web interface. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka covers how to create, modify, run, and refine ad hoc queries. Students will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports and make these reports and information easy to access (dashboards). The final lesson focuses on using BI Publisher to transform these reports into polished/formatted/quality reports in about any language or format required. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and more than 200 published articles. He is also the video author of several LiveLessons including Oracle SQL, Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons. He is frequently published in Oracle trade journals, blogs regularly, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the OBIEE interface Retrieve data in a variety of formats Use report formatting Build dashboards and pass parameters Work with the publishing tool that is included in the base product Understand a variety of tips and techniques for distributing, saving, downloading various reports and data Who Should Take This Course Business analysts Programmers Course Requirements No prior knowledge of OBIEE is required A working knowledge of BI tools would be helpful New Player Enables Streaming and Download Access Now you can stream and download videos for unlimited 24/7 online/offline access and ownership. Streaming—Watch instantly as the video streams online in real time; after purchase, simply click Watch Now to get started. Download—Download video files for offline viewing anytime, anywhere; after purchase, simply click the Download icon within the player and follow the prompts. Plus, enjoy new player features that track your progress and help you navigate between modules. http://www.informit.com/store/obiee-oracle-business-intelligence-enterprise-edition-9780134289304?WT.mc_id=Social_YT
Views: 2498 LiveLessons