DSFC July 2024
-
Week 1 – Excel (Getting Started & Basics)JOIN USING LINK BELOW0sKnowing your instructor0sGetting used to Klaymatrix portal0sKnowing excel and its prowess10mQuiz-Basics of ExcelWalkthrough important excel elements5mEssential Keyboard Shortcuts20mCell Basics and referencing: Your Building Blocks20mQuiz – Cell ReferencingData types in excel0sVlookup and Data Validation0s
-
Week 2 – Pivot, Conditional Format and Data Granularity
-
Week 3 – Excel (Data Mastery)Mastering Text Functions: Transform Your Data with Ease5mUnlocking the Power of Date/Time Functions5mSort and Filter Data Like a Wizard: Tips and Tricks30mVisual Storytelling: Mastering Graphs, Charts and Data Visualization0sExcel- Text FunctionsWeek 3: Recording-Part146m 9sWeek 3: Recording- Part 256m 13sWeek 3: Recording – Part 356m 31sWeek 3: Recording – Part 429m 27s
-
Week 4 – Excel (Advanced Concepts)
-
Week 5 – Introduction to Power BI & Data Visualization
-
Week 6 – Concepts, Calculations, Formatting Visuals & Dashboards
-
Week 7 – Calculations, Parameters, Hierarchies, Drilldown
-
Week 8 – Power BI Service & Advanced ConceptsJoin using LINK below0sInsights & Anlysis in Power BI30mPower Query0sData Analysis Expressions (DAX)30mAdding further Analysis (constant line etc)20mPower BI Services account creation guide0sIntroduction to Power BI Service30mPower BI Embedded & Bookmarks and Buttons30mSharing and publishing15mRoles15mSession Recording – Part 10sSession Recording – Part 20sExcel AssignmentPowerBI Assignment
-
Week 9 – Getting Started with PythonHow to install Python0sJoin using LINK below0sWriting Clear Code: Comments and Documentation10mThe Importance of Indentation10mMaking Your Code Speak: Print Statements10mInteracting with Users: Input10mEssential Math: Basic Operators15mNaming the Game: Variable Declaration and Assignment15mPlaying with Numbers: int, float and complex15mMastering Strings: Operations and Manipulations20mTrue or False? The Boolean Data Type15mTransformations: Type Conversion and Casting15mMaking Decisions: if Statement15mBranching Paths: if-else Statement15mDigging Deeper: Nested if Statements15mMultiple Choices: elif Statement17mOptimizing Decisions: Short-circuit Evaluation15mRecording of session0s
-
Week 10 – Loops, Strings and ListsJoin using LINK below0sRepeating Actions: for Loop15mStaying in the Loop: while Loop15mDirecting Traffic: break and continue10mLoop within a Loop: Nested Loops15mHandy Helpers: Range and Enumerate16mCreating and Manipulating Strings15mAccessing Parts: String Indexing and Slicing15mPowerful Tools: String Methods10mPolishing Output: String Formatting15mBuilding Bigger Strings: Concatenation and Repetition15mList Basics: Creating and Accessing15mManaging Content: Appending, Inserting, Removing15mFine-Tuning: List Slicing and Indexing10mSorting Things Out: List Methods15mEfficiency Tricks: List Comprehensions15mRecording of session0s
-
Week 11 – Tuples, Dictionaries, Sets and FunctionsJoin using LINK below0sDownload Data Set0sTuple Basics: Creating and Accessing10mOrganizing Data: Tuple Packing and Unpacking10mTuple Tools: Methods and Operations10mUnderstanding Immutability10mWhen to Use Tuples vs. Lists10mDictionary Basics: Creating and Accessing15mAdding and Updating Items10mExploring Dictionary Methods15mClever Shortcuts: Dictionary Comprehensions10mNested Dictionaries: Handling Complex Data10mSet Basics: Creating and Accessing10mCombining Sets: Union, Intersection, Difference10mModifying Sets: Adding, Removing, Updating10mHandy Set Methods10mSet Comprehensions: Simplifying Operations10mWriting Functions: Definition and Syntax10mCustomizing Functions: Arguments and Return Values10mUnderstanding Scope and Lifetime of Variables10mRecursive Functions: Breaking Down Problems10mExtending Capabilities: Importing and Using Modules10mRecording of session0s
-
Week 12 – Advanced Python TopicsJoin using LINK below0sOpening and Closing Files10mReading and Writing Text Files10mUnderstanding File Modes and Pointers15mManaging File Content: Reading and Writing Lines10mHandling File Errors Gracefully10mCatching Errors: try-except Block10mDealing with Multiple Errors10mTargeting Specific Exceptions15mEnsuring Cleanup: Finally Block10mRaising Your Own Exceptions10mBuilding with Classes and Objects10mDefining Attributes and Methods10mLeveraging Inheritance and Polymorphism10mKeeping Things Private: Encapsulation and Abstraction10mLifecycle Management: Constructors and Destructors10mGetting Started with NumPy10mHandling Data with Arrays in NumPy10mPerforming Array Operations and Functions10mIntroduction to Pandas10mManipulating DataFrames in Pandas10mHow to add your certificates to LinkedIn1m 39sRecording of session0s
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's included
- 48 hours video
- Certificate
- Articles
- Watch Offline
- Access to recorded sessions
Manvirender
Founder at Klaymatrix Data Labs
4.6Instructor Rating79
Students11
Courses5
ReviewsManvirender holds Post Graduate Diploma in Management (PGDM), M.A. in Economics and Bachelor of Technology. He has 15+ years of diverse professional experience. He has undertaken multiple critical projects and consulting assignments at national and international level. He has worked directly/indirectly with World Health Organization, National AIDS control Organization, National Health Systems Resource Center-MoHFW, NGOs/organization like FHI, ITECH-Univ of Washington, MNCs like Airtel, Evalueserve and other international clients. He is also founder of Klaymatrix Data Labs, catering to data analytics needs of clients across the globe. Training is one of his passions and he frequently delivers lectures, conducts workshops, seminars and training sessions. He has been visiting ‘Tata Institute of Social Sciences (Mumbai)’ for past few years, has been conducting hackathons at ‘Symbiosis International University (Pune)’ and has conducted multiple training/seminars for corporates, international institutions (like World Health Organization and I-TECH (Univerisity of Washington)).
View Details