Big Data Analytics And Business Consulting

[smooth_dawg]

Which is easier to use when starting out? Tableau Public or Power BI Desktop? Ive tried Qlik but I find it cumbersome.

[kzkb]

Which is easier to use when starting out? Tableau Public or Power BI Desktop? Ive tried Qlik but I find it cumbersome.

 

Mas intuitive tableau. Nahihilo ako sa power bi. Sa youtube vids lang ako natuto.

[harveyspecter]

Tableau ftw!

Btw, conceptual ba ang lean six sigma courses or may halo ring technical like programming, stat etc?

 

Apologies for the late response. Lean Six Sigma (LSS) is both conceptual (DMAIC framework) and technical since it borrows some tools and techniques from statistics and project management. Hope this answers your question.

Which is easier to use when starting out? Tableau Public or Power BI Desktop? Ive tried Qlik but I find it cumbersome.

 

In my honest opinion. Tableau is the most user friendly BI tool. I agree with you on Qlik though.

[harveyspecter]

hi how do you become a data analyst?

 

Hi Kerbyzt, as of now, there is no certification yet (as far as I know of) for data analyst here in the Philippines. There are some lessons and seminars on data analytics. Currently, the only profession recognized as a data analyst are statisticians. I hope in the future, we'll have a data analyst degree here in the Philippines.

[kzkb]

Apologies for the late response. Lean Six Sigma (LSS) is both conceptual (DMAIC framework) and technical since it borrows some tools and techniques from statistics and project management. Hope this answers your question.

 

In my honest opinion. Tableau is the most user friendly BI tool. I agree with you on Qlik though.

 

Any reqts para makatake ng courses? How much nagrarange?

[harveyspecter]

Any reqts para makatake ng courses? How much nagrarange?

 

No pre-requisites to take LSS. and for yellow belt, it ranges from 8-10k, green belt is around 35-50k, black belt is 100-120k.

 

Note: For green and black belt, along with a exam that you need to pass, you need to finish a project using the DMAIC and LSS tools and techniques for you to be certified.

[RizzaWizza]

harvey, can you be my BB Certification coach?

[harveyspecter]

harvey, can you be my BB Certification coach?

 

Hi Rizza,

 

Sure! Do you already have a project on going? If you do, please send it to harvey.specter0713@gmail.com I will review your project and provide feedback. Thanks!

[RizzaWizza]

 

Hi Rizza,

 

Sure! Do you already have a project on going? If you do, please send it to harvey.specter0713@gmail.com I will review your project and provide feedback. Thanks!

 

Thanks. My current project is a centralization project. I'll send you the project charter. Estimated savings is 1.5 FTE, roughly $50K, not enough for a BB no?

[harveyspecter]

 

Thanks. My current project is a centralization project. I'll send you the project charter. Estimated savings is 1.5 FTE, roughly $50K, not enough for a BB no?

 

Hmm. It depends on where you are getting your certification from. Does the certifying body need a certain $ savings for you to be certified? For some, they also require you to use advanced statistical tools (i.e. hypothesis testing, regression, DOE, control charts and etc) on your project.

[harveyspecter]

Anyway, Let's talk about an interesting topic and problem most of us are familiar:

 

Traffic situation in Metro Manila.

 

I'm sure everyone of us has experienced this and it seems to be getting worse every year. And I haven't seen any concrete plan or solution coming from the MMDA to resolve this.

 

So my question here is: What are the solutions that you think can lessen & control the traffic in Metro Manila? And Why?

 

Please feel free to share your ideas (no matter how crazy or far-fetched it is). I'll share mine also

[bernard_palanca]

Nice topic! Are you familiar with predictive algorithm? Thanks.

[harveyspecter]

Nice topic! Are you familiar with predictive algorithm? Thanks.

 

Yes, I've read a few books and articles on the topic. I'm very interested in this field, although it's sad that there's no classes or seminars that teach this skill/topic.

 

For predictions/forecasting, I usually just use the classical statistical tools (regression, time series, moving averages and etc.)

[combatjames]

Anyway, Let's talk about an interesting topic and problem most of us are familiar:

 

Traffic situation in Metro Manila.

 

I'm sure everyone of us has experienced this and it seems to be getting worse every year. And I haven't seen any concrete plan or solution coming from the MMDA to resolve this.

 

So my question here is: What are the solutions that you think can lessen & control the traffic in Metro Manila? And Why?

 

Please feel free to share your ideas (no matter how crazy or far-fetched it is). I'll share mine also

 

I will start with defining the problem or problems. Many a times after driving through heavy traffic, we will reach point where traffic will just start to flow more smoothly with no apparent reason for the congestion. Obviously, though there is a cause for congestion thus the congestion no matter how apparent (or otherwise) the reason is.

 

Survey the field which are the main causes for the congestion. For convenience I will categorize them to either fixed or non-fixed.

 

For the fixed, I can reasonably guess that these causes might include, bottlenecks, poor road design, number of stoplights, duration of stoplights signals, presence or absence of sensors etc.

 

For non-fixed, I would include stalled vehicles, accidents, etc.

 

After I get the data then I will look into the frequency of these possible causes. But this point, I should be able to define what is heavy or light traffic empirically. We can then start to do statistical analysis and see which cause is predictive of heavy traffic the most. Then and only then can I suggest a solution.

 

Sorry long way of saying, I don’t know pala the problem hahaha, I can feel it’s symptoms though but till I have the problem I cannot suggest a solution.

 

BUT, assuming for example, stalled vehicles and problema, I think need to survey again if it’s the private vehicles or puv’s that are mostly involved. Tapos kung I am part of the government agency involved, probably create policy on vehicle age Or at least ung road worthiness. Baka naman page more than say 30 years ung sasakyan dapat na rin ipagretire. Unless sobrang pristine condition.

 

Assuming naman na ang problem pla is bottlenecks, mabagal daloy kasi biglang kelangan pumila. Need to know mana, how long ung pila and how many actually needs to fall in line....

[combatjames]

Need to consider din if its the shear volume and the road is just to narrow or baka me mga obstructions, like parked vehicles, illegal structures. My far fetched idea lang dyan is sana kaya ng government iclear and keep clear the roads of all obstructions.

 

One thing obviously missing Nga pla is ung tamang sakayan at babaan. Ideally nakashoulder or diverted yun and not part of the road like the part for moving vehicles.

 

Dami rin i think, need to substantiate with data, ung mga overlapping ma ruta ng mga PUV. Cguro dpat magdesign ng route ang govt such that any point in NCR max three na lipat lng ng puv. Meaning me overlap para makatransfer but not too much para makacause ng congestion.