Tutorials on Project Management:
- https://www.guru99.com/initiation-phase-project-management-life-cycle.html
- https://www.knowledgehut.com/tutorials/project-management
- https://www.projectengineer.net/tutorials/project-management/
or
Pressman E-Book Download Link (8th Edition):
https://invent.ilmkidunya.com/images/Section/12.pdf
Pressman E-Book Download Link (7th Edition):
https://www.mlsu.ac.in/econtents/16_EBOOK-7th_ed_software_engineering_a_practitioners_approach_by_roger_s._pressman_.pdf
Sample User Stories:
https://www.mountaingoatsoftware.com/uploads/documents/example-user-stories.pdf
Scrum Guide PDF:
https://scrumguides.org/docs/scrumguide/v2020/2020-Scrum-Guide-US.pdf#zoom=100
Chapter-3 - UML and www.draw.io Resources:
For Diagram Making:
https://app.diagrams.net/
Tutorial Link for Draw.io:
https://www.youtube.com/watch?v=Em_8IeJBmsQ&list=PLX6xdk86h_0xpW82Q0YkdN6xpHa6hvHjO
draw.io Desktop Version Download Link:
https://www.drawio.com/blog/diagrams-offline
YouTube UML Tutorial Link:
https://www.youtube.com/watch?v=gUEizau0-UQ&list=PLWPirh4EWFpF9Gbnu4_DdF4ITHSN6MSsk
UML Text Toturial Link:
https://www.geeksforgeeks.org/unified-modeling-language-uml-introduction/
UML Project Diagram Samples:
https://in.pinterest.com/meeraacademy/project-uml-diagram/
- MS-Office 2007: https://edu.gcfglobal.org/en/topics/office2007/
- MS-Office 2010: https://edu.gcfglobal.org/en/topics/office2010/
- MS-Office 2013: https://edu.gcfglobal.org/en/topics/office2013/
- MS-Office 2016: https://edu.gcfglobal.org/en/topics/office2016/
- MS-Excel Formulas: https://edu.gcfglobal.org/en/excelformulas/
- 50 Tips to Master Excel ebook: https://app.box.com/s/63dckolyo5syiks5wj670cdnc94b5xv0
- How to remove password from an Excel Worksheet: https://www.youtube.com/watch?v=fsVb6id97_E&list=PLmkaw6oRnRv9uEamCt-PXS-bP-rmoxcLc&index=3
- MS-Excel Cheat Sheet: https://drive.google.com/file/d/1dGDoOiIhFFD71FxUxMO-ZYYE2UYLNGhR/view?usp=sharing
Prompt Engineering Tutorials and Resources:
- ChatGPT Tutorial - A Crash Course on Chat GPT for Beginners: https://www.youtube.com/playlist?list=PLubh2aIGoECLHt4_wNdMVFBEp8Btnjy5_
- Prompt Engineering | Master Speaking to AI: https://www.youtube.com/watch?v=N2Pbed0Q89U
- Eight Things to Know about Large Language Models: http://arxiv.org/pdf/2304.00612v1
- ChatGPT Code Interpreter: The New Frontier in AI Programming: https://softgist.com/chatgpt-code-interpreter
- ChatGPT Documentation API Reference: https://www.promptingguide.ai/introduction/settings
- ChatGPT Parameter Settings: https://platform.openai.com/playground/chat?models=gpt-3.5-turbo-16k
- Prompt Engineering Tutorial-1: https://www.geeksforgeeks.org/chatgpt-tutorial/
- Prompt Engineering Tutorial-2: https://developer.nbg.gr/sites/default/files/PromptEngineeringF.pdf
- Prompt Engineering Tutorial-3: https://www.promptingguide.ai/introduction/settings
- Prompt Engineering Tutorial-4: https://developers.google.com/machine-learning/resources/prompt-eng
- Prompt Engineering Tutorial-5: https://learnprompting.org/docs/intro
- Prompt Engineering Tutorial-6: https://www.mygreatlearning.com/blog/prompt-engineering-complete-guide/
- Prompt Engineering Tutorial-7: https://datasciencehorizons.com/wp-content/uploads/2023/06/Mastering_Generative_AI_and_Prompt_Engineering_Data_Science_Horizons_Final_2023.pdf
MS-Copilot Resources by Microsoft
- Learn to Use Microsoft Copilot: https://learn.microsoft.com/en-us/copilot/tutorials/learn-microsoft-copilot
- Quotas, limits, app registration, certificates, and configuration values for Copilot for Service: https://learn.microsoft.com/en-us/microsoft-copilot-service/about-limits-quotas
- Supported languages for Microsoft Copilot: https://support.microsoft.com/en-us/office/supported-languages-for-microsoft-copilot-94518d61-644b-4118-9492-617eea4801d8
- Start your Copilot journey: https://copilot.cloud.microsoft/en-us/prompts?Form=MD1AFI&CLRTags=c_udf%7E%24%7EMod1CTA1ClearGoal%7E%24%24%7Ec_cmp%7E%24%7EEmailTileCard%7E%24%24%7Ec_type%7E%24%7ETextHyperlink%7E%24%24%7Ec_pos%7E%24%7E3A_%7E_CLRTags_%7E_&ocid=
- Learn about Copilot prompts: https://support.microsoft.com/en-us/topic/learn-about-copilot-prompts-f6c3b467-f07c-4db1-ae54-ffac96184dd5?ocid=copilotlab_smc_articlelearnabout%3FForm%3DMD1AFI&CLRTags=c_udf%7E%24%7EMod1CTA2MoreDetail%7E%24%24%7Ec_cmp%7E%24%7EEmailTileCard%7E%24%24%7Ec_type%7E%24%7ETextHyperlink%7E%24%24%7Ec_pos%7E%24%7E4A_%7E_CLRTags_%7E_&ocid=
- Microsoft Copilot – Microsoft Adoption: https://adoption.microsoft.com/en-us/copilot/
- Introducing Microsoft 365 Copilot | Microsoft 365 Blog: https://www.microsoft.com/en-us/microsoft-365/blog/2023/03/16/introducing-microsoft-365-copilot-a-whole-new-way-to-work/
- Microsoft Copilot for Microsoft 365 | Microsoft 365: https://www.microsoft.com/en-us/microsoft-365/enterprise/copilot-for-microsoft-365
- Compose and summarize documents with Copilot in Word - Training | Microsoft Learn: https://learn.microsoft.com/en-us/training/modules/explore-possibilities-microsoft-365-copilot/2-compose-summarize-documents-copilot
- Introduction - Training | Microsoft Learn: https://learn.microsoft.com/en-us/training/modules/explore-possibilities-microsoft-365-copilot/1-introduction
- Summarize and draft emails with Copilot in Outlook - Training | Microsoft Learn: https://learn.microsoft.com/en-us/training/modules/explore-possibilities-microsoft-365-copilot/3-summarize-draft-emails-copilot
- Design captivating presentations with Copilot in PowerPoint - Training | Microsoft Learn: https://learn.microsoft.com/en-us/training/modules/explore-possibilities-microsoft-365-copilot/4-design-presentations-copilot
- Analyse and transform data with Copilot in Excel - Training | Microsoft Learn: https://learn.microsoft.com/en-us/training/modules/explore-possibilities-microsoft-365-copilot/5-analyze-transform-data-copilot
- Elevate productivity with Copilot in Teams - Training | Microsoft Learn: https://learn.microsoft.com/en-us/training/modules/explore-possibilities-microsoft-365-copilot/6-elevate-productivity-copilot-teams
- Overview of Copilot for Power BI (preview) - Power BI | Microsoft Learn: https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction
- Oracle Tutorial: https://www.oracletutorial.com/
- Oracle/SQL Tutorial: Oracle Tutorial
- SQL Tutorial for Beginners: Learn SQL in 7 Days: https://www.guru99.com/sql.html
- Oracle Live SQL Account Creation link: https://livesql.oracle.com/
- Oracle Notes and PPTs: https://github.com/toarnabtrainer/vodafone_oracle_batch86
- Korth Chapter-4 (SQL) Queries: https://github.com/toarnabtrainer/Oracle_Notes/blob/main/Oracle%20Korth%20SQL%20Chapter-4.md
- Oracle Join Operations: https://github.com/toarnabtrainer/Oracle_Notes/blob/main/Join_Operations.md
- Korth Chap-4 Exercise Link: https://github.com/toarnabtrainer/MySQL_Notes/blob/main/MD-4%20Korth%20Exercise%20(Questions).md
- Korth Chap-4 Exercise with Answer Link: https://github.com/toarnabtrainer/Oracle_Notes/blob/main/Korth%20Chap-4%20Exercise%20(Answers).md
- Transforming ERD to Database: https://github.com/toarnabtrainer/Oracle_Notes/blob/main/ERD%20to%20Database.md
Power BI Download and Tutorial Links:
- PowerBI Download Link: https://www.microsoft.com/en-us/download/details.aspx?id=58494
- Tutorial and Official Documentation on MS-Power BI Link: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
- Learn Power BI: https://powerbi.microsoft.com/en-us/learning/
- Power BI for Absolute Beginners: https://www.tutorialspoint.com/power_bi/index.htm
Important Classwork Resources:
- HTML Color Codes: https://htmlcolorcodes.com/
MS-Power BI Data Compresion Capability:
- PracticeData1.xlsx -> Size 705 KB
- ClassWork.pbix (After all data import) -> Size 64 KB
- ClassWork.pbix (After Unpivot) -> Size 56 KB
- ClassWork.pbix (After Country_Sales Query creation) -> Size 61 KB
- ClassWork.pbix (After Total_Sales_PQEW) -> Size 65 KB
- ClassWork.pbix (After Total_Sales_PBIDW) -> Size 66 KB
- ClassWork.pbix (After Total_Sales measure creation) -> Size 66 KB
- ClassWork.pbix (After Total_Sales_Measure column creation) -> Size 67 KB
Table Formats:
* Wide Format (Unstacked Format) ------------------------> Long Format (Stacked Format) Unpivot Operation * Long Format (Stacked Format) ------------------------> Wide Format (Unstacked Format) Pivot Operation
Assignment on Merge operations:
- Query-1: List those product details which has no discount.
Output: - Query-2: List only those discounted product details along with discount amount and discounted price.
Output: - Query-3: Against all products, display discount amount and discounted price. Fill with 0 where discount % is null.
Output: - Query-4: List those category details which has no product.
Output:
Lookup/Dimension Tables and Data/Fact Tables:
Lookup Tables or Dimension Tables will have Primary Keys, will answer Who, What, Where, When and How
Data Tables or Fact Table will have Foreign Keys, and will contain transactional data
Lookup/Dimenation Tables: Customer (Who), Product (What), Territories (Where), Calendar (When and How)
Data/Fact Tables: Sales, Budget
Operations on Budget Workbook:
- Delete the promoted header
- Delete first 3 null rows
- Promote the first row as a header
- Delete last total column
- Filter out rows from the first column containing “Total”
- Unpivot month columns labelled from Jan to Dec
- Rename new created columns to Month and BudgetAmount
- Change the data type of Month column to Date
- Select close and apply
Data Relationships for the Budget Project:
- Sales(CustomerKey) -> Customer(CustomerKey)
- Sales(OrderDate) -> Calendar(Date)
- Sales(ProductKey) -> Product(ProductKey)
- Sales(SalesTerritoryKey) -> Territories(SalesTerritoryKey)
- Budget(ProductKey) -> Product(ProductKey)
- Budget(Month) -> Calendar(Date)
Suggested DAX Formulaes for Creating Measures:
- MyBudget = SUM(Budget[BudgetAmount])
- MySales = SUM(Sales[SalesAmount])
- MyVariance = [MySales] - [MyBudget]
- MyVariance% = DIVIDE([MyVariance], [MyBudget], 0)
- MyComments = IF([MyVariance] < -100000, "Take Care", IF([MyVariance] < 0, "Not OK", "OK"))
Suggested Tables Summaries (After filtering on Year 2016):
- Table1: Calendar[Year], Calendar[Month], Sum of Sales[SalesAmount]
- Table2: Calendar[Year], Calendar[Month], Sum of Budget[BudgetAmount]
- Table3: Territories[Country], Sum of Sales[SalesAmount]
- Table4: Calendar[Year], Calendar[Month], Sum of Sales[SalesAmount], Sum of Budget[BudgetAmount]
- Table5: Calendat[Year], Calendar[Month], Budget[MySales], Budget[MyBudget], Budget[MyVariance], Budget[MyVariance%], Budget[MyComment]