October 13, 2024

📊Power BI: Introdução

Claudio Ctin4 mins
📊Power BI: Introdução

O Power BI é uma poderosa ferramenta de análise de Dados desenvolvida pela Microsoft, amplamente utilizada para transformar dados brutos em informações significativas por meio de visualizações interativas.
Se você está começando sua jornada no mundo de dados , este guia o ajudará a entender o que é o Power BI, suas principais funcionalidade e como você pode utilizá-lo para melhorar suas análises.

Índice

O que é o Power BI?
Como começar com o Power BI?
Referências](##Referências

O que é o Power BI?

É uma ferramenta de Business Intelligence (BI), é possível gerar relatórios e dashboards que mostram números, estatísticas, valores, listas e gráficos de maneira simples e intuitiva. Permitindo aos usuários visualizar e compartilhar informações de maneira eficiente, coletando , transformando e analisando dados de diversas fontes.

Como começar com o Power BI?

Instalação do Power BI Destktop

Faça o download do Power BI Desktop aqui

Instale a aplicação seguindo as instruções

Conectando-se a Fontes de Dados

Abra o Power BI Desktop e clique em ” Obter Dados”
Escolha a fonte de dados desejada( Ex: SQL Server, Excel, CSV, Txt, etc..), em seguida , carregue os dados

3.Transformando e Modelando Dados

Utilize o Editor de Consultas para transformar seus dados, opções de : filtrar, combinar e limpar os dados conforme necessário

Crie relacionamentos entre diferentes tabelas de dados para permitir análises mais complexas

4.Criando Visualizações

Arraste e solte os campos para a área de relatório e escolha o tipo de visualização que deseja usar ( gráficos de barras, gráficos de pizza, tabelas, ect).
Customize suas visualizações com cores, rótulos e filtros para torná-los mais informativos

5.Publicando e Compartilhando Relatórios

Quando seu relatório estiver pronto, clique em ” Publicar” para enviar para o Powerr BI Server, no Power Bi Service, você pode compartilhar relatórios com outros usuários e configurar atualizações automáticas de dados

_O Power BI Desktop é gratuito. No entanto para compartilhar projetos, colaborar e publicar relatórios é necessário adquirir uma versão paga como Pro,Premium ou PPU.

O Power BI é uma ferramenta extremamente completa, e exploraremos mais detalhes em outros posts desta série

Referências

Microsoft
Ebac
Expertime

Please follow and like us:
fb-share-icon
Tweet
Pin Share

Stiri similare

Introducing Handbooks for Tech: Documentation Got “Better”

Introducing Handbooks for Tech: Documentation Got “Better”

Claudio Ctin

Visit the website | Contact form Hello beautiful developers! Being a developer, one of the most boring things I come across is reading Documentation for hours. Despite being the best source of information for using software, their monotony and complexity are sometimes unbearable. That’s when an idea hit me— can I make them better? Well,…

RMAG news

How to write a great one-pager

Claudio Ctin

One-pagers are the fastest mechanism the software industry uses to gain alignment. A one-pager is a document which outlines a problem’s context and exposes potential solutions to solve the problem. After a one-pager is made available, it is often presented in a review process to drive toward a decision. This one-pager outlines the non-obvious rules…

Unlock 650+ Pokémon in 5 Steps: Build Your Dream Index with Vanilla JavaScript

Unlock 650+ Pokémon in 5 Steps: Build Your Dream Index with Vanilla JavaScript

Claudio Ctin

Get ready to catch ’em all with our latest project: building a Pokémon index using the Pokémon API and vanilla JavaScript. To kick things off, let’s define our project’s goals. We’ll create a user-friendly search bar where users can look for their favorite Pokémon, and when they search, the Pokémon’s image and stats will be…

Productivity Tools to have #1: Google Keep

Productivity Tools to have #1: Google Keep

Claudio Ctin

Hello, We all tend to forget little things and having little reminders is extremely helpful to stay mindful and stop procrastinating. Today, I want to share a tool with you that works like an index for your brain’s database. Google Keep Benefits Minimalistic Cross Platform (Also comes as a widget in Android) Cloud-based – Stays…

RMAG news

Why Vivaldi Might Be the Browser You’ve Been Waiting For

Claudio Ctin

Why Vivaldi Might Be the Browser You’ve Been Waiting For In a web dominated by mainstream browsers, Vivaldi stands out as a refreshing alternative, offering a unique approach to browsing that prioritizes customization, privacy, and user empowerment. If you’ve ever felt that your current browser falls short of catering to your specific needs, Vivaldi might…

RMAG news

2406. Divide Intervals Into Minimum Number of Groups

Claudio Ctin

2406. Divide Intervals Into Minimum Number of Groups Difficulty: Medium Topics: Array, Two Pointers, Greedy, Sorting, Heap (Priority Queue), Prefix Sum You are given a 2D integer array intervals where intervals[i] = [lefti, righti] represents the inclusive interval [lefti, righti]. You have to divide the intervals into one or more groups such that each interval…

LLM Basics: The Transformer Model

LLM Basics: The Transformer Model

Claudio Ctin

Welcome to the first part of several articles outlining the basics of Large Language Models. For some context, I am a software engineer, and not a data scientists, so it may have a more suitable bearing towards those implementing LLMs (training, deployment), but who knows. If you are a data scientist, or at least a…

My First Hacktoberfest as a Maintainer: The Highs and Lows

My First Hacktoberfest as a Maintainer: The Highs and Lows

Claudio Ctin

This is a submission for the 2024 Hacktoberfest Writing challenge: Maintainer Experience This year, I participated in Hacktoberfest for the first time, both as a contributor and a maintainer. My project, CampX, is an open-source platform where people can discover and share campgrounds from across the globe. Built using HTML, CSS, JavaScript, Node.js, Express.js, and…

Using Localized LLM to Fill in Client Requirement Gaps

Using Localized LLM to Fill in Client Requirement Gaps

Claudio Ctin

Challenges in Gathering Requirements In 200+ websites and mobile apps, I have yet to see a client show up with a full set of requirements for their project. In fact, many of our clients are academics who have limited knowledge of software development. More importantly, they often have domain-specific knowledge that far exceeds our own….

RMAG news

The Concept of My Life as an IT Guy

Claudio Ctin

You ever wake up and wonder, “How did I end up here?” Because, let’s be real, no kid grows up saying, “I want to spend my adult life turning things off and on again to fix people’s tech issues.” But here I am, living the IT guy life, and honestly? It’s a wild ride. Somehow,…

RMAG news

AWS Network Load Balancer, cross-zone enabled now supports zonal shift and zonal auto-shift

Claudio Ctin

What’s new at AWS 📢 ❎ AWS NLB supports Amazon Application Recovery Controller’s zonal shift and zonal auto-shift features on load balancers that are enabled across zones. ❎ This zonal shift allows customer to quickly shift traffic away from an impaired Availability Zone and recover from events such as bad application deployment and gray failures….

RMAG news

Materialized Views in SQL | Best Explanation

Claudio Ctin

Materialized Views in Oracle SQL, covering all the important aspects concisely. 1. Definition: A Materialized View (MView) is a database object that stores the result of a query physically on disk. Unlike a regular view, which is a virtual table that always reflects the current data of the underlying tables, a materialized view stores a…

RMAG news

What is Data Engineering?

Claudio Ctin

Simply defined, data engineering is the set of processes and techniques for collection, validation, treatment and modeling made so that raw data becomes quality data and accessible to end users, thus enabling future analyses. The engineering process is the gear between the extraction/collection of sources (ERP, Excel, etc.) and the availability of processed and validated…

RMAG news

O que é Engenharia de Dados?

Claudio Ctin

Definindo de forma simples, a engenharia de dados é o conjunto de processos e técnicas de coleta, validação, tratamento e modelagem feitos para que dados brutos se tornem dados de qualidade e acessíveis aos usuários finais, assim possibilitando análises futuras. O processo de engenharia é a engrenagem entre a extração/coleta da fonte (ERP, Excel, etc.)…

RMAG news

Python Inheritance Explained: Types, Examples, and Best Practices

Claudio Ctin

Inheritance is one of the cornerstones of object-oriented programming (OOP), enabling a class to inherit properties and behaviors from another class. This feature promotes code reusability, makes it easier to maintain code, and fosters a hierarchical relationship among classes. In Python, inheritance is simple to implement and offers various types to accommodate different programming needs….

Elevate Your JavaScript Mastery: 10 Free Resources for Developers

Elevate Your JavaScript Mastery: 10 Free Resources for Developers

Claudio Ctin

Unlock the full potential of your JavaScript skills with this carefully curated collection of free online tutorials and resources. Whether you’re a beginner looking to build a solid foundation or an experienced developer seeking to expand your expertise, this comprehensive guide has something for everyone. 🚀 JavaScript ES6 and Beyond: Embrace the Future of the…

ServBay Version 1.4.6 Upgrade Announcement

ServBay Version 1.4.6 Upgrade Announcement

Claudio Ctin

We are excited to announce that the latest version 1.4.5 has released. Let’s see what’s new. UPGRADE NOW! User Experience Improved Caddyfile validation logic. Added error handling for CA root certificate installation failures. Enhanced stability. Package Updates Service management script updated to 1.0.4. Bug Fixes Fixed version number validation logic to correctly identify new versions…

RMAG news

Are Multi-Agent Systems the Future of AI? A Look at OpenAI’s Swarm Experiment

Claudio Ctin

Are Multi-Agent Systems the Future of AI? A Look at OpenAI’s Swarm Experiment Artificial Intelligence has evolved rapidly, from simple chatbots answering basic queries to AI agents handling more complex tasks. But as AI grows, so does the complexity of coordinating these agents. The next step forward seems to be orchestrating multiple agents working together,…

RMAG news

Simplifying Union Types and Arrays in TypeScript

Claudio Ctin

When working with TypeScript, you might find yourself needing to define a union type and an array containing all of the possible values of that type. A common approach is to write something like this: type Taste = ‘しょうゆ‘ | ‘みそ‘ | ‘とんこつ‘; const tastes = [‘しょうゆ‘, ‘みそ‘, ‘とんこつ‘]; At first glance, this seems fine….

hhhhh

hhhhh

Claudio Ctin

<h2>kkkkkk</h2> .product-category { margin-bottom: 5px; a { color: #adadad; font-size: 12px; } } private getWishlistItems() { if (this.userService.isUser) { this.wishlistService.getWishlistByUser().subscribe({ next: res => { this.wishlists = res.data; this.wishlist = this.wishlists.find(f => (f.product as Product)._id === this.product?._id); console.log(“this.wishlist“,this.wishlist) if (this.wishlist){ this.isWishlist=false }else { this.isWishlist=true } }, error: error => { console.log(error); } } ); } }…

RMAG news

Create an AP with Network Manager

Claudio Ctin

sudo nmcli dev wifi hotspot ifname [wlan0] ssid [smartmapsportable] band bg password [smartmapsportable] Please follow and like us:

JavaScript Error Handling — Try, Catch, Throw, Finally

JavaScript Error Handling — Try, Catch, Throw, Finally

Claudio Ctin

Error handling in JavaScript is important to deal with mistakes or problems that happen while your code is running. JavaScript gives you a few simple tools to handle errors and keep your code from crashing: try: You use this to test a piece of code. If everything works fine, it runs without issues. catch: If…

DebConf24, a conference trip

DebConf24, a conference trip

Claudio Ctin

때는 날씨가 더워지기 시작했던 5월과 6월 사이의 어느 날… Debian 개발자들의 연례 행사인 DebConf24가 대한민국 부산에서 열린다는 소식에 땀을 닦지도 않은 채 등록을 시작했다. 국제 컨퍼런스가 한국에서 열린다고 하니 통 크게 놀아보고 싶어 발표까지 하기로 마음먹었다. 청중을 위한 발표이니 영어를 사용해야했지만 무섭지 않았다. 이번이 아니면 큰 무대에서 발표할 수 있는 기회가 얼마나 많을까 싶은 마음뿐이었다….

My 2024 Hacktoberfest Maintainer Experience: 💔 Building and Growing ImagePro 🚀

My 2024 Hacktoberfest Maintainer Experience: 💔 Building and Growing ImagePro 🚀

Claudio Ctin

My 2024 Hacktoberfest Maintainer Experience: Building and Growing ImagePro This is a submission for the 2024 Hacktoberfest Writing Challenge: Maintainer Experience Hey there, I’m Jackson Kasi 🙂👋, and I’m excited to share my journey as a maintainer during this year’s Hacktoberfest. My project, ImagePro, a Figma plugin, started as a fun experiment but grew into…

A supplement to Copilot and Cursor – utilizes AI for batch processing of project codes

A supplement to Copilot and Cursor – utilizes AI for batch processing of project codes

Claudio Ctin

GITHUB: https://github.com/qiangyt/batchai I often rely on ChatGPT and GitHub Copilot, but it is a little bit frustrating to constantly copy and paste between the copilot chat window and my open code files. Why not update the files directly? I also tried using Cursor, which solved the first problem, but still have to open each file…

How to make your terminal looks Splendid

How to make your terminal looks Splendid

Claudio Ctin

Hello I’m Jairo a semi senior software engineer who works with Java and Kotlin and loves coding with the most beautiful IDE and Terminal of my team rs. Today, I’m going to explain to You how to make your terminal the best terminal ever, the most beautiful one. WARP First thing, we need to choose…

Deno 2.0 Takes Flight

Deno 2.0 Takes Flight

Claudio Ctin

The web is humanity’s largest software platform, boasting over 5 billion users, and growing. However, as the demand for web development soars, so does its complexity. Between endless configuration files, mountains of boilerplate, and an overwhelming number of dependencies, developers are spending more time wrestling with setup than building the next big thing. 😎 Enter…

RMAG news

Refactor a code factor

Claudio Ctin

Greetings, This week we had to learn about refactoring an existing code base. This was a new experience for me as a student you don’t often have to go back to an old assignment. However, since we were working with our existing AI CLI tool we had something to work with. Additionally, we also had…

RMAG news

Membuat Landing Page Sederhana dan Cepat dengan ReactJS, Vite, dan Tailwind CSS

Claudio Ctin

Pendahuluan Landing page yang efektif dapat menjadi alat yang ampuh untuk menarik perhatian audiens dan meningkatkan konversi. Dalam artikel ini, kita akan membahas cara membuat landing page modern menggunakan Vite sebagai build tool, ReactJS sebagai framework UI, dan Tailwind CSS untuk styling yang efisien. Membuat Struktur Komponen Landing Page Buat komponen dasar seperti LandingPage, Home,…