kalinytics

Freelance Data Analyst | Passionate about Data-Driven Insights | Sharing tips, talks, and tutorials | Helping you make sense of data 📊
[email protected]

[kalinytics @kalinytics]

@BiokpoAmachree B, A looks more like a prototype, to much dark and grey.

[kalinytics @kalinytics]

My view
Data Warehouse & Analytics Solution, using the Medallion method, to create a bronze, silver, and gold layer. Each layer handles different stages of the warehouse.

[Jude Raji | Senior BI Analyst @JudeRaji_]

Hi #DataFam, here’s my entry for the January 2025 @MavenBI Music Challenge.
I created an interactive Spotify dashboard and even added a music player using HTML.
Dashboard: https://t.co/TbpGgSw2nH
Medium Article: https://t.co/A7VnydYeRZ

Tools used:
@PowerBI, @figma

[kalinytics @kalinytics]

The first rule of a successful project is proper planning. Whether you're a Data Analyst like me or in any other field, poor planning is often the reason projects fail.
You can use Notion or Jira for proper planning documentation and tracking.

[kalinytics @kalinytics]

Customer Segmentation automation on google sheets:

[kalinytics @kalinytics]

@LamechNyakoe It's my pleasure.

[kalinytics @kalinytics]

Once you know how to use Power Query to clean your data, and how to build a proper model, every other thing you do would be so much easier.

Power Query - https://t.co/RGEfYsnIkF

Data Modelling - https://t.co/d6IUU15aFM

DAX - https://t.co/6Wqfy1UsIS

[Ezekiel @ezekiel_aleke]

This is how you should learn Power BI.

In this order:

[kalinytics @kalinytics]

@javv_90 @ibn_wittig Just choose any option you want and follow steps:

"MS Guides - Using Microsoft software products for FREE" https://t.co/wTYXmfBPPy

[kalinytics @kalinytics]

@ezekiel_aleke One good thing about learning is that, if you even learn about something you already have knowledge about, you would learn new ways of doing that thing better.

[kalinytics @kalinytics]

If you want to build a very good portfolio website without any knowledge of coding check out this video on YouTube.

https://t.co/YK2rppILB0

[kalinytics @kalinytics]

@ezekiel_aleke To have the best dashboard, use colours wisely.

[kalinytics @kalinytics]

@LamechNyakoe Check the exercise part of the tutorials, like this part:
https://t.co/WDoesEQQ6I

[kalinytics @kalinytics]

@sqlbelle Always have at most 3 basic colours for the best dashboard:
1 for background
1 for the visual columns, lines, and so on
1 for the text.

[kalinytics @kalinytics]

@HowToPowerBI First rule of creating data visualisation; always create it to suite the audience that want to use it.
Creating visuals for non technical stakeholders, is different from creating visuals for technical ones.

[kalinytics @kalinytics]

Great YouTube channels to learn excel, especially Leila Gharani if you want to understand Power Query in a short period.

[kalinytics @kalinytics]

I just published Automating Job Vacancy Sourcing using Web Scrapping with Python: A Step-by-Step Guide https://t.co/quzFczGH78

[kalinytics @kalinytics]

@cheftee_lead Power Query would be the best place to clean this kind of data.

[kalinytics @kalinytics]

@ezekiel_aleke And remember that you can't know everything at once, you learn the more you practice.

[kalinytics @kalinytics]

@ibn_wittig @onwedavid There you go:

[kalinytics @kalinytics]

@HowToPowerBI I have never see a basic visual so informative than this.

[kalinytics @kalinytics]

The best thing you can learn in Power BI is how to create "Measures", it would make your dashboard creations so much easier.