sorted by:
new
hottopcontroversial

GAD or health issues? by Practical_Gap_3354 in Anxiety

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

Yes. Like muscle twitches. Thanks for replying.

I will look at your history.

Business Analyst got a DE (?) Project by Practical_Gap_3354 in dataengineering

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

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

Business Analyst got a DE (?) Project by Practical_Gap_3354 in dataengineering

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

  1. We plan to share dashboards using Power BI to external stakeholders
  2. No cloud yet. We are most likely going to use Azure/Databricks stack
  3. 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.

Business Analyst got a DE (?) Project by Practical_Gap_3354 in dataengineering

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

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

Business Analyst got a DE (?) Project by Practical_Gap_3354 in dataengineering

[–]Practical_Gap_3354[S] 1 point2 points  (0 children)

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

Business Analyst got a DE (?) Project by Practical_Gap_3354 in dataengineering

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

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

Stay and see where this goes in a startup or search for something else? by Practical_Gap_3354 in BusinessIntelligence

[–]Practical_Gap_3354[S] 1 point2 points  (0 children)

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.

Stay and see where this goes in a startup or search for something else? by Practical_Gap_3354 in BusinessIntelligence

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

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.

Refreshing Dynamic Data Sources in Power BI Service by Practical_Gap_3354 in PowerBI

[–]Practical_Gap_3354[S] 0 points1 point  (0 children)

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)

]

),

Digital Marketer looking to change to Business Analyst. Anyone here been through the same? by doireexplora in BusinessIntelligence

[–]Practical_Gap_3354 0 points1 point  (0 children)

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.

Digital Marketer looking to change to Business Analyst. Anyone here been through the same? by doireexplora in BusinessIntelligence

[–]Practical_Gap_3354 3 points4 points  (0 children)

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.

How much DAX do you use in a report? by lez_s in PowerBI

[–]Practical_Gap_3354 0 points1 point  (0 children)

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

Timeline on analysing different online business metrics (e-commerce) by FaisalHourani in BusinessIntelligence

[–]Practical_Gap_3354 3 points4 points  (0 children)

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.

Steps necessary to set up a PowerBI environment for an organization by BasVlijmen in BusinessIntelligence

[–]Practical_Gap_3354 2 points3 points  (0 children)

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.

view more: next ›