Відео

Thank you very much. Taking the exam on the 31st of Jan.

what about Apache Iceberg?

Hi Nikola, thank you for the video and all the info! I passed the DP-600 exam on 29th of Dec. There was still one question about Pyspark syntax in the exam and 6 questions about KQL syntax ;-). Thank you!

Hi Nikola, I wanted to thank you for the amazing content you share. I passed the DP-600 exam today with a score of 833, and your resources were incredibly helpful in my preparation. I truly appreciate the value you bring to the community-thank you!

This was an amazing presentation - I will highly recommend others to take the time!

Thanks just passed DP-600, your session helped me a lot as I have no background in Data (I am Power Platform Architect)

0 - Intro 19:22 DP-600 is a single-exam certification for data analytics in Microsoft Fabric. 21:01 Desirable candidate profile who should take this exam. 24:28 Overview or breakdown of the skills measured for the DP-600 exam 30:43 Overview of Fabric tenant structure and its components. 1 - Maintain Data Analytics Solution 34:35 Implement Security + Governance & Maintain the development lifecycle 35:35 Understanding access control granularity in Microsoft Fabric. 39:55 Understanding user roles and permissions in workspace management. 44:27 Implementing row-level security for data access in the warehouse and SQL analytics. 46:40 Understanding permissions and security in SQL analytics endpoints. 51:16 Applying sensitivity labels and endorsement features in Fabric Analytics. 53:48 Master data management ensures reliable organizational data. 58:24 Key advantages of PBIP format for Power BI integration and management. 1:00:38 Enabling the Power BI project format enhances semantic model management. 1:05:25 Understanding flexible deployment stages and selective deployment in data environments. 1:07:45 Understanding deployment workflows and automation in Microsoft Fabric. 1:12:23 Impact analysis helps assess changes in fabric items effectively. 1:14:53 Understanding XMLA endpoints for communication with semantic models. 1:19:31 Using Power BI for semantic models and template files. 1:21:48 Utilizing Power BI Semantic Models for Report Building 2 - Prepare Data 1:23:56 Get, Transform, Query & Analyze data 1:25:27 Connecting data sources in Microsoft Fabric offers multiple flexible options. 1:28:50 Explains data ingestion and mirroring in Microsoft Fabric. 1:33:30 Understanding internal and external shortcuts in Fabric. 1:35:44 Creating shortcuts in DP-600 Lakehouse enhances data integration. 1:50:16 Overview of fabric pipelines and data flow activities. 1:52:34 Creating a data pipeline in Microsoft Fabric involves setting up activities. 1:57:09 Fabric pipelines simplify data orchestration and transformation processes. 1:59:19 Refresh semantic models easily for updated Power BI reports. 2:04:01 Data flows enable comprehensive data transformations in Fabric Lakehouse. 2:06:10 Understanding data flows and pipelines in data profiling operations. 2:10:57 Lakehouses combine data lake scalability with SQL analytics capabilities. 2:13:20 Understanding the structure of Fabric's lake house with files and table areas. 2:17:51 Exploring Microsoft Fabric's Spark engine and its notebook features. 2:20:05 Overview of orchestration and data storage in Fabric Warehouse. 2:24:38 OneLake integration enhances semantic model reusability in Power BI. 2:26:57 Overview of integrating KQL databases with One Lake for data transformation. 2:31:27 Understanding the data layers: Bronze and Silver in data analytics. 2:33:48 Data organization in the Medallion architecture enhances reporting and analysis. 2:38:22 Adding and altering columns in Fabric Analytics is partially supported. 2:40:37 How to alter tables and implement star schema in KQL databases. 2:45:27 Understanding star and snowflake schemas in dimensional modelling. 2:47:41 Understanding slowly changing dimensions for accurate data analysis. 2:52:11 Redundant data can speed up data retrieval and aggregations reduce the number of scanned rows. 2:54:30 Understanding different join operations in data flow Gen 2 is crucial. 2:59:16 Understanding null value handling and data type conversion in KQL. 3:01:39 Column data type transformation techniques in data workflows. 3:11:05 Focus on T-SQL elements vital for the DP-600 exam. 3:13:33 Explaining row numbering and ranking by order date in data analytics. 3:18:18 KQL is preferred for streaming data over TSQL in analytics. 3:21:00 Using KQL for data aggregation and visualization in Power BI. 3 - Implement & Manage Semantic Models 3:21:45 Design, build & Optimize Semantic Models 3:25:52 Direct Lake enhances data performance while minimizing duplication and latency. 3:32:49 Direct Lake has limitations on calculated columns and relationships. 3:35:01 Establishing optimal relationships in Power BI models. 3:39:46 Understanding scalar and window functions in data analysis. 3:42:09 Using SQL functions to retrieve top-selling brands with windowing techniques. 3:46:45 Utilize calculation groups to streamline measure calculations for sales metrics. 3:48:55 Leveraging field parameters enhances Power BI data visualization flexibility. 3:53:42 Dynamic format strings enhance Power BI measure presentation. 3:55:58 Avoid using wide and tall tables in Power BI for optimal performance. 4:00:33 Understanding relationships and aggregations in Power BI enhances performance. 4:02:49 Optimize Power BI performance using Import mode and Performance Analyzer. 4:07:23 Understanding the data refresh process in Direct Lake versus Import mode. 4:09:49 Understanding Direct Lake Behavior in Data Models. 4:14:58 Incremental refresh requires specific prerequisites for effective data management. 4:17:23 Participants engage in a fun, interactive Kahoot game about fabric analytics. 4:26:32 Understanding Slowly Changing Dimensions for Historical Data Tracking 4:30:31 Understanding T-SQL ranking and deployment pipeline limitations in Fabric Analytics. 4:37:49 Essential tips for online exam preparation and effective resource use. 4:40:03 Explore learning resources and trial opportunities for Microsoft Fabric.

Amazing presentation! Thank you very much for preparing this presentation.

Amazing presentation! So many topics to fit within ~ 4.5 hours is pretty challenging and still you managed to cover each of them. Microsoft Fabric really gets bigger and bigger and for beginners it can be pretty confusing. I like you approach, start from what you already know, use skills that you have. You don't need to know all engines to start using Fabric. Well done!

Great content, thanks Nikola

Dude what a amazing breakdown - thank you for doing this.

You sir, are a gentleman and a scholar.

Thank you! Amazing content

Keep It up Mr.Nikola You are shining in social media these days

Great overview, would it be possible to share the PPT ?

Great content, Thank You!

That was the best explanation for that format blin

Please,Nkola - include timestamsp like most other good nUA-camrs do....

Thank Nikola you for the video!!!

It was great to attend this workshop. Thank you so much, Nikola.

Thanks Nikola for this great session. Regarding question no. 5 in the final quiz about unsupported items in deployment pipelines, I am bit confused about the selected correct answer "Dashboards" as the Microsoft online documentation lists it as supported item, technically all choices for this question are currently listed as supported items, could you please confirm.

Hi, thank you for this!

Hi Nikolai, when are we having this full course on your platform

Shameful thing is they marketed a lot Fabric challenge but not alloted exam vouchers to all deserving candidates

Excellence as always. Thank you so much Nikola.

Great Job Nikola! You are better than iniesta :)

00:00 - introduction 02:05 - advantages of apache parquet format 03:06 - row-based 04:06 - column-based storage 05:01 - parquet storage; row groups 05:43 - projection and predicate(s) 07:07 - how parquet knows which row group to scan 07:30 - performance tip about optimal parquet file size 08:31 - data compression in parquet 10:04 - Delta format

What an amazing way to explain this!

This was helpful - appreciate your time putting it together!

we want more of this !!!!!!!!!😀

nice explanation, only first one minute was unnecessary.

Good video, however it's not dynamic filtering but dynamic change of measures

Behind The Hype - Is Analytics Engineer a Real Job: ua-cam.com/video/VXnwYuOCT-U/v-deo.html

You are soo good, hope people notice these videos and get benefitted. I have just started journey into DE, finding these very useful and easy to understand. Hope to see more videos from you.

How many question has a beta exam?

Thanks for all of this info!

with new certifications coming up, my decision to pick up an exam has changed 3 times last 3, 4 months, now I can take a wise decision, thank you very much :)

❤

Do you think new projects should utilise this instead of Fabric?

Nikola, it was great to see you last week. Thank you for this video on the new exam.

I’m currently preparing to do the DP-203 exam. Is the DP-203 exam now redundant?

Is there any sources to get country wise numbers if that 70,000 DP-600 pasing numbers?

Great insights as always Nikola

Super informative, thanks a lot!

You're the best!

So basically it's vertipaq but open source

Thanks for this video! This should be part of every Power BI training!

Thanks Nicola for sharing, small changes can be very powerful.

This is a classic situation, and it usually appears in Fabric or Power BI certification tests.

Thanks Nicola, I had no idea about Fixed Decimal Numbers storing 4 digits instead of two...