JavaScript Object Notation

JavaScript Object Notation

JSON?(JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate.JSON consider as common format to serialize and deserialize data in application that communicate with each other over internet.

There are two models 1)The object Model and other is The Streaming Model.

No alt text provided for this image

The Object Model create a tree which represent data in the memory and provide us for easy navigation in the tree which also allows to analyze or able to modify.

The Streaming Model are event based parser which read JSON data one element at a time. This is exactly opposite to Object Model (Object Model reads all the data at once in a single shot).The streaming model uses event based parser which generates events and stop for processing when an objects?or array begin or end or when it find a value or key.

How JSON data is used practically on the internet.

Open the chrome developer tools and go to twitter, and click on "view x amount of new tweets" go to the network tab, click on the type of data and go to the response tab. You can see the data in JSON format as shown below.

No alt text provided for this image

How JSON Look Like : {"Name" : "Bob"}?- Very Simple Document which represent the key as "Name" and their associate "Value" as "Bob".

{"Name" : "Bob", "Age" : 50, "Hobbies" : ["hockey", "football", "movies"], "Account" : {"Login" : "Bobby", "Password" : "12345"}}?- this is an typical example for complex JSON document with hierarchies.

How JSON is More Compatible Than XML :

No alt text provided for this image

JSON used in RESTful Web services and having more compact than XML.JAVA API available for JSON packages?1)Javax.json?2)javax.json,stream.??

How Mongo Uses JSON : Mongo Db is a non-relational data store for JSON documents. By non-relational we mean that it does not store data in tables like relational databases does. It stores JSON documents.The fact that MongoDb stores documents makes programming your domain model very convenient.Another interesting aspect about MongoDb is that it also schema less. Schema less means that two documents don’t need to have a same schema.

The Idea of MongoDb is to retain most of scalability and performance, giving you a lot of functionality to work with, but not quite as much as you can get in relational database management systems.

No alt text provided for this image
No alt text provided for this image
No alt text provided for this image

How JSON Files is Accessed:

No alt text provided for this image
No alt text provided for this image

What is BJSON - BJSON?is a format specializing in efficient storing of JSON-like documents, which besides supporting the traditional JSON data types it also supports dates and binary data natively.BSON is made for computers to read, JSON for humans.

We Know that JSON is widely used in data storage ,serialization and streaming.what if we want to?use of JSON in a Non-textual form and?in this case BJSON solves our issue.The below are reason for need of JSON in Non-textual form.

No alt text provided for this image
No alt text provided for this image
The Link given an initial understanding JSON :?
https://beginnersbook.com/2015/04/json-tutorial/

Manual Conversion of XML to JSON and Vice-versa (Interesting one)
Project Specific:Manual Type:-

https://convertjson.com/json-to-xml.htm?


Formatting JSON:
https://dev.to/david_j_eddy/til-jsonstringify-can-do-formatted-output-1f44

https://www.codit.eu/blog/2017/06/02/working-with-collections-in-logic-apps/?utm_source=twitter&utm_medium=tweet&utm_campaign=blog-collectionslogicapps-toon

Conversions:

https://convertjson.com/json-to-xml.htm

https://torquemag.io/2014/08/introduction-wordpress-new-universal-connector-json-rest-api/

Storing JSON into SQL Server:
https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/12/19/storing-json-documents-in-sql-database/

Conversion JSON file XML in Qlik
https://wiki.qvsource.com/General-Web-Connector-For-QlikView.ashx

https://sqldbawithabeard.com/2017/12/18/converting-a-datarow-to-a-json-object-with-powershell/?utm_source=paulomorgado.net&utm_medium=twitter


Testing JSON Codes:
https://www.infoworld.com/article/3222851/javascript/what-is-json-javascript-object-notation-explained.html

Testing of JSON: (Recommended way of programming JSON with guidance)
https://seriot.ch/parsing_json.php


Limitation of JSON:
https://www.infoworld.com/article/3222851/javascript/what-is-json-javascript-object-notation-explained.html

JSON schemas into RAML-powered APIs
https://medium.com/raml-api/recycling-your-json-schemas-into-raml-powered-apis-b551fd181045

Other Link may be useful:
https://torquemag.io/2014/08/introduction-wordpress-new-universal-connector-json-rest-api/

Refrence for Understanding?

Mango DB : https://www.habilelabs.io/complete-mongodb-introduction/
https://www.habilelabs.io/choose-mongodb-databases/
https://www.habilelabs.io/importing-csv-files-mongodb-database/ 

Mar12 Devop CI VS CD 

https://www.tothenew.com/blog/8-best-practices-of-continuous-integration-to-supercharge-your-software-development-team/
https://www.slideshare.net/shivamaan/continuous-delivery-and-deployment-on-aws?from_action=save
https://www.tothenew.com/blog/8-best-practices-of-continuous-integration-to-supercharge-your-software-development-team/
https://dzone.com/articles/continuous-delivery-a-step-up-from-continuous-inte
https://www.sandhata.com/are-ci-tools-enough-for-an-effective-continuous-delivery-pipeline/
https://cloudify.co/2015/03/15/continuous-integration-continuous-delivery-deployment-automation-tools.html
https://scmquest.com/continuous-integration-vs-continuous-delivery-vs-continuous-deployment/
https://routedevents.blogspot.com/2017/03/aws-continuous-integration-continuous.html
https://dzone.com/articles/what-is-continuous-integration-1 

March 13 DEVOPS CloudFormation 
https://dzone.com/articles/aws-cloudformation-getting-started-for-beginners
https://www.slideshare.net/AmazonWebServices/aws-cloudformation-best-practices
https://www.thorntech.com/2018/07/s3-ec2-iam-cloudformation/
https://www.slideshare.net/AmazonWebServices/devops-on-windows-how-to-deploy-complex-windows-workloads-aws-public-sector-summit-2017
https://www.slideshare.net/AmazonWebServices/devops-at-amazon-a-look-at-our-tools-and-processes-63396644
https://www.edureka.co/blog/devops-tools 

March-14 AWS CloudFormation Terminology 

https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/template-reference.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/cfn-resource-specification.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/cfn-sample-templates-ap-south-1.html
https://github.com/awslabs/aws-cloudformation-templates
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-product-attribute-reference.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/intrinsic-function-reference.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/pseudo-parameter-reference.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/cfn-helper-scripts-reference.html
ref
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/cfn-console-create-stack.html
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/cfn-using-cloudformer.html
https://www.slideshare.net/AmazonWebServices/aws-cloudformation-masterclass
https://www.slideshare.net/AmazonWebServices/aws-cloudformation-infrastructure-as-code-aws-public-sector-summit-2016
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-template-resource-type-ref.html  

March-15 - CloudFormation IAM

https://www.slideshare.net/AmazonWebServices/zero-to-sixty-aws-cloudformation-dmg201-aws-reinvent-2013
https://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles_create_for-service.html

March 27:
Need of AWS with Tableau why
https://stackarmor.com/data-visualization-and-analytics-with-tableau-on-aws/
Slideshare?
https://www.slideshare.net/AmazonWebServices/analytics-on-the-cloud-with-tableau-on-aws
Tableau Server on AWS
https://aws.amazon.com/quickstart/architecture/tableau-server/
AWS Fearess architecture with tableau
https://www.google.com/imgres?imgurl=https%3A%2F%2Fimage.slidesharecdn.com%2F198250-usingtableau-nonotes-c51bde61-ef41-4c9c-bfc6-1bcec5d49a81-2127500720-180702195800%2F95%2Fusing-tableau-and-aws-for-fearless-reporting-at-umd-6-638.jpg%3Fcb%3D1530561510&imgrefurl=https%3A%2F%2Fwww.slideshare.net%2FAmazonWebServices%2Fusing-tableau-and-aws-for-fearless-reporting-at-umd&docid=DpCPoGX08xYW0M&tbnid=Hn0HMJlV-_p64M%3A&vet=10ahUKEwiItpWAhKHhAhWTjeYKHeoUBPwQMwhFKAUwBQ..i&w=638&h=359&bih=657&biw=1366&q=tableau%20with%20aws%20byol&ved=0ahUKEwiItpWAhKHhAhWTjeYKHeoUBPwQMwhFKAUwBQ&iact=mrc&uact=8
AWS with tableau with other clouds
https://www.dataarchitect.cloud/tag/byol/
Marketsplace aws with tableau license models
https://aws.amazon.com/marketplace/pp/B015WQEKS4#pdp-pricing
https://www.tableau.com/Amazon-Web-Services/Marketplace
https://aws.amazon.com/marketplace/pp/B00ZYOIFLS?_prnt_web_tableau
https://aws.amazon.com/marketplace/pp/B015WQEKS4?_prnt_web_tableau


AWS with Amazon Athena
https://blog.openbridge.com/how-to-use-amazon-athena-views-within-tableau-in-3-simple-steps-c810396a2e3b
https://medium.com/@vikasgrover_19293/https-medium-com-dynamodb-aws-athena-and-tableau-b90fa7182d0f


AWS with Rediffshit with tableau
https://lynnlangit.com/2015/10/26/notes-from-building-an-aws-redshift-data-warehouse-wmatillion-and-tableau-at-reinvent/




AWS cloudwatch with tableau
https://blog.severski.net/2016/02/11/2016-02-11-connecting-tableau-to-aws-cloudwatch/


https://databoss.starschema.net/tableau-server-linux-docker-container/


Oneitguru on tableau with aws
https://onlineitguru.com/blog/tableau-server-with-aws


Youtube videos


Enabling Precision Medicine with Tableau and AWS
https://www.youtube.com/watch?v=8CjzHqK4nh8


Using Tableau and AWS for Fearless Reporting at UMD
https://www.youtube.com/watch?v=l3Lag1-KzuI


aWS with big data
https://hostingjournalist.com/video/aws-reinvent-2017-self-service-analytics-with-aws-big-data-and-tableau-arc217/

April 02
all cloud diagramt for reference:
https://www.awsgeek.com/

April 09 : AWS Cloud Search reference:
https://docs.aws.amazon.com/cloudsearch/latest/developerguide/creating-managing-domains.html
https://www.slideshare.net/AmazonWebServices/building-scalable-search-solution-webinar-final
https://www.slideshare.net/AmazonWebServices/amazon-cloud-search-beginners-guide-final


https://jayendrapatil.com/aws-cloudsearch/
https://jayendrapatil.com/cloudwatch-monitoring-supported-aws-services/
https://data-flair.training/blogs/amazon-cloudsearch/
https://www.slideshare.net/AmazonWebServices/building-scalable-search-solution-webinar-final

April 11:

Amazon simple workflow :
https://pyblog.xyz/getting-started-with-swf-flow-framework/
https://www.slideshare.net/AmazonWebServices/7-use-cases-in-7-minutes-each-the-power-of-workflows-and-automation-svc101-aws-reinvent-2013


April 12:
https://data-flair.training/blogs/
SWF use case NASA
https://aws.amazon.com/swf/testimonials/swfnasa/

April 15 - AWS AD
https://aws-quickstart.s3.amazonaws.com/quickstart-tableau-awsdata/doc/data-warehouse-modernization-on-aws-with-tableau-and-redshift.pdf
https://s3.amazonaws.com/quickstart-reference/microsoft/activedirectory/latest/doc/Microsoft_Active_Directory_Quick_Start.pdf
https://www.youtube.com/watch?v=SIBCi76wspQ
https://www.conceptdraw.com/How-To-Guide/active-directory-domain
https://d0.awsstatic.com/whitepapers/AWS_ActiveDirectory_ReferenceImplementationGuide.pdf

April 16 - Master Copy about DAtascience cheatsheet
Data Science for reference:
https://github.com/ChristosChristofidis/awesome-deep-learning
https://www.rankred.com/machine-learning-cheat-sheets/
https://www.dezyre.com/article/top-10-machine-learning-algorithms/202
https://www.rankred.com/python-frameworks/
https://www.rankred.com/free-data-mining-
https://openml.github.io/articles/slides/useR2017_tutorial/slides_tutorial.html#2
https://github.com/dformoso/machine-learning-mindmap

start a video project
https://github.com/google/youtube-8m
https://github.com/ChristosChristofidis/awesome-deep-learning
https://research.google.com/youtube8m/download.html
https://storage.googleapis.com/openimages/web/visualizer/index.html?set=train&c=%2Fm%2F01m2v

8 sample  machine lanaguage proejct
https://elitedatascience.com/machine-learning-projects-for-beginners

https://sigmoidal.io/machine-learning-terminology-explained-top-8-must-know-concepts/
https://www.google.com/imgres?imgurl=https%3A%2F%2Fnews.efinancialcareers.com%2Fbinaries%2Fcontent%2Fgallery%2Fefinancial-careers%2Farticles%2F2017%2F12%2FMachine-learning-tables.jpg&imgrefurl=https%3A%2F%2Fnews.efinancialcareers.com%2Fdk-en%2F285249%2Fmachine-learning-and-big-data-j-p-morgan&docid=h5RjPalgtSP56M&tbnid=fqwP-h8qCxFkbM%3A&vet=10ahUKEwjw5K7ij9fhAhW463MBHQw8B4IQMwhJKAkwCQ..i&w=950&h=760&bih=657&biw=1366&q=machine%20algorithm%20language%20terminology&ved=0ahUKEwjw5K7ij9fhAhW463MBHQw8B4IQMwhJKAkwCQ&iact=mrc&uact=8
AI:
https://thefinancialbrand.com/71350/ai-machine-learning-analytics-marketing-banking-trends/
https://medium.com/machine-learning-for-humans/why-machine-learning-matters-6164faf1df12

April 19 : Good Visualization and ML free books for reference
https://bbc.github.io/rcookbook/
https://mml-book.github.io/book/mml-book.pdf
https://www.kdnuggets.com/2019/03/how-choose-right-chart-type.html
https://socviz.co/lookatdata.html
https://www.kdnuggets.com/2019/03/another-10-free-must-read-books-for-machine-learning-and-data-science.html
https://bookdown.org/max/FES/illustrative-data-predicting-parkinsons-disease.html
https://www.deeplearningbook.org/

April 20 - Best Practise of AWS always nice to refer
https://www.sumologic.com/insight/10-things-might-not-know-using-s3/
https://docs.snowflake.net/manuals/user-guide/admin-security-privatelink.html
https://www.forbes.com/sites/janakirammsv/2018/11/14/what-to-expect-from-aws-reinvent-2018/#7016163cb75c
https://wblinks.com/notes/aws-tips-i-wish-id-known-before-i-started/ (Refer)
https://docs.aws.amazon.com/marketplace/latest/userguide/what-is-marketplace.html
https://www.rootusers.com/how-to-repair-an-aws-ec2-instance-without-console/
https://winterwindsoftware.com/aws-console-multiple-users/
https://support.beanstalkapp.com/article/909-how-do-i-configure-aws-s3-permissions-for-backups
https://neo4j.com/developer/guide-cloud-deployment/

NLP April 21:
https://aws.amazon.com/blogs/aws/amazon-transcribe-now-generally-available/
https://www.analyticsindiamag.com/awss-recently-launched-features-transcribe-and-translate-are-using-ml-in-revolutionary-manner/


https://medium.com/@julsimon/a-quick-look-at-natural-language-processing-with-amazon-comprehend-238b8d9ec11d
https://steemit.com/news/@cryp2me/wow-amazon-now-understand-everythinghttps://aws.amazon.com/es/comprehend/?ref=producthunt
https://awscentral.blogspot.com/2019/01/identifying-and-working-with-sensitive.html
https://www.hurricanelabs.com/blog/sentiment-analysis-with-aws-splunk-because-all-the-cool-kids-are-doing-it

AWS Mirgartion Best Practise for reference always
https://www.slideshare.net/AmazonWebServices/data-migrations-which-option-is-best-for-you-tel-aviv-summit-tel-aviv-137465990
https://www.alooma.com/blog/best-practices-for-migrating-data-from-on-prem-to-cloud

AWS Block Chain - 
https://recruitingdailyadvisor.blr.com/2018/06/use-blockchain-recruitment-efforts/

https://www.slideshare.net/AmazonWebServices/aws-reinvent-2016-blockchain-on-aws-disrupting-the-norm-gpst301
https://www.slideshare.net/arunmurughan/blockchain-on-aws-136948072
https://www.slideshare.net/AmazonWebServices/how-do-i-know-i-need-a-ledger-database-an-introduction-to-amazon-qldb (main)
https://insightaas.com/blockchain-for-the-data-centre-value-add-or-just-more-hype/
https://www.process.st/introduction-to-blockchain/

        





Difference Between "forecasting?and "prediction":

  • Forecast is scientific and free from intuition and personal bias, whereas prediction is subjective and fatalistic in nature.
  • Forecasting is an extrapolation of past into the future while prediction is judgmental and takes into account changes taking place in the future. Therefore, prediction is utilized more in business and economics while forecasting takes place in weather and earthquakes.
  • Predicting is saying or telling something before the event while forecasting is done on the basis of analysis of the past.
  • Forecasting is still not a complete science as there are chances of error, that we call the forecasting error, it's mostely utilized in data analysis.


Hope this article will give us deeper understanding of JSON and uses in different Application.

Some other link

https://www.atlassian.com/blog/enterprise/how-to-scale-it
How to use our time effectively
https://www.atlassian.com/blog/productivity/daily-schedule-tips-manage-your-meetings?utm_source=linkedin&utm_medium=social&utm_campaign=atlassian_daily-schedule-tips-manage-your-meetings

Good Article on AI and NLP:
https://www.upwork.com/hiring/for-clients/artificial-intelligence-and-natural-language-processing-in-big-data/

April  30
https://aws.amazon.com/blogs/machine-learning/visual-search-on-aws-part-2-deploying-a-visual-search-model-with-aws-deeplens/
https://www.slideshare.net/AmazonWebServices/aws-ai-services-whats-new
https://www.slideshare.net/AmazonWebServices/aws-deeplens-a-new-way-to-learn-machine-learning
https://aws.amazon.com/deeplens/community-projects/
https://github.com/awslabs/visual-search


top cloud servery
https://www.channele2e.com/channel-partners/csps/cloud-market-share-2018-aws-microsoft-google/
https://www.channele2e.com/software/apm/top-50-cloud-monitoring-management-software-tools-for-2017/

Select Any tool use this web url
https://www.scoop.it/topic/bi-tools

May 01: An OCR Serivce by AWS - Aws
May 01
https://vitalflux.com/aws-reinvent-top-7-new-machine-learning-services/
https://stevesnews.com/news/aws-textract-brings-intelligence-to-ocr?uid=434061
https://www.goodtoseo.com/aws-ceo-announces-textract-to-extract-data-without-machine-learning-skills/
https://www.alfresco.com/blogs/digital-transformation/alfresco-and-amazon-textract-help-you-extract-more-value-your-data
https://spendmatters.com/2018/12/04/extinction-event-amazon-textract-has-just-killed-the-ocr-industry-whos-next-and-whos-safe/
https://www.slideshare.net/AmazonWebServices/new-launch-introducing-amazon-textract-now-in-preview-aim363-aws-reinvent-2018pdf

May02:
Recommendation of aws
https://www.techrepublic.com/article/5-architectural-principles-for-building-big-data-systems-on-aws/
5 steps on aws migration tips
https://www.techrepublic.com/article/5-steps-for-a-successful-large-scale-cloud-migration-to-aws/
AI in E-Commerce nice url to refere
https://www.google.com/url?sa=i&source=images&cd=&cad=rja&uact=8&ved=2ahUKEwin8Nij0fvhAhXJXisKHShkC5c4rAIQMyhgMGB6BAgBEGM&url=https%3A%2F%2Fwww.engineerbabu.com%2Fblog%2Ftop-5-use-cases-of-ai-in-ecommerce%2F&psig=AOvVaw1e0s2Qr_wwPwjpcMUibt2X&ust=1556844822773110&ictx=3&uact=3
https://www.engineerbabu.com/blog/ecommerce-trends/

May05 Blackchain
?Ethereum?


https://aws.amazon.com/blogs/aws/get-started-with-blockchain-using-the-new-aws-blockchain-templates
https://docs.aws.amazon.com/blockchain-templates/latest/developerguide/blockchain-templates-ethereum.html
hyperledger:
https://www.slideshare.net/careck/hyperledger-in-awsx
https://github.com/aws-samples/non-profit-blockchain
https://docs.aws.amazon.com/blockchain-templates/latest/developerguide/blockchain-templates-hyperledger.html



shutyourmouth for while to speak confidence
https://www.youtube.com/watch?v=a2MR5XbJtXU

        

POWERBI Tips - 2021

https://www.youtube.com/watch?v=z8Zkz-he2xI

Top 10 Powerbi Blogs for Reference

https://insightsoftware.com/blog/top-power-bi-blogs/

6 things to consider before deploy your powerbi dashbaord
https://www.youtube.com/watch?v=36z41W6dVQs&list=PLr7RyN24TvNYJ7bI8q1KfYN2BUpJdnpJo

https://blog.pragmaticworks.com/time-saving-quick-tips-for-power-bi-beginners

Powerquery:
https://theexcelclub.com/9-tips-for-powerbi-users/


Performance analyzer in Powerbi
https://powerbi.tips/2019/12/more-visuals-mo-problems/



Rowlevel Security
https://sqlmasteracademy.com/how-to-implement-role-level-security-with-role-playing-dimensions-in-powerbi/

How to Refresh incremental:

https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/

https://blog.enterprisedna.co/dax-query-in-power-bi-logical-physical-query-plans/

https://blog.enterprisedna.co/data-modelling-in-power-bi-tips-best-practices/

https://blog.enterprisedna.co/data-loading-and-transformation-best-practices/

https://blog.enterprisedna.co/tips-to-transform-data-inside-power-bi/

https://blog.enterprisedna.co/how-to-organize-your-power-bi-models-best-practice-tips/

https://blog.enterprisedna.co/calculated-columns-power-bi-tips-best-practices/

https://blog.enterprisedna.co/best-practices-for-data-visualization-in-power-bi/

https://blog.enterprisedna.co/simple-power-bi-measures-beginners-tutorial-and-best-practices/

https://blog.enterprisedna.co/creating-measure-groups-power-bi-best-practices/

https://blog.enterprisedna.co/my-3-best-practice-tips-for-organising-power-bi-models/

https://blog.enterprisedna.co/tips-for-power-bi-report-design-best-practices/

DateModeling

https://addendanalytics.com/data-modelling-best-practices/

Data Modeling Video:
https://www.skylinetechnologies.com/Blog/Skyline-Blog/February_2021/power-bi-star-schema-dimensional-data-modeling


dAX:

https://blog.enterprisedna.co/deep-dive-into-the-calculatetable-function-an-important-dax-formula-to-understand-well/

Nice on DAX Patter - Master 
https://www.daxpatterns.com/patterns/

Q&A:

https://blog.enterprisedna.co/detailed-review-of-the-qa-service/

Dashboard :
https://blog.enterprisedna.co/power-bi-dashboard-design-best-practice-tips/


https://blog.enterprisedna.co/tabular-editor-power-bi-version-3-review-tutorial/


https://blog.enterprisedna.co/power-bi-challenge-13-acing-your-documentation/


Formulas :
https://www.fourmoo.com/2017/01/24/power-bi-how-to-filter-slicers-dynamically/



============================================================

Simply Powerbi for Reference : very BAsic idea is good
https://efficiency365.com/2021/02/19/power-bi-for-excel/

Wonderful Blogs:
https://efficiency365.com/blog/page/4/
https://zebrabi.com/blog/
https://www.fourmoo.com/category/power-bi/page/2/


Wonderful Video:
https://zebrabi.com/zebra-bi-guest-at-radacad-youtube-live-session/

Mastering Variance :
https://zebrabi.com/power-bi-variance-reports/ 

Jun08:
POWERBI
https://blog.pragmaticworks.com/migrating-self-service-datasets-to-datflows
Best Practise - Fantastics

https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/


Clean up data
https://efficiency365.com/2020/04/24/cross-tab-and-multi-layer-header-cleanup/

Date:
https://blog.enterprisedna.co/manage-multiple-date-calculations-in-your-fact-table-advanced-power-bi-technique/



https://www.fourmoo.com/2020/09/02/how-to-automate-your-data-to-always-store-the-last-2-years-of-data-using-power-query/


next blog prepared today
https://debbiesmspowerbiazureblog.home.blog/2020/05/07/power-bi-dax-calculate-and-filter-and-implicit-and-explicit-filtering/

DAX:
https://zebrabi.com/power-bi-dax/

Key board shortcut in DAX: Nice one to USe

https://www.biinsight.com/quick-tips-keyboard-shortcuts-hotkeys-when-writing-dax-in-power-bi-desktop/

SQL Equvalent Powerbi DAX formula for Reference

https://datacaffee.com/sql-equivalent-power-bi-dax-functions-part-2/


Deployment :
Power BI Dev to Prod without using Deployment?Pipelines
https://debbiesmspowerbiazureblog.home.blog/2021/02/18/power-bi-dev-to-prod-without-using-deployment-pipelines/

Power BI when to (Possibly) use a Bi Directional Filter in your data?model
https://debbiesmspowerbiazureblog.home.blog/2021/02/12/power-bi-when-to-possibly-use-a-bi-directional-filter-in-your-data-model/

AZURE Deployment:
Azure SQL Database. Publishing from Development to Production Part?2
https://debbiesmspowerbiazureblog.home.blog/2021/01/26/azure-sql-database-publishing-from-development-to-production-part-2/

Others : Performance:

https://www.fourmoo.com/2020/11/26/how-to-enable-dataset-sizes-larger-than-10gb-for-power-bi-premium-or-power-bi-premium-per-user/

SORT:
https://www.fourmoo.com/2020/07/14/showing-dates-in-reverse-order-for-tables-matrix-with-dates-so-that-the-latest-is-always-shown-first-in-a-power-bi-matrix/


All in one : Master
https://www.seerinteractive.com/labs/power-bi-guide-data-visualization-marketers/

Beatiful day :found really good video Jun 16 2021
==================================================
200 + video
https://www.youtube.com/playlist?list=PL1N57mwBHtN0JFoKSR0n-tBkUJHeMP2cP
Adam and patrick
https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w
Curbal
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/featured
Youtbe powerbi

https://www.youtube.com/channel/UCUGtXzpyE-HtDjgCPcXrbyQ

community:
https://community.powerbi.com/

Powerbi Project Checklist
https://www.powerbi-pro.com/en/power-bi-project-checklist/


Powerbi Layout screenshot for Reference
https://www.powerbi-pro.com/layouts/basic-layout/


DAtamodel tips on oltp vs olap : nice explanations - Always Refer
https://debbiesmspowerbiazureblog.home.blog/2020/02/07/the-dos-and-donts-of-power-bi-relationships-and-modelling/



Mis
        

tablau best practise for calculations

https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_bestpractices.htm

https://datacrunchcorp.com/tableau-calculated-field/


Key board Shorcut in DAX:
https://www.biinsight.com/quick-tips-keyboard-shortcuts-hotkeys-when-writing-dax-in-power-bi-desktop/        


POWERBI :

https://www.learndatainsights.com/topic/design-a-data-model/

DATA Model:

https://uxknowledgebase.com/data-modeling-f0c45286a910

No alt text provided for this image

POWER QUERY :

Make your data useful with Power Query (linkedin.com)

The Power Query user interface - Power Query | Microsoft Docs

Referencing Power Query queries - Power BI | Microsoft Docs

Three Ways to Use Power BI Dataflows — SQL Chick

fantastic power query : An overview of Power Query in Power BI - Dibyendu Deb

fantastic power query : Power Query: the 2021 definitive beginners' guide ? UpSlide

15 Best Power BI Dashboard Examples - Rigorous Themes

Dataflow Vs. Dataset: What are the Differences of these two Power BI Components - RADACAD

Three Ways to Use Power BI Dataflows — SQL Chick


fantasic:

Converting Power BI Desktop Reports to Enterprise Ready Components (datahai.co.uk)

Power BI Dataflow - New Diagram View - Hat Full of Data

How to Create Data flow in power very nice represenation with hands on

Introduction to Power BI Dataflow – Part 1 – PARAG CHAPRE BLOG

Capacity and SKUs in Power BI embedded analytics - Power BI | Microsoft Docs

fantatics power query : switch view

The Power Query user interface - Power Query | Microsoft Docs

AZURE :

(74) mrpaulandrew - YouTube

Azure Info Hub - Azure Data Factory (All videos)

A Day Full of Azure Data Factory – Welcome to the Community Blog of Paul Andrew (mrpaulandrew.com)

Data integration at scale Azure Data Factory - Learn | Microsoft Docs

fantasatic all azure vidoes

Azure Info Hub - Azure Data Factory

fantastic on AZure

GitHub - mrpaulandrew/A-Day-Full-of-Azure-Data-Factory: A full day of community training on Microsoft Azure Data Factory

Powerbi dax:

Power Pivot's Data Model and DAX Formula in a Nutshell — Lightdotlab

Calculate Faster with DAX Measures — Lightdotlab


ER - Explained nice

Introduction to the ER Data Model (flaviocopes.com)



6

Santhosh Balakrishnan

IT Recruitment / Campus hiring. immediate joiner

7 年

Share your contact

要查看或添加评论,请登录

Sri Sivakumar Ramar ( An Agile Learner )的更多文章

  • AI World

    AI World

    Welcome to AI World As we know how AI help and facilitates the people make better decisions by analyzing large amounts…

  • Dates Always - Comparing your latest week to the same days of the previous week

    Dates Always - Comparing your latest week to the same days of the previous week

    Solved: Dynamic date period Filter based on slicer selecti..

  • ML and Charts Using R

    ML and Charts Using R

    Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial) – business intelligist…

  • Essential SQL Query to Know

    Essential SQL Query to Know

    select first and last row sql Code Example (codegrepper.com) SQL Window Functions Cheat Sheet | LearnSQL.

  • Looker - BI for making better business decision

    Looker - BI for making better business decision

    Looker's a Web-based platform that allows users to explore data in a timely manner to help them make better business…

  • I want to know what is Python Pandas

    I want to know what is Python Pandas

    Python Zen Master: Jan 26 1121 am python-tips/python_tips.ipynb at main · CalebCurry/python-tips · GitHub…

  • JASPER REPORT - An Overview

    JASPER REPORT - An Overview

    JASPER Report an Overview - Intended for Begineers Jaspersoft : An embeddable reporting and analytics platform designed…

    2 条评论
  • Gradient descent

    Gradient descent

    An Article about Gradient Descent Gradient Descent is a popular algorithm to perform optimization of deep learning such…

  • Visualization ???

    Visualization ???

    Tableau : History of Innovations Analyzing the history of Tableau innovation History of Tableau Innovation | Tableau…

  • Naive Bayes Classifier

    Naive Bayes Classifier

    Naive Bayes Classifier for Predicting the Party Voting of "Republican" & "Democrat". Naive Bayes classification is a…

社区洞察

其他会员也浏览了