DACT Welcome Kit

Course description

Corporate Training Program in Data Analytics:

Syllabus

     - Data Analytics Core Concepts

     - Python L1, L2

     - SQL L1, L2

     - Power BI L1, L2

Data Analytics Core Concepts

     - Covers the core and fundamental concepts to set up a strong foundation in Data & Analytics

     - Exposes the learner to Database, Warehouse, Lake concepts

     - Covers Big Data, Metadata & Statistical Concepts in Data & Analytics 

     - Includes multiple case studies to understand the penetration of Data & Analytics

     - Covers all the Data Analytics terminologies and Data Literacy Concepts

     - Learn how statistics is related to Data & Analytics by using real-world examples

Python L1

     - Learn the core concepts of Python using Kaggle right from covering the fundamentals

     - Conditional statements, Loops, List, Tuple, Dictionary, etc,... we have covered it all

     - Learn the beginner to advance level concepts in python the right way

     - Explore control statements and learn the concept of Numpy

     - Advance List Concepts, Object-Oriented Programming, I/O & Exceptions

     - Register to become a Data Analyst

       ( 7 Days Money Back Guarantee )

Python L2

- Deep dive into the core Data Analytics library like Pandas & Numpy

- Learn Dimensional Modelling - The Python Way

  - Work on the real-world datasets to build a clean, optimized & modeled data

  - Learn Dataframe, Series, indexing, grouping, etc. for advanced data analysis

  - Date and time-series, I/O, Visualization using Seaborn will make you job-ready !!!

SQL L1

      - Learn the concepts of Relational databases and why SQL is in great demand?

- SELECT, INSERT, UPDATE, DELETE, AGGREGATION...Everything covered from scratch

      - Covers concept of all types of joins & unions

      - Interview famous concepts - Self join, subquery, CTE

SQL L2

- Learn how to write long queries in an optimized way

- Master the windows function - rank, dense rank, row number, etc

- Covers advance SQL topics like Stored procedures in an easy to understand way

      - Date-time, mathematical, string functions for data manipulation

- Group by, case-when, conditional statements ...all covered so that you can nail the interview

Power BI L1

- Step by step installation and set-up, databases & connections

- Interface walkthrough, data model pane, visualization, filter & fields

- Data Transformation using Power Query, pivot, data imputation

- Append & merge query, data manipulation & data health

- Relationships, parameters, model view

- Tree map, stack chart, decomposition tree, pie & donut map etc

Power BI L2

- Calculated columns vs measures, DAX coding language

- Aggregations, conditions, calculate, filter, row context

- Level of details function - ALL, ALLEXCEPT, ALLSELECTED, etc

- Q&A, Advance analytics, dynamic tooltip, drill through

- Bookmark, selection pane, conditional formatting etc

- Custom visuals, marketplace, query foldings and a lot more 

Prerequisite

• No prerequisites

Lesson List