DSFC July 2024
By Manvirender
Categories: Featured
About Course
This course is designed to give a practical exposure to one of the most sought after DataScience skills- Excel, Python and Tableau. Whether you are a beginner, a budding data enthusiast or someone looking to explore Data Science, this course would train you on exactly what industry is looking for. Live projects, live session, experienced trainer, online portfolio are some of the key take-aways.
Who can enroll ?
- professionals looking to upskill
- professionals managing or forming datascience teams
- freshers looking for job
- working professionals
- students
- technical or non-technical people
What Will You Learn?
- Excel, Powerbi and Python coding with live instructor driven sessions.
Course Content
Week 1 – Excel (Getting Started & Basics)
-
JOIN USING LINK BELOW
00:00 -
Knowing your instructor
00:00 -
Getting used to Klaymatrix portal
00:00 -
Knowing excel and its prowess
10:00 -
Quiz-Basics of Excel
-
Walkthrough important excel elements
05:00 -
Essential Keyboard Shortcuts
20:00 -
Cell Basics and referencing: Your Building Blocks
20:00 -
Quiz – Cell Referencing
-
Data types in excel
00:00 -
Vlookup and Data Validation
00:00
Week 2 – Pivot, Conditional Format and Data Granularity
-
Week 2 session Recordings
-
Quiz-vlookup and data validation
-
Data aggregations, granularity and pivot tables
00:00 -
Conditional Formatting: Highlighting What Matters
55:00 -
Quiz-Pivot Table and Conditional Formatting
Week 3 – Excel (Data Mastery)
-
Mastering Text Functions: Transform Your Data with Ease
05:00 -
Unlocking the Power of Date/Time Functions
05:00 -
Sort and Filter Data Like a Wizard: Tips and Tricks
30:00 -
Visual Storytelling: Mastering Graphs, Charts and Data Visualization
00:00 -
Excel- Text Functions
-
Week 3: Recording-Part1
46:10 -
Week 3: Recording- Part 2
56:13 -
Week 3: Recording – Part 3
56:31 -
Week 3: Recording – Part 4
29:28
Week 4 – Excel (Advanced Concepts)
-
Recording of Session
04:00:00 -
Dashboards in excel – Part 2
15:00 -
Basic Statistics using excel
00:00
Week 5 – Introduction to Power BI & Data Visualization
-
Installing Power BI
05:27 -
Join using LINK below
00:00 -
Introduction to Power BI
10:00 -
PowerBI Components
15:00 -
Basic concepts for data visualization
30:00 -
Connect with Data & Key concepts
60:00 -
Introduction to Visuals In Power BI -1
75:00 -
Recording of Session
Week 6 – Concepts, Calculations, Formatting Visuals & Dashboards
-
Join using LINK below
00:00 -
Custom Visuals, Page Layout & Formatting, Bookmarks & Selection Pane
30:00 -
Introduction to Visuals in Power BI – 2
00:00 -
Formatting in PowerBI
15:00 -
Power BI Workflow: From Planning to Interactive Dashboards
15:00 -
Recording of Session
00:00
Week 7 – Calculations, Parameters, Hierarchies, Drilldown
-
Join using LINK below
00:00 -
Hierarchies and Drill down
15:00 -
Filters and Filter Card
20:00 -
Calculated Field, Measure and Parameter
15:00 -
Recording of Session – Part 1
00:00 -
Recording of Session – Part 2
00:00
Week 8 – Power BI Service & Advanced Concepts
-
Join using LINK below
00:00 -
Insights & Anlysis in Power BI
30:00 -
Power Query
00:00 -
Data Analysis Expressions (DAX)
30:00 -
Adding further Analysis (constant line etc)
20:00 -
Power BI Services account creation guide
00:00 -
Introduction to Power BI Service
30:00 -
Power BI Embedded & Bookmarks and Buttons
30:00 -
Sharing and publishing
15:00 -
Roles
15:00 -
Session Recording – Part 1
00:00 -
Session Recording – Part 2
00:00 -
Excel Assignment
-
PowerBI Assignment
Week 9 – Getting Started with Python
-
How to install Python
00:00 -
Join using LINK below
00:00 -
Writing Clear Code: Comments and Documentation
10:00 -
The Importance of Indentation
10:00 -
Making Your Code Speak: Print Statements
10:00 -
Interacting with Users: Input
10:00 -
Essential Math: Basic Operators
15:00 -
Naming the Game: Variable Declaration and Assignment
15:00 -
Playing with Numbers: int, float and complex
15:00 -
Mastering Strings: Operations and Manipulations
20:00 -
True or False? The Boolean Data Type
15:00 -
Transformations: Type Conversion and Casting
15:00 -
Making Decisions: if Statement
15:00 -
Branching Paths: if-else Statement
15:00 -
Digging Deeper: Nested if Statements
15:00 -
Multiple Choices: elif Statement
17:00 -
Optimizing Decisions: Short-circuit Evaluation
15:00 -
Recording of session
00:00
Week 10 – Loops, Strings and Lists
-
Join using LINK below
00:00 -
Repeating Actions: for Loop
15:00 -
Staying in the Loop: while Loop
15:00 -
Directing Traffic: break and continue
10:00 -
Loop within a Loop: Nested Loops
15:00 -
Handy Helpers: Range and Enumerate
16:00 -
Creating and Manipulating Strings
15:00 -
Accessing Parts: String Indexing and Slicing
15:00 -
Powerful Tools: String Methods
10:00 -
Polishing Output: String Formatting
15:00 -
Building Bigger Strings: Concatenation and Repetition
15:00 -
List Basics: Creating and Accessing
15:00 -
Managing Content: Appending, Inserting, Removing
15:00 -
Fine-Tuning: List Slicing and Indexing
10:00 -
Sorting Things Out: List Methods
15:00 -
Efficiency Tricks: List Comprehensions
15:00 -
Recording of session
00:00
Week 11 – Tuples, Dictionaries, Sets and Functions
-
Join using LINK below
00:00 -
Download Data Set
00:00 -
Tuple Basics: Creating and Accessing
10:00 -
Organizing Data: Tuple Packing and Unpacking
10:00 -
Tuple Tools: Methods and Operations
10:00 -
Understanding Immutability
10:00 -
When to Use Tuples vs. Lists
10:00 -
Dictionary Basics: Creating and Accessing
15:00 -
Adding and Updating Items
10:00 -
Exploring Dictionary Methods
15:00 -
Clever Shortcuts: Dictionary Comprehensions
10:00 -
Nested Dictionaries: Handling Complex Data
10:00 -
Set Basics: Creating and Accessing
10:00 -
Combining Sets: Union, Intersection, Difference
10:00 -
Modifying Sets: Adding, Removing, Updating
10:00 -
Handy Set Methods
10:00 -
Set Comprehensions: Simplifying Operations
10:00 -
Writing Functions: Definition and Syntax
10:00 -
Customizing Functions: Arguments and Return Values
10:00 -
Understanding Scope and Lifetime of Variables
10:00 -
Recursive Functions: Breaking Down Problems
10:00 -
Extending Capabilities: Importing and Using Modules
10:00 -
Recording of session
00:00
Week 12 – Advanced Python Topics
-
Join using LINK below
00:00 -
Opening and Closing Files
10:00 -
Reading and Writing Text Files
10:00 -
Understanding File Modes and Pointers
15:00 -
Managing File Content: Reading and Writing Lines
10:00 -
Handling File Errors Gracefully
10:00 -
Catching Errors: try-except Block
10:00 -
Dealing with Multiple Errors
10:00 -
Targeting Specific Exceptions
15:00 -
Ensuring Cleanup: Finally Block
10:00 -
Raising Your Own Exceptions
10:00 -
Building with Classes and Objects
10:00 -
Defining Attributes and Methods
10:00 -
Leveraging Inheritance and Polymorphism
10:00 -
Keeping Things Private: Encapsulation and Abstraction
10:00 -
Lifecycle Management: Constructors and Destructors
10:00 -
Getting Started with NumPy
10:00 -
Handling Data with Arrays in NumPy
10:00 -
Performing Array Operations and Functions
10:00 -
Introduction to Pandas
10:00 -
Manipulating DataFrames in Pandas
10:00 -
How to add your certificates to LinkedIn
01:39 -
Recording of session
00:00
Student Ratings & Reviews
No Review Yet