Cooperative Development Authority Tender

Description Purpose: For The Conduct Of Training Provider For The Emerging Technology Workshop/ Training On May 20-24, 2024 To Be Held In Davao City A. Specific Topics: A. 1. Module 1: Meet Microsoft Power Bi A.1.1. Setting Up Power Bi Properties A.1.2. The Power Bi Interface And Workflow A.1.3. Helpful Resources A.2. Module 2: Introduction On Query Editor A.2.1. Types Of Data Connectors A.2.2. The Query Editor Interface A.2.3. Basic Table Transformations A.3. Module 3: Data Shaping With Query Editor A.3.1. Text-specific Tools A.3.2. Number-specific Tools A.3.3. Date-specific Tools A.3.4. Creating A Rolling Calendar A.3.5. Index And Conditional Columns A.3.6. Grouping And Aggregating Data A.3.7. Merging Queries A.3.8. Appending Queries A.3.9. Appending Queries From A Folder A.4. Module 4: Query Editor Configurations A.4.1. Data Source Settings A.4.2. Query Refresh Settings A.4.3. Additional Types And Categories A.4.4. Defining Hierarchies A.5. Module 5: Introduction To Data Model A.5.1. What Is A Data Model? A.5.2. Database Normalization A.5.3. Data Tables Vs Lookup Tables A.5.4. Relationship Vs Merge Tables A.6. Module 6: Creating Table Relationships A.6.1. Star Schema A.6.2. Snowflakes Schema A.6.3. Managing And Editing Relationships A.6.4. Active Vs Inactive Relationships A.6.5. Relationship Cardinality A.6.6. Connecting Multiple Tables A.6.7. Understanding Filter Flow A.6.8. Hiding Fields From Report View A.7. Module 7: Meet Data Analysis Expressions (dax) A.7.1. Introduction To Calculated Columns And Measures A.7.2. Adding Columns And Measures A.7.3. Implicit And Explicit Measures A.7.4. Filter Context Samples A.8. Module 8: Dax Syntax And Operators A.8.1. Common Dax Functions And Categories A.8.2. Basic Date And Time Functions A.8.3. Basic Logical Functions A.8.4. Text Functions A.9. Module 9: Advanced Data Analysis Expressions A.9.1. Joining Data With Related A.9.2. Math And Stats Functions A.9.3. Count Functions A.9.4. Calculated Function A.9.5. Calculate And All Function A.9.6. Calculate And Filter Function A.9.7. Iterator X Functions A.9.8. Dax Time Intelligence Formulas A.10. Module 10: Introduction To Reports And Dashboards A.10.1. The Report View A.10.2. Adding Simple Objects A.10.3. Inserting Basic Charts And Visual A.10.4. Formatting Options A.10.5. Report Filtering Options A.11. Module 11: Different Visuals In Power Bi A.11.1. Matrix Visuals A.11.2. Date Slicers A.11.3. Cards And Kpi’s A.11.4. Text Cards A.11.5. Map Visuals A.11.6. Tree Maps A.11.7. Line And Area Charts A.11.8. Trend-lines And Forecast A.11.9. Gauge Charts A.12. Module 12: Dashboard Configurations And Settings A.12.1. Editing Report Interactions A.12.2. Adding Drill-through Filter A.12.3. Preview: Custom Visual A.12.4. Preview: Publishing To Power Bi Services A.12.5. Exercises B. Mode Of Payment B.1. Send Bill Arrangement B.2. Processing Of Payment After The Conduct Of The Training And Upon Submission Of The Following: B.2.1 Training Completion Reports; And B.2.2. Receipt Of Billing. C. Duration Of Training C.1 Two (2) Days At 8 Hrs Per Day From May 22, 2024 1:00pm To May 24, 2024 12:00pm D. Training Venue D.1. The Venue Location Will Be At Davao City. The Exact Venue Will Be Announced To The Winning Provider. E. Number Of Participants E.1. The Number Of Participants To Be Trained Is Forty (40) F. Training Package Inclusions: F.1. The Training Service Provider Will Cover The Plane Fare For A Maximum Of Two (2) Persons Acting As Resource Persons. F.2. The Training Service Provider Will Provide Materials To Be Used In The Conduct Of The Training May Include Presentations, Handouts, Manuals, Audiovisual Aids, Exercises, Case Studies, And Any Relevant Reference Materials. ********nothing Follows********