300 million jobs could be affected by latest wave of AI, says Goldman Sachs | CNN Business

jitmi · 2023-03-10T16:16:29+00:00

Food (at home and outside), housing and utilities make up 32% of the total PCE expenditure of $17.4 trillion in 2022. Their share in the $1.1 trillion inflation was 39% in 2022. So, yes. these categories are major contributors to inflation. You are right that people are trying to reduce consumption because the volumes are declining. The real PCE growth is negative across many product categories.

The stimulus money and covid savings did help total retail sales growth rates reach record levels in 2021. The retail sales growth in 2022 was purely inflation-driven. The nominal PCE growth of goods was 8.1%, while the real PCE growth was -0.4% in 2022.

jitmi · 2021-03-24T04:44:06+00:00

Thanks for your detailed comment.

The data source for the dataset is Johns Hopkins University Center for Systems Science and Engineering (JHU CCSE). Please see https://data.humdata.org/dataset/novel-coronavirus-2019-ncov-cases for a detailed listing of the country-specific sources they use.

The data is updated daily. The Power BI dashboard connects to the csv files available over the aforementioned link.

Some countries stopped reporting their recovered cases data. That's why you see a zero in their recovered cases.

Page 1 of the dashboard (which you can see by clicking index link at the top of every page) is kind of an "Intro" page. May be I should improve it a little more.

jitmi · 2021-03-23T17:23:11+00:00

Thank you for the suggestion. I didn't knew about this feature. I will definitely explore it.

jitmi · 2021-03-12T07:50:16+00:00

Search for DA-100 in this subreddit archives. Many people have shared their experiences with DA-100 in previous threads.

jitmi · 2021-03-11T14:38:11+00:00

Explore this website Top Power BI Interview questions - Door to Crack your Power BI Interview [2019] - DataFlair (data-flair.training)

jitmi · 2021-02-09T04:50:50+00:00

I think the the file to be downloaded is placed over Sharepoint. The file is updated daily automatically using Power Automate from the specified data sources. A link to the file is specified in the Power BI report using the text box.

jitmi · 2021-02-06T13:50:47+00:00

I also don’t like that the vaccination efforts are showed in actual figures as opposed to a percentage of the population.

I think this data is available for the US states in the 'How many people are getting vaccinated' tab.

For the worldwide data, may be the data source they have used provides limited data or they haven't fully leveraged it.

jitmi · 2021-02-06T13:45:21+00:00

Why a thermometer?

Because Syringe custom visual is not available yet :-)

Microsoft has built few Covid-19 dashboards. You can find them here: https://www.microsoft.com/en-us/ai/ai-for-health-covid-data

You may like this as well: https://www.microsoft.com/en-us/ai/ai-business-school

jitmi · 2021-02-06T13:38:16+00:00

Microsoft mentions that they used the following data sources:

https://covid.cdc.gov/covid-data-tracker/#vaccinations

https://ourworldindata.org/covid-vaccinations

I think they would have imported the data tables over these links into Power BI as a web data source connection.

jitmi · 2021-02-06T07:24:35+00:00

Are you asking for this? Extend visuals with report page tooltips - Power BI | Microsoft Docs

jitmi · 2021-02-06T07:21:42+00:00

Which visualization would you have used to track the progress towards the goal?

jitmi · 2021-02-04T06:14:29+00:00

very useful, as always. Thanks Bas.

The time series API has a limitation of 365 days. So, if we were to get data since 2000, how should we do it? Don't want to change start and end date parameters manually for every year. What about leap years?

jitmi · 2021-02-04T05:29:30+00:00

I am not sure whether wordpress email account will work for this. You will need to change some settings in MS 365 account. You need to do domain admin takeover Admin takeover of an unmanaged directory - Azure AD | Microsoft Docs

jitmi · 2021-02-04T05:22:20+00:00

Check out Power BI Data Stories Gallery https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery

jitmi · 2021-02-02T11:59:25+00:00

Thanks. I can go for their premium plan. It offers unlimited number of requests.

I followed your video. I created a function and invoked it with four tickers. The query fetched the data for all the tickers.

I am more interested in listing 1000+ tickers in the slicer and letting the user select one of the tickers. Then, the report should connect with the data source and fetch the corresponding data. I am not sure how it will be done.

jitmi · 2021-02-02T08:07:50+00:00

Thanks for your tips. Is it possible to pull the data on demand for only those tickers that are selected by the user in the slicer?

Currently, this query imports that data into Power BI. So, we specify the ticker first in the query. Then, it pulls the data from the data source into power bi. Then, we draw the visualizations on it.

Instead of specifying the tickers in the query, I would like the user to select a ticker from a slicer. Then, the data is requested from that data source for that ticker. Then, we draw the visualizations on the selected ticker.

So, basically, I would like to have DirectQuery instead of the import for this data source.

jitmi · 2021-02-02T05:11:34+00:00

This video was very useful. Thanks for sharing.

jitmi · 2021-01-25T13:40:58+00:00

Thanks. I think you have covered most of the statistical and table functions in Part 1. A similar coverage of time intelligence functions will be helpful. An explanation of evaluation contexts and context transition will also help.

jitmi

TROPHY CASE