Discover and read the best of Twitter Threads about #datamodeling

Most recents (5)

In love with Power BI! 😍✨

Power BI is a data analytics tool, and the fact that you can connect it with any data source, transform, manipulate and visualize your data all in one place is really great!

Important things you need to know about creating a data model in Power BI🧵
Before you understand how creating a data model works in Power BI, first you need to understand what kind of tables you need to have in your data model.

There are two types of tables that enables you to create a data model in Power BI and they are Fact Table and Dimension tables
✨ Fact tables: Fact tables contain observational or event data values which can be sales orders, product counts, transactional dates and times and quantities. Fact table can contain several repeated values.

E.g  repeating customer IDs in the Customer ID column.
Read 12 tweets
Hello Data Analyst,

Let's discuss data models & benefits of having solid data models.

One of a data analyst's key responsibilities is building a strong data model.

The term "Data Model" refers to the process of arranging data into tables based on relationships & groups...
...to minimize duplication and maximize efficiency.

By performing this task properly, you contribute to making it simpler for people to comprehend your data, which will make it simpler for both you and them to create useful reports and dashboards.
It is challenging to provide a set of guidelines for what constitutes a good data model because every piece of data is unique and is used in different ways.

A smaller data model is preferable because it will operate more quickly and be easier to use.
Read 5 tweets
"The list of people and things telling us what to do is endless. Nobody needs more of that.
What we need is someone to believe in us – especially in those moments when we don’t believe in ourselves." -- Eric Barker @bakadesuyo greeneracresvaluenetwork.wordpress.com/2022/05/31/dai…
This Is How To Get People To Change: 5 Secrets From Research - Barking Up The Wrong Tree
bakadesuyo.com/2022/05/get-pe…
#BehaviorChange, #InfluencingOthers, #AppliedPsychology, #MotivationalInterviewing
Japan tries—again—to revitalize its research | Science | AAAS
science.org/content/articl…
#JapaneseInvestment, #ResearchRevitalization, #InnovationRate
Read 13 tweets
"Good intentions and accurate data still aren’t enough. You also need to know that you’ve collected the right data and asked the right questions, and these are both much, much harder than the introductory effective altruist material tends to let on." greeneracresvaluenetwork.wordpress.com/2022/05/28/dai…
Read 13 tweets
Over the past couple of weeks, I have been working on a project where I was required to build a #PowerBI connector for an API.
I have to say, this is an interesting experience, because I was learning a new language in the process. Welcome to the M language.
#DataModeling
🧵
M Language, stands for Data Mashup or Data Modelling language, is a very simple but powerful modelling language.
Basically, M language takes input data, model it, and exports it.
Let's look into the simplest M language "let" block. Image
"Let" is a block used for data modelling. Basically it starts with the famous "let" keyword. Which is similar to "let" in Javascript; it basically defines a variable.
Read 9 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!