Curriculum:
- Introduction of Excel compare MS Excel 2016 with other Excel versions
- Copy/Paste, Paste Special
- Add and Edit Comments
- Fill Effects
- Wrapping text within a cell
- Data Formatting
- Filter, Advanced Filter, Color Filter
- Sorting, Advance Sorting, Custom Sorting
- Flash Fill Feature
- Text to column functionality of excel to Split words
- Absolute, Relative and Mixed Cell References
- Protect sheet and workbook
- Protect Range
- Table Feature
- Freeze and unfreeze panes and Split
- Excel Keyboard Shortcut Keys
- Conditional and Custom formatting
- Understanding the number format codes
- Changing the font color with number format codes
- Hide Number and Text based on criteria
- GOTO SPEICAL Feature
- Creating Name range and Name Manager
- Hyperlink from a different sheet, workbook, cell, defined names and websites
- Remove Duplicates
- Data Validation: Data List, rules, modify error messages
- Grouping, ungrouping and Subtotal in Excel
- COUNT, COUNTA, COUNTBLANK
- COUNTIF
- COUNTIF with wildcard
- Uses of COUNTIF with real-time example
- Unique Entry using the COUNTIF function
- Find duplicates using COUNTIF Function
- Running Count
- Example of COUNTIFS
- Example of SUMIFS
- Example of AVERAGEIFS
- Example of DCOUNT
- Example of COUNTA
- Example of DSUM
- Example of DAVERAGE
- Logical Functions: IF, Nested IF, AND, OR, NOT, XOR, IFERROR
- SMALL and LARGE function
- SUMPRODUCT Function
- Use SUMPRODUCT for COUNT
- Use SUMPRODUCT for SUM
- Use SUMPRODUCT for COUNTIF and COUNTIFS
- Use SUMPRODUCT for SUMIF and SUMIFS
- Use SUMPRODUCT for AVERAGE and AVERAGEIFS
- Use SUMPRODUCT for MAXIF and MAXIFS
- Introduction of TEXT Functions (LEFT, RIGHT, MID, REPLACE, SUBSTITUTE, etc) available in Excel
- Use text functions to Split the words
- Use text functions to split characters and numbers What-If Analysis in Excel
- Introduction of Date Functions available in excel.
- Create and Design Calendar using Different Date Functions (WEEKDAY, WEEKNUM, EOMONTH, EDATE) in excel.
- Calculate Age using DATEDIF Function
- Calculate the date and time difference
- count working days using NETWORKDAYS Function
- Introduction of LOOKUP VLOOKUP and HLOOKUP
- VLOOKUP with Exact Match
- VLOOKUP with Approximate Match
- Usage of VLOOKUP Functions using ROW and COLUMN functions
- Example of VLOOKUP with Array
- Example of HLOOPKUP with multiple Examples
- Example of LOOKUP with multiple examples
- Introduction of the INDEX Function
- Introduction of OFFSET Function
- Use of INDEX Function
- Advance uses of Array Function using INDEX, OFFSET, MATCH, SMALL, LARGE, ROW, and COLUMN function Use of ROW and ROWS function using INDEX and OFFSET function
- Introduction of INDIRECT Function
- Introduction of ADDRESS Function
- Uses of INDIRECT Function
- Uses of ADDRESS Function
- Creating a Pivot table and Pivot chart in Excel
- Adding Slicer and Timeline to analyze in Excel
- Using the power pivot to do the Data Analysis
- Using Power Query to Source the data from Different Sources
- Introduction of Dashboards and MIS Reports
- Adding and Using User Form control in Excel
- Recording Macro and run it through a command button
- Creating Dynamic Formula based on` User Form control
- Creating Dynamic Charts using Formula
- Creating 2D charts in Excel
- Importance of charts in Dashboards and MIS Reports
- Project work on MIS Dashboard
- Introduction to RDBMS concepts
- Normalization Technique
- SQL Server Architecture
- Introduction to Microsoft SQL Server
- Introduction to SQL Server Management Studio
- Installation of SQL server Management Studio
- Introduction of Language Statements (DDL, DML, DCL, TCL)
- Creating table and DDL commands
- Introduction of Import and Export Wizard
- SQL Data Types
- SQL Constraints
- SQL Indexing
- Select Statement
- SQL Distinct keyword
- SQL Where Clause
- SQL wild card concept
- SQL Group by and Having clause
- SQL CASE statements
- Introduction of Join
- Inner Join
- Outer Join
- Left Join
- Right Join
- Self Join
- Cross Join
- Concept of Nested Join with Where Clause
- SQL Update Statement
- SQL Insert Statement
- SQL Delete Statement
- SQL Transaction control Language
- SQL Number Functions
- SQL Date Functions
- SQL Text Functions
- SQL Special Functions
- SQL Scalar Subqueries
- SQL Multivalued Sub Queries
- SQL Table Values Sub Queries
- SQL Common Table Expression
- SQL UNION, UNION ALL, INTERSECT AND EXCEPT
- SQL CROSS APPLY operator
- SQL RANK function
- SQL DENSE_RANK function
- SQL ROW_NUMBER function
- SQL Over Clause
- SQL If condition
- SQL While Loop
- Creating Stored Procedure
- Modifying Stored Procedure
- Creating User Defined Function
- Modifying User Defined Function
- SQL Pivot and Unpivot Concept
- Implementing T-SQL Error Handling
- Redirecting Errors with Try/Catch
- Using THROW to pass an error message back to a client
- Applying Error Handling in Stored Procedure
- Introduction of Cursor
- Creating cursor
- Modifying cursor
- Detailed description about Index
- Query optimization
- Performance Tuning
- Introduction to Visualization
- Why Business Intelligence
- Introduction to Power BI
- Power BI Architecture
- Components of Power BI
- Power BI Flow
- Introduction of Power BI Desktop
- Power BI Licensing (Free vs Pro vs Premium)
- Power BI Desktop Installation
- Power BI Desktop User Interface and Views
- Types of Data Sources in Power BI
- Data Loading Modes and Advantages
- First Row Header
- Duplicate Columns
- Split Columns
- Remove Duplicate/Columns
- Replace Value
- Change Data Type
- Group BY
- Pivot and Unpivot
- Formatting data
- Add Custom Columns
- Invoke Function
- Append Queries
- Join Merge Queries
- Combine Files (Folder)
- Parameters
- Other Query Features
- Components of Data Modeling
- Introduction to Data Models
- Data Model Engine
- Types of Data Model (Flat, Star & Snowflake)
- Granularity of Data & multiple fact tables
- Data Modeling Relationships
- One to One
- One to Many
- Many to Many
- Roll Playing Tables
- Sorting/Renaming/Hiding Tables
- Hierarchy Creation
- Formatting & Data Category
- Grouping / Binning
- Drill Through Reports
- What IF Parameter
- Designer Options
- Power BI Visualization Types
- Custom Visualization
- Best Practices
- Choosing Colors
- Types of Charts and Usage
- Slicers / Filters
- Creating Complete Visualization Report (Practical)
- Continue Creating Complete Visualization Report (Practical)
- Story Telling with the created Report
- Bookmarks / Selection Pane
- Spotlight
- Drill Through
- Additional Features
- Publishing / Deploying Reports
- Apps Workspace & Roles
- Creating Dashboard
- Q&A
- Quick Insights
- Dashboard Options
- Subscription
- Alerts
- Export Options (Embed, Web, Power Point…etc.)
- Excel Integration
- Row Level Security
- Data Refresh Concept
- Gateway and Installation
- Power BI Mobile Service
- Power BI Admins Roles
- Audit Logs
- Introduction DAX
- DAX Data Types
- Calculated Columns
- Calculated Tables
- Calculated Measures
- Calculated Columns vs Measures
- Aggregated Functions (SUM, MIN, MAX, AVG, COUNT)
- Relate Functions (RELATED & RELATED TABLE)
- Iterative Functions (SUMX, AVGX, COUNTX)
- Variables (VAR)
- Logical functions (AND, OR, IF, SWITCH)
- Table Functions (VALUES, FILTER, CALCUILATETABLE)
- FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, UNION, ROW, ADDCOLUMNS, SUMMARIZE
- Handling Blanks (ISBLANK, NOTISBLANK)
- Rank Functions (RANKX)
- CALCULATE (ALL, ALLEXCEPT, ALLSELECTED)
- Understand Row & Table level Filter Context
- Date Functions (DATEADD, DATEDIFF, TODAY Required Date Formats)
- Calendar Functions (CALENDAR, CALENDAT AUTO)
- Time Intelligence functions (TOTALMTD, TOTALQTD, TOTALYTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, PARALLELPERIOD, RUNING TOTAL)
- SEMI ADDITIVE (OPENING BALANCE, CLOSING BALANCE, LAST DATE, FIRST DATE, LASTNONBLANK, FIRSTNONBLANK)
- Project 1
- Project 2
- Introduction to Programing Language
- Introduction to Python
- History of Python
- Why Python and Comparison with all languages
- Version of Python
- Environment Setup
- Discussed about IDE
- In window
- Mac
- Variables
- Comments
- Data Types in Python
- Numbers
- String
- List
- Tuple
- Dictionary
- Operators
- I/O Functions
- Type Conversion
- Basic Introduction
- If, If else, Nested if and elif
- Loops
- Basic Introduction
- Need of Loop
- While Loop
- For Loop
- Introduction
- Pre Define Functions
- User Define Functions
- Lambda Function
- String
- List
- Tuple
- Dictionary
- Section introduction
- Raising our own error
- Try and Except Block
- Try, Except, Else and Finally
- Debugging with PDB
- TTP Introduction
- HTTP verbs and API
- Writing your First Python Request
- Requesting Json with Python
- Sending Request with Params
- API Projects
- Section Introduction
- Defining Class and Objects
- Abstraction and Encapsulation
- Creating Class and Instances
- INIT Method
- Introducing the class Attributes
- Class Methods
- Inheritance and Objectives
- All about the Properties
- Introduction to Super
- Polymorphism Introduction
- Some Special Methods
- Section Introduction
- Iterators vs Iterables
- Writing own Custom iterators
- Writing our own Version of Loops
- Making a Deck Class Iterable
- Testing Memory Usage with Generators
- Generator Expression and Speed Testing
- Higher Order Functions
- Introduction to Decorators
- Decorators with Different Signature
- Using Wraps to preserver Metadata
- Building a Speed Test Decorator
- Section Introduction
- Why Test
- Assertions
- Introduction to Doctest
- Introduction to Unit Test
- Hands on work on Testing
- Section Introduction
- Reading the Text File: Open, read and Write
- Reading the File: Seek and Cursor
- The with Statement
- Writing to Text File
- Working on Csv and Pickling
- Reading CSV File
- Writing CSV File
- Introduction to Web Scraping
- Is Scraping ok?
- Selecting with Beautiful Soup
- Navigate with Beautiful Soup
- Web Scraping Projects
- Introduction to Regular Expression
- Writing basic Regix
- Regix basic Quantifiers
- Introduction to the section
- Installing Mysql
- Why Mysql
- Sql Basic: DDl , DML
- Inserting with Python
- Fetching the Data in Python from MySQL
- There will be Assignment on Each and Every Section
- Hands-on experience on Each and Every Section
- Interview Questions will also be discussed
- By this Content you can get a Job in Python Language
- Project 1
- Project 2
Fee:
Online Virtual Class Room
Enroll in any above batch and attend live class at scheduled time
28320Upcoming Batches:
FAQ:
Recommended Courses:
Recommended courses
Data Science with Python
AWS Solutions Architect Certification Course
Informatica ETL
Data Engineering
Reviews:
Sep-15-2023
The best part about this class was its relevance. The projects were often based on real data sets, which made the learning experience authentic
Sep-15-2023
The course material was well-structured, and the instructor was always available to answer questions. The practical experience gained through projects was a highlight
Sep-15-2023
I had zero background in data analytics before this class, but now I feel like I can confidently tackle real-world data problems.
Sep-15-2023
Taking the data analytics class was a game-changer for me. The instructor made complex concepts easy to understand, and the hands-on projects were incredibly valuable.
Sep-15-2023
Taking the data analytics class was a game-changer for me. The instructor made complex concepts easy to understand, and the hands-on projects were incredibly valuable.
Sep-14-2023
"Taking the data analytics class was a game-changer for me. The instructor made complex concepts easy to understand, and the hands-on projects were incredibly valuable. I learned how to use various tools like Python, Excel, and SQL to analyze data effectively. Highly recommended!"
Sep-04-2023
I am Bindu . I was working in Wounderman Thompson at gurgaon location. due to some reason i was looking an opportunity in chennai but due to recession and all i was not able to get it . i joined Wifi Learning for Data Analytics training program . after complettion of just three modules i got an opportunity at my preferred location. i am very thankful to wifi learning for helping me . it became possible just because of the dedication of entire team .
Sep-04-2023
Hi, i am Daksh , being a fresher it was difficult to me to get a job .i joined Data Analytics program . it is very good training experience . even i did not complete my trainig one module is still running and i got placed as data analyst . Thanks to the entire team of wifi learning for support and right guidance
Feb-08-2023
hello, i am rishi If you want get real time experience during training I would like recommend you to join Wifi Learning because you will get training by only professional trainer who is actually working in corporate .
Feb-08-2023
I am nikhil I got training in Data Analytics . it really help us to get my first job . this Data Analytics training program is the best program . it really help you to make your career
Feb-08-2023
I am avinash i placed in a reputed company in the middle of my training . I would like to thanks to the entire team of Wifi Learning because of them I achieved this milestone. Very good training center in terms of Training quality. Training content is upto the corporate requirement . Thank you so much sir for helping me to get placement after a long gap in my career . your training helps me a lot special thanks to the placement cell of Wifi Learning for providing me such a great opportunity . Thank you once again .
Feb-08-2023
I am rashi I got training in Data Analytics . it really help us to get my first job . this Data Analytics training program is the best program . it really help you to make your career . it doesn’t matter whether you are from IT background or non-IT Background .
Feb-08-2023
Hello I am Rohit , I have taken class of Data Analytics from wifi learning few days back , even I have not completed my training , my one module is still remaining because I placed in a reputed company in the middle of my training . I would like to thanks to the entire team of Wifi Learning because of them I achieved this milestone.
Aug-26-2021
Very good trainer , good course you should get experience with wifi learning
Aug-26-2021
It was great experience , for me it was vert difficult to find a place where we can get industry expose . finally at wifi
