APCER – Data Analytics
-
Day 1 – Excel (Basics, Personalizing & Presenting Your Work)Knowing excel and its prowess10mWalkthrough important excel elements5mEssential Keyboard Shortcuts20mQuiz-Basics of ExcelCell Basics and referencing: Your Building Blocks20mQuiz – Cell ReferencingData types in excel0sVlookup and Data Validation0sQuiz-vlookup and data validationData aggregations, granularity and pivot tables0sConditional Formatting: Highlighting What Matters55mQuiz-Pivot Table and Conditional Formatting
-
Day 2 – Excel (Data Mastery) & Introduction to Power BI & Data VisualizationMastering 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 FunctionsInstalling Power BI5m 27sIntroduction to Power BI10mPowerBI Components15mBasic concepts for data visualization30mConnect with Data & Key concepts60mIntroduction to Visuals In Power BI -175m
-
Day 3 – Essential Concepts, Calculations and Interactive Dashboards
-
Day 4 – 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 publishing15mRoles15m
This course is designed to give a practical exposure to one of the most sought after Data skills- Excel. 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. The course has been created to cater to both : technical or non-technical professionals
Session Plan:
- 28th Nov 2024
- 2nd Dec 2024
- 5th Dec 2024
- 9th Dec 2024
Start time: 10:30 am
End time: 01:30 pm
What's included
- 12 hours video
- Certificate
- Articles
- Watch Offline
- Access to recorded sessions
Manvirender
Founder at Klaymatrix Data Labs
4.6Instructor Rating80
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