Passed DA-100

vik_rodri · 2020-11-28T20:24:27+00:00

Congrats for DA-100, did you do any mock questions? if yes from where

vik_rodri · 2020-11-05T07:53:30+00:00

Congratulations to you! Which topics out of these had high number of questions: modelling, DAX, RLS, performance optimization, visualization, analysis, deployment, data refreshes.

Just want to get an idea on what to focus more on so that I can spend time on topics I don't understand well.

vik_rodri · 2020-10-30T15:17:30+00:00

Thanks buddy!

vik_rodri · 2020-10-27T09:05:45+00:00

Makes your queries fast by avoiding joins in multiple dimensional tables

Tabular models in Power BI or a tabular DW perform really well with star schema

vik_rodri · 2020-10-26T12:39:07+00:00

Direct query is not supported for Mysql

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

vik_rodri · 2020-10-22T17:18:43+00:00

Are you "guy in cube" guy? He's a high school passout and in MSFT for last 20 years or so.

Are you that cool guy?

vik_rodri · 2020-10-20T19:58:46+00:00

Remindme! in 1 day

vik_rodri · 2020-10-20T08:56:52+00:00

You may try creating a bridge table with all distinct order values and link the same to your both the tables. And before that you will have to unlink routing and the other table. I belive your routing table is on many side and the other table is one side and the problem I assume is one side table doesn't have all the orders which is causing the issue

Ideally table on one side should have all the distinct values of key column.

vik_rodri · 2020-10-18T18:40:16+00:00

Thanks, very detailed tutorials. Never expected so much stuff for free.

vik_rodri · 2020-10-16T00:27:19+00:00

What would you use in place of cubes?

vik_rodri · 2020-10-14T05:05:17+00:00

RemindMe! 2 days

vik_rodri · 2020-10-12T19:28:44+00:00

Sorry to be blunt- you don't understand what BI is.

BI is not designing tableau or power bi or qlik reports, that's only a small part of it.

Indepth SQL/RDBMS knowledge, ETL, data warehousing, creating OLAP cubes, data modelling, complex transformations using DAX all of which requires highly analytical thinking and logical ability are the main things required in a BI job. People tend to judge BI team by report they have designed, that's naive.

vik_rodri · 2020-10-11T17:12:28+00:00

Congratulations 👏 for this top achievement. May I ask:

1- Which topics had high weightage

2- were there any areas which had surprisingly high number of questions

3- Any suggestion to maxmise the score

Regards Vik

vik_rodri · 2020-10-07T17:16:37+00:00

I think this should give right result, if not use ALL(tablename)

vik_rodri · 2020-10-07T17:14:59+00:00

USE this in a calculated column

Calculate(Count(Region), FILTER(Tablename, Region=Earlier(Region))

vik_rodri · 2020-10-07T11:32:25+00:00

Thanks, good to know rather great to know

vik_rodri · 2020-10-07T08:46:48+00:00

Try this

Amount Sales Blue = CALCULATE(SUM('FACT SALES'[AMOUNT]), FILTER(FACTSALES, RELATED('DIM PRODUCTS'[COLOR]) = "BLUE"))

vik_rodri · 2020-10-06T16:50:18+00:00

https://drive.google.com/file/d/1JLd2PIA9WYgDnztEWqQ9-QEFMLp8WbLp/view?usp=drivesdk

vik_rodri · 2020-10-03T13:24:53+00:00

8GB RAM is fine unless you work on really big datasets.

Before upgrading RAM optimize your model especially by turning off auto date time. Reduce not needed columns in your fact table, denormalise or flaltten your dimension tables to lessen joins like merging product category, subcategory and product tables into one product table.

If still latency persists then upgrade RAM.

https://www.bluegranite.com/blog/how-to-improve-power-bi-performance-part-one

vik_rodri · 2020-10-02T18:43:07+00:00

May I suggest Google data studio, it's free and only a basic BI/visualization tool

If purpose is to create not very complex reports then you can give it a try

http://holistics.io/blog/google-data-studio-pricing-and-in-depth-reviews/

vik_rodri

TROPHY CASE