{"title":"collection","description":null,"products":[{"product_id":"power-bi-step-by-step-tutorial-for-beginners-and-experienced","title":"Power BI Step by Step Tutorial for Beginners and Experienced","description":"\u003ch4 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat will students learn in your course?\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eStudents will be able to learn Power BI from begineers to advance level where any one can build professional-quality business intelligence reports from scratch.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eLearn how you can visualize and format data using different visualizations like Pie-chart, Donut chart, Table, Cards etc in a meaningful way to get deep insight\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eMastering Data Analysis Expressions (DAX) for Power BI Desktop. Where we learn basic to advance level DAX progressively.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eLearn how to shape-up data, clean messy data, remove errors and do ETL process as per your requirement using Power Query Editor\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eLearn how to connect to different sources like CSV, Text, Excel, SQL Server and Live Websites etc..\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eExploring latest tools and features available in Power BI Service and Learn to create stunning Dashboards and Reports (This part will be updated soon)\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eConfiguring user roles and row-level security to maintain data quality and control (This part will be updated soon)\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eStudents will have the required knowledge to work with Power BI and this hands on course will prepare you to build job-ready skills for career in Data Analysis\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat are the requirements or prerequisites for taking your course?\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eAbsolutely no prior technical experience is required just need basic knowledge of operating computer and internet.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eThis course is designed from basic to advance level so no prior Power BI knowledge needed.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eYou must have Microsoft Power BI Desktop (free download) along with Windows operating system \/ computer\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eExperience with Excel and SQL is a plus, but not required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWho is this course for?\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eAny one who wants to build job-ready skills for a career in Data Analysis or Business Intelligence.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eNewbies who are looking to enhance their skill sets in the field of Business Analysis.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWorking Power BI professionals who want to take up their skills to next level.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eIf you are pursuing your career as a data analyst then this course is for you\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-pm-slice=\"1 1 []\"\u003eThis course will be progressively updated (on regular basis) and we will try to cover all Power BI topics from basic to advance level, New videos will be added weekly or regularly.\u003c\/p\u003e\n\u003cp\u003eIf you are looking for complete practical based step by step Power BI course, you've come to right place. This course for those users looking to learn Power BI using real time practical based scenarios and want to take their Power BI skills to next level.\u003c\/p\u003e\n\u003cp\u003eLearning power bi will be the smartest move in your career because among all other BI tools available in a market, Power BI  standout as a No 1 BI tool in the world right now and not only that there is a huge demand and big job market available for Power BI professionals in most MNCs and in bigger firms. So to boost your career by learning Power BI Step by Step.\u003c\/p\u003e\n\u003cp\u003eWith Power BI you can connect to hundreds of data sources like text, CSV, SQL analysis services, SQL server, MySQL, build complex relational models using simple and intuitive tools, and design stunning, interactive awesome dashboards from scratch, You can turn your raw data into visualization and many more.\u003c\/p\u003e\n\u003cp\u003eThis hands on course will prepare you to start your data analytics career.\u003c\/p\u003e\n\u003cp\u003eIf you're looking to build expert level data analysis skills using DAX and Power BI, this is the course for you and this course will prepare you prepare you to build job-ready skills for a career in Data Analysis or Business Intelligence.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 1 - What is Power BI, Linked Reports, Power BI Installation,  Power Query.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1:- What is Business Intelligence, Power BI and Why Power BI ?\u003cbr\u003eChapter 2:- How to Download and Install Power BI\u003cbr\u003eChapter 3:- Interface Tour of Power BI Desktop\u003cbr\u003eChapter 4:- Connecting to Text\/CSV Source File\u003cbr\u003eChapter 5:- Power Query Editor : Shaping up CSV Data, Working with Applied   Steps,    Renaming Data Table, Headers and Removing Blank Rows, Error Data, Replacing Values.\u003cbr\u003eChapter 6:- Loading Multiple Data : Excel Data with CSV Data\u003cbr\u003eChapter 7:- Creating Duplicating Columns For Creating Relationship in Data Model.\u003cbr\u003eChapter 8:- Loading and Formatting Data in Stacked Bar Visual, Creating \u0026amp; Duplicating Pages\u003cbr\u003eChapter 9:- Working with Clustered Bar Chart, Pie Chart, Line Chart and Funnel Chart\u003cbr\u003eChapter 10:- Working with Slicers, Table, Donut Charts, Maps, Cards\u003cbr\u003eChapter 11 :-  Understand types of filters, Data Filters, TopN, types of filters in power bi?\u003cbr\u003eChapter 12 :-  Conditional Formatting in Charts\u003cbr\u003eChapter 13 :-  Linked Reports (Drill Through Report)\u003cbr\u003eChapter 14 :-  Working with Bookmarks and Buttons\u003cbr\u003eChapter 15 :-  Exploring Data with QnA Component\u003cbr\u003eChapter 16 :-  Connecting SQL Server Database and creating visual\u003cbr\u003eChapter 17 :-  Connecting Website URL and Creating Visuals\u003cbr\u003eChapter 18 :-  What is Power Query ?\u003cbr\u003eChapter 19 :-  Understanding Data Types and Creating Custom  Tables\u003cbr\u003eChapter 20 :-  Keep rows and remove rows\u003cbr\u003eChapter 21 :-  Removing Special Characters (Rupee Symbol) From Strings (M-Function)\u003cbr\u003eChapter 22 :-  Basic Calculations (Standard and Scientific), Conditional Columns and Creating Index\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 2 - Explain Pivot vs Unpivot, Parameters, Merge and append Queries .\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 23 :- Pivot and Unpivot\u003cbr\u003eChapter 24 :- Working with Parameters (Simple, List, Query)\u003cbr\u003eChapter 25 :- Merge Queries and Append Queries.\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 3 - Joins and Join Kind, Optimize PBIX File , Database Normalization.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 26 :- Types of Join or Types of Join Kind in Power BI.\u003cbr\u003eChapter 27 :- How to optimize PBIX file using Load Feature.\u003cbr\u003eChapter 28 :- Understand Database Normalization.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 4 - Explain Data Model, OLTP, Star Schema \u0026amp; Snowflake Design. Dax Function\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 29 :- What is Data Model, Fact Table, Dimension Table?\u003cbr\u003eChapter 30 :- OLTP VS OLAP, Star Schema and SnowFlake designs.\u003cbr\u003eChapter 31 :- Explain DAX and how to Create Measure Table.\u003cbr\u003eChapter 32 :- Calculated Columns vs Calculated Measures.\u003cbr\u003eChapter 33 :- Dax Function - SUM vs SUMX.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 5 : Maths DAX Function, Logical DAX Function, Text DAX Function in Power BI.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 34 :- Maths DAX Functions : MIN, MAX, AVERAGE, DISTINCT, COUNT\u003cbr\u003eChapter 35 :- Logical DAX Functions : IF, AND, OR, TRUE, FALSE, ISTEXT, ISERROR, ISBLANK, SWITCH.\u003cbr\u003eChapter 36 :- Text DAX Functions : TRIM, LEN, LOWER, UPPER.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 6 :- Understand Filter Dax Functions in Power BI.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 37 :- Filter DAX Functions - Value, Filter, Calculate \u0026amp; Related.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 7 :- Explain ALL, ALLExcept, AllSelected Table Joins-Crossjoin, Union.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 38 : Explain ALL, ALLExcept,\u003cbr\u003eChapter 39 : AllSelected Table Joins-Crossjoin, Union, Except \u0026amp; Intersect?\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 8 :- Explain Fields in Power BI, Numeric range parameter and difference between DateAdd and ParallelPeriod.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 40 :- What are Fields, Numeric Range (What-if) Parameter in Power BI?\u003cbr\u003eChapter 41 :- Date and Time : DateAdd vs ParallelPeriod\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 9 :- LookupValue DAX Function and Date \u0026amp; Time Function in Power BI.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 42 :- What is LookupValue DAX Function in Power BI?\u003cbr\u003eChapter 43 :- Date \u0026amp; Time : Datesbetween, DatesinPeriod, DatesQTD, DatesMTD, DatesYTD.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 10 :- DAX Variables, Power DAX USERELATIONSHIP \u0026amp; TREATAS.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 44 :- Understand DAX Variables(VAR).\u003cbr\u003eChapter 45 :- Power DAX USERELATIONSHIP, TREATAS.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 11 :- Explain the difference between TotalMTD \u0026amp; DatesMTD, what is SAMEPERIODLASTYEAR function in DAX.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 46 :- TotalMTD vs DatesMTD, TotalQTD vs DatesQTD and TotalYTD vs DatesYTD (DAX).\u003cbr\u003eChapter 47 :- Understanding SAMEPERIODLASTYEAR function and SAMEPERIODLASTYEAR vs PARALLELPERIOD (DAX).\u003cbr\u003eChapter 48 :- Import Query vs Direct Query in Power BI.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 12 :- What is RELATED \u0026amp; RELATEDTABLE, Calculate Top N Values Dynamically, Rank using DAX RANKX.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 49 :- Understand RELATED and RELATEDTABLE in Power BI Dax.\u003cbr\u003eChapter 50 :- Understand DAX TOPN and how to dynamically calculate Top N Values.\u003cbr\u003eChapter 51 :- How to rank using DAX RANKX in Power BI?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 13 :- Explain SELECTEDVALUE DAX function, SELECTCOLUMNS vs ADDCOLUMNS.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 52 :- Using the SELECTEDVALUE DAX function in Power BI?\u003cbr\u003eChapter 53 :- SELECTCOLUMNS vs ADDCOLUMNS and how to use these functions to generate new tables in Power BI?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePart 14 :- Use GROUPBY without DAX, Explain SUMMARIZE vs GROUPBY.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 54 :- How to use GROUPBY in Power BI without DAX?\u003cbr\u003eChapter 55 :- Power BI DAX SUMMARIZE vs GROUPBY.\u003cbr\u003eChapter 56 :- Calculating work days using DAX Networddays.\u003c\/p\u003e","brand":"Questpond Videos","offers":[{"title":"Default Title","offer_id":42876578332878,"sku":"","price":1200.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0644\/2359\/2142\/files\/PowerBIStepByStep.png?v=1732620784"},{"product_id":"msbi-interview-questions-with-answers","title":"MSBI Interview Questions with Answers","description":"\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat will students learn in your course?\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eThis course contains practical MSBI Interview Questions with Answers.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eMSBI Interview Questions around SSIS Data Flow, Control Data Flow, ETL Process, SSIS Architecture, SSIS Perfmon Counters, SSIS lookup component.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eError Handling in SSIS, SSIS Containers, Deploy SSIS package to SQL Server, Transactions and CheckPoints\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eSSIS logging, File System Deployment, Union all, Merge, Data Profiling Task, Precedence Constraints.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat are the requirements or prerequisites for taking your course?\u003c\/h3\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\n\u003cul\u003e\n\u003cli\u003eBasic Knowledge of SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWho is this course for?\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eMSBI Developers who are looking to crack MSBI Interviews\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eSSIS developers who want to crack SSIS interviews\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eSSAS developers who want to crack MSBI Interviews\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eSSRS developer who want to crack SSRS interviews\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-pm-slice=\"1 3 []\"\u003ePrepare for MSBI Interview with over 25 questions and answers with practical demonstrations :-\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on ETL Process, SSIS Control Flow and other SSIS concepts :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 1: What is ETL Process with example?\u003cbr\u003eQuestion 2: Difference between control flow and data flow in SSIS?\u003cbr\u003eQuestion 3: Explain the architecture of SSIS?\u003cbr\u003eQuestion 4: Explain the types of Perfmon counters for SSIS?\u003cbr\u003eQuestion 5: Explain the types of Cache Mode in SSIS Lookup component?\u003cbr\u003eQuestion 6: SSIS Variables vs Parameters?\u003cbr\u003eQuestion 7: How to Schedule SQL Server Integration Services (SSIS) Package?\u003cbr\u003eQuestion 8: How to pass variable as a parameter in Execute SQL Task SSIS?\u003cbr\u003eQuestion 9: How to send mails in SSIS?\u003cbr\u003eQuestion 10: SSIS Pivot and Unpivot?\u003cbr\u003eQuestion 11: What is Aggregation in SSAS?\u003cbr\u003eQuestion 12: What are Partitions in SSAS?\u003cbr\u003eQuestion 13: Explain Types of SSAS Storage Modes?\u003cbr\u003eQuestion 14: SSAS Relationships Types?\u003cbr\u003eQuestion 15: Named calculation vs Named query in SSAS?\u003cbr\u003eQuestion 16: What are the different data regions in SSRS?\u003cbr\u003eQuestion 17: How to Create Multi Valued Parameterized Report in SSRS?\u003cbr\u003eQuestion 18:  Explain the different types of reports in SSRS?\u003cbr\u003eQuestion 19: How to send Automatic Report Delivery in SSRS?\u003cbr\u003eQuestion 20: Mention some of the open source softwares which are an alternative to SQL Server Reporting Services (SSRS)?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on Error Handling, SSIS Containers, Deploy SSIS Package :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 21 - How to do Error Handling in SSIS.\u003cbr\u003eQuestion 22- Types of Containers in SSIS.\u003cbr\u003eQuestion 23 - How to do SSIS Package Deployment to SQL Server?\u003cbr\u003eQuestion 24 - What are Transactions?\u003cbr\u003eQuestion 25 - What are Checkpoints?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on SSIS Logging, Union All vs Merge, Data Profiling Task :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 26 : What is Logging in SSIS?\u003cbr\u003eQuestion 27 : How to create File System Deployment?\u003cbr\u003eQuestion 28 : Difference between Merge and Union All?\u003cbr\u003eQuestion 29 : What is the Data Profiling task?\u003cbr\u003eQuestion 30 : What is Precedence Constraints?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on Joins in MSBI, OLAP VS OLTP, Star Schema, Snow Flake, SSAS Cube :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 31 : What is Merge Join and explain its different types of Joins?\u003cbr\u003eQuestion 32 : Difference between OLTP \u0026amp; OLAP.\u003cbr\u003eQuestion 33 : What is Fact, Dimension, Cube, Star Schema and Snow Flake?\u003cbr\u003eQuestion 34 : How to create a Cube in SSAS?\u003cbr\u003eQuestion 35 : What is SCD?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on CDC, SSRS Report, Tabular Report, Matrix Report and Page Break :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 36 :- What is CDC?\u003cbr\u003eQuestion 37 :- What is SSRS, what is Data Region, can embed\/display SSRS Reports in any application, File extension and Code behind of SSRS Report.\u003cbr\u003eQuestion 38 :- How to Deploy SSRS reports?\u003cbr\u003eQuestion 39 :- Difference between Tabular and Matrix Report.\u003cbr\u003eQuestion 40 :- What is Page Break in SSRS?\u003cbr\u003eQuestion 41 :- Difference between Drilldown Report \u0026amp; Sub Report.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eExplain creating cascade parameters and defining clickable areas in SSRS Reports?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 42 :- How to Create Cascade Parameters in SSRS Report ?\u003cbr\u003eQuestion 43 :- How to define clickable areas in SSRS Report?\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Questpond","offers":[{"title":"Default Title","offer_id":42878379622606,"sku":"","price":499.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0644\/2359\/2142\/files\/msbi1_300x-100.jpg?v=1732769148"},{"product_id":"power-bi-interview-questions-and-answers","title":"Power BI Interview Questions and Answers","description":"\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat will students learn in your course?\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eUnderstand what kind of Questions are asked in Power BI and how to answer the same.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eCovers Power BI questions around Calculated columns,Calculate measures , M Codes , Power Query, Parameters , Power BI gateway, visual level vs page level vs rep\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eHow to tackle Power BI Interview Questions around All vs All Except ,What IF , Grouping in power BI , Distinct vs Values.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eHow to confidently answer questions around Sum vs Sumx , Query vs Direct Query\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat are the requirements or prerequisites for taking your course?\u003c\/h3\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\n\u003cul\u003e\n\u003cli\u003eBasic SQL Server knowledge.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWho is this course for?\u003c\/h3\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\n\u003cul\u003e\n\u003cli\u003ePower BI Developers who are looking for cracking interview.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-pm-slice=\"1 3 []\"\u003e\u003cstrong\u003eWe're pleased to let you know that we have just published a new video on variables (DAX VAR) and power bi pivot and unpivot. This new year 2023 we are planning to add more videos in this course  especially around advance DAX questions like Time Intelligence Questions, Dashboards and Row Level Security and many more.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eSo stay updated and please subscribe to this course.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCovers Calculated Columns, Measures, Power Query, Data Gateway \u0026amp; Parameters :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 01 :- What are Calculated columns ?\u003cbr\u003eQuestion 02 :- Where can calculated columns be created in Power BI?\u003cbr\u003eQuestion 03 :- What are calculated measures in Power BI?\u003cbr\u003eQuestion 04 :- Where can calculated measures be created in Power BI?\u003cbr\u003eQuestion 05 :- Difference between Calculated Column and Measure in Power BI?\u003cbr\u003eQuestion 06 :- What are M codes in power bi \u0026amp; Where Can You Write Power Query M Code?\u003cbr\u003eQuestion 07 :- What are Parameters in Power BI?\u003cbr\u003eQuestion 08 :- What is Power BI data gateway?\u003cbr\u003eQuestion 09 :- Do we need data gateway for schedule refresh in Power BI?\u003cbr\u003eQuestion 10 :- What is Query Folding in Power BI?\u003cbr\u003eQuestion 11 :- What is the use of Split function in Power BI?\u003cbr\u003eQuestion 12 :- Difference between visual level, page level and report level filters in Power BI?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on ALL \u0026amp; ALL EXCEPT functions, Grouping , what if parameter, Distinct :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 13:- Difference between ALL and ALL EXCEPT functions?\u003cbr\u003eQuestion 14:- What is \"What if\" parameter in Power BI?\u003cbr\u003eQuestion 15:- How to keep or remove specific rows in Power BI?\u003cbr\u003eQuestion 16: What is grouping in power bi and how to use it?\u003cbr\u003eQuestion 17:- Difference between Distinct and Values in Power BI?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eImportant questions on DAX, DAX Function, Power Query, Power BI Reports :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 18:-What is DAX and most common DAX functions used?\u003cbr\u003eQuestion 19:- What is Power Query?\u003cbr\u003eQuestion 20:- What are different types of Filters in Power BI Reports?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDifferentiating between sum vs sumx and Direct Query vs Import Query :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 21 :- Difference between sum and sumx in power bi?\u003cbr\u003eQuestion 22 :- Import Query vs Direct Query in power bi?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAppend Query vs Merge Query and different types of Power BI Joins :-\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 23 - Append Query VS Merge Query in Power BI ?\u003cbr\u003eQuestion 24 - Types of Join and Types of Join kind in Power BI ?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLookupValue DAX function, Differentiate Datesbeteween VS  DatesinPeriod in Power BI.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 25 - What is LookupValue DAX function in Power BI ?\u003cbr\u003eQuestion 26- Understand Datesbetween vs DatesinPeriod ?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCrack Power BI Interview Questions on COUNTA, COUNTX, COUNTAX, Filter Top N.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 27 - COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTINCTCOUNT, COUNTROWS ?\u003cbr\u003eQuestion 28 - How to filter Top N in Power BI ?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDifference between USERELATIONSHIP and TREATAS, Bookmark in Power BI.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 29 :- Power BI USERELATIONSHIP VS TREATAS ?\u003cbr\u003eQuestion 30:- What is Bookmark in Power BI?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eVariables in Power BI and how Power Pivot and Unpivot differs from each other.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 31 - Variables in Power BI ?\u003cbr\u003eQuestion 32 - Power Pivot VS Power Unpivot ?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eEssential questions around Table Joins, Crossjoin and DAX RANX Function.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 33 - How to use the DAX RANKX function in Power BI?\u003cbr\u003eQuestion 34 - Table Joins - Crossjoin, Union, Except \u0026amp; Intersect?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eExplain how to use Calculate DAX Function ?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 35 :- How to use Calculate DAX Function in Power BI ?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eRELATED VS RELATEDTABLE, DATEADD \u0026amp; PARALLELPERIOD Functions in DAX.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 36 :- What is the difference between Related and RelatedTable ?\u003cbr\u003eQuestion 37 :- What is the use of DateAdd and ParallelismPeriod Functions?\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\u003c\/div\u003e","brand":"Questpond","offers":[{"title":"Default Title","offer_id":42878389190862,"sku":"","price":499.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0644\/2359\/2142\/files\/pic_78.jpg?v=1732769508"},{"product_id":"mysql-interview-questions-answers","title":"MYSQL Interview Questions \u0026 Answers","description":"\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat will students learn in your course?\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eQuestions will help you in revising MySQL concepts \u0026amp; to know how to answer most asked MySQL questions by IT firms. Each question is explained with an example.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eHow to answer common MySQL Interview Questions around Normalization \u0026amp; Denormalization, 1st, 2nd and 3rd Normal Form, Aggregate functions, InnoDB, MyISAM.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eMySQL writing question around Inner Join, Left Join, Right Join, Cross Join, Subqueries \u0026amp; Co-related queries, Union vs Union All, Views, Like \u0026amp; Regex operators\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eIn-depth explanations of complex and tricky concepts around ENUM, Char vs Varchar, Blog datatypes, text datatypes, Triggers, Transactions and its implementation\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eComparison questions Stored Procedures vs functions, text vs blob, primary key vs candidate key,  IFnull vs ISNull, Char vs Varchar.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eExtensive explanations of tricky questions such as Transactions, Trigger, Blog vs Text data types, Candidate key vs Unique key, Stored Procedure vs Stored Function.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWhat are the requirements or prerequisites for taking your course?\u003c\/h3\u003e\n\u003cdiv class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003e\n\u003cul\u003e\n\u003cli\u003eKnowledge of MySQL and PHPMyAdmin.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eWho is this course for?\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eMySQL Developers who are preparing for the next job interview.\u003c\/li\u003e\n\u003cli class=\"ud-heading-md goals-form--question-label--Q6a-b\"\u003eDevelopers who wants answer to the point, be practical and be prepared about MySQL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp data-pm-slice=\"1 3 []\"\u003eWelcome to the MySQL interview and answers course ! Are you ready to take your interview preparations skills and career to the next level?\u003c\/p\u003e\n\u003cp\u003eThis course will prepare you for the \u003cstrong\u003e40 plus most asked difficult \/ easy MySQL interview questions\u003c\/strong\u003e. Each questions is answered with practical example and shown how to frame your answer, so we will learn the answers to 40 plus most asked questions in total! and updating more !\u003c\/p\u003e\n\u003cp\u003eThis course will help you to understand and know how to answer most difficult questions like on \u003cstrong\u003eTransactions, Triggers, MySQL Joins, Stored Procedures, Functions, Database Normalization and so on\u003c\/strong\u003e.\u003c\/p\u003e\n\u003cp\u003eIf you are looking to boost your career to next level or looking for MySQL jobs, this course will help you to strengthen your skills and to connect the dots like how to rightly answer to the point with practical example.\u003c\/p\u003e\n\u003cp\u003eAlso, a free e-book is provided, with all questions and answers from the course compiled together.\u003c\/p\u003e\n\u003cp\u003eSo, why hesitate? Join me in this course and ace your next interview!\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eExplain Normalization, Denormalization, Normal Forms in MySQL, Trigger \u0026amp; Joins.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 1 : Explain Normalization \u0026amp; Denormalization?Question 2 : Explain 1st,2nd and 3rd Normal Form in MYSQL Database Normalization?\u003cbr\u003eQuestion 3 : Primary Key vs Foreign Key?\u003cbr\u003eQuestion 4 : Primary Key vs Candidate Key vs Unique Key?\u003cbr\u003eQuestion 5 : What is a trigger? How you can create a trigger in MYSQL?\u003cbr\u003eQuestion 6 : Explain Transactions and How to Implement it in MYSQL?\u003cbr\u003eQuestion 7 : What is an index? How can an index be declared in MYSQL?\u003cbr\u003eQuestion 8 : What is the view? How can you create and drop view in MYSQL?\u003cbr\u003eQuestion 9 : Explain Inner Join?\u003cbr\u003eQuestion 10 : Explain Left Join?\u003cbr\u003eQuestion 11 : Explain Right Join?\u003cbr\u003eQuestion 12 : Explain Cross Join?\u003cbr\u003eQuestion 13 : MYSQL Union vs Union All?\u003cbr\u003eQuestion 14 : What are MYSQL Aliases?\u003cbr\u003eQuestion 15 : Explain MYSQL Subquery?\u003cbr\u003eQuestion 16 : Blob vs Text data types in MYSQL?\u003cbr\u003eQuestion 17 : CHAR vs VARCHAR data types?\u003cbr\u003eQuestion 18 : What are the differences between InnoDB and MyISAM engines?\u003cbr\u003eQuestion 19 : What are some of the common MYSQL COMMANDS?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eENUM in MySQL, GRANT Command, TRUNCATE vs DELETE in MySQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 20 : What are aggregate functions in MYSQL?\u003cbr\u003eQuestion 21: How can ENUM be used in MySQL?\u003cbr\u003eQuestion 22:Explain GRANT Command in MySQL?\u003cbr\u003eQuestion 23:What is the difference between Truncate and Delete?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat are Stored Procedure \u0026amp; Stored Function in MySQL?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 24 :- Explain MySQL Stored Procedures ?\u003cbr\u003eQuestion 25 :- Explain MySQL Stored Function ?\u003cbr\u003eQuestion 26 :- MySQL - Stored Procedures VS Stored Function\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat is self-referencing foreign key, LIKE vs REGEXP Operators, query cache.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 27 :- What is self-referencing foreign key?\u003cbr\u003eQuestion 28 :- What is the difference between the LIKE and REGEXP Operators?\u003cbr\u003eQuestion 29 :- How does query cache work in MySQL?\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions on SAVEPOINT statement, import\/export work in MySQL, IFNULL \u0026amp; ISNULL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestion 30 :- Explain the SAVEPOINT statement in MySQL Transactions?\u003cbr\u003eQuestion 31 :- How does database import or export work in MySQL?\u003cbr\u003eQuestion 32 :- Explain difference between IFNULL \u0026amp; ISNULL functions in MySQL?\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Questpond","offers":[{"title":"Default Title","offer_id":42878399152334,"sku":"","price":499.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0644\/2359\/2142\/files\/YoutubeThumbnail_13.png?v=1732770167"},{"product_id":"https-questpondshop-myshopify-com-products-online-live-training","title":"Project Based Angular Step By Step Training","description":"\u003ch3 class=\"title\"\u003eWhat you'll learn :- \u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eIt is a 6 Days combined Training \u0026amp; Practical's on Angular.\u003cbr\u003e\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003e8 Months Video Subscription Program of Angular step by step and Interview Questions.\u003cbr\u003e\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDoubt clearing related to Training Program.\u003cbr\u003e\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eExclusive support from expert. \u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cdiv\u003e\u003cstrong\u003ePre-requisite: -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cstrong\u003eVS Code :- \u003ca href=\"https:\/\/code.visualstudio.com\/sha\/download?build=stable\u0026amp;os=win32-x64-user\"\u003ehttps:\/\/code.visualstudio.com\/sha\/download?build=stable\u0026amp;os=win32-x64-user\u003c\/a\u003e\u003cbr\u003e\u003cbr\u003e\u003c\/strong\u003e\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eNode recent installation\u003cbr\u003e\u003c\/strong\u003e\u003cstrong\u003e\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eGood internet\u003cbr\u003e\u003cbr\u003e\u003c\/strong\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eVisual Studio Latest Version:- \u003ca href=\"https:\/\/visualstudio.microsoft.com\/thank-you-downloading-visual%20studio\/?sku=Community\u0026amp;rel=16\"\u003ehttps:\/\/visualstudio.microsoft.com\/thank-you-downloading-visual studio\/?sku=Community\u0026amp;rel=16\u003c\/a\u003e\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"title\"\u003eTraining Content\u003c\/h3\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 1 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eWhat \u0026amp; Why Angular?\u003c\/li\u003e\n\u003cli\u003eUnderstand the concept of Single Page Application\u003c\/li\u003e\n\u003cli\u003eFeatures of different versions of Angular\u003c\/li\u003e\n\u003cli\u003eUnderstand NodeJs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 2 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand Typescript fundamentals\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 3 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eCreating angular application with angular cli.\u003c\/li\u003e\n\u003cli\u003eUnderstand Startup Project structure\u003c\/li\u003e\n\u003cli\u003eSetting up Visual studio\/Visual Studio Code for Angular and Typescript\u003c\/li\u003e\n\u003cli\u003eUnderstand the Architecture of an Angular App\u003c\/li\u003e\n\u003cli\u003eAngular Setup – Configuration and Bootstrapping\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 4 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eCreating a very first component\u003c\/li\u003e\n\u003cli\u003eUnderstand Component decorator\u003c\/li\u003e\n\u003cli\u003eUnderstand the fundamental behind directives\u003c\/li\u003e\n\u003cli\u003eComponents vs Directives\u003c\/li\u003e\n\u003cli\u003eUnderstanding types of binding\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 5 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eExploring in built directives\u003c\/li\u003e\n\u003cli\u003eUnderstand Attribute Directives and introduction to ElementRef\u003c\/li\u003e\n\u003cli\u003eCreating Custom directives\u003c\/li\u003e\n\u003cli\u003ePipes\u003c\/li\u003e\n\u003cli\u003eCreating custom Pipe\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 6 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the fundamental thought behind SPA \u0026amp; routing\u003c\/li\u003e\n\u003cli\u003eUnderstand Routing \u0026amp; navigation\u003c\/li\u003e\n\u003cli\u003eUnderstand Component based routing in Angular\u003c\/li\u003e\n\u003cli\u003eDemonstration of routing in Angular\u003c\/li\u003e\n\u003cli\u003eNested Routing\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 7 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eNested Components\u003c\/li\u003e\n\u003cli\u003eData passing with parent child component\u003c\/li\u003e\n\u003cli\u003eUnderstand ViewChild\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 8 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eValidating using FormsGroups and FormControls.\u003c\/li\u003e\n\u003cli\u003eEnabling and Disabling control as per valid and invalid.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eReusable component (2 Hours) -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eServices\u003c\/li\u003e\n\u003cli\u003eUsing Service inside Component\u003c\/li\u003e\n\u003cli\u003eIntroduction to RxJs\u003c\/li\u003e\n\u003cli\u003eHow to create WebAPI\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 9 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eImplementing dependency injection\u003c\/li\u003e\n\u003cli\u003eAngular forms \u0026amp; its types\u003c\/li\u003e\n\u003cli\u003eCreating custom validators\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 10 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eRestricting from component loading\u003c\/li\u003e\n\u003cli\u003eComponent Life cycle hooks\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003cstrong\u003eModule 11 -\u003c\/strong\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eStandalone Components\u003c\/li\u003e\n\u003cli\u003eRouting without NgModule\u003c\/li\u003e\n\u003cli\u003eTyped Reactive Forms\u003c\/li\u003e\n\u003cli\u003eAngular CLI autocomplete\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e","brand":"Questpond Videos","offers":[{"title":"Default Title","offer_id":42930791547086,"sku":"","price":20000.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0644\/2359\/2142\/files\/YoutubeThumbnail_1_466c7303-bd5a-4bc1-870c-5b2d8100ba0f.png?v=1737631865"}],"url":"https:\/\/questpondshop.myshopify.com\/collections\/collection.oembed","provider":"Questpond Videos","version":"1.0","type":"link"}