
Exam DA-100: Analyzing Data with Microsoft Power BI
All my blog posts on DA-100 subject you can find it here; all topics I’ve used, reference links, resume, summaries, videos, etc. My goal here is to really share actual and practical content that I used to get certified. I really hope it can help you too. Have fun!
Power BI architecture for multiple developers
Power BI architecture for multiple developers, Setting up a collaborative Power BI environment, Multi-developer Power BI implementation, Building a scalable Power BI solution, Power BI workspace collaboration, Implementing a shared Power BI data model, Developing a Power BI architecture for team collaboration, Setting up Power BI for team-based development, Best practices for Power BI collaboration,…
Cloud Glossary | Azure – AWS – GCP
I have been studying, and working with, Microsoft Azure, Amazon AWS and Google Cloud Platform. They are all cloud platforms and they all work in similar ways, so here on this post I will try to add all terms that I find that are shared across them all. Topics Worth Knowing well for any Cloud…
AWS Certified Solutions Architect Associate SAA-C03 | Well-Architected Framework
Here are some basics links for AWS Well-Architected Framework: Overview – https://aws.amazon.com/architecture/well-architected/ Docs – https://docs.aws.amazon.com/wellarchitected/latest/framework/welcome.html Whitepaper – https://docs.aws.amazon.com/pdfs/wellarchitected/latest/framework/wellarchitected-framework.pdf AWS Well-Architected Framework Pillars We must know all pillars, but pay some special attention to Sustainability.
AWS Certified Solutions Architect Associate SAA-C03 | Overview
Below are the basic details about the exam. Format: Multiple choice and multiple response questions only Type: Associate Delivery method: Pearson VUE testing center or online proctored exam Number of questions: 65 Time: 130 minutes Cost: 150 USD Languages offered: English, French (France), German, Italian, Japanese, Korean, Portuguese (Brazil), Simplified Chinese, Spanish (Latin America), Spanish…
AWS Certified Solutions Architect Associate SAA-C03 | Glossary
Another certification I’m working on, the AWS Associate Solution Architect. You can find more about it here: https://aws.amazon.com/certification/certified-solutions-architect-associate/ Here are some topics and terms (I’m calling this Glossary for simplicity) I would like to write down so we can start having a more foundational, basic, understanding of what AWS Solution Architect should know about. Glossary…
Google Cloud Digital Leader Certification – My resume
I am studying for this Google Cloud Digital Leader Certification, as I understand, this is like AZ 900 but from Google. Here is the exam breakdown, every topic they say they can charge on the exam: https://cloud.google.com/certification/guides/cloud-digital-leader In this post I will explain all topics with my own words, try to provide links and etc,…
Google Looker – the basics
First part gives a macro overview on Google Looker, so it’s time to start digging deeper. Is Looker free? No, Looker is not free. Looker Studio is free, but that is a different product. I really wish they could change names, remove one of those products or I don’t know…. so much confusion, even harder…
Google Looker – First steps
So, I am trying to learn Looker for a new project, and, as usual, I will share here all materials I am using to better understand this new tool. Let me first start saying that, start to learn a new tool from scratch, with no help from anyone, is really hard, you will usually get…
Azure DP-900: Microsoft Azure Data Fundamentals | Notes and Highlights
Just passed Azure DP-900 exam! Here is what and how I did it: And here are all notes I’ve taken during my study process: Document Data Store Azure Storage Azure SQL Database Graph Database Azure HDInsight Azure Data Explorer Azure Table Storage Key / Value Data Store Spark Structured Streaming Azure Cosmos DB
Azure AZ-900: Microsoft Azure Fundamentals | Notes and Highlights
Just passed AZ-900 certification!! I have written a page on all my tips and notes to help you get through as well, check it out here: https://powerbixpert.com/azure-az-900-microsoft-azure-fundamentals/ Notice that not all topics are covered there. What I suggest, and the best way I see to take advantage of these notes, is: Have fun, good luck!
The Drunkard’s Walk, a book worth reading twice, or more. A Data Analyst perspective
As you know, if you follow my LinkedIn profile (which, if you doesn’t, you should) I was reading Leonard Mlodinow’s “The Drunkard’s Walk”, a really great book if you want to get a grasp on how chance, or how randomness, affects our lives, and, what is better, how we fail to perceive what is chance,…
4 Insights you can gather from Michael Lewis’ Moneyball as a Data Analyst
If you follow me on LinkedIn you already know that I’m, or actually was, reading Moneyball. Just finished the book today, and so I thought it would be fun to share what I got from this book using my perspective, in other words, a data analyst’s perspective. It’s no surprise that this book is, or…
SQL Soccer Questions
Recently I came across a SQL interview question, the “SQL Soccer Matches” question, have you seen this already? This is the kind of question you can find in an interview exam. Anyway, in order to answer that I developed many approaches to solve it: using union, using many ctes and union, using case sum, and…
SQL Interview Questions
I’m going big on SQL these days. I always loved SQL, but this couple last days I’m going hard on learning and mastering it. There’s still lot to do, many courses to take, many books to read, and many exercises to do. Talking about exercises, this guys Nick Singh just lunched a site with questions,…
[Solved, Spoilers] SQL Murder Mystery – Can you find out whodunnit?
Here: https://mystery.knightlab.com/ So, couple of friends of mine send me this challenge, and it’s really fun. Go there and try it! The plot is: someone killed someone else, and you, as the detective, need to find out who did it. Your weapons are SQL, table and relationships. Off you go! My solution to this On…
Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)
I highly recommend reading the first three links on References, at the end of this post. About XML What says the official documentation: “Each group in an XML source definition is analogous to a relational table, and the Designer treats each group within the XML Source Qualifier transformation as a separate source of data.” The…
Loading…
Something went wrong. Please refresh the page and/or try again.