Published inMicrosoft Power BI·Nov 16Business Intelligence: 5 Non-Technical TipsThese 5 tips are mainly for people who want to enter, whether it is career transitioning or if you’re a young professional searching for a position within the IT sector. Intro If you are a guy that wants to seat at your desk alone, write some DAX/SQL/Python codes as a true…Data Science4 min readData Science4 min read
Sep 193 Tips to Audit your Data with PandasIn this post, I’ll tell you Why and How you should use this 3 basic tips to audit your data using Python Pandas. Index Normalize your Data Counting Null/NaN Values Display only the COLUMNS and ROWS with Null values Extra tip — Grouping and Counting Null Values 1 Normalize your Data Why Sometimes data can…Data Science2 min readData Science2 min read
Published inMicrosoft Power BI·Sep 3Power BI: 5 Advanced Tips to Organize your DashboardIn this post, I’ll give you 5 tips to sleep better, or, why and how to organize your dashboards and avoid nightmares when the project complexity goes beyond our memory. Most of the dahsboards, in the beginning, they seem to be extremely easy, but … as the project continues and…Power Bi5 min readPower Bi5 min read
Aug 27How ChatGPT API is Charged? Understanding Models, Tokens and Limits with Python CodesHow OpenAI API works and a basic chatbot in Python. Index OpenAI API (Endpoints, Models and Limits) Tokens Costs (input and output) ChatBot (This post is being written in August/2023) If you landed in this very post, you probably here to understand how ChatGPT API is charged, therefore, I’ll be…Python9 min readPython9 min read
Published inMicrosoft Power BI·Jul 13Power BI — Version ControlIntro To control the version of your PBI dashboard you should have: Power BI Desktop (Microsoft store link) Git GitHub account Optional GitHub Desktop Visual Studio Code To visit the repository of this post, follow this link. In june/2023 Microsoft released an update for Power BI which (finally) brought us the…Power Bi3 min readPower Bi3 min read
Jun 25Data Science: International Space Station — pt.1API Source. For codes of this post, check my GitHub’s repository. Visual Studio Code and Anaconda’s JupyterLab tools will be used to this analysis. For all my posts, please click here. The ISS “It is a multinational collaborative project involving five participating space agencies: NASA (United States), Roscosmos (Russia), JAXA (Japan), ESA…Data5 min readData5 min read
Jun 22How I Documented an Entire Database From Scratch (Without DB Diagram)Privacy Due to privacy policies I will NOT disclosure ANY real name, database, table and/or content. All the content is this post was changed to preserve privacy. Scenario When I was hired and 12/april/2022, I accepted this very job due to the challenge that was offered to me, because I was looking…Data6 min readData6 min read
Nov 13, 2022Data Science: How to download Bitrix CRM with PythonThe reposity of this post My Github For all my posts Intro In my actual work, another problem showed up. Our managers requested a series of (Power BI) dashboards with our data from Bitrix24. We find this link (it’s in BR-portuguese). In this link they show you how to connect PBI…Data Science3 min readData Science3 min read
Jul 25, 2022How I am Learning Computer Vision — Pt.2 — Mathematics and ColorsPrevious post: https://igorcomune.medium.com/how-i-am-learning-computer-vision-pt-1-b1bf22804e0c I barely started my study about Computer Vision and my mathematicians skills started killing me… I really do not remember if I studied Linear Algebra in my school days, but I am sure that during my Bachelors I did not. Eigen Values, matrices, scalar values, span… what…Data Science6 min readData Science6 min read
Jul 17, 2022How I am Learning Computer Vision — Pt.1Objective Learn Computer Vision Share my Learning Path Intro And as I said in my last post I was hired as BI Analyst. And If you read my post “How I Got into the World of Data Science” you already know part of my history and how I got to where I…Computer Vision2 min readComputer Vision2 min read
