The top 8 Intelligence Analysis courses you need to take

1. Artificial Intelligence and Predictive Analysis

4

(181)

Artificial intelligence is the simulation of human intelligence through machines and mostly through computer systems. Artificial intelligence is a sub field of computer. It enables computers to do things which are normally done by human beings. This course is a comprehensive understanding of AI concepts and its application using Python and iPython. The training will include the following;What is Artificial Intelligence?IntelligenceApplications of AIProblem solvingAI search algorithmsInformed (Heuristic) Search StrategiesLocal Search AlgorithmsLearning SystemCommon SenseGenetic algorithmsExpert SystemsScikit-learn moduleWhat is Artificial Intelligence?The first idea of artificial intelligence was given by scientist Mr. Alan Turing around the time of the second world war. He suggested building a machine that can mimic the understanding of human intelligence and act like a human. Artificial Intelligence today is used in all fields of work specifically banking, insurance, manufacturing, retail, logistics and so on. Its application in medical diagnosis, robots, remote sensing, etc. is a high state of the art. AI as a subject includes the use of computer science, mathematics, statistics and domain expertise. AI has great advantages and so of them are mentioned below: It provides greater precision and accuracy on detection and predictionRobots trained on AI can be used to do the works which are difficult for usAI has created newer technological breakthroughs in our lifeFraudulent activities such as credit card transactions have become easier with AI technologiesAI can be used in time-consuming tasks and it can save a lot of time by becoming more efficient. You will be able to build the following as a practical project: -Classifiers of various typesLogic Programming based optimizersHeuristic Search performed on NP-complete problemsNatural Language Processing on text dataMachine Learning in general for several kinds of dataLogic and reasoning for model evaluation and interpretationRule-based Programming for business use casesDecision Making based on AI and MLStochastic methods such as time series and HMM...

2. Advanced Tableau for Business Intelligence & Data Analysis

4.6

(940)

If you're ready to build expert-level data analysis and visualization skills with Tableau Desktop, you've come to the right place. This course is a hands-on and project-based dive deep into several advanced Tableau topics, ranging from data relationships and calculations to predictive analytics and dynamic design techniques. As always, we'll be applying these tools to real-world business intelligence use cases every step of the way. You'll be playing the role of a newly hired analyst for Maven Roasters, a bespoke, small batch coffee roasting company. Your mission? Use advanced analytics and visual design tools to take the company's business intelligence reports to the next level. We'll kick things off by digging into relationships and the Tableau Desktop data model, exploring topics like logical vs. physical layers, contextual joins, smart aggregation, and performance optimization. From there we'll introduce a range of powerful visualization and design tools, including custom templates, dynamic formats, animations, parameter & set actions, and geospatial mapping. Last but not least, we'll cover advanced calculations like RegEx and custom LOD expressions, along with powerful predictive analytics tools like regression, forecasting, clustering, and more. COURSE OUTLINE: Tableau RelationshipsLogical & physical layers, contextual joins, smart aggregation, etc. Dynamic DesignCustom templates, KPI shapes, dynamic formatting, filter menus, etc. Parameter & Set ActionsInteractivity, relative dimensional analysis, animation, color scaling, etc. Geospatial MappingSpatial functions, custom territories, hierarchies, background maps, etc. Advanced CalculationsRegEx, advanced table calcs, LOD functions, cohort analysis, etc. Predictive AnalyticsRegression models, forecasting, clustering, R & Python integration, etc. Throughout the course, you'll come across unique opportunities to put your new Tableau skills to the test, like analyzing employee earnings for the Boston Police Department, building forecast models for the World Health Organization, and designing geospatial dashboards to help FEMA identify environmental risks. Whether you're an aspiring business intelligence analyst or data scientist, or just looking to take your Tableau skills to the next level, this is the course for you! Join today and get immediate, lifetime access to the following:11+ hours of high-quality videoAdvanced Tableau Desktop ebookDownloadable Tableau project files & solutionsHomework assignments & quizzesCourse Q & A forum30-day money-back guaranteeSee you in the course!-Dustin (Featured Tableau Author & Lead Tableau Instructor, Maven Analytics) Looking for the full business intelligence stack? Search for Maven Analytics to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses! See why Maven Analytics courses are among the TOP-RATED the BEST-SELLING analytics courses on Udemy: Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen! Russ C. This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier! Tatsiana M. Excellent from start to finish. I picked up a bunch of techniques that will be useful in the workplace, from new chart templates to some very cool advanced visualizations. I loved all of it! Robert C. Maven Analytics should become the new standard for all courses taught on Udemy! Jonah M...

3. MySQL for Data Analysis and Business Intelligence

4.7

(62)

SQL is a powerful tool and one you will likely use often as a Data Analyst. It is one of the best skills an aspiring data analyst can learn. If you want to learn SQL for data analysis as a beginner with no experience in SQL, this is the course for you. Learn SQL and build that boldness you need to apply for any data analyst job position. Here are what you are going to learn in this course; Lesson One: Introduction to SQL for Data AnalysisIn this lesson, I explained everything you need to know about SQL for data analysis. I talked about why data analyst use SQL, database, how to create a database in My SQL Workbench and different types of databases. Lesson Two: How to Import and Export Excel Files in MySQL Workbench Do you know how to export your final results in SQL after your analysis? Do you know how to save SQL script and send to someone remotely in a different location?This is what I covered in this lesson. You will learn how to import and export an Excel file in MySQL Workbench without experiencing any error. Lesson Three: Basic SQL Queries In this lesson, you will learn how to talk to database to extract data and run analysis using different SQL queries. Lesson Four: SQL JoinsAspiring Data Analysts need to know how to JOIN data. JOINS allow you to combine two or more tables. In this lesson, you will learn how to use the different types of SQL joins to join tables. Lesson Five: SQL Data CleaningIn this lesson, you will learn how to clean data in SQL as a data analyst. Lesson Six: SubqueriesSubqueries are an excellent feature within SQL, which can save you from writing endless lines of unnecessary code. In this lesson, you will learn how to write subqueries to analyze data as a data analyst. Lesson Seven: SQL Aggregate Functions An aggregate function in SQL performs a calculation on multiple values and returns a single value. In this lesson, you will learn how to summarize data with simple functions like SUM, MIN, MAX, AVG, and COUNT. And so much more! In this course, the SQL environment used for analysis is MySQL Workbench. So, you will need to have MySQL Workbench on your computer to be able to learn SQL with this course...

4. Python Foundations for Data Analysis & Business Intelligence

4.6

(879)

This is a hands-on, project-based course designed to help you master the core building blocks of Python for data analysis and business intelligence. We'll start by introducing the Python language and ecosystem, installing Anaconda and Jupyter Notebooks where we'll write our first lines of code, and reviewing key Python data types and properties. From there we'll dive into foundational tools like variables, numeric and string operators, loops, custom functions, and more. You'll learn how to create and manipulate raw data, define conditional logic, loop through iterables or indices, and extract values stored in a wide variety of data types including dictionaries, lists, tuples, and more. Throughout the course you'll play the role of a Data Analytics Intern for Maven Ski Shop, the world's #1 store for skis, snowboards and winter gear. Using the skills you learn throughout the course, you'll help the Maven team track inventory, pricing, and sales performance using your Python skills. COURSE OUTLINE: Why Python for Analytics?Introduce the Python analytics ecosystem and why it's the programming tool of choice for many data analystsJupyter NotebooksInstall Anaconda and create your first Jupyter Notebook, a user-friendly Python coding environment designed for data analysisPython Data TypesIntroduce native Python data types, common use cases, type conversion methods, and key concepts like iteration and mutabilityVariablesLearn how to name and store values in memory using variables, as well as how to overwrite, delete and track themNumeric DataLearn how to work with numeric data, and use numeric functions to perform a range of arithmetic operationsStringsLearn how to manipulate text via indexing and slicing, calculate string lengths, apply various string methods, and print f-strings to include variablesConditional LogicLearn how to use IF statements and Boolean operators to establish conditional logic and control the flow of your programsSequence Data TypesLearn how to create, modify, and nest lists, tuples, and ranges, all of which allow you to store many values within a single variableLoopsUnderstand the logic behind For and While loops and learn how to refine loop logic and handle common errorsDictionaries & SetsAddress the limitations of working with lists and explore common scenarios for using dictionaries and sets in their placeFunctionsLearn how to create custom functions in Python to boost productivity, and how to import external functions stored in modules or packagesManipulating Excel SheetsImport the openpyxl package and manipulate data from an Excel worksheet using the Python skills you've learned throughout the courseFinal ProjectImport and manipulate data from an Excel workbookJoin today and get immediate, lifetime access to the following:11+ hours of high-quality videoPython Foundations PDF ebook (300+ pages)Downloadable project files & solutionsExpert support and Q & A forum30-day money-back guaranteeIf you're an Analyst, Data Scientist, or Business Intelligence professional looking to build a strong Python foundation and add powerful skills to your resume, this is the course for you! Happy learning!-Chris Bruehl (Python Expert & Lead Instructor, Maven Analytics) Looking for our full business intelligence stack? Search for Maven Analytics to browse our full course library, including Excel, Power BI, MySQL, Tableau and Machine Learning courses! See why our courses are among the TOP-RATED on Udemy: Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen! Russ C. This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier! Tatsiana M. Maven Analytics should become the new standard for all courses taught on Udemy! Jonah M...

5. Excel Data Analytics in AML Financial Intelligence Analysis

4.5

(1,254)

I  created this course as a quick start in using Excel for AML/CFT analysis and investigation for those analysts or investigators that are looking for an alternative tool that is more affordable and has a much simpler learning curve than the conventional vendor specific analytical tools used in AML/CFT analysis and investigations.   The course is also designed to accommodate anyone who  is interested in having an insight into AML/CFT financial intelligence analysis using excel data analytics or anyone who wants to have a quick start in learning how to apply  excel data analytics  in AML/CFT financial intelligence analysis...

6. SQL for Data Analysis: Beginner MySQL Business Intelligence

4.7

(8,345)

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal. In this course, you'll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior. But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way. COURSE OUTLINE: SQL Intro & MySQL SetupWe'll start with a quick intro to the SQL landscape and it's common flavors (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)SQL Database Fundamentals (Part 1)Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions. Analyzing Data from Single Tables with MySQLIn this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.[MID-COURSE MYSQL PROJECT]SQL Database Fundamentals (Part 2)The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc. Analyzing Multiple Tables via MySQL JOINSIn this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.[FINAL MYSQL PROJECT]IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course). Enroll today and get LIFETIME access to:5+ hours of high-quality videoDownloadable MySQL ebookQuizzes and homework assignmentsMid-course and Final SQL projects30-day money-back guaranteeIf you're looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you! Happy analyzing!-John (Lead SQL Instructor & MySQL Expert, Maven Analytics) Looking for the full business intelligence stack? Search for Maven Analytics to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses! See why this is one of the TOP RATED SQL/MySQL Courses on Udemy: Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!- Maggi M. I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning - I wanted to keep charging on to the next lesson!- Ann S. John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!- Steven M...

7. Data Analysis And Business Intelligence With Microsoft Excel

4.6

(338)

The first thing you need to know about this course, is that this is NOT your granddad's Excel. Instead of the same old spreadsheet stuff, we'll do a deep dive on a truly revolutionary set of tools that empower you to do industrial-strength Business Intelligence: the art and science of transforming data - usually massive amounts of it - into meaningful, actionable insights. In the past, doing "real" BI meant using expensive enterprise software that only a select few people would have access to anyway. But with what you'll learn in this course, you'll be building robust Business Intelligence solutions in no time, using nothing more than an Excel spreadsheet on your desktop. First up, we'll dive into Power Query, a feature-packed yet easy to use tool for extracting, transforming, and loading (ETL for short) data from just about any source you can imagine into Excel. From text files to databases, wherever the data you want to analyze might be stored, you can use Power Query to pull it into Excel, and then transform it however you need to support your analysis. Next, there's an optional section on Pivot Tables, just in case you're not already familiar with them. While Pivot Tables may not be a revolutionary new feature in and of themselves, they nonetheless play a crucial role in the Excel Business Intelligence landscape. We'll then learn to turn those Pivot Tables into "Power" Pivot Tables, by connecting them to the Excel Data Model... which is basically a relational database that lives right inside your Excel spreadsheet! This will allow us to mash up and analyze multiple datasets in a single Pivot Table... no VLOOKUPS required! And remember how Excel usually starts to sputter out once you try to play around with more than a couple hundred thousand rows of data? No more! Power Pivot let's you work with up to hundreds of millions of records in a single Excel file. Then, so we can get the absolute most out of our Data Model (and into our Power Pivot Tables), we'll learn DAX, an incredibly powerful formula language for creating complex calculations that you can drop right into your Pivots. Since the basics of DAX syntax are easy to pick up if you're already familiar with Excel formulas, we'll venture into advanced topics like Time Intelligence, Iterator Functions, and Variables; and with exercises after almost every video, you'll have plenty of opportunities to master what you've learned, right after you learn it. Of course, all that number crunching doesn't help much if we can't present those numbers in an intuitive, easily digestible way. That's why I close the course out with a series of powerful visualization techniques - from conditional formatting to Pivot Charts - that will transform your calculations into insights that can be used to make real-world decisions. We'll even explore techniques for building dynamic dashboards in Excel, using Slicers and Timelines to not only filter our charts, but actually change the metrics we display in them. And all supported by the Data Model's capacity for juggling hundreds of millions of rows of data in a single spreadsheet. And in each section, I use hands-on demos, practical examples, and intuitive, common-sense explanations to teach you these concepts in a way that will help you see the connection between your new skills and the problems you're trying to solve on the job. But just as importantly, I've packed the course with TONS of exercises - ranging from straightforward to challenging - that will help you retain, and even build on, what you've learned. So if you want to master these game-changing tools and build professional-grade Business Intelligence solutions right on your desktop, all you need is Microsoft Excel - and this course - to do it. I look forward to seeing you there!...