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 10sWeek 3: Recording- Part 256m 13sWeek 3: Recording – Part 356m 30sWeek 3: Recording – Part 429m 28s
-
Week 4 – Excel (Advanced Concepts)
-
Week 5 – Introduction to Power BI & Data Visualization
-
Week 6 – Concepts, Calculations, Formatting Visuals and DashboardsJoin using LINK below0sHierarchies and Drill down15mFilters, Filter Cards Formatting20mAdding further Analysis (constant line etc)20mMeasures15mCalculated Field15mParameters15mFormatting in PowerBI15mDashboards/Reports in PowerBI15mPlanning and Creating Reports15mPutting up the idea on PowerBI desktop20mAdding and Modifying Interactions15mCustom Visuals, Page Layout & Formatting, Bookmarks & Selection Pane30m
-
Week 7 – Data Analysis Expression (DAX)
-
Week 8 – Power BI Service & Advanced Concepts
-
Week 9 – Getting Started with PythonWriting 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 Evaluation15m
-
Week 10 – Loops, Strings and ListsRepeating 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 Comprehensions15m
-
Week 11 – Tuples, Dictionaries, Sets and FunctionsTuple 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 Modules10m
-
Week 12 – Advanced Python TopicsOpening 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 Pandas10m
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 Rating73
Students8
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