
A detailed discussion on what Alteryx and data analytics topics we are covering in this course. This course will be very useful for ETL developers and/or Data analysts and Data scientists looking for enhancing or starting their career into the world of Business Intelligence and Business Analytics
A motivating video providing a reason of why you should take up the course. You should take up the course because Alteryx is an easy to understand tool, We have included intuitive slides so that we can make this training interactive, the course is very comprehensive as it is focused not just on data analysts but also on software developers, we are also covering interview questions and 2 elaborated projects towards end of this course.
In this lesson we will discuss about agenda items for this lesson and entire course. The agenda items will be (1) Trainer introduction - Background and experience (2) Alteryx course outline. (3) Why you should take up this course
An education background about trainer and how he evolved his career into development and data analytics industry. A brief about the extensive training experience Steven has on niche technologies like Informatica, Alteryx, Tableau, SAS DI Studio, Spark, Hadoop, Advanced SAS. These technologies are used in Business Intelligence and data analytics space.
Agenda slide on importance of data and history of data spurt. Database concepts and jargons.
Jargons used in databases like What is database, structured data
Jargons used in databases like semi-structured data, unstructured data, ETL, variable, observation, data type.
Understanding of core concepts of data bases like Primary key, foreign key. How are tables maintained in a relational database and what is the relevance.
Agenda slide on Core Concepts of ETL & data processing tools, Core Concepts of Analytics & Analytical tools and Application of Analytics
Understanding the ETL concept i.e Extract, transform and load of data. How does ETL work in creating a enterprise data warehouse. Discussion on various ETL tools available.
Evolution of data from raw data sources to a meaningful insights. Before a decision is made by the stakeholders of company how is data processed and the tedious transformation it goes through. Various analytical tools available.
Certain industry use cases where analytics can be used to take business decisions.
Agenda discussion on - Downloading Alteryx Designer - 14 day trial version, Alteryx at a Glance, Servers and platforms & A deep dive into Alteryx - Options available in Alteryx Tool.
A video on how to download Alteryx designer a 14 day trial software on your local desktop.
Accessing Alteryx. Look and feel of Alteryx. What does various ribbon and tools do in Alteryx.
Different modules of Alteryx with industry relevance. Modules of Alteryx are Alteryx Designer, Desktop Automation and Alteryx Server
A detailed discussion on some of tools in Alteryx. How to make use of canvas to define workflows.
History of Alteryx, What all can Alteryx do and capabilities of Alteryx.
Why Alteryx? - Alteryx as a ONE STOP SHOP. Provides solutions for ETL, Visualization and Data/Statistical Analytics. Alteryx – An end to end tool.
Importing a data from raw data file that can be csv or excel or flat files or a Database.
Importing a data from raw data file using Input Tool in Alteryx and how to visualize data in Alteryx in table format.
Using Text Input tool to manually create a dataset in Alteryx with Variables and observations.
Various kinds of Character, Numeric and date data types in Alteryx. Refer to below link for various data types:
https://help.alteryx.com/current/Reference/DataFieldType.htm
Basic understanding of how to save a Alteryx dataset and workflow. Various formats of Alteryx files.
Efficient management of variables and tables size with Auto field tool functionality in Alteryx.
Visualizing the large volume of data with Browse tool. Since all records are not visible by default in Alteryx and if you want to visualize data with more than 7,000 records, it can be visualized with Browse tool.
An understanding of data variables is imperative for a BI or Data Analyst. Types of variables are classified into Quantitative and Qualitative at a broader level. Quantitative variables are further classified into Continuous and Discrete. Qualitative variables are further classified into nominal and ordinal.
In this course we will make you a champion in Alteryx tool. From data extraction to business analytics this course will give you a good direction to kick start with your aspirations of delivering in Business Intelligence and/or Data Analytics. We will be majorly focusing on Business Intelligence and will add concepts of Analytics. You will learn how to extract data from raw data sources, manipulate data and utilize data for running linear and logistic regression models besides machine learning models like SVM and DT. You will also understand forecasting for a time series driven data.