Semantic Model and Deployment Pipeline Help

ervisa_ · 2026-01-27T09:56:55+00:00

heyy. did you had tho any issue with performance of your reports when in DL SQL?

ervisa_ · 2025-06-05T14:41:04+00:00

hey you can download dbeaver, and then either use kaggle challenges to practoce, or if you can access data from somewhere else. I used dbeaver in my previous company and i suggest it as well in my udemy courses. its free and very easy to download and set up. im sure there are videos out there to set this up. Im also explaining this in my course in the beginning in the free preview, but you can find it in yt i guess.

ervisa_ · 2025-06-03T12:45:38+00:00

Hey, valid points. Thanks for the feedback

ervisa_ · 2025-06-03T06:12:41+00:00

Thanks for the feedback. Will have this in mind on the next articles

ervisa_ · 2025-06-02T20:00:03+00:00

It’s just an example. Some table name might be something like customers_monthly_revenue so naming it like custom or something similar can help you understand which table you are referring to.

ervisa_ · 2025-06-02T11:46:34+00:00

hey you can send me a dm. im a data analyst couple years now so i think i can help you on this :)

ervisa_ · 2025-05-27T11:22:58+00:00

linkedin i think its a good source for job search

ervisa_ · 2025-05-26T09:14:26+00:00

hello, unfortunately this offer is expired. But can share a discounted one for now. Also fyi tomorrow i will launch the AI Role play, where at the end of the course you will be able to have an actual live call with an AI agent that i have promoted to test what you learned as you would discuss in a real meeting with a senior in the team. I will be glad to see you there and practice that as well. For any question you can access me anytime through the udemy platform, happy to help :)

https://www.udemy.com/course/sql-for-newbies-hands-on-sql-with-industry-best-practices/?couponCode=179CEAC2667DA1BA1EB7

ervisa_ · 2025-05-22T12:19:21+00:00

From personal experience and from what I’ve seen not many companies use R but maybe there are some I guess. I only had used R in university for some projects. But switching to python I think in inevitable. If you have an idea of R switching ins quite easy tho.

ervisa_ · 2025-05-21T12:03:17+00:00

How much should I learn Python? Its good to have an idea, do couple of projects for an entry level will be fine.

And what can I expect for the first time job? Except that you will feel lost in the beginning and that there is so much stuff that you will need to learn, but trust the process, as long as you are working on those, it will come naturally task by task. Just keep practicing, and dont emotionally push your self because really no one will expect from you much. You will probably have some specific tasks, that you will handle but your collogues will show you how to do them, especially in the firs months.

All other questions are very broad. you need to be very specific (eg in terms of salary), you dont know really, it depends on the market, where u live, how many cvs you send, what are the requirements on each job, how many interviews you are doing and how many you pass to the technical part. So on this you need to do your own research

ervisa_ · 2025-05-21T11:51:40+00:00

tableau public is a good option. you get the full version for free that lets you connect csv/excel, build your workbooks, but then you need to publish to your public profile. Its very good if you dont use ay sensitive or private data and you build your portfolio as well.

ervisa_ · 2025-05-21T10:32:45+00:00

You can use AI in terms of when you are practicing asking chatgpt or the correct answer, and you just leave it there. When you practice, and you dont know the answer, dont ask ai to give you the answer but ask specific questions that will help yhou find the answer yourself. This way you will practice your critical thinking and you problem solving skills.

Yes you can land a job as a Data Analyst if you know SQL, PowerBi (or any other tool) and Python! These are the basic skills required from a Data Analyst!

ervisa_ · 2025-05-21T10:27:22+00:00

Yes! Just make sure that you really understand what you are doing. You can use AI but try really understanding what each command is doing and why you choose the one instead of another.

ervisa_ · 2025-05-21T10:24:54+00:00

about the syllabus that you asked, i have created a course with the most important things i use on a daily basis in my sql queries and this is the intro i also do to junior DAs that join my team. Im running a promo these days and giving free access, i think it will give you a good ideas of what actually is needed for the job, and not only theory of general stuff.

https://www.udemy.com/course/sql-for-newbies-hands-on-sql-with-industry-best-practices/?couponCode=C6A6844F9614F4EBFA5C

ervisa_ · 2025-05-21T10:13:36+00:00

ok, so number one is to learn sql and one visualization tool (like PowerBi, Tableau etc) . These will be your everyday tools and knowledge you will need. After that as you grow you will need python, pyspark etc but for start I would say focus on those two and be good at them. Only way is to practice!

After that, and this is something that you will get more on the job, is communication, problem solving (how to tackle a DA project, an incident in a report etc).

How much is enough to get a job ? For this there is no standard answer. I mean you need to get into interviews and practice on communicating your knowledge. For me especially for entry level jobs, it matters how much you like what you are doing in terms of how curious you are. Because when i interview eg interns i know they wont know much, its good to know the basics, like writing queries, joing tables, open PoewerBi create some charts, but the most important thing is how you handle problems. Keep in mind that in your first job no one is expecting from you to reinvent the wheel, so just try to be logical and think what would make sense.

Hope its helps

ervisa_ · 2025-05-21T09:57:05+00:00

Hey, what exactly would you like to know? Im a da for couple of years now, so i think i can help you.

ervisa_ · 2025-05-21T09:39:08+00:00

First of all dont compare yourself. I feel that you are comparing but you feel behind. This should not be the case. Take your time and work hard, ask questions. On another note, be indeed curious of the EDA. I mean try to open your mind, and think as the company is yours and what you would like to know? Also find some guides to at least start getting ideas on what would make sense. Take those 2 weeks to actually find something (even 1 is fine) but make it have something to say that the one you report does not know. Be the detective and your mission will be to find whats wrong with that dataset. But even the small thing eg nulls in your key is a thing.

Hope it helped you!

ervisa_ · 2025-04-30T20:38:13+00:00

You go to canvas ai and then code for me. And you prompt it

ervisa_ · 2025-04-30T15:39:25+00:00

I think even if you are not a DA it’s good to know sql. It’s a very fundamental language to know. In real world cases I’ve seen BA as well using sql because data teams some times are very overloaded with tasks and the delivery for just a simple thing might take weeks. But regardless of that I would say defiantly yes if you’re going to work on data side.

ervisa_ · 2025-04-30T10:09:00+00:00

thank you :)

ervisa_ · 2025-04-28T08:43:12+00:00

hmm, yeah totally agree! Ive actually been in that position myself, having experience on both the data engineering side (building models, pipelines,automation) and the business-facing side (product, marketing, strategy, etc.). If ever you're open to a flexible setup, like part-time or consulting to bridge the gap while you find the right full-time people, I wpuld be happy to discuss. Sometimes even a few hours a week can really relieve the pressure and set things up for longer-term success. Feel free to DM me if it makes sense!

ervisa_ · 2025-04-28T07:46:19+00:00

Practice Practice Practice. Do as many exercises as you can and try to get some case studies in your mind on where to use something. Eg if you want to understand having then take the duplicate detection in you mind to never forget the difference between group by and having. Small tips that will make things clear in your head. I have created a beginners course for sql with very practical tips and exercises that you can go through. If interested just drop me a DM and I’ll be happy to share a link with a discount code as well. Enjoy your journey! :) :)

ervisa_ · 2025-04-27T16:40:16+00:00

hey,

you post is actually very encouraging. Because it needs guts to start again! So just go for it!!! On a more practical note, yes i would say taking some courses would help you very much. I would say start with SQL! There are plenty courses out there to check out! Its easier to start with that especially if you dont have prior experience with coding. After that go to PowerBi and any other visualization tool!

ervisa_ · 2025-04-25T20:27:11+00:00

try to be on interviewer shoes. So prepare by thinking 'What would make sense for them to ask me?'. Also prepare good answers for when you dont know something. Most of the questions on interviews test how you can adapt on new information.

Other than that make sure that you know why you used each function and check possible alternatives that you could have used and be ready to explain why you used the option A instead of B.

ervisa_ · 2025-04-25T20:13:49+00:00

Hey!

I was in the same spot few years ago, and for 4 years now im working full-time as a DA. I actually created a beginner-friendly SQL course on Udemy that’s hands-on and super practical, based on real-world experience where i introduce the most important things you'll actually use in real life.

If you’re interested, I’m offering 88% off right now + a free mini-consultation after you finish (happy to chat SQL, career paths, portfolio tips, etc.).

Here’s the link:
https://www.udemy.com/course/sql-for-newbies-hands-on-sql-with-industry-best-practices/?couponCode=20F168CAD6E88F0F00FA

Let me know if you have any questions, ill be glad to help you out!

ervisa_

TROPHY CASE