This category provides a listing of various Azure Data & AI learn at home learning paths on the site. 5MinuteBI – Helping create data power users, 5 minutes at a time.
Visualizations can make even the most mundane information more accessible and easier to digest. I put together these two facts to make a visualization out of my lesson plan that the students could take away as a memory jogger when they get back to their offices.
There is a very active community around PowerBI with many sites specializing in different aspects of the product. The following 4 resources are ones I always fall back on recommending that provide both beginner and advanced users learning resources.
There are times when, as a consultant, you have to produce a demo or training database. This can be due to security or confidentiality of the data. I try to produce training and samples that at least have realistic values so that the people involved have a frame of reference.
If you have an excel table that is built for data entry, it may not be in the best format for data analysis or your data model. By using Query Editor, you can keep the original table and create a version that you can use for analysis as a dimensional fact table.
How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.
I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations. R provides many packages and functions that let you perform data discovery over a data set.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
