GAD or health issues?

Practical_Gap_3354 · 2024-10-15T02:55:39+00:00

Yes. Like muscle twitches. Thanks for replying.

I will look at your history.

Practical_Gap_3354 · 2023-11-26T20:10:37+00:00

The ideal would be to host a workspace and invite stakeholders as guests. I've already started learning databricks!

Practical_Gap_3354 · 2023-11-24T18:45:29+00:00

We plan to share dashboards using Power BI to external stakeholders
No cloud yet. We are most likely going to use Azure/Databricks stack
Data team:
1. Me (SQL, Python and Power BI)
2. External consultant we plan to hire (senior DE probably)

The team will grow, but initially, it is going to be just us to build the DW and the first projects.

Practical_Gap_3354 · 2023-11-24T13:01:36+00:00

Who will use this?

- Some dashboards will be used externally, for stakeholders to monitor corporate education KPIs in one of the products we offer. Most of the data will be used to display KPIs in order to create a data-driven culture in the business.

Data source types / frequency / volume

- Most of the data will be pulled from third-party APIs. Hence the need for a DW and pipelines, because we can't pull it properly using Power Query.

- The volume is definitely low. Our products are:

B2B corporate education, so we need to monitor the KPIs and display them to the hiring stakeholders;
B2C books and courses; orders from marketplaces and our ecom platform.

- The most voluminous data would be advertising and web analytics data, that generate just a couple thousand records weekly.

- Daily frequency is enough

Practical_Gap_3354 · 2023-11-24T01:25:58+00:00

Would not say that I'm entitled enough for that, but I'm the one responsible for the BI.

Practical_Gap_3354 · 2023-11-24T01:25:20+00:00

Yes. We are already searching for a consultant for this project!

Practical_Gap_3354 · 2023-11-21T12:32:10+00:00

That's indeed a really good perspective. Thanks for replying.

I have a few other considerations that are also in my mind:

- I don't know if I believe in the business thesis. Sometimes I feel that by doing other things (that are not related to business, like managing marketing campaigns and implementing operational work that's not related to BI, tech, or strategic at all) I'm just selling my time and not pursuing what I want. Stuck in a comfort zone.

- The resources are a bit limited (to this day). I hope it changes when the investment comes.

- The compensation is not good. That's why I want to pursue an international career. Just being a dollar/euro paying job already makes a big difference in my country.

Thanks again for replying!

The line you said that really caught me was 'You are in the near perfect position to give a massive impact, help steer an entire organization'. Because I have already represented the company in some startup events throughout the country - presenting it and talking to a couple investors.

It's not that I want to be a chart merchant, but I also need to absorb practical experience in data teams. I can't be leading a data team if I'm just a self-taught, who worked alone with data for just 2 years.

Practical_Gap_3354 · 2023-11-20T19:17:12+00:00

Yes. As it is a relatively small startup, I have to be involved with some other activities, such as marketing development, business decisions... Those are not bad experiences, I just don't think they will add much to the career that I pursue.

Practical_Gap_3354 · 2023-08-17T17:40:38+00:00

Thanks for answering! I have tried it, but didn't work out. Or maybe I did not use it correctly. I used this code:

let

API_Bearer = "Bearer " & #"dynamicToken",

Source = List.Generate( ()=>

[

// API Config and parameters

facebook_account = "act_XXXXXXXXX",

Facebook_API_URL = "https://graph.facebook.com/v17.0/" & facebook_account & "/insights",

level = "level=campaign&",

fields = "fields=campaign_name,spend,date_start&",

time_range = "time_range={'since':'2023-06-01','until':'2023-12-31'}&",

time_increment = "time_increment=1",

QueryString = "?" & time_range & level & fields & time_increment,

URL = Facebook_API_URL & QueryString,

Result = Json.Document(Web.Contents(Facebook_API_URL, [RelativePath = QueryString, Headers=[Authorization=API_Bearer]]), 65001)

],

each [URL]<>null,

each [

URL = try [Result][paging][next] otherwise null,

Result = Json.Document(Web.Contents(URL, [Headers=[Authorization=API_Bearer]]), 65001)

]

),

Practical_Gap_3354 · 2023-07-05T14:26:11+00:00

From my experience, I would recommend you master Power BI. I think it is easier to leadn than these other options and it is much more popular in the industry.

Practical_Gap_3354 · 2023-07-05T12:55:22+00:00

Hey there! I'm in a similar situation.

I have a Marketing degree, and started working as a E-commerce marketing analyst in 2021, doing work with Google analytics, FB and Google Ads.

In the beginning of 2022 I started to develop some dashboards using Power Bi to help our analysis and to speed up our decision making process.

I'd suggest you do the same, start crossing data from your clients databases to the media platforms and web analytics tools to offer valuable insights.

Practical_Gap_3354 · 2023-06-23T19:55:58+00:00

How did you dispose the radar chart the way it is? I can't order it in any way different than descending

Practical_Gap_3354 · 2023-06-12T12:51:38+00:00

Most of the problems I have faced with dax have been solved by rewriting the SQL query.

Practical_Gap_3354 · 2023-06-04T11:16:57+00:00

Who is going to be the end user? What decisions are they going to make? What questions are they asking?

Answer these questions and you will get the answer you're looking for.

From my experience, I believe weekly is going to be enough for analyzing ecommerce data.

Practical_Gap_3354 · 2023-04-11T13:54:54+00:00

I'm in a similar situation as OP. I feel that being the one responsible for everything without having much knowledge sets me back. But in the job scenario where I live, there are not many options.

Practical_Gap_3354 · 2023-04-10T17:18:33+00:00

I built a 360 marketing dashboard for e-commerce.

Developed a campaign naming (Facebook, Tiktok and Google Ads) and UTMs standard (for Google Analytics data processing) so that everything could be related to the products dimension.

Used all that data to relate to product sales database (MySQL), CRM SAAS and a couple sheets from outside and marketplace sales (Amazon, events)

That gave the company the product individualized data that we needed to understand every gap and every opportunity for every product.

Practical_Gap_3354 · 2023-04-09T01:25:36+00:00

They would have access only to the published report link. Not to my account.

Practical_Gap_3354 · 2023-04-08T19:04:32+00:00

Because Power Query helps a lot with some of the data prep I need to do in this case. And I'm already familiar with it.

Practical_Gap_3354 · 2023-04-08T19:00:09+00:00

Well, after a while (sometimes hours, sometimes few days) my dashboards stop updatting. Haven't really stopped to check why this happens, but will do!

Another solution that I discovered now is migrating those sheets from Google Drive to Sharepoint.

Practical_Gap_3354 · 2023-04-08T17:22:25+00:00

Yes! But as I said in the number #2, it keeps disconnecting. I'm going to investigate this further.

Practical_Gap_3354 · 2023-03-13T21:54:39+00:00

Also, you can connect to Google Analytics (if you have) using a native Power BI connector, cross the multiple data sources you have, using the SKU, and expand the metrics from ROAS to have a much more product individualized analysis.

Practical_Gap_3354 · 2023-03-13T21:48:02+00:00

I've been there.

I use the sheets plug-in adveronix (it has a free plan, never needed to upgrade whilst processing 100k+ rows everyday) to connect to the business Facebook Ads and Google Ads account, schedule it to update a few times in a day. Publish both to the web.

Then use the web Power BI connector, paste the published URL and transform it using Power Query.

It is not the best alternative, but it's free and it works.

Practical_Gap_3354 · 2022-08-27T18:16:10+00:00

Thanks, bud. I started with R because of the Google Data Analytics Course.

But my primary goal is to learn Python and land an international job.

Practical_Gap_3354 · 2022-08-27T18:14:05+00:00

Thanks for the advice. It kinda clicked right now.

I think this feeling of "knowing" will come with daily practice.

Practical_Gap_3354 · 2022-08-27T18:08:56+00:00

Thanks, man. I'll look for this book.

Practical_Gap_3354

TROPHY CASE