PyPbitExtractor

Name	PyPbitExtractor JSON
Version	1.2.0 JSON
	download
home_page
Summary	Extract Measures and its Description, Source Information, and Relationships from Power BI template.
upload_time	2023-03-24 12:43:38
maintainer
docs_url	None
author
requires_python	>=3.7
license	MIT License Copyright (c) [2023] [Akash Rajak] Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
keywords	dax formatter excel json openai power bi pbit
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

## ✔ Power BI Automation Using Open AI API
### Problem Statement:
- Power BI documentation is essential for maintaining the accuracy and integrity of data models, ensuring compliance with regulations, and improving collaboration and efficiency across teams.
- It is a time-consuming task that requires more human intervention and is highly error prone.
- Our model aims to automate this process using OpenAI's NLP capabilities.

****

### Purpose:
- The purpose of our Power BI model documentation automation is to provide a Time-saving and Accurate solution for fetching pbix details. Below are the purpose that our model is fulfilling:
- Automating the Power BI model documenter using one of the most efficient GPT-3 architecture i.e. `text-davinci-002`.
- Fetched the `Measures`, `Source Information`, and `Model Relationships` attributes from the Power BI report.
- Wrote back the Measures and Modification Descriptions and displayed on hovering the respective properties in updated pbit files.
- Presented the output into three directories, namely `EXCEL`, `JSON` and `Updated PBIT`.

****

### Input/Output Deliverables:
```
- Input:
- Single File
- Multiple Files
- A Folder

- Output:
- Excel Directory
- JSON Directory
- Updated PBIT Directory
```

****

### Features:
- Implemented following features in our model:
1. Features in JSON Deliverables:
- `DataModelSchema Generation`: Generated the datamodelschema file for the respective pbit file and stored it in JSON format.

2. Features in EXCEL Deliverables:
- `Measure Sheet`:
- Measure Name
- Measure Expression
- Measure Data Type
- Measure Description
- `Source Information Sheet`:
- Table No
- Table Name
- Table Mode
- Table Type
- Table Source
- Original Table Name
- Table Query
- Modification
- Modification Description
- `Relationships Sheet`:
- From Table
- From Column
- To Table
- To Column
- State
- Direction
- Cardinality

3. Features in UPDATED PBIT Deliverables:
- `Dynamic Hover Description`: Made the Measures and Modifications Description to hover on each respective properties.

****

### Prerequisites:
- In order to use this script, one need to ensure to met the following requirements:
- A Power BI Desktop installation (version - 2.115.663.0 64-bit).
- A valid API secret key for OpenAI's NLP capabilities.
- Python 3.7 or later installed on your machine.
- Access to the Power BI models that you want to document.

****
****

## ✔ Package Description
### PyPbitExtractor
- Created a python package for the given python script and published it on https://pypi.org/

### Package Usage
```
- from PyPbitExtractor import Extractor
- This command will install all the uninstalled required libraries used in script.
- Extractor.api()
- This command will prompt user for Open API Secret Key.
- Extractor.main()
- This will prompt user for input of file selection and thereafter the repective file/folder.
```

### Package Installation
```bash
pip install PyPbitExtractor
```

Raw data

            {
    "_id": null,
    "home_page": "",
    "name": "PyPbitExtractor",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.7",
    "maintainer_email": "Pragya Gautam <pragyagautam020801@gmail.com>, Akash Rajak <aakashrajak02@gmail.com>, Ayush Jain <jainaayush051@outlook.com>",
    "keywords": "DAX Formatter,EXCEL,JSON,OpenAI,Power BI,pbit",
    "author": "",
    "author_email": "Akash Rajak <aakashrajak02@gmail.com>",
    "download_url": "https://files.pythonhosted.org/packages/b1/d0/c88cc4964a2730b7a87b251cfbef74f03cf968aa5751ec3ea98993df2b04/pypbitextractor-1.2.0.tar.gz",
    "platform": null,
    "description": "## \u2714 Power BI Automation Using Open AI API\n### Problem Statement:\n- Power BI documentation is essential for maintaining the accuracy and integrity of data models, ensuring compliance with regulations, and improving collaboration and efficiency across teams. \n- It is a time-consuming task that requires more human intervention and is highly error prone. \n- Our model aims to automate this process using OpenAI's NLP capabilities. \n\t\t\n****\n\n### Purpose:\n- The purpose of our Power BI model documentation automation is to provide a Time-saving and Accurate solution for fetching pbix details. Below are the purpose that our model is fulfilling:\n    - Automating the Power BI model documenter using one of the most efficient GPT-3 architecture i.e. `text-davinci-002`.\n    - Fetched the `Measures`, `Source Information`, and `Model Relationships` attributes from the Power BI report.\n    - Wrote back the Measures and Modification Descriptions and displayed on hovering the respective properties in updated pbit files.\n    - Presented the output into three directories, namely `EXCEL`, `JSON` and `Updated PBIT`.\n\n****\n\n### Input/Output Deliverables:\n```\n- Input: \n    - Single File\n    - Multiple Files\n    - A Folder\n\n- Output:\n    - Excel Directory\n    - JSON Directory\n    - Updated PBIT Directory\n```\n\n****\n\n### Features:\n- Implemented following features in our model:\n    1.\tFeatures in JSON Deliverables:\n        - `DataModelSchema Generation`: Generated the datamodelschema file for the respective pbit file and stored it in JSON format.\n\n    2.\tFeatures in EXCEL Deliverables:\n        - `Measure Sheet`:\n            - Measure Name\n            - Measure Expression\n            - Measure Data Type\n            - Measure Description\n        - `Source Information Sheet`:\n            - Table No\n            - Table Name\n            - Table Mode\n            - Table Type\n            - Table Source\n            - Original Table Name\n            - Table Query\n            - Modification\n            - Modification Description\n        - `Relationships Sheet`:\n            - From Table\n            - From Column\n            - To Table\n            - To Column\n            - State\n            - Direction\n            - Cardinality\n\n    3.\tFeatures in UPDATED PBIT Deliverables:\n        - `Dynamic Hover Description`: Made the Measures and Modifications Description to hover on each respective properties.\n\n****\n\n### Prerequisites:\n- In order to use this script, one need to ensure to met the following requirements:\n    - A Power BI Desktop installation (version - 2.115.663.0 64-bit).\n    - A valid API secret key for OpenAI's NLP capabilities.\n    - Python 3.7 or later installed on your machine.\n    - Access to the Power BI models that you want to document.\n\n****\n****\n\n## \u2714 Package Description\n### PyPbitExtractor\n    - Created a python package for the given python script and published it on https://pypi.org/\n\n### Package Usage\n```\n- from PyPbitExtractor import Extractor\n    - This command will install all the uninstalled required libraries used in script.\n- Extractor.api()\n    - This command will prompt user for Open API Secret Key.\n- Extractor.main()\n    - This will prompt user for input of file selection and thereafter the repective file/folder.\n```\n\n### Package Installation\n```bash\npip install PyPbitExtractor\n```",
    "bugtrack_url": null,
    "license": "MIT License  Copyright (c) [2023] [Akash Rajak]  Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the \"Software\"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:  The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.  THE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.",
    "summary": "Extract Measures and its Description, Source Information, and Relationships from Power BI template.",
    "version": "1.2.0",
    "split_keywords": [
        "dax formatter",
        "excel",
        "json",
        "openai",
        "power bi",
        "pbit"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "bb94c91c75eb327660e84bd85f3f9765de99384e963e08a9c06564bda0c6acf1",
                "md5": "7ed3996b77adfc0a38160f8cf7ba4777",
                "sha256": "f52da12c2d31f521e309c6d6371836026981688b8f2ccc8f2159caa86dda43e0"
            },
            "downloads": -1,
            "filename": "pypbitextractor-1.2.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "7ed3996b77adfc0a38160f8cf7ba4777",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.7",
            "size": 9197,
            "upload_time": "2023-03-24T12:43:32",
            "upload_time_iso_8601": "2023-03-24T12:43:32.251678Z",
            "url": "https://files.pythonhosted.org/packages/bb/94/c91c75eb327660e84bd85f3f9765de99384e963e08a9c06564bda0c6acf1/pypbitextractor-1.2.0-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "b1d0c88cc4964a2730b7a87b251cfbef74f03cf968aa5751ec3ea98993df2b04",
                "md5": "271877d0172af8b5af76191efe89b1f6",
                "sha256": "4e64ff1f87e751bfe8a878c3ff654b7695720daf49a279505c664d20ad49d900"
            },
            "downloads": -1,
            "filename": "pypbitextractor-1.2.0.tar.gz",
            "has_sig": false,
            "md5_digest": "271877d0172af8b5af76191efe89b1f6",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.7",
            "size": 9845,
            "upload_time": "2023-03-24T12:43:38",
            "upload_time_iso_8601": "2023-03-24T12:43:38.741196Z",
            "url": "https://files.pythonhosted.org/packages/b1/d0/c88cc4964a2730b7a87b251cfbef74f03cf968aa5751ec3ea98993df2b04/pypbitextractor-1.2.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-03-24 12:43:38",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "lcname": "pypbitextractor"
}