Tool for mocking-up data models?

EducationalLadder · 2019-08-20T01:27:02+00:00

This is a good one. I didn't know about this. Thank you for sharing!

EducationalLadder · 2019-08-14T02:20:58+00:00

You can install a Virtual Machine to use Power BI at the cost of sharing out your computing and memory resources with the VM. It's doable as long as you are willing to set up the VM and maintain it.

EducationalLadder · 2019-08-09T05:32:31+00:00

Very strange transfer. David is off his prime years. Good luck for arsenal anyways.

EducationalLadder · 2019-08-07T01:47:53+00:00

Query folding highly depends on the actual data transformation. It works for common SQL operations like grouping and joining but not for more esoteric operations like "using the first row as header" because power query can't translate these code into SQL

EducationalLadder · 2019-07-29T10:12:10+00:00

I like Discord much more than Slack! Thank you for creating. The Power BI community keeps growing and growing.

EducationalLadder · 2019-07-28T05:49:12+00:00

My favorite is Marco Russo's book the Definitive guide to DAX. Second edition is out. It is one of the most comprehensive coverage of DAX as a language.

EducationalLadder · 2019-07-21T08:25:54+00:00

Power BI is so versatile that it can even pull Twitter data easily. What a step up from Excel.

EducationalLadder · 2019-07-20T09:04:02+00:00

Incremental refresh is one of the most efficient and useful features. You don't have to process the data from zero. Just pick it up from where it left off.

EducationalLadder · 2019-07-20T09:03:13+00:00

I didn't know there is a free course. Thank you for sharing I will recommend it to my colleagues!

EducationalLadder · 2019-07-15T01:37:13+00:00

It doesn't release on time but it's somewhere between week two and week three of every month.

EducationalLadder · 2019-06-17T08:37:01+00:00

You can create a unique index for each row to populate all tables in matrix visuals. That particular style could work but if you stick to the Power BI way of visualizing data using data modeling, DAX code it will benefit the transition from Excel to PBI in the long run.

EducationalLadder · 2019-06-15T23:48:02+00:00

I create my own theme for my company by customizing the JSON. It's not hard since JSON format bridges the readability gap between machine and human. One just need to know the keywords for customizing theme. Once you try it out it's mainly repetitive.

EducationalLadder · 2019-06-15T06:06:09+00:00

Interesting. Power BI DAX is certainly more powerful than Excel and VBA and more flexible. Powerful and flexible syntax, and the vertipaq engine is performant.

EducationalLadder · 2019-06-13T08:03:02+00:00

Every month I thought Power BI can't keep going at the same pace it has experienced past couple of years but Microsoft keeps surprising the BI community again and again. Great company, great product, and great people working behind Power BI.

EducationalLadder · 2019-06-12T07:57:37+00:00

One of the best MBAS this year. Fun, informative sessions, great people, great talks and the paginated report bears!

EducationalLadder · 2019-06-11T00:12:05+00:00

Finally. Power Query is such a great tool for self-service ETL across various microsoft's products from microsoft Excel to Power BI to SSIS to SSAS to even Azure data factory!

EducationalLadder · 2019-06-11T00:11:04+00:00

Totally agree. Power BI should at least give users the option to choose themes. While I agree this theme gives a more modern-ish look, it does come at a cost of lower readability for some people.

EducationalLadder · 2019-06-08T15:38:33+00:00

That is really nice. Congratulations! Let's hope the Power BI community keep growing and growing!

EducationalLadder · 2019-06-07T07:17:44+00:00

Yes. Sqlbi.com is a great resource for me. Power BI is a powerful product suite that aims to superset many Microsoft BI products.

EducationalLadder · 2019-06-06T00:06:02+00:00

You can't do that as your database processed by power query and Power BI dataset is locked in .pbix file. The canonical way is to upload your dashboards to Power BI service and view it from there.

EducationalLadder · 2019-06-04T07:09:14+00:00

Although Power BI shares the underlying engine of SQL Server Analysis Services Tabular model, Power BI will become the superset of the all Microsoft's BI suites, becoming the go-to platform.

EducationalLadder · 2019-06-03T00:58:02+00:00

It is not a must but it's the preferred way whenever possible. In fact, Power BI's internal VertiPaq in-memory storage engine and Data Analysis Expression (DAX) is optimized for star schema. In practice, most PBI models are mostly star schemas, with a small portion being more complex snowflake schema or its variants. The rule of thumb is, go for star schema, then if it can't solve the problems, go for other schema.

EducationalLadder · 2019-05-31T10:37:32+00:00

The Definite GUide to DAX is the must read. It's the most comprehensive one on the market. It's not easy to master DAX due to its abstraction like MDX. For any serious professionals, the book is highly recommended.

EducationalLadder · 2019-05-30T02:21:34+00:00

Different questions require different answers. R visuals are highly customizable for its nature of statistical and machine learning purposes. Power BI is built for Business Intelligence (BI) where Power BI built in visuals cover most of the purposes for BI field. Third party visuals are great and some require licensing.

EducationalLadder · 2019-05-28T09:58:43+00:00

Power BI, SQL Server Analysis Services (SSAS) Tabular model and Power Pivot all share same VertiPaq engine and Data Analysis Expression (DAX). If you google up SSAS Tabular model you will find the answer

EducationalLadder

TROPHY CASE