About Data Analytics Course

Engaging with data using the industry-standard spreadsheet tool. You can use it to enter, manage, manipulate, analyze, and visualize data. Calculations, fundamental functions, graphing, formatting, and printing. 1. Functions like SUMIFs and VLOOKUP. 2. Using pivot tables, summarize data. 3. Database sorting and filtering. 4. Text manipulation: split and connect text, dropdown menus. 5. Advanced database features like MATCH and INDEX. 6. Build simple macros. 7. For goal-seeking and data tables, use what-if analysis.

Data analytics is the process of drawing insightful conclusions from unstructured data. The students will gain knowledge of how to manage and optimize the analytics value chain, which includes gathering and extracting the appropriate values, choosing the proper data processing, and integrating the data from different sources using programming languages like Python. It is the science of gathering data and discovering insightful patterns, trends, and other useful information. 1. Data analytics fundamentals. 2. How to utilize descriptive and inferential statistics. 3. Using data for forecasting and decision-making. 4. Today's world and the role of big data.

A general-purpose programming language that is useful for creating machine learning algorithms, automating processes, developing apps, and analyzing and visualizing data. Discover how to manipulate, examine, and visualize complicated datasets using robust open-source Python tools like Git, Pandas, and Matplotlib. 1. Describe the fundamentals of Python, including types, expressions, and variables. 2. Apply Python programming using Branching, Loops, Functions, Objects & Classes. 3. Control flow programming and conditional statements 4. Object Oriented concepts in details -reusability of code. 5. Data Structures understanding in Python including Lists, Tuples, Dictionaries, Sets. 6. Using Matplotlib -Build graphs and visualizations in python 7. using scikit-learn, Make predictions with linear regression 8. Work with data in Python using Pandas and NumPy libraries and collect data using API's and web scraping

SQL is a language that is used to communicate with databases. It is an abbreviation for Structured Query Language, which is a method of querying (questioning) the information stored in a database. 1. Getting Started and Selecting & Retrieving Data with SQL 2. Filtering, Sorting, and Calculating ,summarize Data with SQL 3. Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results 4. Subqueries and Joins in SQL 5. Advanced SQL Commands 6. Database Design 7. Modifying and Analyzing Data with SQL 8. Understanding/Querying AdventureWorks Database

Although it is rarely discussed, automation may be the single biggest payback for learning Python. I refer to software that directly substitutes for human labor as "automation." In other words, a computer software that performs things that you would ordinarily perform by hand. 1. Write scripts that follow industry best practices for syntax and conventions. 2. Python syntax and program construction 3. How to schedule your programs to run at specific times. 4. Diagnose and fix frequent errors. 5. Python instructions for updating Excel files automatically 6. How to create scripts that can be used to automate manual tasks

With a focus on data visualization, the class will begin with the Python libraries NumPy and Pandas before moving on to plotting solutions. You will learn how to use Plotly and Dash Enterprise, a potent tool for constructing dashboards, in addition to more standard plotting tools like Matplotlib and Seaborn. 1. Prepare and present a data story 2. collect, analyze, and/or modify data from a variety of sources. 3. Investigate data stories with exploratory data analysis. 4. Utilize Pandas and NumPy to manipulate data. 5. Utilize the cutting-edge Python visualization tools Plotly and Dash 6. Create a dashboard 7. Create expert data science solutions by abiding by the rules of powerful dashboard design. 8. Set up the dashboard on a live server and launch your project.

Making a computer learn by analyzing data and statistics is known as machine learning. The development of machine learning is a step toward artificial intelligence (AI). A program that analyzes data and learns to predict outcomes is known as machine learning. 1. Utilizing the scikit-learn library to apply machine learning algorithms like logistic regression and random forest. 2. Choosing quality features to feed your algorithms. 3. Separating data into training, test, and cross-validation sets appropriately. 4. How to use the Pandas library to clean and balance your data. 5. Important theoretical ideas including bias, variance, and overfitting. 6. Assessing the performance of your machine learning models.

You will learn how to create visualizations, organize data, and design dashboards in order to make more informed business decisions. You'll understand statistics, data mapping, and building data connections. 1. Understanding data 2. Tableau calculations 3. Formatting visualizations 4. Manipulating data in Tableau 5. Advanced visualization tools 6. Building Dashboards & Creating Stories 7. Publication & Distribution of your visualization 8. Intro to data maps 9. Building visualization maps 10. Advanced data manipulations 11. Building custom charts

Module 1: Introducing Microsoft Power Bi Desktop 1. Meet Power BI Desktop 2. Downloading Power BI 3. Adjusting Settings 4. Power BI Desktop Interface & Workflow 5. Resources & Monthly Updates 6. Introduction to the Project 1 dataset 7. Preliminary visualization and dashboard development Module 2: Connecting & Shaping Data 1. Power BI Front-end and Back-end 2. Types of data connectors 3. Introduction to Power Query Editor Layout 4. Transformations: a. Index and conditional column b. Calculated column c. Grouping & Aggregating d. Pivoting & Un-pivoting e. Merging Queries & Joins f. Appending Queries g. Data source setting and refreshing queries h. Folders and append queries i. Advanced queries, M Language, and customisation Module 3: Data Modeling 1. Fact Table & Dim Table 2. Primary, Foreign & Composite Key 3. Cardinality – 121, 12Many & Many21, Many2Many 4. Cross Filter Direction & Security 5. Data Model Diagrams and how Visuals interact based on the relationships 6. Star & Snowflake Schemas 7. Introduction to Project 2 Module 4: DAX 1. Dax v/s M Language 2. Introduction to Project 3 3. DAX as calculated columns 4. DAX as measures 5. Quick Measures 6. Time intelligence functions 7. Dedicated Measure Tables 8. Parameters 9. DAX Syntax & Operators