Home
Search results “Query and analysis tools”
QGIS: Understanding and Using Attribute Data, Queries, and Analysis
 
51:26
This webinar will introduce novice QGIS and GIS users to simple analysis tools that take advantage of attribute data.
Views: 7057 VTgeospatial
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: 12273 Efficiency 365
ATLAS.ti 7-The Query Tool
 
11:33
The Query Tool allows you to retrieve quotations by codes or combination of codes, across documents or combination of documents. It combines codes with codes using Boolean, Semantic and Proximity operators, and combines documents using Boolean operators. You may learn more about this tool by reading this manual section: http://atlastitraining.files.wordpress.com/2012/03/atlas-ti-7-query-tool1.pdf
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: 3417 Jonathan Ng
SQL for the business analyst
 
01:00:01
BA Community: http://www.ModernAnalyst.com Data preparation is another problem analysts are challenged with, and knowing how write expert SQL to query and join it all. In this webinar, the database experts at Dell Software will show different tips and tricks to make you a SQL expert without writing a line of code, and how to automate SQL queries and reporting. In this webinar, you will learn: • Tools analysts can use to access different data sources, including Excel/Access, database systems, data warehouse and BI systems, and NoSQL databases. • How to visually build cross-platform SQL queries without coding • Tips to accelerate integrating data while ensuring data quality • How to automate reoccurring reporting BA Resources: http://www.DigiBytes.com Twitter: https://twitter.com/ModernAnalyst
Views: 49335 ModernAnalyst.com
Using Tools to Analyze SQL Server Query Performance
 
51:34
SQLServerZest.com
Views: 7081 Suresh Raavi
How to build a query in Toad Data Point
 
08:21
http://quest.com/products/toad-data-point/ In this video, see an overview of how to build a query in the Query Builder tool in Toad Data Point. Some topics include: an overview of the tool bar, how to interact with objects, how to create and analyze joins, how to filter and aggregate queries, and how to view and execute queries.
Views: 6544 Quest
Data Analyst Job Description | What 4 Skills Will You Need To Be A Data Analyst?
 
04:38
In this video we are going to define the job description of a data analyst, what a data analyst does, and the best online course to become a data analyst. ► Full Playlist Explaining Data Jargon ( http://bit.ly/2mB4G0N ) ► Top 4 Best Laptops for Data Analysts ( https://youtu.be/Vtk50Um_yxA ) ► Break Into the Data Industry with the best data analytics online learning resources from Edureka! ( http://bit.ly/2yCbsac ) --- affiliate link to help support this channel!^ Currently the average pay for a data analyst is $76,419 on the button, according to glassdoor I receive a lot of questions about what it takes to become a data analyst and what is a data analyst. Clearing up what a data analyst does everyday and what that description means to someone looking to enter the data science industry What will you actually be asked to do on the day to day as a data analyst. ► Top 4 Responsibilities in the Daily Life of a Data Analyst: 1 ) Mathematics Although mathematics only makes up about 20% of the day to day life of a data analyst. It is still important to have a strong understanding of the foundations of mathematics. - Addition - Subtraction - Multiplication - Division - Most Importantly --- Statistics Data analytics is all about statistics. Most of the statistics will be handled by the tools you are working with, but in order to be a great data analyst it is best to know why the tools are producing specific results. A strong understanding of statistics will be useful to you. 2 ) Computer Programming You must be able to work proficiently in one or more computer programming languages. This make up for roughly 60%-70% of your daily work. in order to analyze data it must be queried (drawn) from a large data warehouse. You will use computer programming languages such as SQL, Python, and R to query data. Before we move on let me define the term Query, if it does not resonate with you. You need strong computer programming skills in order to accomplish this task. As a data analyst you will do a lot of drawing and analyzing data. ► For more info on databases, SQL, and other jargon check out our Video Series on Data Jargon ( https://www.youtube.com/playlist?list=PL_9qmWdi19yDhnzqVCAhA4ALqDoqjeUOr ) 3 ) Know the Tools of the Trade Once you query data from the database onto your workspace you will begin to utilize data analytics tools to process, scrub, and analyze data (data Jargon explained on our Video series ^^^). You will be able to perform these tasks by using tools like Hadoop, Open Refine, Tableau, Apache Spark, etc... As you process the data you will begin to see connections between the data sets. You will see some of the following errors and you will want to remove these in order to ensure that your data analysis is accurate: - Duplicated data - Improperly formatted data - Incomplete data - Inaccurate data - This data will corrupt your findings and could possibly lose you client or employer millions of dollars. Make sure you know how to use those data analytics tools WELL! 4 ) Communicate and Present Insights Data Analyst will also be called upon to clearly and consciously present your research to clients, managers, or executives. Ok, now I know you are curious if you are capable of learning all of these crucial skills. Yes, you can, but there is a clause. You have to learn from the best. The guys over at Edureka.co are the leading professionals in the big data training industry. Based out of India, home to over 101,000 individuals in the data science industry (at the time of this writing). They are eager to make a way for themselves in the new digital economy. They are on the cutting edge of data analytics and eager to teach it to anyone worldwide. Testimonies of increased salaries, new employment, and 597,089 (updated) satisfied learners make edureka the best choice to learn the skills you need in the data industry. Question is will you actually do it. Imagine deregulating yourself for the data industry. Right now, it is a black hole, you don't know what's inside, but it is screaming opportunity from the darkness. TURN ON THE LIGHT and break into the data industry. A future proof opportunity for the next decade and beyond. ► Edureka Big Data Masters Program ( http://bit.ly/2yCbsac ) affiliate link^ ------- SOCIAL Twitter ► @jobsinthefuture Facebook ►/jobsinthefuture Instagram ►@Jobsinthefuture WHERE I LEARN: (affiliate links) Lynda.com ► http://bit.ly/2rQB2u4 edX.org ► http://fxo.co/4y00 MY FAVORITE GEAR: (affiliate links) Camera ► http://amzn.to/2BWvE9o CamStand ► http://amzn.to/2BWsv9M Computer ► http://amzn.to/2zPeLvs Mouse ► http://amzn.to/2C0T9hq TubeBuddy ► https://www.tubebuddy.com/bengkaiser ► Download the Ultimate Guide Now! ( https://www.getdrip.com/forms/883303253/submissions/new ) Thanks for Supporting Our Channel!
Views: 56708 Ben G Kaiser
Querying and Downloading Data with the Data Portal and Transfer Tool: Genomic Data Commons Workshop
 
42:09
This workshop will help introduce users to the GDC tools for downloading and retrieving data from cancer genomic studies. As an example, we will query and download open access data using the GDC Data Portal and the high performance GDC Data Transfer Tool. We will also review the process for obtaining access to controlled data and demonstrate how to generate a token for downloading controlled access data. http://gdc.cancer.gov/support/gdc-workshops
Views: 3070 NCIwebinars
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: 26618 Michael Herman
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: 1451078 ExcelIsFun
MapInfo/Discover Selecting & Querying Data clip
 
05:31
This is an excerpt from the MapInfo/Discover webinar series - Selecting & Querying Data. Understanding selections is essential if you wish to work effectively with any GIS system. These tools include: MapInfo Graphical Selection Methods - MapInfo Professional includes several tools on the Main toolbar to allow you to choose records for further viewing and analysis, including the Select tool, Radius Select tool, Marquee Select tool, Polygon Select tool, Boundary Select tool, and Invert Selection tool. Each tool is discussed in the video Discover Graphical Selection Utilities - Discover provides additional tools to select objects. These include Select by Object Style, Select by Group, Split Table. Selecting by Query - MapInfo makes finding information and locations easy. You can create subset databases of your information by using the Select function. The Query/Find Tool - Find allows you to locate individual objects. When an object is located, it is marked with a symbol.
Views: 22413 Barbara Carroll
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.
Data Analysis using Excel- Database Queries, Filters and Pivot Tables
 
54:54
I have noticed that many people throughout the world have been interested in my training videos on Using Database Queries and Pivot Tables in Microsoft Excel. So this training video, while very helpful for Active Planner customers, is applicable to any Excel user who wants to create database queries and then analyze that data using Filters and Pivot Tables. And as an added bonus, we will go into SQL Management Studio to build and debug our query and I will show you how to create a PIVOT query. I have created a new video for Sage 300 users so check it out at: https://youtu.be/HXzm8s2mVhI And Sage 500 users check out this new video at: https://youtu.be/UWJ9UrTeEr8 Thank you, Doug Leasure
Views: 169068 ActivePlanner
Analyzing Big Data in less time with Google BigQuery
 
29:14
Most experienced data analysts and programmers already have the skills to get started. BigQuery is fully managed and lets you search through terabytes of data in seconds. It’s also cost effective: you can store gigabytes, terabytes, or even petabytes of data with no upfront payment, no administrative costs, and no licensing fees. In this webinar, we will: - Build several highly-effective analytics solutions with Google BigQuery - Provide a clear road map of BigQuery capabilities - Explain how to quickly find answers and examples online - Share how to best evaluate BigQuery for your use cases - Answer your questions about BigQuery
Views: 49215 Google Cloud Platform
Don't Learn Advanced Excel Until You Watch This
 
03:15
https://www.datastrategywithjonathan.com If you're looking to learn Advanced Excel, VBA or Databases then you need to check out this video series. In this videos series, I will show you how to use 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. This Microsoft Excel tutorial is part of a series where I will take you step by step through the process of setting up a dynamic dashboard using slicers and pivot tables / pivot charts in Excel 2016. We will link directly to your data using power query (Excel 2010 and Excel 2013) which has recently been renamed to Get and Transform in Excel 2016. This solution allows you to create an advanced dashboard with no Excel VBA or complex Excel Formulas required. 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: 672 Jonathan Ng
What is Ad Hoc Reporting? | Ad Hoc Reporting
 
02:29
What is Ad Hoc Reporting and what are its benefits? Watch this demo to learn about ad hoc reporting and why it's an important feature in embedded reporting tools. To learn more about JReport's ad hoc reporting, visit http://www.jinfonet.com/resources/bi-defined/ad-hoc-reporting/
SQL for Beginners. Learn basics  of SQL in 1 Hour
 
57:13
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Buy SQL Books from Amazon at http://amzn.to/2tQcrXf Watch this Video to learn basics of SQL. This Video covers below topics about SQL. 0:01 What is SQL? 2:07 Creating a Table and Inserting Data 5:52 Querying The Table 8:03 Aggregating Data 11:24 Queries with AND OR 15:59 Querying IN subqueries 21:22 Restricting Grouped Results with HAVING 25:52 Calculating results with CASE 31:51 JOINing tables 37:15 Joining related tables with left outer joins 41:21 Changing Rows with UPDATE and DELETE 45:54 ALTERing tables after creation 49:51 Joining tables to themselves with self joins 53:50 Combining multiple joins By watching this Video we can learn how to use #SQL to store, query, and manipulate data. And, you can watch the original interactive talk-through on Khan Academy, where you can pause and edit the code and see the code in better resolution at https://www.khanacademy.org/computing/computer-programming/sql or learn SQL from http://www.w3schools.com/sql/sql_intro.asp I created this video with the YouTube Video Editor (http://www.youtube.com/editor) with creative commons permission videos provided by Khan Academy Computer Science Basic SQL Questions and Answers http://learnwebdevelopment.info/2017/11/basic-sql-questions-and-answers/ ****************************************************************** Amazon: https://www.amazon.com/shop/rajamanickamantonimuthu Twitter: https://twitter.com/rajamanickam_a LinkedIn: https://www.linkedin.com/in/qualitypoint/ ******************************************************************
Views: 1723282 Rajamanickam Antonimuthu
Business Data Analysis with Excel
 
01:46:44
Lecture Starts at: 8:25 Business data presents a challenge for the data analyst. Business data is often aggregated, recorded over time, and tends to exhibit autocorrelation. Additionally, and most problematically, the amount of business data is usually quite limited. These characteristics lead to a situation where many of the tools in the analyst's tool belt (e.g., regression) aren't ideal for the task. Despite these challenges, proper analysis of business data represents a fundamental skill required of Business/Data Analysts, Product/Program Managers, and Data Scientists. At this meetup presenter Dave Langer will show how to get started analyzing business data in a robust way using Excel – no programming or statistics required! Dave will cover the following during the presentation: • The types of business data and why business data is a unique analytical challenge. • Requirements for robust business data analysis. • Using histograms, running records, and process behavior charts to analyze business data. • The rules of trend analysis. • How to properly compare business data across time, organizations, geographies, etc.Where you can learn more about the tools and techniques. *Excel spreadsheets can be found here: https://github.com/datasciencedojo/meetup/tree/master/business_data_analysis_with_excel **Find out more about David here: https://www.meetup.com/data-science-dojo/events/236198327/ -- Learn more about Data Science Dojo here: http://bit.ly/2lF48cC -- Like Us: https://www.facebook.com/datasciencedojo/ Follow Us: https://plus.google.com/+Datasciencedojo Connect with Us: https://www.linkedin.com/company/data-science-dojo Also find us on: Google +: https://plus.google.com/+Datasciencedojo Instagram: https://www.instagram.com/data_science_dojo/ Vimeo: https://vimeo.com/datasciencedojo
Views: 40861 Data Science Dojo
Excel Tutorial: What is Business Intelligence and an OLAP Cube? | ExcelCentral.com
 
10:18
This video lesson fully explains the concepts of Business Intelligence, OLAP, MDX and and how they apply to Excel 2013. At http://ExcelCentral.com you can view over 850 free Excel video lessons just like this one. All in full HD with vari-speed and human-transcribed subtitles providing the perfect Excel learning environment. You can also track your progress through the course and print a certificate upon completion. Separate videos are provided for Excel 2007, Excel 2010 and Excel 2013. The lesson begins with an explanation of OLAP and its purpose. You'll learn about OLAP Cubes and how they are divided into Dimensions, Measure and Hierarchies to create a multidimensional data structure. You'll also learn about how the MDX query language is used to extract values from OLAP cubes. This lesson also explains the concept of Business Intelligence and how it applies to OLAP. This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills free video training course). This session includes the following video lessons: ▪ Lesson 6-1: Understand primary and foreign keys (11m 27s) http://excelcentral.com/excel2013/expert/lessons/06010-understand-primary-key-foreign-key-relationships.html ▪ Lesson 6-2: Create a simple data model (6m 31s) http://excelcentral.com/excel2013/expert/lessons/06020-create-a-simple-data-model.html ▪ Lesson 6-3: Understand OLAP, MDX and Business Intelligence (10m 17s) http://excelcentral.com/excel2013/expert/lessons/06030-what-is-business-intelligence-and-an-olap-cube.html ▪ Lesson 6-4: Use the GETPIVOTDATA function (4m 31s) http://excelcentral.com/excel2013/expert/lessons/06040-use-the-getpivotdata-function.html ▪ Lesson 6-5: Use the CUBEVALUE function to query an OLAP cube (5m 40s) http://excelcentral.com/excel2013/expert/lessons/06050-use-the-cubevalue-function-to-query-an-olap-cube.html ▪ Lesson 6-6: Convert CUBEVALUE functions to include MDX expressions (5m 48s) http://excelcentral.com/excel2013/expert/lessons/06060-convert-cubevalue-functions-to-include-mdx-expressions.html ▪ Lesson 6-7: Understand OLAP pivot table limitations (10m 52s) http://excelcentral.com/excel2013/expert/lessons/06070-understand-olap-pivot-table-limitations.html ▪ Lesson 6-8: Create an asymmetric OLAP pivot table using Named Sets (4m 57s) http://excelcentral.com/excel2013/expert/lessons/06080-create-an-asymmetric-olap-pivot-table-using-named-sets.html ▪ Lesson 6-9: Understand many-to-many relationships (11m 5s) http://excelcentral.com/excel2013/expert/lessons/06090-understand-many-to-many-relationships.html ▪ Lesson 6-10: Create an OLAP pivot table using a many-to-many relationship (12m 47s) http://excelcentral.com/excel2013/expert/lessons/06100-create-an-olap-pivot-table-using-a-many-to-many-relationship.html You can watch any of the 850 Excel video lessons, free and without any required registration at http://excelcentral.com/excel2013/expert/tutorials/default.html.
Views: 215656 ExcelCentral.com
Power BI Tutorial For Beginners | Introduction to Power BI | Power BI Training | Edureka
 
01:57:51
** Flat 20% Off (Use Code: YOUTUBE) Power BI Training - https://www.edureka.co/power-bi-training ** This Edureka "Power BI" video will help you to understand what is BI as well as Power BI (Blog: https://goo.gl/uFTDU3). Then moving on in this video we have discussed the components and building blocks of Power BI. We have also discussed lots of examples in this session. Below are the topics covered in this tutorial: 1.Why choose Power BI? 2.What is Power BI? 3.Components of Power BI 4.Architecture of Power BI 5.Building Blocks of Power BI 6.Hands On Subscribe to our channel to get video updates. Hit the subscribe button above. Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka How it Works? 1. This is a 4 Week Instructor led Online Course, 20 hours of assignment and 20 hours of project work 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. At the end of the training you will have to work on a project, based on which we will provide you a Grade and a Verifiable Certificate! - - - - - - - - - - - - - - About the Course Power BI is a powerful cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information and share insights. Edureka's Power Bi course features easy drag and drop report authoring for advanced insights , and online web dashboards that update automatically and can be shared within seconds. You begin by learning about architecture and components of Power BI along with Power Query and Power Pivot. You will learn about Data Visualization with Power BI Desktop, Power View and Power Map. Along with the process of visualization, You will learn about Power BI Q&A and how the users can discover, explore and visualize their own enterprise. You will be introduced to the Power BI Administration for deployment of files and building dashboards in the Power BI Website. After the completion of Edureka's Power BI Certification Course, you will be able to: Discuss Power BI, Power Pivot, Power view, Power Map Discuss Power Query Describe Power BI Desktop Describe DAX Explain Data Visualization State Power BI Q&A and Data insights Develop Custom Visualizations Discuss Power BI Embedded Explain Power BI with SSRS Reports Discuss the concepts around Power BI Administration - - - - - - - - - - - - - - Who should go for this Course? The Power BI training at edureka is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. For example: Business Analysts Business Intelligence Manager Statisticians and Analysts Data Scientists Project Managers - - - - - - - - - - - - - - Why learn Power BI? Power BI helps Business Analysts, Business Intelligence Manager, Statisticians & Analysts, Project Managers and Data scientists to visualize and share insights from their organizations’ data. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information from technology staff or database administrator. Power BI provides cloud based BI services - known as Power BI Services, along with a desktop based interface - called Power BI desktop. It offers Data modelling capabilities, including data preparation, data discovery and interactive dashboards. Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc., Brillio and over 45,000 MNCs across 185 countries use Power BI Please write back to us at [email protected] or call us at +91 88808 62004 for more information. Customer Review: Michael Harkins, Solution Engineer-Open Source Analytics at IBM says: "The courses are top rate. The best part is live instruction, with playback. You get all the presentations and labs. Great instructions. But my favorite feature is viewing a previous class. They provide a set of videos from a previous session, so you can watch the course before you participate. This way you can get the most out of the course. Also, they are always there to answer questions, and prompt when you open an issue if you are having any trouble. Added bonus ~ you get lifetime access to the course you took!!! I have taken so many courses and then not really gotten to work with a technology until I forgot most of what was taught. Edureka lets you go back later, when your boss says "I want this ASAP!" ~ This is the killer education app... I've take two courses, and I'm taking two more. Love these guys."
Views: 391739 edureka!
Microsoft Excel data analysis tool for statistics mean, median, hypothesis, regression
 
15:51
This video covers a few topics using the data analysis tool. After this video you should be able to: a) Find and use data analysis on excel to calculate statistics b) Calculate the mean, median, mode, standard deviation, range and coefficient variation on a variable set of data in excel. c) Conduct a confidence interval in excel. d) Complete a T-test in excel to help complete a hypothesis test. e) Conduct a linear regression analysis output from excel and create a scatter diagram.
Views: 85342 Me ee
Skyline TerraExplorer 6.5 Feature Demo
 
12:35
The new release of TerraExplorer v6.5 introduces support for stream-optimized and fully textured urban models (3DML) that can be queried and analyzed. New terrain analysis tools expand TerraExplorer's powerful viewshed capabilities (3D Viewshed Analysis and Viewshed Query) and increase shadow display/analysis options (Shadow Query and Selection Shadow). Other new analysis tools provide for easier visualization of slope data (Slope Query), and for dynamic comparison of imagery layers or of 3D View snapshots. For more information, visit us at http://www.skylineglobe.com
Views: 7245 skylinesoft
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: 73911 Excel Yoda learning
Spatial query , Query Builder , Analysis Tool ,Vector data Classification In Hindi /  हिंदी
 
13:44
This Video is specially for bsc it student Which is doing by mumbai university .. this video contains practical 3,4,5
Views: 2121 Mumbiker Suraj
Looker - Database to Dashboard Technical Demo
 
15:05
Anika Kuesters Smith, Sales Engineering Manager at Looker, takes us through the process of connecting your data to Looker, generating a model, and exploring your data in Looker. In this demo you'll learn about: - Connecting your data to Looker - Building out your data model - Creating and sharing dashboards - Generating and scheduling reports for various departments
Views: 21674 Looker
MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries
 
21:19
Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleStart.xlsx Download Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/TextFiles012.zip Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.xlsx Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.pbix Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Locale.pdf Comprehensive video about using Locale Settings so that Power Query interprets Dates and Numbers from different parts of the world correctly. In this Video learn about how to use the “Using Locale…” Feature and Regional Settings to import Text Files from Different Countries so that Dates and Numbers in Different Formats can be interpreted correct, and the multiple Text Files and be Appended into a single table. Also see how to change the Locale settings on individual columns. Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor. Topics: 1. (00:15) Introduction 2. (00:25) Text Files from Different Countries have Different Date and Number Formats 3. (02:40) Change Regional Settings in Power Query and Power BI Desktop 4. (04:28) Using Locale… Feature on Single Columns to interpret Dates and Numbers Correctly 5. (06:50) Convert ISO Dates to Proper Dates in Power Query 6. (08:04) Power BI Desktop: Import Multiple Text Files with Different Date and Number Formats From Folder and Append. See 1) Create Table in Power BI Desktop, 2) Build Custom Function 3) Import Text Files From Folder and Append 7. (20:30) Summary Assigned Homework: Download pdf file with homework description: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Homework-Start.docx Zipped Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-TextFilesForHomework.zip Example of Finished Homework in Excel: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-HomeworkFinishedExample.xlsx
Views: 2086 ExcelIsFun
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: 393556 ExcelIsFun
Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform
 
05:14
Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn how to import multiple Text Files (.txt) from a folder into Excel using the new Excel 2016 Power Query: Data Ribbon Tab, Get and Transform group. Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Views: 64095 ExcelIsFun
IEDB Analysis Resource – Package of tools for immune epitope prediction and analysis, Dr. Sinu Paul
 
54:45
The Neuroscience Information Framework Presents this week's NeuroTools Webinar on June 29th, 2018: Title: IEDB Analysis Resource – Package Of Tools For Immune Epitope Prediction And Analysis RRID: Immune Epitope Database and Analysis Resource (RRID:SCR_006604) : https://scicrunch.org/resources/Tools/record/nlx_144509-1/SCR_006604/resolver?q=*&l=&sort=internal_create_date Presenter: Dr. Sinu Paul Biography: Dr. Sinu Paul is a bioinformatics scientist at the Immune Epitope Database and Analysis Resource Project located at the La Jolla Institute for Allergy & Immunology in San Diego, California. His work is mainly focused on development of computational algorithms and tools using machine learning techniques and statistical applications for application in immunology such as immune epitope prediction and analysis of epitope related data. Synopsis of Webinar: The IEDB Analysis Resource (IEDB-AR, http://tools.iedb.org) hosts a collection of tools for the prediction and analysis of immune epitopes. Epitopes are peptides derived from antigens and recognized by T cells which in turn result in generation of immune response. Identification of epitopes is important in several areas such as vaccine discovery, development of diagnostics and removal of unwanted immune responses against protein therapeutics. Experimental identification of epitopes can be laborious and time consuming. Therefore computational prediction tools are used nowadays to select epitope candidates. The IEDB-AR provides several methods for prediction of MHC class I and MHC class II binding affinity, antigen processing, immunogenicity and B cell epitopes as well as tools for analysis of epitope related data. The talk will give an overview of important tools available at IEDB-AR and brief descriptions on how to use them and interpret the results. Related Links: IEDB Analysis Resource: http://tools.iedb.org/main/ This webinar is part of the Neuro-Tools Webinar series, for upcoming webinars please visit The Neuroscience Information Framework: https://neuinfo.org/about/UpcomingWebinars
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: 183510 APMonitor.com
Excel Data Analysis Tools
 
10:10
Learn how to use the new Data Analysis tools in Excel 2016.
Excel 2016 Dashboard Custom Grouping and Doughnut Charts - Pivot Table Dashboard Part 2
 
07:24
https://www.datastrategywithjonathan.com In this video I'm going to show you how to setup this doughnut chart from a custom grouped pivot table. From here we can see the relative proportions of employee headcount vs pay, per department grouping. In the previous video we pulled in our data via power query also known as get and transform in Excel 2016, applied a top 10 item filter and adjusted a setting to stop our dashboards from becoming distorted on refresh. This Microsoft Excel tutorial is part of a series where I will take you step by step through the process of setting up a dynamic dashboard using slicers and pivot tables / pivot charts in Excel 2016. We will link directly to your data using power query (Excel 2010 and Excel 2013) which has recently been renamed to Get and Transform in Excel 2016. This solution allows you to create an advanced dashboard with no Excel VBA or complex Excel Formulas required. 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: 126 Jonathan Ng
Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools
 
01:15
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Install Data Analysis Add-in For Amazing Excel Statistical Tools in Excel 2013.
Views: 35452 ExcelIsFun
Querying Data in ArcGIS Desktop
 
11:30
Demonstration of how to query data as part of thematically analyzing spatial data in ArcGIS Desktop, specifically, ArcGIS 10, with discussion and modeling of how to incorporate these methods into educational settings. Includes attribute and spatial querying.
Views: 36093 ESRIEdTeam
Genotype Query Tools Pedigree Analysis Example
 
02:29
Searching for putative de novo mutations in NA12878 that are passed to the next generation and are within an exon. Source code: https://github.com/ryanlayer/gqt Commands: http://bit.ly/gqt_ceph
Views: 137 Ryan Layer
Google Analytics Dashboard with Google Sheets (Reporting API)
 
10:05
http://measureschool.com/dashboard Supermetrics - http://supermetrics.com/?aff=1014 Google Analytics Dashboard and custom Reporting functionality are not always flexible enough. That’s why Digital Analyst prefer to export the data out of GA (via the Reporting API) and manipulate the data in other Tools. In this video, we’ll take a look at how you can accomplish all these with Google Sheets and a Plugin called Supermetrics. #GoogleAnalyticsDashbaords #GoogleSheets #Measure Tools mentioned: Klipfolio - http://klipfolio.com/ Tableau - http://www.tableau.com/ R - https://www.r-project.org/ Google Sheets - https://www.google.com/sheets/about/ Supermetrics - http://supermetrics.com/?aff=1014 GA Reporting API - https://developers.google.com/analytics/devguides/reporting/ Query Explorer - https://ga-dev-tools.appspot.com/query-explorer/ ******* Free Email course: http://measureschool.com/emailcourse Free Resource Library: http://measureschool.com/resources More Measure Courses: http://measureschool.com/products 🚀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
Views: 32633 Measureschool
BigQuery: Simple example of a data collection and analysis pipeline + Your questions
 
26:53
Join Michael Manoochehri and Ryan Boyd live to talk about Google BigQuery. We'll give an overview of how we're using our cars, phones, App Engine and BigQuery to collect and analyze data. We'll be discussing our trusted tester feature which allows analyzing data from the App Engine datastore. We'll also review some of the more interesting questions from Stack Overflow and take questions via Google Moderator.
Views: 7753 Google Developers
Excel "Power" Tools
 
02:07
Find out how the Excel "Power" Tools - Power Pivot, Power Query and Power View - can change your life!
Analyze MySQL Query Performance with Percona Cloud Tools
 
01:01:31
https://www.percona.com/resources/mysql-webinars - Queries are often the main culprit for MySQL database performance problems with today's workloads. The beta release of Percona Cloud Tools reveals new insights about database performance which enables you to improve the performance of your MySQL database queries and applications. The Percona Cloud Tools Query Analytics component collects and analyzes queries from your application to identify the top opportunities for improvement. Vadim Tkachenko, Percona CTO and Co-Founder, will show you how to: -Set up Percona Cloud Tools Query Analytics -Decipher advanced database query metrics -Identify the best opportunities to achieve significant query performance improvements
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: 1232817 MyOnlineTrainingHub
Module 1: Data Analysis in Excel
 
10:40
This video is part of the Analyzing and Visualizing Data with Excel course available on EdX. To sign up for the course, visit: http://aka.ms/edxexcelbi
Views: 374168 DAT206x
OBIEE 12CR training tutorial for Beginners -  Bigclasses
 
01:02:12
Bigclasses is conducting A FREE DEMO SESSION on COGNOS 10.3 today to ENROLL please visit http://bigclasses.com/obiee-online-training.html OR Feel free to call : IND: 8008 11 4040 USA: +1 732 325 1626 BIG CLASSES PROVIDES you OBIEE 12CR Tutorial for Beginners and OBIEE 12CR TRAINING in USA INDIA and OBIEE 12CR TUTORIAL and OBIEE 12CR TRAINING VISIT US @ http://bigclasses.com OBIEE 12CR Demo explains What is OBIEE 12CR? Why OBIEE 12CR ? How to learn OBIEE 12CR ? OBIEE 12CR Interview question and answers. ---------------------------------------------------------------------------------------------- VISIT us : http://bigclasses.com Email us : [email protected] Call us : +91 8008 11 4040 ----------------------------------------------------------------------------------------------- Learn OBIEE Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine.Oracle Business Intelligence online training is designed for every learner to bring greater business visibility and insight to a wide variety of users. OBIEE training provides a full range of business intelligence capabilities that allow you to: Collect up-to-date data from your organization Present the data in easy-to-understand formats (such as tables and graphs) Deliver data in a timely fashion to the employees in your organization These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes. Connect with us @ facebook :https://www.facebook.com/bigclasses twitter :https://twitter.com/bigclasses youtube :https://www.youtube.com/user/Bigclassescom linkedin :https://www.linkedin.com/company/bigclasses plus.google :https://plus.google.com/+Bigclassesonlinetraining
Views: 79 Bigclasses
How To Create Timetable and Shift In Check Time  Software
 
07:04
Check Time Fingerprint & Face Time & Attendance management System How To Install check Time Software https://www.youtube.com/watch?v=ROubwFRSz4o Quick Introduction of Check Time Software https://www.youtube.com/watch?v=O1gPQqnJ1bY how to add Edit Department https://www.youtube.com/watch?v=uX8EA... How To Add/Edit Employee Data https://www.youtube.com/watch?v=V6HrjUd1U8c How To Add/Edit Time Table and Shift https://www.youtube.com/watch?v=dpXpk7P_OAw For more info Visit Our Website #attendance #checktime http://www.check-time.com http://www.cte.my contact us : Sales Telephone +60195597808– Alvin Tang Email : [email protected] Technical Support Telephone +60146606059– Sohi Email: [email protected] #timeattendance Easy to use interface Check Time Software Dashboard module integrates information from multiple modules into a unified display. The module gives you a clean, user-friendly interface, that you can manage all data easy and fast, Shift Time Management Shift scheduling is a very important factor for any organization to optimize resources & team. It ensures that right combination of staff and supervisors are working at one time resulting in highest standard of service / to maximize the output. payroll export Payroll export capabilities We know the stress that processing payroll put on the individual or HR staff in charge of this task. Our Payroll export tool can easily create an export format as required by your payroll software or provider. Export in Excel/CSV/TXT/SQL Employee Data Management Check-Time centralized employee database, the Personal Information Management gives you the capability to easily and Manage store and utilize all aspects of your employee information.. View and search employee details when needed Leave /Time off Management Staff can submit and monitor the status of their leave requests from any internet connected device. Check Time Online Web interface. when their time off request has been approved or denied by their manager/HR Admin Attendance Report Print Easy Reporting Check-time reporting solutions you can print all report end of the month, work-time, absent report, leave report, late coming report, early going out report and over time report all report you can print by individual employee and by selecting whole department Simple Time Tracking attendance Simple Time Tracking Check-Time is a next generation time & attendance software features a powerful and easy to use interface which gives you instant real time insight to effectively manage your company’s time attendance data dramatically reducing the number of hours required to process employee time & attendance and automatically calculating total worked hours including overtime, vacation, sick days and holidays. Biometric Verification Check-time reporting solutions which give you with informed real time decision making capabilities so you can easily convert data into valuable information. Easy access for managers and executives to reporting, query, and analysis tools enables your organization to proactively manage business needs
ATLAS.ti 7 Query Tool: First steps in working with the query tool (Chapter 6)
 
20:51
In this video I show how to work with the query tool. It imight be best if you watch the presentation first (Introducing the ATLAS.ti 7 analysis tools) - this video follows up on it.
Views: 178 ATLAS.ti video blog
Import Data and Analyze with MATLAB
 
09:19
Data are frequently available in text file format. This tutorial reviews how to import data, create trends and custom calculations, and then export the data in text file format from MATLAB. Source code is available from http://apmonitor.com/che263/uploads/Main/matlab_data_analysis.zip
Views: 326004 APMonitor.com
Skyline TerraExplorer v6.5 3D Viewshed, Viewshed Query and Snapshot Comparison
 
01:57
In this movie we demonstrate how to perform a 3D Viewshed analysis, Viewshed Query and use the Snapshot Comparison tool, using TerraExplorer v6.5.
Views: 1233 skylinesoft
Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC
 
29:49
Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about how to clean and transform data to prepare it for data analysis using Formulas, Flash Fill, Power Query and Text To Columns: 1) (00:19) Intro to Import, Clean and Transform Data for this section of the class 2) (02:00) Use VLOOKUP to create better labels for our data set and for our PivotTable Report with % of Column Totals and a Slicer (Filter) 3) (05:40) Get rid of extra spaces with the TRIM Function 4) (07:11) Get rid of extra spaces with Flash Fill 5) (09:08) Formula: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates. TEXT function, Custom Number Format “0000-00-00” and add zero (any math operation) to convert number stroed as text back to a number. 6) (11:14) Text To Column: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates. 7) (12:12) Power Query: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates. 8) (15:16) Formula: Split Region and City from Same Cell. LEFT and SEARCH functions. 9) (17:19) Flash Fill: Split Region and City from Same Cell. 10) (17:44) Text To Columns: Split Region and City from Same Cell. 11) (18:43) Formulas: Get Date and Sales from a transaction description in a single cell. See the MID, SUBSTITUTE, SEARCH and REPLACE functions. 12) (23:53) Power Query: Get Department, Product, Date and Sales from a transaction description in a single cell. 13) (27:35) Compare the dynamic (ability to update when source data changes) aspects of Formulas and Power Query. 14) (28:27) Summary and Conclusion Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Views: 23439 ExcelIsFun